PREVIEW / stock_1hour / 2023-12-07

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-12-07.parquet
  size:    1.3 MB
  rows:    58,990
  symbols: 1,268

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-07 04:00:00	AAPL	Stock	192.22	192.38	191.81	192.32	10222.0
2023-12-07 05:00:00	AAPL	Stock	192.39	192.4	192.12	192.4	7716.0
2023-12-07 06:00:00	AAPL	Stock	192.27	192.36	192.22	192.29	3355.0
2023-12-07 07:00:00	AAPL	Stock	192.3	192.43	192.25	192.35	8602.0
2023-12-07 08:00:00	AAPL	Stock	192.26	193.17	191.88	192.94	91427.0
2023-12-07 09:00:00	AAPL	Stock	193.0	194.92	192.93	193.89	6636659.0
2023-12-07 10:00:00	AAPL	Stock	193.89	194.98	193.88	194.7937	5320049.0
2023-12-07 11:00:00	AAPL	Stock	194.8	194.9	194.02	194.87	3624842.0
2023-12-07 12:00:00	AAPL	Stock	194.87	195.0	194.51	194.515	3032632.0
2023-12-07 13:00:00	AAPL	Stock	194.52	194.78	194.23	194.32	2457430.0
2023-12-07 14:00:00	AAPL	Stock	194.32	194.4911	194.13	194.15	2173840.0
2023-12-07 15:00:00	AAPL	Stock	194.15	194.35	194.01	194.24	4929701.0
2023-12-07 16:00:00	AAPL	Stock	194.21	194.29	193.85	193.9625	8027061.0
2023-12-07 17:00:00	AAPL	Stock	194.0	194.14	193.97	194.06	8794.0
2023-12-07 18:00:00	AAPL	Stock	194.0616	194.17	194.06	194.1001	12194.0
2023-12-07 19:00:00	AAPL	Stock	194.11	194.15	194.05	194.0814	10968.0
2023-12-07 04:00:00	MSFT	Stock	368.58	368.58	366.0	367.39	12811.0
2023-12-07 05:00:00	MSFT	Stock	367.3	367.3	366.01	366.01	3436.0
2023-12-07 06:00:00	MSFT	Stock	366.17	366.36	365.8	365.92	6994.0
2023-12-07 07:00:00	MSFT	Stock	366.25	367.05	366.25	367.05	8393.0
2023-12-07 08:00:00	MSFT	Stock	366.21	369.0	366.21	368.14	45408.0
2023-12-07 09:00:00	MSFT	Stock	368.1	370.49	366.32	367.04	2633741.0
2023-12-07 10:00:00	MSFT	Stock	366.995	370.11	366.8	368.6748	2400881.0
2023-12-07 11:00:00	MSFT	Stock	368.68	370.59	367.71	370.59	1724414.0
2023-12-07 12:00:00	MSFT	Stock	370.6	371.25	369.86	370.44	1125824.0
2023-12-07 13:00:00	MSFT	Stock	370.43	370.8899	369.81	370.39	829048.0
2023-12-07 14:00:00	MSFT	Stock	370.34	371.22	370.2497	370.285	1083214.0
2023-12-07 15:00:00	MSFT	Stock	370.29	371.4527	370.18	370.85	2355314.0
2023-12-07 16:00:00	MSFT	Stock	370.95	370.99	370.12	370.49	4066079.0
2023-12-07 17:00:00	MSFT	Stock	370.5	370.8691	370.4	370.84	9131.0
2023-12-07 18:00:00	MSFT	Stock	370.6	370.75	370.4	370.6	5390.0
2023-12-07 19:00:00	MSFT	Stock	370.6	370.72	370.42	370.53	1880.0
2023-12-07 04:00:00	NVDA	Stock	45.503	45.534	45.25	45.5	114960.0
2023-12-07 05:00:00	NVDA	Stock	45.523	45.74	45.501	45.55	152600.0
2023-12-07 06:00:00	NVDA	Stock	45.613	45.675	45.555	45.635	80190.0
2023-12-07 07:00:00	NVDA	Stock	45.645	45.718	45.52	45.7	434250.0
2023-12-07 08:00:00	NVDA	Stock	45.528	45.787	45.336	45.732	1588680.0
2023-12-07 09:00:00	NVDA	Stock	45.731	46.247	45.604	45.723	47339740.0
2023-12-07 10:00:00	NVDA	Stock	45.735	46.437	45.69	46.31	52280310.0
2023-12-07 11:00:00	NVDA	Stock	46.3115	46.357	46.022	46.258	27188590.0
2023-12-07 12:00:00	NVDA	Stock	46.266	46.445	46.205	46.385	23065450.0
2023-12-07 13:00:00	NVDA	Stock	46.388	46.51	46.2809	46.43	22053700.0
2023-12-07 14:00:00	NVDA	Stock	46.429	46.525	46.356	46.426	22778880.0
2023-12-07 15:00:00	NVDA	Stock	46.4315	46.629	46.394	46.598	31963630.0
2023-12-07 16:00:00	NVDA	Stock	46.592	46.667	46.45	46.548	19828070.0
2023-12-07 17:00:00	NVDA	Stock	46.548	46.596	46.501	46.595	290790.0
2023-12-07 18:00:00	NVDA	Stock	46.596	46.615	46.53	46.56	257010.0
2023-12-07 19:00:00	NVDA	Stock	46.56	46.651	46.56	46.63	309140.0
2023-12-07 04:00:00	AMZN	Stock	144.79	145.12	144.45	144.91	4889.0
2023-12-07 05:00:00	AMZN	Stock	144.92	145.09	144.85	145.0	3705.0

> showing 50 of 58,990 rows — these rows as CSV

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