PREVIEW / stock_1hour / 2023-10-25

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-10-25.parquet
  size:    1.3 MB
  rows:    57,865
  symbols: 1,351

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-10-25 04:00:00	AAPL	Stock	172.56	172.73	172.34	172.59	22174.0
2023-10-25 05:00:00	AAPL	Stock	172.56	172.62	172.28	172.54	16207.0
2023-10-25 06:00:00	AAPL	Stock	172.51	172.79	172.41	172.79	2510.0
2023-10-25 07:00:00	AAPL	Stock	172.8	172.97	172.51	172.51	9779.0
2023-10-25 08:00:00	AAPL	Stock	172.83	173.19	172.02	172.05	78189.0
2023-10-25 09:00:00	AAPL	Stock	172.05	172.11	170.95	171.27	4622025.0
2023-10-25 10:00:00	AAPL	Stock	171.28	172.96	170.83	172.145	7938231.0
2023-10-25 11:00:00	AAPL	Stock	172.145	173.06	171.715	171.74	5095669.0
2023-10-25 12:00:00	AAPL	Stock	171.74	172.0	171.33	171.92	3786579.0
2023-10-25 13:00:00	AAPL	Stock	171.92	172.05	170.77	171.125	4322901.0
2023-10-25 14:00:00	AAPL	Stock	171.12	171.6198	170.94	171.09	3647041.0
2023-10-25 15:00:00	AAPL	Stock	171.095	171.43	170.65	171.09	8133949.0
2023-10-25 16:00:00	AAPL	Stock	171.09	171.61	170.5	170.5	8029937.0
2023-10-25 17:00:00	AAPL	Stock	170.49	170.7787	170.21	170.4	57835.0
2023-10-25 18:00:00	AAPL	Stock	170.48	170.57	169.3204	169.76	140559.0
2023-10-25 19:00:00	AAPL	Stock	169.75	169.8	169.3	169.3	68645.0
2023-10-25 04:00:00	MSFT	Stock	341.72	343.04	340.79	342.42	49312.0
2023-10-25 05:00:00	MSFT	Stock	342.54	342.92	342.15	342.65	11429.0
2023-10-25 06:00:00	MSFT	Stock	342.57	343.6	341.09	343.33	39387.0
2023-10-25 07:00:00	MSFT	Stock	343.33	343.85	342.48	343.4	92760.0
2023-10-25 08:00:00	MSFT	Stock	342.7	347.3199	341.51	346.29	523561.0
2023-10-25 09:00:00	MSFT	Stock	346.11	347.0	341.6	344.65	8426279.0
2023-10-25 10:00:00	MSFT	Stock	344.63	344.68	338.62	339.54	6407802.0
2023-10-25 11:00:00	MSFT	Stock	339.53	341.57	337.62	338.07	4569580.0
2023-10-25 12:00:00	MSFT	Stock	338.095	340.21	338.02	339.59	2994116.0
2023-10-25 13:00:00	MSFT	Stock	339.59	339.67	337.82	339.3299	2958726.0
2023-10-25 14:00:00	MSFT	Stock	339.33	340.86	339.3	339.9407	3087234.0
2023-10-25 15:00:00	MSFT	Stock	339.955	341.2	339.6	340.68	5610522.0
2023-10-25 16:00:00	MSFT	Stock	340.68	341.3	338.49	338.5	4625074.0
2023-10-25 17:00:00	MSFT	Stock	338.5	340.67	338.1	338.25	392129.0
2023-10-25 18:00:00	MSFT	Stock	338.37	338.89	336.5647	338.01	30950.0
2023-10-25 19:00:00	MSFT	Stock	338.04	338.2	337.0	337.09	34896.0
2023-10-25 04:00:00	NVDA	Stock	43.388	43.456	43.25	43.4	79440.0
2023-10-25 05:00:00	NVDA	Stock	43.35	43.487	43.35	43.428	36700.0
2023-10-25 06:00:00	NVDA	Stock	43.4	43.489	43.3	43.461	42850.0
2023-10-25 07:00:00	NVDA	Stock	43.452	43.575	43.425	43.434	296650.0
2023-10-25 08:00:00	NVDA	Stock	43.545	43.5772	43.144	43.275	1292380.0
2023-10-25 09:00:00	NVDA	Stock	43.3	43.65	42.867	43.189	37219360.0
2023-10-25 10:00:00	NVDA	Stock	43.189	43.478	42.9455	43.0155	43203200.0
2023-10-25 11:00:00	NVDA	Stock	43.025	43.185	42.511	42.558	32239140.0
2023-10-25 12:00:00	NVDA	Stock	42.55	42.639	42.211	42.334	34221390.0
2023-10-25 13:00:00	NVDA	Stock	42.333	42.387	41.709	41.9875	42137840.0
2023-10-25 14:00:00	NVDA	Stock	41.9865	42.15	41.651	41.7495	36636600.0
2023-10-25 15:00:00	NVDA	Stock	41.746	41.944	41.555	41.761	47902550.0
2023-10-25 16:00:00	NVDA	Stock	41.76	41.872	41.023	41.355	21487300.0
2023-10-25 17:00:00	NVDA	Stock	41.355	41.56	41.197	41.197	1032460.0
2023-10-25 18:00:00	NVDA	Stock	41.18	41.2815	40.9	40.998	1466150.0
2023-10-25 19:00:00	NVDA	Stock	40.985	41.03	40.89	40.99	682640.0
2023-10-25 04:00:00	AMZN	Stock	126.88	127.43	126.22	126.72	30701.0
2023-10-25 05:00:00	AMZN	Stock	126.74	126.98	126.66	126.83	19845.0

> showing 50 of 57,865 rows — these rows as CSV

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