PREVIEW / stock_1hour / 2023-06-28

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-06-28.parquet
  size:    1.3 MB
  rows:    59,879
  symbols: 1,567

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-06-28 04:00:00	AAPL	Stock	187.98	188.3	187.86	187.91	12580.0
2023-06-28 05:00:00	AAPL	Stock	187.9	187.95	187.72	187.8	14373.0
2023-06-28 06:00:00	AAPL	Stock	187.8	187.8	187.7	187.78	16494.0
2023-06-28 07:00:00	AAPL	Stock	187.9	187.93	187.6	187.6	44519.0
2023-06-28 08:00:00	AAPL	Stock	187.9	188.14	187.6	187.81	146442.0
2023-06-28 09:00:00	AAPL	Stock	187.85	188.63	187.6	188.16	5654334.0
2023-06-28 10:00:00	AAPL	Stock	188.165	189.34	187.8	189.1378	6489685.0
2023-06-28 11:00:00	AAPL	Stock	189.14	189.56	188.945	189.3824	4610400.0
2023-06-28 12:00:00	AAPL	Stock	189.38	189.9	188.285	188.525	4819536.0
2023-06-28 13:00:00	AAPL	Stock	188.52	189.2299	188.34	188.95	3347524.0
2023-06-28 14:00:00	AAPL	Stock	188.955	189.53	188.9	188.96	3232139.0
2023-06-28 15:00:00	AAPL	Stock	188.97	189.29	188.365	189.28	7130146.0
2023-06-28 16:00:00	AAPL	Stock	189.29	189.65	189.01	189.26	5819704.0
2023-06-28 17:00:00	AAPL	Stock	189.22	189.29	189.13	189.2	26307.0
2023-06-28 18:00:00	AAPL	Stock	189.18	189.75	189.18	189.71	30289.0
2023-06-28 19:00:00	AAPL	Stock	189.73	189.74	189.5	189.6594	29357.0
2023-06-28 04:00:00	MSFT	Stock	334.57	335.5	334.29	335.19	7864.0
2023-06-28 05:00:00	MSFT	Stock	335.06	335.24	334.5	334.65	6212.0
2023-06-28 06:00:00	MSFT	Stock	335.28	335.7	335.23	335.7	2322.0
2023-06-28 07:00:00	MSFT	Stock	335.37	336.89	335.26	335.26	21413.0
2023-06-28 08:00:00	MSFT	Stock	335.65	336.88	334.0	335.22	44196.0
2023-06-28 09:00:00	MSFT	Stock	335.17	336.81	333.9	335.52	1717049.0
2023-06-28 10:00:00	MSFT	Stock	335.5	337.98	333.935	337.27	2070278.0
2023-06-28 11:00:00	MSFT	Stock	337.28	337.87	335.23	337.1399	1261408.0
2023-06-28 12:00:00	MSFT	Stock	337.11	337.94	334.57	335.0484	1358238.0
2023-06-28 13:00:00	MSFT	Stock	335.0	335.64	334.46	335.2	1595564.0
2023-06-28 14:00:00	MSFT	Stock	335.29	336.18	335.0	335.15	1127601.0
2023-06-28 15:00:00	MSFT	Stock	335.19	335.95	333.81	335.89	2214185.0
2023-06-28 16:00:00	MSFT	Stock	335.93	337.19	335.85	336.3353	2286508.0
2023-06-28 17:00:00	MSFT	Stock	336.54	336.8263	336.04	336.04	2872.0
2023-06-28 18:00:00	MSFT	Stock	336.75	337.1931	336.6	337.1931	9026.0
2023-06-28 19:00:00	MSFT	Stock	337.02	337.29	336.28	336.32	8656.0
2023-06-28 04:00:00	NVDA	Stock	40.988	41.088	39.65	39.975	2919170.0
2023-06-28 05:00:00	NVDA	Stock	39.952	40.2	39.9	40.168	621790.0
2023-06-28 06:00:00	NVDA	Stock	40.16	40.397	40.1	40.37	873000.0
2023-06-28 07:00:00	NVDA	Stock	40.354	40.722	40.351	40.46	3370760.0
2023-06-28 08:00:00	NVDA	Stock	40.48	40.709	39.8282	40.5	6494860.0
2023-06-28 09:00:00	NVDA	Stock	40.499	41.202	40.4	40.9891	77268040.0
2023-06-28 10:00:00	NVDA	Stock	40.985	41.74	40.738	41.526	82962700.0
2023-06-28 11:00:00	NVDA	Stock	41.538	41.664	41.286	41.579	45341600.0
2023-06-28 12:00:00	NVDA	Stock	41.574	41.845	40.817	41.0317	82422210.0
2023-06-28 13:00:00	NVDA	Stock	41.03	41.326	40.962	41.239	39148390.0
2023-06-28 14:00:00	NVDA	Stock	41.2365	41.4975	41.225	41.382	34199320.0
2023-06-28 15:00:00	NVDA	Stock	41.385	41.401	40.973	41.139	53989020.0
2023-06-28 16:00:00	NVDA	Stock	41.148	41.36	41.117	41.22	18091200.0
2023-06-28 17:00:00	NVDA	Stock	41.217	41.239	41.165	41.2	376310.0
2023-06-28 18:00:00	NVDA	Stock	41.19	41.32	41.19	41.26	503240.0
2023-06-28 19:00:00	NVDA	Stock	41.245	41.4	41.241	41.36	882870.0
2023-06-28 04:00:00	AMZN	Stock	129.18	129.65	129.01	129.62	14227.0
2023-06-28 05:00:00	AMZN	Stock	129.7	129.7	129.38	129.4	6935.0

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

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