PREVIEW / stock_1hour / 2023-12-12

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-12-12.parquet
  size:    1.3 MB
  rows:    59,425
  symbols: 1,285

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-12 04:00:00	AAPL	Stock	193.34	193.38	192.75	192.8	11752.0
2023-12-12 05:00:00	AAPL	Stock	192.8	192.84	192.29	192.54	30041.0
2023-12-12 06:00:00	AAPL	Stock	192.54	192.85	192.54	192.64	4052.0
2023-12-12 07:00:00	AAPL	Stock	192.74	193.24	192.65	193.12	31920.0
2023-12-12 08:00:00	AAPL	Stock	192.73	193.55	192.23	192.5	243985.0
2023-12-12 09:00:00	AAPL	Stock	192.55	193.39	191.721	192.415	5500631.0
2023-12-12 10:00:00	AAPL	Stock	192.4186	193.42	192.26	193.21	5773341.0
2023-12-12 11:00:00	AAPL	Stock	193.215	193.62	193.13	193.435	3479450.0
2023-12-12 12:00:00	AAPL	Stock	193.435	193.51	193.07	193.43	2262289.0
2023-12-12 13:00:00	AAPL	Stock	193.43	194.1465	193.37	194.0611	3941297.0
2023-12-12 14:00:00	AAPL	Stock	194.065	194.34	193.99	194.2428	3245662.0
2023-12-12 15:00:00	AAPL	Stock	194.25	194.72	194.21	194.67	6097478.0
2023-12-12 16:00:00	AAPL	Stock	194.71	194.8	194.56	194.7201	8194347.0
2023-12-12 17:00:00	AAPL	Stock	194.75	194.75	194.65	194.66	11782.0
2023-12-12 18:00:00	AAPL	Stock	194.67	194.79	194.67	194.7401	17039.0
2023-12-12 19:00:00	AAPL	Stock	194.78	194.83	194.6601	194.7699	14281.0
2023-12-12 04:00:00	MSFT	Stock	372.65	372.65	372.4	372.4	668.0
2023-12-12 05:00:00	MSFT	Stock	372.35	372.35	371.9	371.97	1508.0
2023-12-12 06:00:00	MSFT	Stock	372.16	372.27	372.1	372.1	586.0
2023-12-12 07:00:00	MSFT	Stock	371.99	372.0	371.6	372.0	6027.0
2023-12-12 08:00:00	MSFT	Stock	371.98	372.65	370.8	370.85	48979.0
2023-12-12 09:00:00	MSFT	Stock	370.86	372.42	369.61	371.69	2540069.0
2023-12-12 10:00:00	MSFT	Stock	371.72	372.165	370.46	371.94	2140120.0
2023-12-12 11:00:00	MSFT	Stock	371.9496	373.16	371.665	371.99	1523496.0
2023-12-12 12:00:00	MSFT	Stock	372.02	372.4099	371.24	372.3	1045620.0
2023-12-12 13:00:00	MSFT	Stock	372.3	372.94	372.1	372.54	1405855.0
2023-12-12 14:00:00	MSFT	Stock	372.525	372.75	372.2	372.5721	1357379.0
2023-12-12 15:00:00	MSFT	Stock	372.59	374.42	372.5314	374.34	2938418.0
2023-12-12 16:00:00	MSFT	Stock	374.38	374.95	374.26	374.5801	4284258.0
2023-12-12 17:00:00	MSFT	Stock	374.58	374.7	374.41	374.41	15740.0
2023-12-12 18:00:00	MSFT	Stock	374.41	375.19	374.41	375.19	25775.0
2023-12-12 19:00:00	MSFT	Stock	375.19	375.55	374.63	374.7	9450.0
2023-12-12 04:00:00	NVDA	Stock	46.619	46.925	46.619	46.896	111170.0
2023-12-12 05:00:00	NVDA	Stock	46.865	46.876	46.775	46.8	23290.0
2023-12-12 06:00:00	NVDA	Stock	46.8	46.82	46.786	46.82	17160.0
2023-12-12 07:00:00	NVDA	Stock	46.791	46.818	46.759	46.81	255640.0
2023-12-12 08:00:00	NVDA	Stock	46.785	46.875	46.15	46.2	2912440.0
2023-12-12 09:00:00	NVDA	Stock	46.178	47.421	45.945	47.3255	63707180.0
2023-12-12 10:00:00	NVDA	Stock	47.3255	47.373	46.805	47.1752	58832150.0
2023-12-12 11:00:00	NVDA	Stock	47.18	47.3	47.002	47.014	35106250.0
2023-12-12 12:00:00	NVDA	Stock	47.008	47.0302	46.834	46.971	22506650.0
2023-12-12 13:00:00	NVDA	Stock	46.962	47.181	46.907	47.1582	20432590.0
2023-12-12 14:00:00	NVDA	Stock	47.16	47.465	47.1	47.431	29798840.0
2023-12-12 15:00:00	NVDA	Stock	47.436	47.666	47.37	47.6584	36740380.0
2023-12-12 16:00:00	NVDA	Stock	47.657	47.719	47.493	47.694	16827390.0
2023-12-12 17:00:00	NVDA	Stock	47.685	47.69	47.582	47.6	271770.0
2023-12-12 18:00:00	NVDA	Stock	47.6	47.66	47.595	47.64	215390.0
2023-12-12 19:00:00	NVDA	Stock	47.635	47.64	47.6051	47.614	288060.0
2023-12-12 04:00:00	AMZN	Stock	146.1	146.43	146.0	146.43	6421.0
2023-12-12 05:00:00	AMZN	Stock	146.16	146.3	146.16	146.25	2294.0

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

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