PREVIEW / stock_1hour / 2021-03-22

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-03-22.parquet
  size:    1.5 MB
  rows:    67,520
  symbols: 2,907

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-22 04:00:00	AAPL	Stock	120.7	121.13	120.2	120.83	34439.0
2021-03-22 05:00:00	AAPL	Stock	120.82	120.95	120.73	120.85	12374.0
2021-03-22 06:00:00	AAPL	Stock	120.87	121.18	120.8	121.0	18285.0
2021-03-22 07:00:00	AAPL	Stock	120.95	121.0	120.71	120.89	169352.0
2021-03-22 08:00:00	AAPL	Stock	120.8495	120.94	119.99	120.81	477702.0
2021-03-22 09:00:00	AAPL	Stock	120.82	121.79	119.99	121.425	13470348.0
2021-03-22 10:00:00	AAPL	Stock	121.43	122.69	121.43	122.58	13453312.0
2021-03-22 11:00:00	AAPL	Stock	122.575	122.84	122.16	122.32	9047058.0
2021-03-22 12:00:00	AAPL	Stock	122.32	123.77	122.32	123.4212	12076883.0
2021-03-22 13:00:00	AAPL	Stock	123.4212	123.7	123.04	123.68	8796241.0
2021-03-22 14:00:00	AAPL	Stock	123.69	123.84	123.4	123.79	7638484.0
2021-03-22 15:00:00	AAPL	Stock	123.79	123.87	123.02	123.37	14682715.0
2021-03-22 16:00:00	AAPL	Stock	123.39	123.47	123.1	123.12	13591447.0
2021-03-22 17:00:00	AAPL	Stock	123.13	123.2	123.05	123.1	88312.0
2021-03-22 18:00:00	AAPL	Stock	123.14	123.39	123.09	123.14	351033.0
2021-03-22 19:00:00	AAPL	Stock	123.18	123.24	123.01	123.18	97001.0
2021-03-22 04:00:00	MSFT	Stock	231.2	231.99	231.2	231.8	2597.0
2021-03-22 05:00:00	MSFT	Stock	231.82	231.86	231.66	231.66	768.0
2021-03-22 06:00:00	MSFT	Stock	232.08	232.63	232.08	232.16	3070.0
2021-03-22 07:00:00	MSFT	Stock	232.15	232.27	231.61	232.25	20834.0
2021-03-22 08:00:00	MSFT	Stock	231.9999	232.3	230.35	232.02	25267.0
2021-03-22 09:00:00	MSFT	Stock	232.09	233.69	230.14	233.6033	3110763.0
2021-03-22 10:00:00	MSFT	Stock	233.62	235.1454	233.331	234.97	3078847.0
2021-03-22 11:00:00	MSFT	Stock	234.98	236.325	234.8	235.8901	2565691.0
2021-03-22 12:00:00	MSFT	Stock	235.93	236.9	235.8728	236.715	1808123.0
2021-03-22 13:00:00	MSFT	Stock	236.7	236.75	236.13	236.33	1384651.0
2021-03-22 14:00:00	MSFT	Stock	236.32	236.684	236.1	236.43	1423124.0
2021-03-22 15:00:00	MSFT	Stock	236.44	236.6	235.72	236.04	2955751.0
2021-03-22 16:00:00	MSFT	Stock	235.99	236.28	235.52	236.05	5721115.0
2021-03-22 17:00:00	MSFT	Stock	235.95	236.05	235.65	236.02	8337.0
2021-03-22 18:00:00	MSFT	Stock	236.04	236.35	235.86	235.94	31211.0
2021-03-22 19:00:00	MSFT	Stock	236.04	236.5	235.9	236.06	3144.0
2021-03-22 04:00:00	NVDA	Stock	12.9357	12.9357	12.9357	12.9357	5040.0
2021-03-22 05:00:00	NVDA	Stock	12.9025	12.9025	12.8	12.8	43520.0
2021-03-22 06:00:00	NVDA	Stock	12.9372	12.9372	12.9372	12.9372	7360.0
2021-03-22 07:00:00	NVDA	Stock	12.9593	12.9708	12.95	12.9618	165320.0
2021-03-22 08:00:00	NVDA	Stock	12.9562	12.9715	12.9	12.9715	149880.0
2021-03-22 09:00:00	NVDA	Stock	12.9625	13.0372	12.8458	12.9843	16909120.0
2021-03-22 10:00:00	NVDA	Stock	12.9975	13.1835	12.9765	13.1775	27054520.0
2021-03-22 11:00:00	NVDA	Stock	13.1775	13.2848	13.15	13.2452	19059600.0
2021-03-22 12:00:00	NVDA	Stock	13.2482	13.3833	13.2481	13.3375	21701320.0
2021-03-22 13:00:00	NVDA	Stock	13.344	13.3945	13.2958	13.3848	17983760.0
2021-03-22 14:00:00	NVDA	Stock	13.3846	13.3893	13.301	13.3428	14429520.0
2021-03-22 15:00:00	NVDA	Stock	13.3411	13.3411	13.1648	13.1862	26474640.0
2021-03-22 16:00:00	NVDA	Stock	13.1862	13.2094	13.1745	13.175	38132320.0
2021-03-22 17:00:00	NVDA	Stock	13.181	13.185	13.1575	13.175	96000.0
2021-03-22 18:00:00	NVDA	Stock	13.175	13.21	13.175	13.2095	174960.0
2021-03-22 19:00:00	NVDA	Stock	13.193	13.2095	13.193	13.2095	64560.0
2021-03-22 04:00:00	AMZN	Stock	153.927	154.0	153.927	154.0	4000.0
2021-03-22 06:00:00	AMZN	Stock	154.27	154.27	154.27	154.27	3280.0

> showing 50 of 67,520 rows — these rows as CSV

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