Sample data

Sample datasets are used throughout the InfluxDB Clustered documentation to demonstrate functionality. Use the following sample datasets to replicate provided examples.

Get started home sensor data
Home sensor actions data
NOAA Bay Area weather data
Bitcoin price data
Random numbers sample data

Get started home sensor data

Includes hourly home sensor data used in the Get started with InfluxDB Clustered guide. This dataset includes anomalous sensor readings and helps to demonstrate processing and alerting on time series data. To customize timestamps in the dataset, use the button in the lower right corner of the page. This lets you modify the sample dataset to stay within the retention period of the database you write it to.

Time Range

2022-01-01T08:00:00Z to 2022-01-01T20:00:00Z (Customizable)

Schema

home (measurement)
- tags:
  - room
    - Kitchen
    - Living Room
- fields:
  - co (integer)
  - temp (float)
  - hum (float)

Write home sensor data to InfluxDB

Write the home sensor data to InfluxDB

Use the InfluxDB v2 or v1 API to write the Get started home sensor sample data to InfluxDB Clustered.

v2 API v1 API

curl --request POST \
  https://cluster-host.com/api/v2/write?bucket=DATABASE_NAME
&precision=s \
  --header "Authorization: Bearer DATABASE_TOKEN
" \
  --header "Content-Type: text/plain; charset=utf-8" \
  --header "Accept: application/json" \
  --data-binary "
home,room=Living\ Room temp=21.1,hum=35.9,co=0i 1641024000
home,room=Kitchen temp=21.0,hum=35.9,co=0i 1641024000
home,room=Living\ Room temp=21.4,hum=35.9,co=0i 1641027600
home,room=Kitchen temp=23.0,hum=36.2,co=0i 1641027600
home,room=Living\ Room temp=21.8,hum=36.0,co=0i 1641031200
home,room=Kitchen temp=22.7,hum=36.1,co=0i 1641031200
home,room=Living\ Room temp=22.2,hum=36.0,co=0i 1641034800
home,room=Kitchen temp=22.4,hum=36.0,co=0i 1641034800
home,room=Living\ Room temp=22.2,hum=35.9,co=0i 1641038400
home,room=Kitchen temp=22.5,hum=36.0,co=0i 1641038400
home,room=Living\ Room temp=22.4,hum=36.0,co=0i 1641042000
home,room=Kitchen temp=22.8,hum=36.5,co=1i 1641042000
home,room=Living\ Room temp=22.3,hum=36.1,co=0i 1641045600
home,room=Kitchen temp=22.8,hum=36.3,co=1i 1641045600
home,room=Living\ Room temp=22.3,hum=36.1,co=1i 1641049200
home,room=Kitchen temp=22.7,hum=36.2,co=3i 1641049200
home,room=Living\ Room temp=22.4,hum=36.0,co=4i 1641052800
home,room=Kitchen temp=22.4,hum=36.0,co=7i 1641052800
home,room=Living\ Room temp=22.6,hum=35.9,co=5i 1641056400
home,room=Kitchen temp=22.7,hum=36.0,co=9i 1641056400
home,room=Living\ Room temp=22.8,hum=36.2,co=9i 1641060000
home,room=Kitchen temp=23.3,hum=36.9,co=18i 1641060000
home,room=Living\ Room temp=22.5,hum=36.3,co=14i 1641063600
home,room=Kitchen temp=23.1,hum=36.6,co=22i 1641063600
home,room=Living\ Room temp=22.2,hum=36.4,co=17i 1641067200
home,room=Kitchen temp=22.7,hum=36.5,co=26i 1641067200
"

curl --request POST \
  https://cluster-host.com/write?db=DATABASE_NAME
&precision=s \
  --header "Authorization: Bearer DATABASE_TOKEN
" \
  --header "Content-type: text/plain; charset=utf-8" \
  --data-binary "
