PREVIEW / stock_1hour / 2021-04-06

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-04-06.parquet
  size:    1.4 MB
  rows:    66,015
  symbols: 2,954

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-04-06 04:00:00	AAPL	Stock	125.33	125.68	125.0	125.5	35105.0
2021-04-06 05:00:00	AAPL	Stock	125.5	125.64	125.46	125.53	12162.0
2021-04-06 06:00:00	AAPL	Stock	125.61	125.7	125.5	125.63	10493.0
2021-04-06 07:00:00	AAPL	Stock	125.64	126.38	125.61	126.3	231435.0
2021-04-06 08:00:00	AAPL	Stock	125.9192	126.71	125.68	126.33	528292.0
2021-04-06 09:00:00	AAPL	Stock	126.34	126.61	125.65	126.575	11887460.0
2021-04-06 10:00:00	AAPL	Stock	126.57	126.96	125.979	126.5672	12992130.0
2021-04-06 11:00:00	AAPL	Stock	126.5699	127.13	126.5	126.9201	8872822.0
2021-04-06 12:00:00	AAPL	Stock	126.93	126.94	126.2198	126.235	6338883.0
2021-04-06 13:00:00	AAPL	Stock	126.235	126.29	125.7491	126.1853	7050695.0
2021-04-06 14:00:00	AAPL	Stock	126.185	126.605	126.12	126.55	5729049.0
2021-04-06 15:00:00	AAPL	Stock	126.55	126.68	126.0	126.23	10278198.0
2021-04-06 16:00:00	AAPL	Stock	126.21	126.41	126.04	126.28	7228413.0
2021-04-06 17:00:00	AAPL	Stock	126.23	126.27	126.2	126.23	24417.0
2021-04-06 18:00:00	AAPL	Stock	126.23	126.34	126.2	126.26	52090.0
2021-04-06 19:00:00	AAPL	Stock	126.27	126.37	126.21	126.33	66058.0
2021-04-06 04:00:00	MSFT	Stock	248.0	248.28	247.63	248.28	6861.0
2021-04-06 05:00:00	MSFT	Stock	248.1	248.1	247.64	247.64	4465.0
2021-04-06 06:00:00	MSFT	Stock	247.92	247.92	247.58	247.62	1870.0
2021-04-06 07:00:00	MSFT	Stock	247.87	248.23	247.8	248.04	27061.0
2021-04-06 08:00:00	MSFT	Stock	248.09	249.07	247.9501	248.26	172295.0
2021-04-06 09:00:00	MSFT	Stock	248.55	248.78	246.88	248.27	2793532.0
2021-04-06 10:00:00	MSFT	Stock	248.26	248.99	247.395	248.51	2689714.0
2021-04-06 11:00:00	MSFT	Stock	248.51	249.38	248.27	249.3626	1963756.0
2021-04-06 12:00:00	MSFT	Stock	249.36	249.4	248.705	248.82	1302938.0
2021-04-06 13:00:00	MSFT	Stock	248.8	248.86	247.95	248.5465	1292077.0
2021-04-06 14:00:00	MSFT	Stock	248.55	249.0598	248.46	248.84	1535831.0
2021-04-06 15:00:00	MSFT	Stock	248.8324	248.91	247.28	247.87	2851888.0
2021-04-06 16:00:00	MSFT	Stock	247.86	248.22	247.82	248.18	2515728.0
2021-04-06 17:00:00	MSFT	Stock	248.2	248.2	248.02	248.2	919.0
2021-04-06 18:00:00	MSFT	Stock	248.2	248.25	248.03	248.18	2187.0
2021-04-06 19:00:00	MSFT	Stock	248.1	248.34	248.03	248.13	3879.0
2021-04-06 04:00:00	NVDA	Stock	13.975	13.975	13.975	13.975	4000.0
2021-04-06 07:00:00	NVDA	Stock	13.9375	13.9625	13.9275	13.9625	87960.0
2021-04-06 08:00:00	NVDA	Stock	13.9445	14.0	13.925	13.975	167560.0
2021-04-06 09:00:00	NVDA	Stock	13.985	14.0402	13.8825	14.0402	17364080.0
2021-04-06 10:00:00	NVDA	Stock	14.0335	14.052	13.913	13.9874	15019920.0
2021-04-06 11:00:00	NVDA	Stock	13.9877	14.0541	13.9575	14.0096	11592400.0
2021-04-06 12:00:00	NVDA	Stock	14.0095	14.0118	13.921	13.9292	9067280.0
2021-04-06 13:00:00	NVDA	Stock	13.9275	13.9325	13.7736	13.8768	18518160.0
2021-04-06 14:00:00	NVDA	Stock	13.8762	13.9398	13.8613	13.9351	11766400.0
2021-04-06 15:00:00	NVDA	Stock	13.9352	13.9438	13.813	13.8585	16568920.0
2021-04-06 16:00:00	NVDA	Stock	13.8615	13.87	13.8592	13.8638	23418760.0
2021-04-06 17:00:00	NVDA	Stock	13.8613	13.8662	13.8613	13.8662	30200.0
2021-04-06 18:00:00	NVDA	Stock	13.8628	13.8725	13.8628	13.8725	80600.0
2021-04-06 19:00:00	NVDA	Stock	13.87	13.8725	13.8615	13.8725	210160.0
2021-04-06 04:00:00	AMZN	Stock	160.5	160.7	160.5	160.7	12000.0
2021-04-06 05:00:00	AMZN	Stock	160.7	160.7	160.55	160.55	6360.0
2021-04-06 07:00:00	AMZN	Stock	160.7095	161.2	160.7095	161.1	70380.0
2021-04-06 08:00:00	AMZN	Stock	160.945	161.4255	160.799	161.0	144500.0

> showing 50 of 66,015 rows — these rows as CSV

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