PREVIEW / stock_1hour / 2023-12-28

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-12-28.parquet
  size:    1.4 MB
  rows:    60,726
  symbols: 1,236

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-12-28 04:00:00	AAPL	Stock	193.5	194.0	193.5	193.6	6430.0
2023-12-28 05:00:00	AAPL	Stock	193.6	193.83	193.6	193.8	4810.0
2023-12-28 06:00:00	AAPL	Stock	193.83	193.85	193.73	193.73	2843.0
2023-12-28 07:00:00	AAPL	Stock	193.75	193.75	193.56	193.64	14474.0
2023-12-28 08:00:00	AAPL	Stock	193.69	193.76	193.5142	193.65	71068.0
2023-12-28 09:00:00	AAPL	Stock	193.63	194.66	193.4	194.095	4409634.0
2023-12-28 10:00:00	AAPL	Stock	194.095	194.48	193.73	194.21	3895276.0
2023-12-28 11:00:00	AAPL	Stock	194.2112	194.22	193.89	194.13	2513479.0
2023-12-28 12:00:00	AAPL	Stock	194.125	194.43	193.89	193.98	2082974.0
2023-12-28 13:00:00	AAPL	Stock	193.975	193.98	193.58	193.8706	2565917.0
2023-12-28 14:00:00	AAPL	Stock	193.875	194.09	193.865	193.9741	1881975.0
2023-12-28 15:00:00	AAPL	Stock	193.97	193.97	193.17	193.58	5919286.0
2023-12-28 16:00:00	AAPL	Stock	193.58	193.92	193.58	193.75	4207127.0
2023-12-28 17:00:00	AAPL	Stock	193.73	193.77	193.58	193.68	52097.0
2023-12-28 18:00:00	AAPL	Stock	193.67	193.67	193.58	193.6	27130.0
2023-12-28 19:00:00	AAPL	Stock	193.6	193.7991	193.6	193.78	6956.0
2023-12-28 04:00:00	MSFT	Stock	374.5	375.0	374.5	374.94	3152.0
2023-12-28 05:00:00	MSFT	Stock	374.89	374.89	374.81	374.81	433.0
2023-12-28 06:00:00	MSFT	Stock	374.83	374.83	374.83	374.83	439.0
2023-12-28 07:00:00	MSFT	Stock	374.85	375.37	374.85	375.35	4511.0
2023-12-28 08:00:00	MSFT	Stock	374.8	375.4	374.07	374.92	46901.0
2023-12-28 09:00:00	MSFT	Stock	375.0	376.458	374.76	374.895	1396035.0
2023-12-28 10:00:00	MSFT	Stock	374.92	375.3695	374.16	375.24	1261487.0
2023-12-28 11:00:00	MSFT	Stock	375.21	375.44	374.53	375.09	763533.0
2023-12-28 12:00:00	MSFT	Stock	375.1	376.05	375.05	375.95	722920.0
2023-12-28 13:00:00	MSFT	Stock	375.95	376.01	375.315	375.66	735072.0
2023-12-28 14:00:00	MSFT	Stock	375.68	376.21	375.64	376.06	702146.0
2023-12-28 15:00:00	MSFT	Stock	376.06	376.3	375.18	375.25	2370127.0
2023-12-28 16:00:00	MSFT	Stock	375.31	376.28	375.28	375.8986	2175106.0
2023-12-28 17:00:00	MSFT	Stock	375.9	375.95	375.28	375.8	11763.0
2023-12-28 18:00:00	MSFT	Stock	375.81	376.0	375.8	375.92	18610.0
2023-12-28 19:00:00	MSFT	Stock	375.98	376.0	375.91	376.0	6500.0
2023-12-28 04:00:00	NVDA	Stock	49.675	49.675	49.551	49.571	53560.0
2023-12-28 05:00:00	NVDA	Stock	49.58	49.616	49.572	49.572	29290.0
2023-12-28 06:00:00	NVDA	Stock	49.582	49.594	49.57	49.58	20580.0
2023-12-28 07:00:00	NVDA	Stock	49.57	49.594	49.56	49.588	105920.0
2023-12-28 08:00:00	NVDA	Stock	49.588	49.75	49.417	49.634	1091240.0
2023-12-28 09:00:00	NVDA	Stock	49.6312	49.772	49.412	49.53	35074610.0
2023-12-28 10:00:00	NVDA	Stock	49.525	49.849	49.42	49.7502	40598630.0
2023-12-28 11:00:00	NVDA	Stock	49.75	49.782	49.5691	49.616	23361110.0
2023-12-28 12:00:00	NVDA	Stock	49.6175	49.884	49.616	49.778	24818510.0
2023-12-28 13:00:00	NVDA	Stock	49.777	49.8	49.637	49.678	15039210.0
2023-12-28 14:00:00	NVDA	Stock	49.683	49.73	49.526	49.558	13297320.0
2023-12-28 15:00:00	NVDA	Stock	49.563	49.706	49.47	49.52	25611450.0
2023-12-28 16:00:00	NVDA	Stock	49.52	49.598	49.505	49.59	10523730.0
2023-12-28 17:00:00	NVDA	Stock	49.597	49.63	49.522	49.56	342300.0
2023-12-28 18:00:00	NVDA	Stock	49.56	49.577	49.551	49.57	99250.0
2023-12-28 19:00:00	NVDA	Stock	49.57	49.59	49.555	49.57	170840.0
2023-12-28 04:00:00	AMZN	Stock	153.8	153.8	153.7	153.7	4429.0
2023-12-28 05:00:00	AMZN	Stock	153.75	153.85	153.75	153.85	3570.0

> showing 50 of 60,726 rows — these rows as CSV

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