PREVIEW / stock_1hour / 2023-12-29

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-12-29.parquet
  size:    1.4 MB
  rows:    61,027
  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-29 04:00:00	AAPL	Stock	193.77	193.88	193.7	193.76	5205.0
2023-12-29 05:00:00	AAPL	Stock	193.74	193.75	193.67	193.67	600.0
2023-12-29 06:00:00	AAPL	Stock	193.75	193.75	193.67	193.75	1579.0
2023-12-29 07:00:00	AAPL	Stock	193.8	193.86	193.6	193.73	15436.0
2023-12-29 08:00:00	AAPL	Stock	193.72	193.95	193.56	193.93	57647.0
2023-12-29 09:00:00	AAPL	Stock	193.93	194.4	193.4301	193.505	2594389.0
2023-12-29 10:00:00	AAPL	Stock	193.505	193.55	192.6646	192.755	3163375.0
2023-12-29 11:00:00	AAPL	Stock	192.76	192.8667	191.89	192.3201	3371498.0
2023-12-29 12:00:00	AAPL	Stock	192.325	192.48	191.725	191.955	3559674.0
2023-12-29 13:00:00	AAPL	Stock	191.955	192.42	191.87	192.37	2702612.0
2023-12-29 14:00:00	AAPL	Stock	192.375	192.54	192.09	192.47	1897078.0
2023-12-29 15:00:00	AAPL	Stock	192.475	193.13	192.02	192.52	8024359.0
2023-12-29 16:00:00	AAPL	Stock	192.54	192.955	192.26	192.38	8783763.0
2023-12-29 17:00:00	AAPL	Stock	192.3702	192.53	192.0	192.26	90524.0
2023-12-29 18:00:00	AAPL	Stock	192.2599	192.2599	192.13	192.1894	13094.0
2023-12-29 19:00:00	AAPL	Stock	192.14	192.24	192.1	192.1501	22198.0
2023-12-29 04:00:00	MSFT	Stock	376.01	376.03	375.81	375.81	1055.0
2023-12-29 05:00:00	MSFT	Stock	375.84	375.96	375.84	375.96	510.0
2023-12-29 06:00:00	MSFT	Stock	376.2	376.25	376.15	376.23	1408.0
2023-12-29 07:00:00	MSFT	Stock	376.03	376.04	375.48	375.51	7793.0
2023-12-29 08:00:00	MSFT	Stock	375.9	376.48	375.5	375.88	19504.0
2023-12-29 09:00:00	MSFT	Stock	375.92	377.16	375.66	376.805	1369493.0
2023-12-29 10:00:00	MSFT	Stock	376.78	377.13	375.27	375.685	1413540.0
2023-12-29 11:00:00	MSFT	Stock	375.67	375.92	373.56	374.37	1191264.0
2023-12-29 12:00:00	MSFT	Stock	374.35	374.73	373.48	374.7	825014.0
2023-12-29 13:00:00	MSFT	Stock	374.68	376.05	374.64	376.04	1114623.0
2023-12-29 14:00:00	MSFT	Stock	376.04	376.72	375.72	376.67	878405.0
2023-12-29 15:00:00	MSFT	Stock	376.68	376.86	375.3109	375.98	2786611.0
2023-12-29 16:00:00	MSFT	Stock	376.01	376.56	375.89	375.9	4345928.0
2023-12-29 17:00:00	MSFT	Stock	375.93	376.2	375.75	376.2	8327.0
2023-12-29 18:00:00	MSFT	Stock	375.9985	375.9989	375.8	375.87	6182.0
2023-12-29 19:00:00	MSFT	Stock	375.81	375.88	375.63	375.65	1095.0
2023-12-29 04:00:00	NVDA	Stock	49.575	49.69	49.575	49.66	62890.0
2023-12-29 05:00:00	NVDA	Stock	49.655	49.655	49.6	49.625	80980.0
2023-12-29 06:00:00	NVDA	Stock	49.612	49.685	49.612	49.653	29140.0
2023-12-29 07:00:00	NVDA	Stock	49.665	49.74	49.665	49.7	251440.0
2023-12-29 08:00:00	NVDA	Stock	49.725	49.754	49.532	49.698	938510.0
2023-12-29 09:00:00	NVDA	Stock	49.706	49.997	49.7	49.835	36903600.0
2023-12-29 10:00:00	NVDA	Stock	49.83	49.905	49.216	49.2628	49072820.0
2023-12-29 11:00:00	NVDA	Stock	49.271	49.314	48.751	49.047	49236060.0
2023-12-29 12:00:00	NVDA	Stock	49.0462	49.16	48.9567	49.1433	23483590.0
2023-12-29 13:00:00	NVDA	Stock	49.1439	49.792	49.128	49.755	42895310.0
2023-12-29 14:00:00	NVDA	Stock	49.752	49.95	49.752	49.875	43761600.0
2023-12-29 15:00:00	NVDA	Stock	49.877	49.878	49.446	49.526	42103030.0
2023-12-29 16:00:00	NVDA	Stock	49.526	49.705	49.49	49.5	17186110.0
2023-12-29 17:00:00	NVDA	Stock	49.5	49.522	49.431	49.46	286160.0
2023-12-29 18:00:00	NVDA	Stock	49.465	49.465	49.44	49.45	112380.0
2023-12-29 19:00:00	NVDA	Stock	49.45	49.46	49.325	49.33	345000.0
2023-12-29 04:00:00	AMZN	Stock	153.51	153.53	153.3	153.42	14858.0
2023-12-29 05:00:00	AMZN	Stock	153.39	153.44	153.39	153.44	664.0

> showing 50 of 61,027 rows — these rows as CSV

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