PREVIEW / stock_1hour / 2023-08-15

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-08-15.parquet
  size:    1.3 MB
  rows:    60,083
  symbols: 1,494

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-15 04:00:00	AAPL	Stock	179.4	179.4	178.63	178.97	12953.0
2023-08-15 05:00:00	AAPL	Stock	178.91	178.99	178.85	178.86	3627.0
2023-08-15 06:00:00	AAPL	Stock	178.91	178.92	178.1	178.4	34547.0
2023-08-15 07:00:00	AAPL	Stock	178.39	178.8	178.3	178.47	49890.0
2023-08-15 08:00:00	AAPL	Stock	178.58	180.17	178.25	178.79	207772.0
2023-08-15 09:00:00	AAPL	Stock	178.77	179.48	178.42	178.44	4157957.0
2023-08-15 10:00:00	AAPL	Stock	178.43	178.495	177.38	177.695	6353519.0
2023-08-15 11:00:00	AAPL	Stock	177.7	178.395	177.695	178.31	3284832.0
2023-08-15 12:00:00	AAPL	Stock	178.31	178.44	177.781	177.95	2452490.0
2023-08-15 13:00:00	AAPL	Stock	177.96	178.24	177.62	177.83	2292699.0
2023-08-15 14:00:00	AAPL	Stock	177.8391	178.235	177.74	178.0	1982133.0
2023-08-15 15:00:00	AAPL	Stock	177.99	178.075	177.05	177.48	6583416.0
2023-08-15 16:00:00	AAPL	Stock	177.485	177.58	177.35	177.4	4932072.0
2023-08-15 17:00:00	AAPL	Stock	177.41	177.45	177.36	177.41	23451.0
2023-08-15 18:00:00	AAPL	Stock	177.45	177.55	177.4	177.46	29530.0
2023-08-15 19:00:00	AAPL	Stock	177.53	177.79	177.45	177.7	29686.0
2023-08-15 04:00:00	MSFT	Stock	324.68	324.68	322.55	323.09	4831.0
2023-08-15 05:00:00	MSFT	Stock	322.92	322.92	322.43	322.5	2328.0
2023-08-15 06:00:00	MSFT	Stock	322.54	322.54	321.3	321.64	11845.0
2023-08-15 07:00:00	MSFT	Stock	321.9	322.29	321.4	321.45	13411.0
2023-08-15 08:00:00	MSFT	Stock	321.86	324.0	321.2	322.2	34732.0
2023-08-15 09:00:00	MSFT	Stock	321.81	324.9	321.81	323.66	1435805.0
2023-08-15 10:00:00	MSFT	Stock	323.61	323.67	321.1	322.19	1895376.0
2023-08-15 11:00:00	MSFT	Stock	322.195	324.937	322.19	324.85	1626410.0
2023-08-15 12:00:00	MSFT	Stock	324.855	325.09	323.7262	324.138	1122732.0
2023-08-15 13:00:00	MSFT	Stock	324.09	325.02	323.8	324.41	1067604.0
2023-08-15 14:00:00	MSFT	Stock	324.42	324.52	323.11	323.53	880598.0
2023-08-15 15:00:00	MSFT	Stock	323.53	323.5494	320.9034	321.89	2159173.0
2023-08-15 16:00:00	MSFT	Stock	321.92	321.99	321.71	321.88	2429365.0
2023-08-15 17:00:00	MSFT	Stock	321.87	321.9	321.634	321.9	9666.0
2023-08-15 18:00:00	MSFT	Stock	321.85	322.1	321.73	321.75	5208.0
2023-08-15 19:00:00	MSFT	Stock	321.85	322.29	321.85	322.15	3313.0
2023-08-15 04:00:00	NVDA	Stock	44.411	44.681	44.022	44.681	579750.0
2023-08-15 05:00:00	NVDA	Stock	44.67	44.675	44.25	44.25	387880.0
2023-08-15 06:00:00	NVDA	Stock	44.23	44.266	44.056	44.2	494420.0
2023-08-15 07:00:00	NVDA	Stock	44.2	44.583	44.141	44.3	3043510.0
2023-08-15 08:00:00	NVDA	Stock	44.276	44.793	44.105	44.535	9423360.0
2023-08-15 09:00:00	NVDA	Stock	44.535	45.268	43.948	44.031	119495210.0
2023-08-15 10:00:00	NVDA	Stock	44.0275	44.259	43.71	44.115	110201890.0
2023-08-15 11:00:00	NVDA	Stock	44.121	44.74	44.116	44.7376	74203130.0
2023-08-15 12:00:00	NVDA	Stock	44.734	44.822	44.317	44.5	52257130.0
2023-08-15 13:00:00	NVDA	Stock	44.5067	44.635	44.233	44.4735	40169570.0
2023-08-15 14:00:00	NVDA	Stock	44.4654	44.666	44.426	44.594	34333010.0
2023-08-15 15:00:00	NVDA	Stock	44.5905	44.699	43.902	43.942	73551260.0
2023-08-15 16:00:00	NVDA	Stock	43.948	43.98	43.855	43.98	16601540.0
2023-08-15 17:00:00	NVDA	Stock	43.98	44.1663	43.858	44.0533	893580.0
2023-08-15 18:00:00	NVDA	Stock	44.048	44.088	44.0	44.0496	662120.0
2023-08-15 19:00:00	NVDA	Stock	44.042	44.086	43.94	43.956	610280.0
2023-08-15 04:00:00	AMZN	Stock	140.15	140.16	139.66	140.05	13909.0
2023-08-15 05:00:00	AMZN	Stock	140.04	140.13	139.77	140.1	2098.0

> showing 50 of 60,083 rows — these rows as CSV

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