PREVIEW / stock_1hour / 2023-12-26

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-12-26.parquet
  size:    1.4 MB
  rows:    60,125
  symbols: 1,219

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-26 04:00:00	AAPL	Stock	193.8	194.12	193.76	193.81	7117.0
2023-12-26 05:00:00	AAPL	Stock	193.83	193.92	193.83	193.84	984.0
2023-12-26 06:00:00	AAPL	Stock	193.89	193.89	193.83	193.87	944.0
2023-12-26 07:00:00	AAPL	Stock	193.85	193.88	193.7	193.87	10978.0
2023-12-26 08:00:00	AAPL	Stock	193.85	194.02	193.116	193.5294	86316.0
2023-12-26 09:00:00	AAPL	Stock	193.53	193.89	192.98	193.25	3662252.0
2023-12-26 10:00:00	AAPL	Stock	193.255	193.44	192.89	193.225	3279273.0
2023-12-26 11:00:00	AAPL	Stock	193.228	193.3	192.89	193.225	2151802.0
2023-12-26 12:00:00	AAPL	Stock	193.22	193.33	193.03	193.18	2148198.0
2023-12-26 13:00:00	AAPL	Stock	193.18	193.36	192.83	192.8898	1949029.0
2023-12-26 14:00:00	AAPL	Stock	192.89	193.14	192.87	193.045	1912916.0
2023-12-26 15:00:00	AAPL	Stock	193.05	193.49	192.92	193.04	4605179.0
2023-12-26 16:00:00	AAPL	Stock	193.07	193.11	192.86	192.9	3811671.0
2023-12-26 17:00:00	AAPL	Stock	192.9	193.05	192.87	192.9099	13110.0
2023-12-26 18:00:00	AAPL	Stock	192.92	193.0	192.89	192.9056	21391.0
2023-12-26 19:00:00	AAPL	Stock	192.93	192.95	192.86	192.9	6833.0
2023-12-26 04:00:00	MSFT	Stock	375.7	376.0	375.7	376.0	2011.0
2023-12-26 05:00:00	MSFT	Stock	375.9	375.97	375.69	375.97	1132.0
2023-12-26 06:00:00	MSFT	Stock	375.98	375.98	375.6	375.71	1218.0
2023-12-26 07:00:00	MSFT	Stock	375.5	375.7	375.07	375.7	9431.0
2023-12-26 08:00:00	MSFT	Stock	375.55	376.0	374.72	375.313	25453.0
2023-12-26 09:00:00	MSFT	Stock	375.35	376.94	374.57	375.42	1341285.0
2023-12-26 10:00:00	MSFT	Stock	375.4	375.53	374.62	374.8721	1208391.0
2023-12-26 11:00:00	MSFT	Stock	374.87	374.87	373.98	374.18	776853.0
2023-12-26 12:00:00	MSFT	Stock	374.18	374.2666	373.92	373.955	670710.0
2023-12-26 13:00:00	MSFT	Stock	373.9399	374.1	373.5	373.59	721544.0
2023-12-26 14:00:00	MSFT	Stock	373.6	374.46	373.5856	374.45	719215.0
2023-12-26 15:00:00	MSFT	Stock	374.455	374.95	373.6	374.7	1593672.0
2023-12-26 16:00:00	MSFT	Stock	374.66	374.77	374.59	374.62	2029010.0
2023-12-26 17:00:00	MSFT	Stock	374.55	374.66	374.5	374.66	1374.0
2023-12-26 18:00:00	MSFT	Stock	374.65	374.82	374.65	374.81	3247.0
2023-12-26 19:00:00	MSFT	Stock	374.82	374.82	374.66	374.66	4026.0
2023-12-26 04:00:00	NVDA	Stock	48.899	49.033	48.867	48.89	191280.0
2023-12-26 05:00:00	NVDA	Stock	48.913	48.913	48.846	48.846	31900.0
2023-12-26 06:00:00	NVDA	Stock	48.828	48.829	48.712	48.801	25740.0
2023-12-26 07:00:00	NVDA	Stock	48.799	48.98	48.799	48.98	388470.0
2023-12-26 08:00:00	NVDA	Stock	48.95	48.991	48.7989	48.886	827970.0
2023-12-26 09:00:00	NVDA	Stock	48.905	49.6	48.891	49.429	39693010.0
2023-12-26 10:00:00	NVDA	Stock	49.438	49.545	49.1975	49.252	36645680.0
2023-12-26 11:00:00	NVDA	Stock	49.257	49.482	49.21	49.4532	23028420.0
2023-12-26 12:00:00	NVDA	Stock	49.444	49.468	49.265	49.3498	18703870.0
2023-12-26 13:00:00	NVDA	Stock	49.348	49.393	49.301	49.311	12007750.0
2023-12-26 14:00:00	NVDA	Stock	49.307	49.435	49.307	49.4255	12933020.0
2023-12-26 15:00:00	NVDA	Stock	49.424	49.487	49.265	49.281	26197290.0
2023-12-26 16:00:00	NVDA	Stock	49.279	49.325	49.279	49.317	9711620.0
2023-12-26 17:00:00	NVDA	Stock	49.324	49.324	49.279	49.315	96290.0
2023-12-26 18:00:00	NVDA	Stock	49.312	49.336	49.308	49.334	144870.0
2023-12-26 19:00:00	NVDA	Stock	49.33	49.35	49.31	49.319	202240.0
2023-12-26 04:00:00	AMZN	Stock	153.55	153.8	153.42	153.77	7842.0
2023-12-26 05:00:00	AMZN	Stock	153.89	153.89	153.71	153.71	2224.0

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

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