PREVIEW / stock_1hour / 2023-06-22

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-06-22.parquet
  size:    1.3 MB
  rows:    59,514
  symbols: 1,584

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
2023-06-22 04:00:00	AAPL	Stock	183.66	183.78	183.3	183.4	11459.0
2023-06-22 05:00:00	AAPL	Stock	183.4	183.77	183.4	183.55	5919.0
2023-06-22 06:00:00	AAPL	Stock	183.55	183.6	183.25	183.5	13774.0
2023-06-22 07:00:00	AAPL	Stock	183.58	183.58	183.2	183.38	23597.0
2023-06-22 08:00:00	AAPL	Stock	183.4383	183.96	183.07	183.42	149607.0
2023-06-22 09:00:00	AAPL	Stock	183.396	185.555	183.16	185.4399	5962125.0
2023-06-22 10:00:00	AAPL	Stock	185.44	185.99	185.02	185.93	6793338.0
2023-06-22 11:00:00	AAPL	Stock	185.93	186.73	185.895	186.34	6280920.0
2023-06-22 12:00:00	AAPL	Stock	186.35	186.36	185.732	186.13	3102749.0
2023-06-22 13:00:00	AAPL	Stock	186.135	186.49	185.6	186.445	3204927.0
2023-06-22 14:00:00	AAPL	Stock	186.445	186.73	186.21	186.7011	3294515.0
2023-06-22 15:00:00	AAPL	Stock	186.71	187.045	186.2832	186.97	7473655.0
2023-06-22 16:00:00	AAPL	Stock	186.96	187.24	186.93	187.1026	5789679.0
2023-06-22 17:00:00	AAPL	Stock	187.14	187.24	187.08	187.19	58851.0
2023-06-22 18:00:00	AAPL	Stock	187.19	187.22	187.12	187.18	31291.0
2023-06-22 19:00:00	AAPL	Stock	187.2	187.21	187.01	187.02	42941.0
2023-06-22 04:00:00	MSFT	Stock	333.1	333.79	333.0	333.39	8850.0
2023-06-22 05:00:00	MSFT	Stock	333.49	334.36	333.49	333.99	3414.0
2023-06-22 06:00:00	MSFT	Stock	333.98	334.18	333.61	333.9	5061.0
2023-06-22 07:00:00	MSFT	Stock	333.8	335.05	333.8	334.8	20594.0
2023-06-22 08:00:00	MSFT	Stock	333.81	335.5	333.12	334.39	46365.0
2023-06-22 09:00:00	MSFT	Stock	334.39	337.385	333.34	336.71	2515513.0
2023-06-22 10:00:00	MSFT	Stock	336.68	338.56	335.45	335.885	2831224.0
2023-06-22 11:00:00	MSFT	Stock	335.87	338.755	335.86	338.05	1890510.0
2023-06-22 12:00:00	MSFT	Stock	338.04	338.06	336.7	337.12	1146060.0
2023-06-22 13:00:00	MSFT	Stock	337.12	338.19	336.18	338.1	1211115.0
2023-06-22 14:00:00	MSFT	Stock	338.13	339.04	337.82	338.934	1593664.0
2023-06-22 15:00:00	MSFT	Stock	338.94	340.12	338.38	339.69	2706565.0
2023-06-22 16:00:00	MSFT	Stock	339.71	340.15	339.4	339.95	2506447.0
2023-06-22 17:00:00	MSFT	Stock	339.82	340.3197	339.75	340.1	11435.0
2023-06-22 18:00:00	MSFT	Stock	340.25	340.48	340.1	340.3172	6343.0
2023-06-22 19:00:00	MSFT	Stock	340.13	340.5	339.71	339.71	10631.0
2023-06-22 04:00:00	NVDA	Stock	42.55	42.76	42.447	42.542	286910.0
2023-06-22 05:00:00	NVDA	Stock	42.622	42.767	42.622	42.735	51390.0
2023-06-22 06:00:00	NVDA	Stock	42.76	42.764	42.4	42.511	239380.0
2023-06-22 07:00:00	NVDA	Stock	42.511	42.579	42.468	42.525	642220.0
2023-06-22 08:00:00	NVDA	Stock	42.475	43.045	42.401	42.525	2132440.0
2023-06-22 09:00:00	NVDA	Stock	42.517	42.997	42.2	42.878	53760260.0
2023-06-22 10:00:00	NVDA	Stock	42.874	43.319	42.704	42.8715	65068020.0
2023-06-22 11:00:00	NVDA	Stock	42.869	43.4255	42.861	43.38	46638030.0
2023-06-22 12:00:00	NVDA	Stock	43.383	43.3843	43.041	43.126	28137620.0
2023-06-22 13:00:00	NVDA	Stock	43.128	43.17	42.836	43.163	27492200.0
2023-06-22 14:00:00	NVDA	Stock	43.166	43.1888	42.87	43.066	22335340.0
2023-06-22 15:00:00	NVDA	Stock	43.065	43.1133	42.6528	43.031	48135160.0
2023-06-22 16:00:00	NVDA	Stock	43.02	43.162	42.985	43.091	17831710.0
2023-06-22 17:00:00	NVDA	Stock	43.085	43.125	43.064	43.09	205950.0
2023-06-22 18:00:00	NVDA	Stock	43.106	43.12	43.08	43.0898	206950.0
2023-06-22 19:00:00	NVDA	Stock	43.09	43.15	43.074	43.121	444030.0
2023-06-22 04:00:00	AMZN	Stock	124.41	124.49	124.06	124.24	13629.0
2023-06-22 05:00:00	AMZN	Stock	124.12	124.4	124.11	124.4	2895.0

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

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