home,room=Living\ Room temp=21.1,hum=35.9,co=0i 1641024000
home,room=Kitchen temp=21.0,hum=35.9,co=0i 1641024000
home,room=Living\ Room temp=21.4,hum=35.9,co=0i 1641027600
home,room=Kitchen temp=23.0,hum=36.2,co=0i 1641027600
home,room=Living\ Room temp=21.8,hum=36.0,co=0i 1641031200
home,room=Kitchen temp=22.7,hum=36.1,co=0i 1641031200
home,room=Living\ Room temp=22.2,hum=36.0,co=0i 1641034800
home,room=Kitchen temp=22.4,hum=36.0,co=0i 1641034800
home,room=Living\ Room temp=22.2,hum=35.9,co=0i 1641038400
home,room=Kitchen temp=22.5,hum=36.0,co=0i 1641038400
home,room=Living\ Room temp=22.4,hum=36.0,co=0i 1641042000
home,room=Kitchen temp=22.8,hum=36.5,co=1i 1641042000
home,room=Living\ Room temp=22.3,hum=36.1,co=0i 1641045600
home,room=Kitchen temp=22.8,hum=36.3,co=1i 1641045600
home,room=Living\ Room temp=22.3,hum=36.1,co=1i 1641049200
home,room=Kitchen temp=22.7,hum=36.2,co=3i 1641049200
home,room=Living\ Room temp=22.4,hum=36.0,co=4i 1641052800
home,room=Kitchen temp=22.4,hum=36.0,co=7i 1641052800
home,room=Living\ Room temp=22.6,hum=35.9,co=5i 1641056400
home,room=Kitchen temp=22.7,hum=36.0,co=9i 1641056400
home,room=Living\ Room temp=22.8,hum=36.2,co=9i 1641060000
home,room=Kitchen temp=23.3,hum=36.9,co=18i 1641060000
home,room=Living\ Room temp=22.5,hum=36.3,co=14i 1641063600
home,room=Kitchen temp=23.1,hum=36.6,co=22i 1641063600
home,room=Living\ Room temp=22.2,hum=36.4,co=17i 1641067200
home,room=Kitchen temp=22.7,hum=36.5,co=26i 1641067200
"

Replace the following in the sample script:

DATABASE_NAME: your database
DATABASE_TOKEN: a database token with write permission to the database

Home sensor actions data

Includes hypothetical actions triggered by data in the Get started home sensor data and is a companion dataset to that sample dataset. To customize timestamps in the dataset, use the button in the lower right corner of the page. This lets you modify the sample dataset to stay within the retention period of the database you write it to.

Time Range

2022-01-01T08:00:00Z to 2022-01-01T20:00:00Z (Customizable)

Schema

home_actions (measurement)
- tags:
  - room
    - Kitchen
    - Living Room
  - action
    - alert
    - cool
  - level
    - ok
    - warn
- fields:
  - description (string)

Write home sensor actions data to InfluxDB

Write the home sensor actions data to InfluxDB

Use the InfluxDB v2 or v1 API to write the home sensor actions sample data to InfluxDB Clustered.

v2 API v1 API

curl --request POST \
  https://cluster-host.com/api/v2/write?bucket=DATABASE_NAME
&precision=s \
  --header "Authorization: Bearer DATABASE_TOKEN
" \
  --header "Content-Type: text/plain; charset=utf-8" \
  --header "Accept: application/json" \
  --data-binary '
home_actions,room=Kitchen,action=cool,level=ok description="Temperature at or above 23°C (23°C). Cooling to 22°C." 1641027600
home_actions,room=Kitchen,action=cool,level=ok description="Temperature at or above 23°C (23.3°C). Cooling to 22°C." 1641060000
home_actions,room=Kitchen,action=cool,level=ok description="Temperature at or above 23°C (23.1°C). Cooling to 22°C." 1641063600
home_actions,room=Kitchen,action=alert,level=warn description="Carbon monoxide level above normal: 18 ppm." 1641060000
home_actions,room=Kitchen,action=alert,level=warn description="Carbon monoxide level above normal: 22 ppm." 1641063600
home_actions,room=Kitchen,action=alert,level=warn description="Carbon monoxide level above normal: 26 ppm." 1641067200
home_actions,room=Living\ Room,action=alert,level=warn description="Carbon monoxide level above normal: 14 ppm." 1641063600
home_actions,room=Living\ Room,action=alert,level=warn description="Carbon monoxide level above normal: 17 ppm." 1641067200
'

curl --request POST \
  https://cluster-host.com/write?db=DATABASE_NAME
&precision=s \
  --header "Authorization: Bearer DATABASE_TOKEN
" \
  --header "Content-type: text/plain; charset=utf-8" \
  --data-binary '
