PREVIEW / stock_1hour / 2020-12-18

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-12-18.parquet
  size:    1.4 MB
  rows:    64,120
  symbols: 2,693

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-12-18 04:00:00	AAPL	Stock	128.88	129.36	128.59	129.07	17326.0
2020-12-18 05:00:00	AAPL	Stock	129.1	129.13	128.7	128.84	15391.0
2020-12-18 06:00:00	AAPL	Stock	128.89	129.2	128.6	128.84	56446.0
2020-12-18 07:00:00	AAPL	Stock	128.8	129.15	128.72	128.9	212846.0
2020-12-18 08:00:00	AAPL	Stock	128.93	129.2	128.55	129.12	737846.0
2020-12-18 09:00:00	AAPL	Stock	129.11	129.35	127.385	127.61	26168998.0
2020-12-18 10:00:00	AAPL	Stock	127.62	127.94	127.08	127.745	11618668.0
2020-12-18 11:00:00	AAPL	Stock	127.745	127.9	127.22	127.414	7456575.0
2020-12-18 12:00:00	AAPL	Stock	127.415	127.85	127.3	127.695	6534270.0
2020-12-18 13:00:00	AAPL	Stock	127.7	128.0	126.625	126.79	9509692.0
2020-12-18 14:00:00	AAPL	Stock	126.79	127.99	126.42	126.775	11279620.0
2020-12-18 15:00:00	AAPL	Stock	126.78	127.0	126.12	126.65	23117175.0
2020-12-18 16:00:00	AAPL	Stock	126.66	127.1	126.65	127.02	75514053.0
2020-12-18 17:00:00	AAPL	Stock	127.02	127.39	126.655	127.18	489763.0
2020-12-18 18:00:00	AAPL	Stock	127.18	127.18	127.01	127.09	63063.0
2020-12-18 19:00:00	AAPL	Stock	127.1	127.33	127.05	127.31	119797.0
2020-12-18 04:00:00	MSFT	Stock	219.38	219.4	219.0	219.0	1512.0
2020-12-18 05:00:00	MSFT	Stock	218.85	219.13	218.03	218.48	8959.0
2020-12-18 06:00:00	MSFT	Stock	218.5	218.84	218.33	218.5	31067.0
2020-12-18 07:00:00	MSFT	Stock	218.37	218.78	218.0	218.06	70805.0
2020-12-18 08:00:00	MSFT	Stock	218.59	219.42	218.0	218.16	235958.0
2020-12-18 09:00:00	MSFT	Stock	218.16	219.69	217.98	218.195	8475229.0
2020-12-18 10:00:00	MSFT	Stock	218.17	218.275	216.97	218.145	3674848.0
2020-12-18 11:00:00	MSFT	Stock	218.17	218.75	217.45	218.13	2615511.0
2020-12-18 12:00:00	MSFT	Stock	218.14	218.56	217.89	218.035	1720725.0
2020-12-18 13:00:00	MSFT	Stock	218.035	218.2	217.25	217.54	1731201.0
2020-12-18 14:00:00	MSFT	Stock	217.54	217.62	216.05	216.14	2386999.0
2020-12-18 15:00:00	MSFT	Stock	216.14	219.21	216.02	218.15	6272214.0
2020-12-18 16:00:00	MSFT	Stock	218.15	219.49	218.15	218.5	28112464.0
2020-12-18 17:00:00	MSFT	Stock	218.5	218.7	218.4	218.46	96496.0
2020-12-18 18:00:00	MSFT	Stock	218.34	218.59	218.34	218.59	7600.0
2020-12-18 19:00:00	MSFT	Stock	218.59	218.79	218.43	218.75	20159.0
2020-12-18 04:00:00	NVDA	Stock	13.3538	13.3538	13.332	13.3322	18600.0
2020-12-18 05:00:00	NVDA	Stock	13.3225	13.3225	13.3108	13.3108	9200.0
2020-12-18 06:00:00	NVDA	Stock	13.3108	13.3108	13.3108	13.3108	7040.0
2020-12-18 07:00:00	NVDA	Stock	13.3375	13.35	13.33	13.33	190840.0
2020-12-18 08:00:00	NVDA	Stock	13.325	13.3718	13.3225	13.3675	762920.0
2020-12-18 09:00:00	NVDA	Stock	13.362	13.405	13.259	13.2805	44227520.0
2020-12-18 10:00:00	NVDA	Stock	13.2748	13.3	13.2295	13.2765	21438360.0
2020-12-18 11:00:00	NVDA	Stock	13.2732	13.2915	13.219	13.2363	17310200.0
2020-12-18 12:00:00	NVDA	Stock	13.2322	13.2498	13.2125	13.2318	13145520.0
2020-12-18 13:00:00	NVDA	Stock	13.2368	13.25	13.1988	13.2149	15219760.0
2020-12-18 14:00:00	NVDA	Stock	13.2168	13.225	13.1714	13.1835	16312240.0
2020-12-18 15:00:00	NVDA	Stock	13.1844	13.275	13.0705	13.2653	73330240.0
2020-12-18 16:00:00	NVDA	Stock	13.272	13.272	13.2118	13.25	11297000.0
2020-12-18 17:00:00	NVDA	Stock	13.2438	13.272	13.2425	13.2438	805160.0
2020-12-18 18:00:00	NVDA	Stock	13.2438	13.2565	13.2328	13.2565	83880.0
2020-12-18 19:00:00	NVDA	Stock	13.2508	13.27	13.225	13.2688	172360.0
2020-12-18 04:00:00	AMZN	Stock	161.8	161.8	161.8	161.8	3360.0
2020-12-18 05:00:00	AMZN	Stock	161.381	161.381	161.381	161.381	4000.0

> showing 50 of 64,120 rows — these rows as CSV

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