PREVIEW / stock_1hour / 2023-10-30

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-10-30.parquet
  size:    1.3 MB
  rows:    57,693
  symbols: 1,379

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-30 04:00:00	AAPL	Stock	168.98	169.0	168.6	168.99	15037.0
2023-10-30 05:00:00	AAPL	Stock	168.97	169.47	168.96	169.16	9154.0
2023-10-30 06:00:00	AAPL	Stock	169.17	169.22	168.96	169.19	36164.0
2023-10-30 07:00:00	AAPL	Stock	169.14	169.3	169.1	169.16	23572.0
2023-10-30 08:00:00	AAPL	Stock	169.16	169.28	168.35	168.58	182724.0
2023-10-30 09:00:00	AAPL	Stock	168.56	171.17	168.37	170.615	6452920.0
2023-10-30 10:00:00	AAPL	Stock	170.63	170.9	169.21	169.4414	7345137.0
2023-10-30 11:00:00	AAPL	Stock	169.44	170.2	169.425	169.92	4010897.0
2023-10-30 12:00:00	AAPL	Stock	169.91	170.0	169.05	169.37	3156864.0
2023-10-30 13:00:00	AAPL	Stock	169.37	170.4	169.1834	170.2801	3779105.0
2023-10-30 14:00:00	AAPL	Stock	170.28	170.82	170.135	170.5	3796488.0
2023-10-30 15:00:00	AAPL	Stock	170.5	170.67	169.8402	170.23	8115708.0
2023-10-30 16:00:00	AAPL	Stock	170.24	170.29	169.91	169.96	5099533.0
2023-10-30 17:00:00	AAPL	Stock	170.0	170.06	169.92	169.92	18529.0
2023-10-30 18:00:00	AAPL	Stock	169.94	169.99	169.8	169.8699	15555.0
2023-10-30 19:00:00	AAPL	Stock	169.87	169.91	169.7	169.7	21253.0
2023-10-30 04:00:00	MSFT	Stock	330.3	333.0	330.3	332.6	10242.0
2023-10-30 05:00:00	MSFT	Stock	332.85	333.55	332.85	333.4	3032.0
2023-10-30 06:00:00	MSFT	Stock	333.4	333.4	333.18	333.3	1970.0
2023-10-30 07:00:00	MSFT	Stock	333.47	333.47	332.59	333.1	17643.0
2023-10-30 08:00:00	MSFT	Stock	333.37	333.7	331.0	333.26	70019.0
2023-10-30 09:00:00	MSFT	Stock	333.27	339.45	331.83	338.15	3280894.0
2023-10-30 10:00:00	MSFT	Stock	338.18	338.45	334.06	334.78	2492143.0
2023-10-30 11:00:00	MSFT	Stock	334.74	336.41	334.02	336.03	1645500.0
2023-10-30 12:00:00	MSFT	Stock	336.044	336.05	334.64	334.95	1271291.0
2023-10-30 13:00:00	MSFT	Stock	334.965	337.41	334.69	337.12	1680143.0
2023-10-30 14:00:00	MSFT	Stock	337.125	337.35	336.205	337.0604	1272735.0
2023-10-30 15:00:00	MSFT	Stock	337.0801	338.155	336.8	337.35	2326230.0
2023-10-30 16:00:00	MSFT	Stock	337.3	337.79	337.25	337.66	2579498.0
2023-10-30 17:00:00	MSFT	Stock	337.5696	337.78	337.56	337.6801	13634.0
2023-10-30 18:00:00	MSFT	Stock	337.69	337.7999	337.1	337.5	4697.0
2023-10-30 19:00:00	MSFT	Stock	337.51	337.7	337.2	337.25	6451.0
2023-10-30 04:00:00	NVDA	Stock	40.712	41.045	40.712	40.975	95440.0
2023-10-30 05:00:00	NVDA	Stock	40.999	41.13	40.999	41.105	123270.0
2023-10-30 06:00:00	NVDA	Stock	41.076	41.084	40.95	41.06	179780.0
2023-10-30 07:00:00	NVDA	Stock	41.03	41.084	40.955	41.067	687810.0
2023-10-30 08:00:00	NVDA	Stock	41.0	41.099	40.777	40.967	1189760.0
2023-10-30 09:00:00	NVDA	Stock	40.967	41.766	40.789	41.5415	45646480.0
2023-10-30 10:00:00	NVDA	Stock	41.552	41.593	40.634	40.833	54443660.0
2023-10-30 11:00:00	NVDA	Stock	40.832	41.069	40.614	41.057	35182530.0
2023-10-30 12:00:00	NVDA	Stock	41.0514	41.0859	40.481	40.576	32882230.0
2023-10-30 13:00:00	NVDA	Stock	40.5815	41.215	40.49	41.194	34681470.0
2023-10-30 14:00:00	NVDA	Stock	41.1873	41.369	40.955	41.313	37288440.0
2023-10-30 15:00:00	NVDA	Stock	41.325	41.499	41.1284	41.159	41128250.0
2023-10-30 16:00:00	NVDA	Stock	41.161	41.175	41.0121	41.015	12101320.0
2023-10-30 17:00:00	NVDA	Stock	41.005	41.078	40.974	41.0	448930.0
2023-10-30 18:00:00	NVDA	Stock	41.001	41.045	40.935	40.9502	262600.0
2023-10-30 19:00:00	NVDA	Stock	40.96	41.02	40.95	41.01	221950.0
2023-10-30 04:00:00	AMZN	Stock	128.98	130.0	128.01	128.76	18766.0
2023-10-30 05:00:00	AMZN	Stock	128.72	129.2	128.72	129.03	10561.0

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

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