PREVIEW / stock_1hour / 2021-03-18

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-03-18.parquet
  size:    1.5 MB
  rows:    68,025
  symbols: 2,909

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-03-18 04:00:00	AAPL	Stock	123.36	124.27	123.04	123.04	40775.0
2021-03-18 05:00:00	AAPL	Stock	123.19	123.7	123.02	123.42	18132.0
2021-03-18 06:00:00	AAPL	Stock	123.6	123.85	123.45	123.6	16361.0
2021-03-18 07:00:00	AAPL	Stock	123.65	123.89	122.69	123.0	452350.0
2021-03-18 08:00:00	AAPL	Stock	123.8	125.071	122.68	122.92	735306.0
2021-03-18 09:00:00	AAPL	Stock	122.92	123.18	121.78	122.36	14192243.0
2021-03-18 10:00:00	AAPL	Stock	122.35	122.64	121.59	122.51	15130579.0
2021-03-18 11:00:00	AAPL	Stock	122.51	122.73	121.77	121.93	9897554.0
2021-03-18 12:00:00	AAPL	Stock	121.93	122.59	121.71	121.75	9210941.0
2021-03-18 13:00:00	AAPL	Stock	121.76	122.215	121.7	121.97	9751079.0
2021-03-18 14:00:00	AAPL	Stock	121.96	122.03	121.02	121.17	11940061.0
2021-03-18 15:00:00	AAPL	Stock	121.17	121.37	120.32	120.55	21854981.0
2021-03-18 16:00:00	AAPL	Stock	120.55	121.427	120.4	120.63	10332656.0
2021-03-18 17:00:00	AAPL	Stock	120.61	120.78	120.5	120.72	119381.0
2021-03-18 18:00:00	AAPL	Stock	120.75	120.87	120.61	120.62	109898.0
2021-03-18 19:00:00	AAPL	Stock	120.65	120.67	120.5	120.55	125290.0
2021-03-18 04:00:00	MSFT	Stock	235.38	235.38	234.13	234.4	6664.0
2021-03-18 05:00:00	MSFT	Stock	234.4	235.37	234.2	234.85	9342.0
2021-03-18 06:00:00	MSFT	Stock	234.85	235.97	234.85	235.07	6483.0
2021-03-18 07:00:00	MSFT	Stock	235.29	235.46	233.11	233.56	70882.0
2021-03-18 08:00:00	MSFT	Stock	234.839	236.448	233.25	233.6	46837.0
2021-03-18 09:00:00	MSFT	Stock	233.6	234.19	232.03	233.26	2619117.0
2021-03-18 10:00:00	MSFT	Stock	233.21	233.36	232.21	232.99	3481688.0
2021-03-18 11:00:00	MSFT	Stock	233.0	233.3	232.03	232.38	2371202.0
2021-03-18 12:00:00	MSFT	Stock	232.38	233.4	231.8	231.89	2191174.0
2021-03-18 13:00:00	MSFT	Stock	231.91	233.59	231.8	233.5301	1876061.0
2021-03-18 14:00:00	MSFT	Stock	233.55	233.58	230.735	231.09	3196635.0
2021-03-18 15:00:00	MSFT	Stock	231.09	231.45	230.33	230.72	5955321.0
2021-03-18 16:00:00	MSFT	Stock	230.72	231.6772	230.72	230.72	5046338.0
2021-03-18 17:00:00	MSFT	Stock	231.02	231.18	230.5254	231.0707	8580.0
2021-03-18 18:00:00	MSFT	Stock	231.07	231.2	230.95	230.95	7671.0
2021-03-18 19:00:00	MSFT	Stock	230.95	231.1	230.76	230.9	9066.0
2021-03-18 04:00:00	NVDA	Stock	13.2	13.2	13.1725	13.2	46200.0
2021-03-18 05:00:00	NVDA	Stock	13.2002	13.2002	13.175	13.175	13640.0
2021-03-18 07:00:00	NVDA	Stock	13.2748	13.2925	13.1	13.1252	369600.0
2021-03-18 08:00:00	NVDA	Stock	13.319	13.3746	13.1	13.1213	422000.0
2021-03-18 09:00:00	NVDA	Stock	13.114	13.184	12.977	13.141	23592800.0
2021-03-18 10:00:00	NVDA	Stock	13.142	13.1472	12.9973	13.0785	14701800.0
2021-03-18 11:00:00	NVDA	Stock	13.0805	13.1178	12.98	13.0175	17326320.0
2021-03-18 12:00:00	NVDA	Stock	13.017	13.1382	12.9833	12.9877	11392280.0
2021-03-18 13:00:00	NVDA	Stock	12.9895	13.0405	12.9602	13.0328	15017160.0
2021-03-18 14:00:00	NVDA	Stock	13.0358	13.0418	12.798	12.8368	21886200.0
2021-03-18 15:00:00	NVDA	Stock	12.8415	12.8638	12.717	12.7198	47458440.0
2021-03-18 16:00:00	NVDA	Stock	12.7225	12.78	12.7213	12.73	25945360.0
2021-03-18 17:00:00	NVDA	Stock	12.7475	12.7518	12.7326	12.75	89880.0
2021-03-18 18:00:00	NVDA	Stock	12.775	12.775	12.7275	12.745	92280.0
2021-03-18 19:00:00	NVDA	Stock	12.75	12.75	12.7375	12.7375	31800.0
2021-03-18 04:00:00	AMZN	Stock	155.25	155.25	154.963	154.963	17280.0
2021-03-18 05:00:00	AMZN	Stock	155.74	155.74	155.5045	155.5045	4000.0
2021-03-18 06:00:00	AMZN	Stock	155.75	155.75	155.75	155.75	5420.0

> showing 50 of 68,025 rows — these rows as CSV

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