home_actions,room=Kitchen,action=cool,level=ok description="Temperature at or above 23°C (23°C). Cooling to 22°C." 1641027600
home_actions,room=Kitchen,action=cool,level=ok description="Temperature at or above 23°C (23.3°C). Cooling to 22°C." 1641060000
home_actions,room=Kitchen,action=cool,level=ok description="Temperature at or above 23°C (23.1°C). Cooling to 22°C." 1641063600
home_actions,room=Kitchen,action=alert,level=warn description="Carbon monoxide level above normal: 18 ppm." 1641060000
home_actions,room=Kitchen,action=alert,level=warn description="Carbon monoxide level above normal: 22 ppm." 1641063600
home_actions,room=Kitchen,action=alert,level=warn description="Carbon monoxide level above normal: 26 ppm." 1641067200
home_actions,room=Living\ Room,action=alert,level=warn description="Carbon monoxide level above normal: 14 ppm." 1641063600
home_actions,room=Living\ Room,action=alert,level=warn description="Carbon monoxide level above normal: 17 ppm." 1641067200
'

Replace the following in the sample script:

DATABASE_NAME: your database
DATABASE_TOKEN: a database token with write permission to the database

NOAA Bay Area weather data

Includes daily weather metrics from three San Francisco Bay Area airports from January 1, 2020 to December 31, 2022. This sample dataset includes seasonal trends and is good for exploring time series use cases that involve seasonality.

Time Range

2020-01-01T00:00:00Z to 2022-12-31T00:00:00Z

Schema

weather (measurement)
- tags:
  - location
    - Concord
    - Hayward
    - San Francisco
- fields
  - precip (float)
  - temp_avg (float)
  - temp_max (float)
  - temp_min (float)
  - wind_avg (float)

Write the NOAA Bay Area weather data to InfluxDB

Bitcoin price data

The Bitcoin price sample dataset provides Bitcoin prices from 2023-05-01T00:00:00Z to 2023-05-15T00:00:00Z—Powered by CoinDesk.

Time Range

2023-05-01T00:19:00Z to 2023-05-14T23:48:00Z

Schema

bitcoin (measurement)
- tags:
  - code
    - EUR
    - GBP
    - USD
  - crypto
    - bitcoin
  - description
    - Euro
    - British Pound Sterling
    - United States Dollar
  - symbol
    - € (€)
    - £ (£)
    - $ ($)
- fields
  - price (float)

Write the Bitcoin sample data to InfluxDB

Random numbers sample data

Includes two fields with randomly generated numbers reported every minute. Each field has a specific range of randomly generated numbers. This sample dataset is used to demonstrate mathematic operations and transformation functions.

Time Range

2023-01-01T00:00:00Z to 2023-01-01T12:00:00Z

Schema

numbers (measurement)
- fields
  - a (float between -1 and 1)
  - b (float between -3 and 3)

Write the random number sample data to InfluxDB

Was this page helpful?

Thank you for your feedback!

Support and feedback

Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB and this documentation. To find support, use the following resources:

Customers with an annual or support contract can contact InfluxData Support.

Edit this page Submit docs issue Submit InfluxDB issue

Sample data

Get started home sensor data

Time Range

Schema

Write the home sensor data to InfluxDB

Home sensor actions data

Time Range

Schema

Write the home sensor actions data to InfluxDB

NOAA Bay Area weather data

Time Range

Schema

Write the NOAA Bay Area weather data to InfluxDB

Bitcoin price data

Time Range

Schema

Write the Bitcoin price sample data to InfluxDB

Random numbers sample data

Time Range

Schema

Write the random number sample data to InfluxDB

Support and feedback

The future of Flux

InfluxDB v3 enhancements and InfluxDB Clustered is now generally available

InfluxDB v3 performance and features

InfluxDB Clustered general availability

Sample data

Get started home sensor data

Time Range

Schema

Write the home sensor data to InfluxDB

Home sensor actions data

Time Range

Schema

Write the home sensor actions data to InfluxDB

NOAA Bay Area weather data

Time Range

Schema

Write the NOAA Bay Area weather data to InfluxDB

Bitcoin price data

Time Range

Schema

Write the Bitcoin price sample data to InfluxDB

Random numbers sample data

Time Range

Schema

Write the random number sample data to InfluxDB

Support and feedback

What is your InfluxDB cluster URL?

Enter cluster URL

Thank you for your feedback!

Select a new date

The future of Flux

InfluxDB v3 enhancements and InfluxDB Clustered is now generally available

InfluxDB v3 performance and features

InfluxDB Clustered general availability