PREVIEW / stock_1hour / 2021-12-31

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-12-31.parquet
  size:    1.4 MB
  rows:    64,310
  symbols: 2,649

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-12-31 04:00:00	AAPL	Stock	177.98	178.13	177.76	177.9	3950.0
2021-12-31 05:00:00	AAPL	Stock	177.91	177.91	177.8	177.8	786.0
2021-12-31 06:00:00	AAPL	Stock	177.8	177.99	177.8	177.83	2233.0
2021-12-31 07:00:00	AAPL	Stock	177.75	178.24	177.71	178.03	30323.0
2021-12-31 08:00:00	AAPL	Stock	177.8902	178.35	177.72	178.26	162120.0
2021-12-31 09:00:00	AAPL	Stock	178.26	179.23	177.72	177.88	5936208.0
2021-12-31 10:00:00	AAPL	Stock	177.89	178.5899	177.32	178.395	7817279.0
2021-12-31 11:00:00	AAPL	Stock	178.3908	178.43	177.64	177.705	4868915.0
2021-12-31 12:00:00	AAPL	Stock	177.71	177.84	177.26	177.56	4492042.0
2021-12-31 13:00:00	AAPL	Stock	177.56	177.91	177.355	177.55	4531417.0
2021-12-31 14:00:00	AAPL	Stock	177.55	177.75	177.29	177.605	4521085.0
2021-12-31 15:00:00	AAPL	Stock	177.61	178.27	177.44	177.61	11355065.0
2021-12-31 16:00:00	AAPL	Stock	177.61	177.8	177.45	177.5	8045804.0
2021-12-31 17:00:00	AAPL	Stock	177.48	177.57	177.48	177.55	19749.0
2021-12-31 18:00:00	AAPL	Stock	177.55	177.69	177.5	177.6	18710.0
2021-12-31 19:00:00	AAPL	Stock	177.6	177.75	177.5	177.7	16646.0
2021-12-31 04:00:00	MSFT	Stock	338.0	338.0	338.0	338.0	259.0
2021-12-31 05:00:00	MSFT	Stock	338.73	338.73	338.52	338.52	210.0
2021-12-31 07:00:00	MSFT	Stock	338.37	338.9	338.34	338.89	2456.0
2021-12-31 08:00:00	MSFT	Stock	338.14	339.3	338.14	338.9481	13442.0
2021-12-31 09:00:00	MSFT	Stock	339.32	339.355	337.14	337.35	1436137.0
2021-12-31 10:00:00	MSFT	Stock	337.38	338.11	336.14	336.9	1489916.0
2021-12-31 11:00:00	MSFT	Stock	336.89	337.0173	335.85	336.34	1397906.0
2021-12-31 12:00:00	MSFT	Stock	336.37	337.13	336.05	337.06	1016890.0
2021-12-31 13:00:00	MSFT	Stock	337.0595	338.01	336.94	337.265	891896.0
2021-12-31 14:00:00	MSFT	Stock	337.27	337.9894	336.74	337.23	1089970.0
2021-12-31 15:00:00	MSFT	Stock	337.24	337.86	336.11	336.33	2323640.0
2021-12-31 16:00:00	MSFT	Stock	336.32	336.78	336.1	336.58	4088729.0
2021-12-31 17:00:00	MSFT	Stock	336.62	336.62	336.34	336.4	3077.0
2021-12-31 18:00:00	MSFT	Stock	336.4	336.46	336.32	336.32	2044.0
2021-12-31 19:00:00	MSFT	Stock	336.44	336.79	336.44	336.79	9048.0
2021-12-31 04:00:00	NVDA	Stock	29.586	29.6	29.45	29.58	28280.0
2021-12-31 05:00:00	NVDA	Stock	29.547	29.547	29.4	29.4	36210.0
2021-12-31 06:00:00	NVDA	Stock	29.49	29.49	29.49	29.49	1180.0
2021-12-31 07:00:00	NVDA	Stock	29.451	29.661	29.45	29.638	184550.0
2021-12-31 08:00:00	NVDA	Stock	29.4338	29.802	29.4314	29.757	770760.0
2021-12-31 09:00:00	NVDA	Stock	29.76	30.03	29.57	29.7215	35047350.0
2021-12-31 10:00:00	NVDA	Stock	29.729	29.79	29.435	29.546	34109540.0
2021-12-31 11:00:00	NVDA	Stock	29.5465	29.754	29.428	29.6598	25963500.0
2021-12-31 12:00:00	NVDA	Stock	29.655	29.69	29.464	29.545	17640500.0
2021-12-31 13:00:00	NVDA	Stock	29.54	29.597	29.468	29.507	14587410.0
2021-12-31 14:00:00	NVDA	Stock	29.509	29.527	29.3306	29.422	20892200.0
2021-12-31 15:00:00	NVDA	Stock	29.423	29.575	29.372	29.411	34886950.0
2021-12-31 16:00:00	NVDA	Stock	29.411	29.479	29.38	29.445	14753350.0
2021-12-31 17:00:00	NVDA	Stock	29.441	29.441	29.4	29.425	176420.0
2021-12-31 18:00:00	NVDA	Stock	29.417	29.42	29.4	29.42	110860.0
2021-12-31 19:00:00	NVDA	Stock	29.419	29.44	29.401	29.44	139360.0
2021-12-31 06:00:00	AMZN	Stock	168.85	168.85	168.85	168.85	5840.0
2021-12-31 07:00:00	AMZN	Stock	168.75	168.8	168.75	168.75	8300.0
2021-12-31 08:00:00	AMZN	Stock	168.8491	169.1	168.775	169.1	50120.0

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

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