PREVIEW / stock_1hour / 2023-07-21

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-07-21.parquet
  size:    1.3 MB
  rows:    59,614
  symbols: 1,549

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-07-21 04:00:00	AAPL	Stock	193.13	193.36	193.04	193.18	12090.0
2023-07-21 05:00:00	AAPL	Stock	193.01	193.08	192.78	192.96	3280.0
2023-07-21 06:00:00	AAPL	Stock	192.94	193.4	192.94	193.38	5478.0
2023-07-21 07:00:00	AAPL	Stock	193.35	193.7	193.3	193.33	31589.0
2023-07-21 08:00:00	AAPL	Stock	193.335	193.9	193.0	193.82	134403.0
2023-07-21 09:00:00	AAPL	Stock	193.82	194.97	193.72	193.79	7427158.0
2023-07-21 10:00:00	AAPL	Stock	193.795	193.97	192.81	193.15	5889835.0
2023-07-21 11:00:00	AAPL	Stock	193.16	193.81	192.7	193.105	3640595.0
2023-07-21 12:00:00	AAPL	Stock	193.105	193.15	191.96	192.173	4112294.0
2023-07-21 13:00:00	AAPL	Stock	192.17	193.22	192.1	193.11	2975211.0
2023-07-21 14:00:00	AAPL	Stock	193.11	193.1849	192.39	192.59	2757022.0
2023-07-21 15:00:00	AAPL	Stock	192.59	192.69	191.23	191.93	8383097.0
2023-07-21 16:00:00	AAPL	Stock	191.93	192.32	191.91	192.3	15544678.0
2023-07-21 17:00:00	AAPL	Stock	192.29	192.2972	191.92	191.92	151786.0
2023-07-21 18:00:00	AAPL	Stock	191.98	192.07	191.93	192.0	18011.0
2023-07-21 19:00:00	AAPL	Stock	192.05	192.07	191.98	192.05	7914.0
2023-07-21 04:00:00	MSFT	Stock	347.73	348.86	347.73	348.75	7192.0
2023-07-21 05:00:00	MSFT	Stock	348.69	348.7	348.06	348.1	17813.0
2023-07-21 06:00:00	MSFT	Stock	348.17	349.7	348.1	349.42	4630.0
2023-07-21 07:00:00	MSFT	Stock	349.06	349.94	348.5	348.51	21123.0
2023-07-21 08:00:00	MSFT	Stock	349.03	349.85	347.04	349.02	112365.0
2023-07-21 09:00:00	MSFT	Stock	349.11	350.56	346.88	347.665	3538629.0
2023-07-21 10:00:00	MSFT	Stock	347.661	348.54	345.5	347.06	2877402.0
2023-07-21 11:00:00	MSFT	Stock	347.06	348.35	345.735	346.38	1801995.0
2023-07-21 12:00:00	MSFT	Stock	346.37	346.61	344.96	345.77	1790622.0
2023-07-21 13:00:00	MSFT	Stock	345.73	347.25	345.61	346.19	1742864.0
2023-07-21 14:00:00	MSFT	Stock	346.185	346.245	343.99	344.16	2400016.0
2023-07-21 15:00:00	MSFT	Stock	344.16	346.01	339.83	343.77	8936851.0
2023-07-21 16:00:00	MSFT	Stock	343.78	344.8	343.51	344.12	26653704.0
2023-07-21 17:00:00	MSFT	Stock	344.1	344.85	343.77	344.65	32635.0
2023-07-21 18:00:00	MSFT	Stock	344.65	345.2	344.45	344.51	27550.0
2023-07-21 19:00:00	MSFT	Stock	344.58	344.94	344.58	344.75	8801.0
2023-07-21 04:00:00	NVDA	Stock	45.04	45.824	45.04	45.75	165860.0
2023-07-21 05:00:00	NVDA	Stock	45.727	45.74	45.53	45.589	40170.0
2023-07-21 06:00:00	NVDA	Stock	45.589	45.81	45.589	45.772	161550.0
2023-07-21 07:00:00	NVDA	Stock	45.77	45.86	45.705	45.754	696800.0
2023-07-21 08:00:00	NVDA	Stock	45.771	45.97	45.29	45.89	1989390.0
2023-07-21 09:00:00	NVDA	Stock	45.9	46.017	44.91	44.964	60085440.0
2023-07-21 10:00:00	NVDA	Stock	44.9715	45.27	44.592	44.676	67129010.0
2023-07-21 11:00:00	NVDA	Stock	44.6772	44.958	44.58	44.697	37043180.0
2023-07-21 12:00:00	NVDA	Stock	44.6878	44.902	44.4521	44.624	35536940.0
2023-07-21 13:00:00	NVDA	Stock	44.623	45.413	44.604	45.3566	39017700.0
2023-07-21 14:00:00	NVDA	Stock	45.355	45.4063	44.642	44.676	43257150.0
2023-07-21 15:00:00	NVDA	Stock	44.6675	44.741	44.1	44.31	105363550.0
2023-07-21 16:00:00	NVDA	Stock	44.412	44.544	44.309	44.491	232983070.0
2023-07-21 17:00:00	NVDA	Stock	44.492	44.514	44.36	44.36	451750.0
2023-07-21 18:00:00	NVDA	Stock	44.38	44.446	44.366	44.43	289770.0
2023-07-21 19:00:00	NVDA	Stock	44.42	44.45	44.401	44.45	438960.0
2023-07-21 04:00:00	AMZN	Stock	131.14	131.6	131.14	131.43	20393.0
2023-07-21 05:00:00	AMZN	Stock	131.43	131.54	131.26	131.42	6576.0

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

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