PREVIEW / stock_1hour / 2023-08-18

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-08-18.parquet
  size:    1.3 MB
  rows:    59,206
  symbols: 1,444

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-08-18 04:00:00	AAPL	Stock	173.4	173.83	173.37	173.5	17190.0
2023-08-18 05:00:00	AAPL	Stock	173.55	173.62	173.03	173.16	13576.0
2023-08-18 06:00:00	AAPL	Stock	173.16	173.28	172.89	173.03	24435.0
2023-08-18 07:00:00	AAPL	Stock	173.1	173.12	171.96	172.36	165654.0
2023-08-18 08:00:00	AAPL	Stock	173.01	174.0	171.93	172.5	382462.0
2023-08-18 09:00:00	AAPL	Stock	172.47	173.35	171.7	172.48	7536235.0
2023-08-18 10:00:00	AAPL	Stock	172.46	173.77	172.4314	173.71	7068095.0
2023-08-18 11:00:00	AAPL	Stock	173.7059	174.37	173.281	174.315	4551637.0
2023-08-18 12:00:00	AAPL	Stock	174.3	174.44	173.7401	173.9782	3824222.0
2023-08-18 13:00:00	AAPL	Stock	173.98	174.47	173.8201	174.41	3465806.0
2023-08-18 14:00:00	AAPL	Stock	174.41	174.88	174.295	174.42	3961397.0
2023-08-18 15:00:00	AAPL	Stock	174.425	175.1	174.095	174.49	7482159.0
2023-08-18 16:00:00	AAPL	Stock	174.5	174.65	174.27	174.36	8716070.0
2023-08-18 17:00:00	AAPL	Stock	174.34	174.58	174.33	174.57	20465.0
2023-08-18 18:00:00	AAPL	Stock	174.56	174.6	174.49	174.5	14237.0
2023-08-18 19:00:00	AAPL	Stock	174.5	174.7	174.47	174.7	33937.0
2023-08-18 04:00:00	MSFT	Stock	315.65	315.99	314.99	315.3	7500.0
2023-08-18 05:00:00	MSFT	Stock	315.5	315.84	314.99	315.28	2680.0
2023-08-18 06:00:00	MSFT	Stock	315.16	315.41	314.52	314.52	2006.0
2023-08-18 07:00:00	MSFT	Stock	314.77	314.77	312.81	313.41	25006.0
2023-08-18 08:00:00	MSFT	Stock	314.73	315.99	312.65	313.31	69046.0
2023-08-18 09:00:00	MSFT	Stock	313.3	315.2	311.95	313.3101	3274675.0
2023-08-18 10:00:00	MSFT	Stock	313.31	314.46	311.5508	314.27	2503880.0
2023-08-18 11:00:00	MSFT	Stock	314.3	316.46	314.066	316.3	2034940.0
2023-08-18 12:00:00	MSFT	Stock	316.28	316.91	315.21	315.6699	1620001.0
2023-08-18 13:00:00	MSFT	Stock	315.6	316.81	314.95	316.34	1213772.0
2023-08-18 14:00:00	MSFT	Stock	316.33	316.91	315.62	316.02	866775.0
2023-08-18 15:00:00	MSFT	Stock	316.0	318.38	315.39	316.53	2742543.0
2023-08-18 16:00:00	MSFT	Stock	316.53	317.75	315.92	316.7	3011233.0
2023-08-18 17:00:00	MSFT	Stock	316.71	316.984	316.49	316.49	5533.0
2023-08-18 18:00:00	MSFT	Stock	316.57	316.9699	316.52	316.7	4706.0
2023-08-18 19:00:00	MSFT	Stock	316.7	316.93	316.46	316.93	2012.0
2023-08-18 04:00:00	NVDA	Stock	43.1	43.21	43.098	43.137	103480.0
2023-08-18 05:00:00	NVDA	Stock	43.131	43.131	42.763	42.929	177040.0
2023-08-18 06:00:00	NVDA	Stock	42.931	43.026	42.877	42.898	86100.0
2023-08-18 07:00:00	NVDA	Stock	42.898	42.917	42.592	42.79	1402050.0
2023-08-18 08:00:00	NVDA	Stock	42.87	43.62	42.58	42.661	3615220.0
2023-08-18 09:00:00	NVDA	Stock	42.655	42.865	41.825	41.8695	75844970.0
2023-08-18 10:00:00	NVDA	Stock	41.874	42.32	41.66	42.2016	85229830.0
2023-08-18 11:00:00	NVDA	Stock	42.2	42.849	42.2	42.7657	67580490.0
2023-08-18 12:00:00	NVDA	Stock	42.768	43.141	42.7199	42.9958	57062910.0
2023-08-18 13:00:00	NVDA	Stock	43.003	43.189	42.782	43.037	43362480.0
2023-08-18 14:00:00	NVDA	Stock	43.0438	43.514	42.992	43.312	52034700.0
2023-08-18 15:00:00	NVDA	Stock	43.322	43.578	43.135	43.288	65945830.0
2023-08-18 16:00:00	NVDA	Stock	43.299	43.46	43.22	43.415	17159480.0
2023-08-18 17:00:00	NVDA	Stock	43.418	43.48	43.402	43.472	431870.0
2023-08-18 18:00:00	NVDA	Stock	43.475	43.5	43.452	43.47	432190.0
2023-08-18 19:00:00	NVDA	Stock	43.49	43.587	43.47	43.525	435410.0
2023-08-18 04:00:00	AMZN	Stock	133.08	133.33	132.63	133.07	22035.0
2023-08-18 05:00:00	AMZN	Stock	133.07	133.1	132.8	132.92	14428.0

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

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