PREVIEW / stock_1hour / 2020-11-19

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-11-19.parquet
  size:    1.3 MB
  rows:    59,524
  symbols: 2,570

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
2020-11-19 04:00:00	AAPL	Stock	117.4	117.7	117.4	117.61	16517.0
2020-11-19 05:00:00	AAPL	Stock	117.61	117.75	117.52	117.73	3202.0
2020-11-19 06:00:00	AAPL	Stock	117.76	117.79	117.51	117.65	21444.0
2020-11-19 07:00:00	AAPL	Stock	117.71	118.03	117.71	117.91	137570.0
2020-11-19 08:00:00	AAPL	Stock	117.9	118.2	117.75	117.99	324431.0
2020-11-19 09:00:00	AAPL	Stock	118.0	118.18	116.81	117.944	13852422.0
2020-11-19 10:00:00	AAPL	Stock	117.95	118.3	117.5	117.76	9858719.0
2020-11-19 11:00:00	AAPL	Stock	117.775	118.38	117.65	118.13	6884317.0
2020-11-19 12:00:00	AAPL	Stock	118.135	118.35	117.57	117.729	6007065.0
2020-11-19 13:00:00	AAPL	Stock	117.723	118.14	117.54	118.098	5218631.0
2020-11-19 14:00:00	AAPL	Stock	118.096	118.7	117.9	118.63	6486763.0
2020-11-19 15:00:00	AAPL	Stock	118.64	119.05	118.43	118.64	9963417.0
2020-11-19 16:00:00	AAPL	Stock	118.64	118.9	118.45	118.49	6274160.0
2020-11-19 17:00:00	AAPL	Stock	118.47	118.64	118.41	118.51	159642.0
2020-11-19 18:00:00	AAPL	Stock	118.51	118.51	118.08	118.2	176388.0
2020-11-19 19:00:00	AAPL	Stock	118.18	118.4	118.15	118.32	88819.0
2020-11-19 04:00:00	MSFT	Stock	210.4	210.8	210.0	210.27	4675.0
2020-11-19 05:00:00	MSFT	Stock	210.89	210.99	210.65	210.65	481.0
2020-11-19 06:00:00	MSFT	Stock	210.5	210.7	210.31	210.7	4081.0
2020-11-19 07:00:00	MSFT	Stock	210.89	211.06	210.66	210.85	16591.0
2020-11-19 08:00:00	MSFT	Stock	210.8	211.39	210.5	211.24	81859.0
2020-11-19 09:00:00	MSFT	Stock	211.37	212.37	210.02	212.23	2662380.0
2020-11-19 10:00:00	MSFT	Stock	212.25	212.6	209.93	211.22	4306067.0
2020-11-19 11:00:00	MSFT	Stock	211.25	211.48	210.6	211.315	1688107.0
2020-11-19 12:00:00	MSFT	Stock	211.31	212.43	211.2	211.28	1811436.0
2020-11-19 13:00:00	MSFT	Stock	211.26	212.37	211.03	212.191	1056297.0
2020-11-19 14:00:00	MSFT	Stock	212.199	212.99	212.03	212.99	1323488.0
2020-11-19 15:00:00	MSFT	Stock	212.99	213.03	212.27	212.31	2780173.0
2020-11-19 16:00:00	MSFT	Stock	212.42	212.7	212.15	212.24	3839794.0
2020-11-19 17:00:00	MSFT	Stock	212.15	212.42	212.15	212.3	42004.0
2020-11-19 18:00:00	MSFT	Stock	212.17	212.17	211.7	211.81	12984.0
2020-11-19 19:00:00	MSFT	Stock	211.99	212.15	211.65	211.85	11418.0
2020-11-19 04:00:00	NVDA	Stock	13.16	13.2	13.15	13.1925	100520.0
2020-11-19 05:00:00	NVDA	Stock	13.175	13.2065	13.175	13.2065	16640.0
2020-11-19 06:00:00	NVDA	Stock	13.225	13.2748	13.2	13.2748	215000.0
2020-11-19 07:00:00	NVDA	Stock	13.25	13.2745	13.1523	13.235	2813560.0
2020-11-19 08:00:00	NVDA	Stock	13.2425	13.375	13.1555	13.2875	5848360.0
2020-11-19 09:00:00	NVDA	Stock	13.275	13.4062	13.1	13.2392	140868560.0
2020-11-19 10:00:00	NVDA	Stock	13.2423	13.2769	13.1782	13.201	75201560.0
2020-11-19 11:00:00	NVDA	Stock	13.1995	13.3625	13.1568	13.319	67199240.0
2020-11-19 12:00:00	NVDA	Stock	13.321	13.4348	13.2882	13.3828	48337880.0
2020-11-19 13:00:00	NVDA	Stock	13.3828	13.4835	13.35	13.4708	43825520.0
2020-11-19 14:00:00	NVDA	Stock	13.4741	13.4875	13.4062	13.4525	37109880.0
2020-11-19 15:00:00	NVDA	Stock	13.4525	13.4542	13.3923	13.4462	46308320.0
2020-11-19 16:00:00	NVDA	Stock	13.4402	13.4613	13.42	13.42	4200240.0
2020-11-19 17:00:00	NVDA	Stock	13.4155	13.4402	13.3838	13.4138	567360.0
2020-11-19 18:00:00	NVDA	Stock	13.415	13.415	13.33	13.3452	887840.0
2020-11-19 19:00:00	NVDA	Stock	13.349	13.375	13.3363	13.3382	643680.0
2020-11-19 04:00:00	AMZN	Stock	155.25	155.25	155.25	155.25	2000.0
2020-11-19 05:00:00	AMZN	Stock	155.25	155.25	155.25	155.25	2000.0

> showing 50 of 59,524 rows — these rows as CSV

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