PREVIEW / stock_1hour / 2021-12-01

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-12-01.parquet
  size:    1.5 MB
  rows:    68,701
  symbols: 2,700

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-01 04:00:00	AAPL	Stock	167.2	168.0	166.95	167.95	70060.0
2021-12-01 05:00:00	AAPL	Stock	167.91	167.95	167.75	167.81	31399.0
2021-12-01 06:00:00	AAPL	Stock	167.8	168.09	167.65	168.09	49826.0
2021-12-01 07:00:00	AAPL	Stock	168.07	168.65	167.9	168.5	337538.0
2021-12-01 08:00:00	AAPL	Stock	168.29	168.61	164.887	167.6	914498.0
2021-12-01 09:00:00	AAPL	Stock	167.6	168.29	166.04	168.27	17740390.0
2021-12-01 10:00:00	AAPL	Stock	168.27	169.5	167.1	169.37	21014795.0
2021-12-01 11:00:00	AAPL	Stock	169.37	170.2	169.0799	169.2613	18719755.0
2021-12-01 12:00:00	AAPL	Stock	169.27	170.3	169.06	169.12	11759805.0
2021-12-01 13:00:00	AAPL	Stock	169.13	169.67	167.38	168.3836	14931299.0
2021-12-01 14:00:00	AAPL	Stock	168.38	168.39	167.01	167.18	11106461.0
2021-12-01 15:00:00	AAPL	Stock	167.17	167.4488	164.53	164.67	23709094.0
2021-12-01 16:00:00	AAPL	Stock	164.65	165.28	164.02	164.6	7791942.0
2021-12-01 17:00:00	AAPL	Stock	164.54	165.6	164.44	165.55	166078.0
2021-12-01 18:00:00	AAPL	Stock	165.55	165.85	164.91	165.76	237129.0
2021-12-01 19:00:00	AAPL	Stock	165.75	166.3	165.5	166.0	150086.0
2021-12-01 04:00:00	MSFT	Stock	335.0	336.8	335.0	336.8	4932.0
2021-12-01 05:00:00	MSFT	Stock	336.6	336.6	336.37	336.37	2694.0
2021-12-01 06:00:00	MSFT	Stock	336.57	336.88	336.39	336.86	4171.0
2021-12-01 07:00:00	MSFT	Stock	336.69	337.3	336.55	337.05	24495.0
2021-12-01 08:00:00	MSFT	Stock	336.95	337.4	335.1	335.12	45101.0
2021-12-01 09:00:00	MSFT	Stock	335.22	336.83	334.21	335.81	2463761.0
2021-12-01 10:00:00	MSFT	Stock	335.85	336.1	333.86	335.62	2470375.0
2021-12-01 11:00:00	MSFT	Stock	335.6499	338.53	334.96	337.32	2666623.0
2021-12-01 12:00:00	MSFT	Stock	337.3	339.28	335.7101	335.9	2438454.0
2021-12-01 13:00:00	MSFT	Stock	335.885	337.1099	334.21	335.725	2745946.0
2021-12-01 14:00:00	MSFT	Stock	335.71	335.94	333.834	334.61	2068858.0
2021-12-01 15:00:00	MSFT	Stock	334.66	334.87	329.39	329.98	4827187.0
2021-12-01 16:00:00	MSFT	Stock	330.08	331.21	328.98	330.15	3442812.0
2021-12-01 17:00:00	MSFT	Stock	330.08	331.2	329.99	331.2	10806.0
2021-12-01 18:00:00	MSFT	Stock	330.99	331.74	330.0	331.69	32924.0
2021-12-01 19:00:00	MSFT	Stock	331.75	331.9	330.55	331.65	16648.0
2021-12-01 04:00:00	NVDA	Stock	33.112	33.515	33.112	33.44	372690.0
2021-12-01 05:00:00	NVDA	Stock	33.405	33.457	33.26	33.35	86330.0
2021-12-01 06:00:00	NVDA	Stock	33.33	33.4	33.253	33.395	90480.0
2021-12-01 07:00:00	NVDA	Stock	33.379	33.4	33.213	33.235	837250.0
2021-12-01 08:00:00	NVDA	Stock	33.251	33.35	33.16	33.225	1058620.0
2021-12-01 09:00:00	NVDA	Stock	33.2	33.292	32.626	33.1284	46892840.0
2021-12-01 10:00:00	NVDA	Stock	33.133	33.24	32.646	33.082	59124150.0
2021-12-01 11:00:00	NVDA	Stock	33.0865	33.288	32.73	32.823	42126860.0
2021-12-01 12:00:00	NVDA	Stock	32.828	33.04	32.402	32.424	34876170.0
2021-12-01 13:00:00	NVDA	Stock	32.422	32.594	32.04	32.355	48426650.0
2021-12-01 14:00:00	NVDA	Stock	32.343	32.45	32.0	32.1626	43057030.0
2021-12-01 15:00:00	NVDA	Stock	32.166	32.212	31.38	31.397	80557590.0
2021-12-01 16:00:00	NVDA	Stock	31.4052	31.547	31.355	31.51	19551050.0
2021-12-01 17:00:00	NVDA	Stock	31.51	31.69	31.435	31.687	1328240.0
2021-12-01 18:00:00	NVDA	Stock	31.69	31.888	31.59	31.829	802900.0
2021-12-01 19:00:00	NVDA	Stock	31.812	31.84	31.718	31.775	442100.0
2021-12-01 04:00:00	AMZN	Stock	177.078	177.4185	177.078	177.4185	25800.0
2021-12-01 05:00:00	AMZN	Stock	177.475	177.48	177.4185	177.48	11180.0

> showing 50 of 68,701 rows — these rows as CSV

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