PREVIEW / stock_1hour / 2021-02-23

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-02-23.parquet
  size:    1.5 MB
  rows:    73,080
  symbols: 2,839

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2021-02-23 04:00:00	AAPL	Stock	126.0	126.0	123.99	124.2	159377.0
2021-02-23 05:00:00	AAPL	Stock	124.2	124.39	121.58	122.42	364880.0
2021-02-23 06:00:00	AAPL	Stock	122.45	123.5	122.04	123.36	91840.0
2021-02-23 07:00:00	AAPL	Stock	123.33	123.9	123.21	123.62	560284.0
2021-02-23 08:00:00	AAPL	Stock	123.62	126.0	122.29	123.59	2108326.0
2021-02-23 09:00:00	AAPL	Stock	123.58	123.9	118.39	121.73	30393172.0
2021-02-23 10:00:00	AAPL	Stock	121.72	123.93	121.4	123.63	22585518.0
2021-02-23 11:00:00	AAPL	Stock	123.64	124.12	122.02	122.13	14136402.0
2021-02-23 12:00:00	AAPL	Stock	122.12	122.81	121.31	122.15	15120124.0
2021-02-23 13:00:00	AAPL	Stock	122.14	124.6	121.92	124.41	12963747.0
2021-02-23 14:00:00	AAPL	Stock	124.4	125.65	124.19	125.63	12847216.0
2021-02-23 15:00:00	AAPL	Stock	125.649	126.71	125.47	125.85	17808749.0
2021-02-23 16:00:00	AAPL	Stock	125.86	125.91	125.16	125.25	5106288.0
2021-02-23 17:00:00	AAPL	Stock	125.25	125.74	125.25	125.5	232659.0
2021-02-23 18:00:00	AAPL	Stock	125.54	125.79	125.29	125.69	150779.0
2021-02-23 19:00:00	AAPL	Stock	125.69	125.87	125.1	125.5	296674.0
2021-02-23 04:00:00	MSFT	Stock	234.7	234.7	232.0	232.8	10603.0
2021-02-23 05:00:00	MSFT	Stock	232.63	233.18	230.05	230.34	52629.0
2021-02-23 06:00:00	MSFT	Stock	230.25	231.3	230.06	230.89	19111.0
2021-02-23 07:00:00	MSFT	Stock	230.94	231.0	230.21	230.54	62331.0
2021-02-23 08:00:00	MSFT	Stock	230.6	231.0	229.697	230.5	115277.0
2021-02-23 09:00:00	MSFT	Stock	230.75	231.5	228.73	230.72	4525877.0
2021-02-23 10:00:00	MSFT	Stock	230.64	233.14	230.23	232.57	3907524.0
2021-02-23 11:00:00	MSFT	Stock	232.61	233.36	232.15	232.17	2379455.0
2021-02-23 12:00:00	MSFT	Stock	232.16	232.55	229.99	230.03	2016682.0
2021-02-23 13:00:00	MSFT	Stock	230.04	232.68	229.821	232.21	1683014.0
2021-02-23 14:00:00	MSFT	Stock	232.2	233.04	231.8	232.99	1556271.0
2021-02-23 15:00:00	MSFT	Stock	233.0	234.83	232.925	233.27	3504211.0
2021-02-23 16:00:00	MSFT	Stock	233.27	233.27	232.17	232.3	2799272.0
2021-02-23 17:00:00	MSFT	Stock	232.72	232.72	232.3	232.5	16087.0
2021-02-23 18:00:00	MSFT	Stock	232.57	232.9	232.04	232.67	23469.0
2021-02-23 19:00:00	MSFT	Stock	232.7	233.27	232.5	232.5	21747.0
2021-02-23 04:00:00	NVDA	Stock	14.3125	14.3135	14.1788	14.2192	116360.0
2021-02-23 05:00:00	NVDA	Stock	14.1838	14.1838	13.875	13.95	469280.0
2021-02-23 06:00:00	NVDA	Stock	13.95	14.05	13.9252	14.05	215400.0
2021-02-23 07:00:00	NVDA	Stock	14.0822	14.1848	14.0125	14.025	1396920.0
2021-02-23 08:00:00	NVDA	Stock	14.1463	14.2255	13.9875	14.125	2412360.0
2021-02-23 09:00:00	NVDA	Stock	14.1243	14.1243	13.3895	13.7368	74346960.0
2021-02-23 10:00:00	NVDA	Stock	13.7339	14.0239	13.6295	13.9415	64961440.0
2021-02-23 11:00:00	NVDA	Stock	13.9452	14.0848	13.805	13.8052	29674800.0
2021-02-23 12:00:00	NVDA	Stock	13.8048	13.8533	13.653	13.6708	25632880.0
2021-02-23 13:00:00	NVDA	Stock	13.6705	13.8955	13.645	13.8731	19252680.0
2021-02-23 14:00:00	NVDA	Stock	13.865	14.0277	13.841	14.0169	26379960.0
2021-02-23 15:00:00	NVDA	Stock	14.023	14.2388	13.986	14.1412	42706720.0
2021-02-23 16:00:00	NVDA	Stock	14.142	14.1625	14.078	14.1202	20419680.0
2021-02-23 17:00:00	NVDA	Stock	14.125	14.1403	14.1	14.1403	237160.0
2021-02-23 18:00:00	NVDA	Stock	14.1403	14.2	14.1248	14.2	307480.0
2021-02-23 19:00:00	NVDA	Stock	14.2	14.2	14.1645	14.18	275240.0
2021-02-23 04:00:00	AMZN	Stock	158.75	158.75	157.5	157.5	15840.0
2021-02-23 05:00:00	AMZN	Stock	155.75	155.75	154.4	155.0	109480.0

> showing 50 of 73,080 rows — these rows as CSV

> unlock the full archive -- $79 one-time