PREVIEW / stock_1hour / 2021-02-08

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-02-08.parquet
  size:    1.5 MB
  rows:    71,349
  symbols: 2,782

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-08 04:00:00	AAPL	Stock	136.68	137.1	136.5	136.94	69362.0
2021-02-08 05:00:00	AAPL	Stock	136.95	137.1	136.8	136.8	17719.0
2021-02-08 06:00:00	AAPL	Stock	136.8	136.99	136.74	136.89	13895.0
2021-02-08 07:00:00	AAPL	Stock	136.9	136.96	136.05	136.2	292193.0
2021-02-08 08:00:00	AAPL	Stock	136.229	136.89	136.01	136.17	443663.0
2021-02-08 09:00:00	AAPL	Stock	136.15	136.35	134.92	135.69	11938513.0
2021-02-08 10:00:00	AAPL	Stock	135.68	136.68	135.6	136.61	9984024.0
2021-02-08 11:00:00	AAPL	Stock	136.62	136.9	135.84	136.231	8382279.0
2021-02-08 12:00:00	AAPL	Stock	136.235	136.54	135.84	135.979	5794369.0
2021-02-08 13:00:00	AAPL	Stock	135.975	136.3	135.8	135.933	4177130.0
2021-02-08 14:00:00	AAPL	Stock	135.938	136.32	135.89	136.32	3832018.0
2021-02-08 15:00:00	AAPL	Stock	136.32	136.96	136.14	136.901	9370437.0
2021-02-08 16:00:00	AAPL	Stock	136.905	136.91	136.6	136.72	6088233.0
2021-02-08 17:00:00	AAPL	Stock	136.71	136.74	136.65	136.68	76256.0
2021-02-08 18:00:00	AAPL	Stock	136.7	136.74	136.64	136.67	69190.0
2021-02-08 19:00:00	AAPL	Stock	136.66	136.7	136.51	136.6	82082.0
2021-02-08 04:00:00	MSFT	Stock	243.1	243.7	243.1	243.7	6366.0
2021-02-08 05:00:00	MSFT	Stock	243.56	243.77	243.3	243.51	3616.0
2021-02-08 06:00:00	MSFT	Stock	243.59	243.61	243.55	243.61	400.0
2021-02-08 07:00:00	MSFT	Stock	243.7	243.7	243.09	243.24	12410.0
2021-02-08 08:00:00	MSFT	Stock	243.36	243.55	242.64	243.4	60803.0
2021-02-08 09:00:00	MSFT	Stock	243.41	243.68	241.76	243.21	2129778.0
2021-02-08 10:00:00	MSFT	Stock	243.18	243.285	241.933	242.309	1956566.0
2021-02-08 11:00:00	MSFT	Stock	242.32	242.36	240.81	241.47	1526836.0
2021-02-08 12:00:00	MSFT	Stock	241.5	241.95	241.342	241.51	968213.0
2021-02-08 13:00:00	MSFT	Stock	241.52	242.2	241.35	241.53	916165.0
2021-02-08 14:00:00	MSFT	Stock	241.55	241.75	241.0	241.17	834959.0
2021-02-08 15:00:00	MSFT	Stock	241.15	242.57	240.99	242.47	2619888.0
2021-02-08 16:00:00	MSFT	Stock	242.47	242.47	241.07	242.4	3620965.0
2021-02-08 17:00:00	MSFT	Stock	242.3	242.45	242.14	242.32	5692.0
2021-02-08 18:00:00	MSFT	Stock	242.25	242.25	242.2	242.25	2075.0
2021-02-08 19:00:00	MSFT	Stock	242.02	242.02	241.9	242.0	1504.0
2021-02-08 04:00:00	NVDA	Stock	13.6625	13.6625	13.6625	13.6625	12440.0
2021-02-08 06:00:00	NVDA	Stock	13.6425	13.6762	13.6425	13.6762	22440.0
2021-02-08 07:00:00	NVDA	Stock	13.6425	13.6425	13.6412	13.6412	8000.0
2021-02-08 08:00:00	NVDA	Stock	13.6452	13.7528	13.6325	13.7375	1858680.0
2021-02-08 09:00:00	NVDA	Stock	13.7438	14.1922	13.725	14.1176	76999600.0
2021-02-08 10:00:00	NVDA	Stock	14.1215	14.2393	14.0333	14.2327	56738040.0
2021-02-08 11:00:00	NVDA	Stock	14.2345	14.2962	14.1205	14.277	33315640.0
2021-02-08 12:00:00	NVDA	Stock	14.2788	14.3938	14.2295	14.328	33875120.0
2021-02-08 13:00:00	NVDA	Stock	14.3285	14.375	14.263	14.2835	23154240.0
2021-02-08 14:00:00	NVDA	Stock	14.2852	14.4242	14.2798	14.3958	26922160.0
2021-02-08 15:00:00	NVDA	Stock	14.3985	14.4738	14.3955	14.4378	70574240.0
2021-02-08 16:00:00	NVDA	Stock	14.4388	14.4613	14.313	14.4555	15293440.0
2021-02-08 17:00:00	NVDA	Stock	14.4552	14.4625	14.4388	14.44	408880.0
2021-02-08 18:00:00	NVDA	Stock	14.44	14.44	14.4002	14.4388	455640.0
2021-02-08 19:00:00	NVDA	Stock	14.4332	14.4332	14.4038	14.41	351280.0
2021-02-08 04:00:00	AMZN	Stock	168.3	168.3	168.3	168.3	2540.0
2021-02-08 05:00:00	AMZN	Stock	168.149	168.149	168.149	168.149	2000.0
2021-02-08 06:00:00	AMZN	Stock	168.149	168.25	168.149	168.25	6000.0

> showing 50 of 71,349 rows — these rows as CSV

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