PREVIEW / stock_1hour / 2023-07-07

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-07-07.parquet
  size:    1.3 MB
  rows:    58,865
  symbols: 1,519

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-07 04:00:00	AAPL	Stock	192.4	192.46	191.3	191.79	10356.0
2023-07-07 05:00:00	AAPL	Stock	191.75	191.8	191.65	191.73	6399.0
2023-07-07 06:00:00	AAPL	Stock	191.73	191.73	191.44	191.61	6868.0
2023-07-07 07:00:00	AAPL	Stock	191.65	191.76	191.56	191.56	37436.0
2023-07-07 08:00:00	AAPL	Stock	191.63	192.44	191.45	191.85	329538.0
2023-07-07 09:00:00	AAPL	Stock	191.75	191.93	190.71	191.535	5410993.0
2023-07-07 10:00:00	AAPL	Stock	191.535	191.72	190.24	190.6899	5305175.0
2023-07-07 11:00:00	AAPL	Stock	190.68	191.78	190.675	191.7525	3869585.0
2023-07-07 12:00:00	AAPL	Stock	191.76	192.53	191.76	192.31	4610195.0
2023-07-07 13:00:00	AAPL	Stock	192.31	192.67	192.16	192.315	3323929.0
2023-07-07 14:00:00	AAPL	Stock	192.32	192.5	192.17	192.265	2509032.0
2023-07-07 15:00:00	AAPL	Stock	192.26	192.38	190.6	190.71	7066791.0
2023-07-07 16:00:00	AAPL	Stock	190.71	190.85	190.5	190.75	6317933.0
2023-07-07 17:00:00	AAPL	Stock	190.75	190.85	190.75	190.81	9158.0
2023-07-07 18:00:00	AAPL	Stock	190.81	190.97	190.81	190.97	13463.0
2023-07-07 19:00:00	AAPL	Stock	190.93	190.99	190.88	190.89	11602.0
2023-07-07 04:00:00	MSFT	Stock	340.71	341.0	340.0	341.0	5354.0
2023-07-07 05:00:00	MSFT	Stock	341.17	341.27	340.91	340.91	2500.0
2023-07-07 06:00:00	MSFT	Stock	340.91	340.91	340.21	340.74	1754.0
2023-07-07 07:00:00	MSFT	Stock	340.84	341.27	340.69	340.69	7314.0
2023-07-07 08:00:00	MSFT	Stock	342.65	343.0	340.09	340.54	131620.0
2023-07-07 09:00:00	MSFT	Stock	340.54	341.2	338.88	340.915	2299549.0
2023-07-07 10:00:00	MSFT	Stock	340.89	340.93	337.56	338.9266	2166562.0
2023-07-07 11:00:00	MSFT	Stock	338.91	339.64	338.62	339.53	1155981.0
2023-07-07 12:00:00	MSFT	Stock	339.54	341.5435	339.52	341.35	1536064.0
2023-07-07 13:00:00	MSFT	Stock	341.36	341.79	340.63	340.86	1057388.0
2023-07-07 14:00:00	MSFT	Stock	340.84	340.84	339.4	339.729	1193804.0
2023-07-07 15:00:00	MSFT	Stock	339.67	339.74	337.0	337.24	2548899.0
2023-07-07 16:00:00	MSFT	Stock	337.24	337.6	337.06	337.3	3268586.0
2023-07-07 17:00:00	MSFT	Stock	337.21	337.29	337.0	337.27	11749.0
2023-07-07 18:00:00	MSFT	Stock	337.27	337.4	337.21	337.31	7391.0
2023-07-07 19:00:00	MSFT	Stock	337.31	337.59	337.3	337.36	12182.0
2023-07-07 04:00:00	NVDA	Stock	41.93	41.93	41.83	41.925	52840.0
2023-07-07 05:00:00	NVDA	Stock	41.93	41.983	41.915	41.921	41460.0
2023-07-07 06:00:00	NVDA	Stock	41.905	41.905	41.887	41.892	15660.0
2023-07-07 07:00:00	NVDA	Stock	41.92	41.978	41.9	41.917	231550.0
2023-07-07 08:00:00	NVDA	Stock	41.912	42.6	41.88	42.202	2787700.0
2023-07-07 09:00:00	NVDA	Stock	42.2	42.675	42.054	42.641	37599600.0
2023-07-07 10:00:00	NVDA	Stock	42.645	42.947	42.5	42.731	60387890.0
2023-07-07 11:00:00	NVDA	Stock	42.7285	42.988	42.688	42.985	29676770.0
2023-07-07 12:00:00	NVDA	Stock	42.9843	43.062	42.8705	43.0017	25982800.0
2023-07-07 13:00:00	NVDA	Stock	43.004	43.199	42.971	43.109	24966370.0
2023-07-07 14:00:00	NVDA	Stock	43.116	43.214	43.016	43.067	23322520.0
2023-07-07 15:00:00	NVDA	Stock	43.061	43.061	42.432	42.504	48880150.0
2023-07-07 16:00:00	NVDA	Stock	42.503	42.544	42.49	42.5056	18017270.0
2023-07-07 17:00:00	NVDA	Stock	42.512	42.535	42.503	42.524	232380.0
2023-07-07 18:00:00	NVDA	Stock	42.525	42.575	42.522	42.5521	158220.0
2023-07-07 19:00:00	NVDA	Stock	42.559	42.576	42.5421	42.575	273940.0
2023-07-07 04:00:00	AMZN	Stock	128.15	128.22	127.87	128.01	19130.0
2023-07-07 05:00:00	AMZN	Stock	128.01	128.15	128.01	128.09	3924.0

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

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