PREVIEW / stock_1hour / 2023-07-12

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-07-12.parquet
  size:    1.4 MB
  rows:    61,308
  symbols: 1,543

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-12 04:00:00	AAPL	Stock	188.3	188.5	188.3	188.43	5802.0
2023-07-12 05:00:00	AAPL	Stock	188.46	188.79	188.45	188.61	11977.0
2023-07-12 06:00:00	AAPL	Stock	188.53	188.64	188.43	188.5	9695.0
2023-07-12 07:00:00	AAPL	Stock	188.52	188.74	188.52	188.65	18875.0
2023-07-12 08:00:00	AAPL	Stock	188.59	189.5	188.11	189.23	479166.0
2023-07-12 09:00:00	AAPL	Stock	189.22	191.7	189.21	190.71	9938100.0
2023-07-12 10:00:00	AAPL	Stock	190.72	190.99	189.565	189.6699	7486741.0
2023-07-12 11:00:00	AAPL	Stock	189.67	189.9	188.47	188.6399	6071289.0
2023-07-12 12:00:00	AAPL	Stock	188.63	189.82	188.57	189.361	3911184.0
2023-07-12 13:00:00	AAPL	Stock	189.365	190.03	189.365	189.92	3029353.0
2023-07-12 14:00:00	AAPL	Stock	189.93	190.4027	189.815	189.98	3245424.0
2023-07-12 15:00:00	AAPL	Stock	189.985	190.24	189.57	189.82	6734240.0
2023-07-12 16:00:00	AAPL	Stock	189.82	189.89	189.61	189.65	7174271.0
2023-07-12 17:00:00	AAPL	Stock	189.68	189.77	189.53	189.6616	635711.0
2023-07-12 18:00:00	AAPL	Stock	189.72	190.0	189.69	189.99	27145.0
2023-07-12 19:00:00	AAPL	Stock	189.98	189.99	189.8	189.99	21235.0
2023-07-12 04:00:00	MSFT	Stock	333.06	333.14	332.48	332.63	1733.0
2023-07-12 05:00:00	MSFT	Stock	332.6	332.99	332.6	332.99	1279.0
2023-07-12 06:00:00	MSFT	Stock	333.05	333.67	333.05	333.67	5793.0
2023-07-12 07:00:00	MSFT	Stock	333.5	334.88	333.5	334.13	14537.0
2023-07-12 08:00:00	MSFT	Stock	333.5	336.5	333.09	336.07	196125.0
2023-07-12 09:00:00	MSFT	Stock	336.1	339.98	335.41	339.26	4087129.0
2023-07-12 10:00:00	MSFT	Stock	339.28	341.652	338.8901	339.75	3644366.0
2023-07-12 11:00:00	MSFT	Stock	339.74	339.76	335.67	336.43	2502208.0
2023-07-12 12:00:00	MSFT	Stock	336.4355	338.13	336.33	337.56	1601796.0
2023-07-12 13:00:00	MSFT	Stock	337.57	338.59	337.08	338.11	1332696.0
2023-07-12 14:00:00	MSFT	Stock	338.14	338.71	337.29	337.72	1453874.0
2023-07-12 15:00:00	MSFT	Stock	337.64	338.18	336.85	337.41	2815186.0
2023-07-12 16:00:00	MSFT	Stock	337.41	337.87	337.12	337.64	3994882.0
2023-07-12 17:00:00	MSFT	Stock	337.62	337.85	337.2	337.6	341743.0
2023-07-12 18:00:00	MSFT	Stock	337.5	338.17	337.5	338.0999	9646.0
2023-07-12 19:00:00	MSFT	Stock	338.04	338.04	337.35	337.5	8671.0
2023-07-12 04:00:00	NVDA	Stock	42.474	42.63	42.474	42.583	69250.0
2023-07-12 05:00:00	NVDA	Stock	42.61	42.66	42.61	42.642	17580.0
2023-07-12 06:00:00	NVDA	Stock	42.65	42.65	42.58	42.58	26060.0
2023-07-12 07:00:00	NVDA	Stock	42.566	42.606	42.541	42.57	245260.0
2023-07-12 08:00:00	NVDA	Stock	42.585	43.058	42.48	43.016	4157920.0
2023-07-12 09:00:00	NVDA	Stock	43.008	43.69	42.7773	43.625	68767580.0
2023-07-12 10:00:00	NVDA	Stock	43.631	43.929	43.528	43.5925	67453090.0
2023-07-12 11:00:00	NVDA	Stock	43.585	43.722	43.211	43.282	45532940.0
2023-07-12 12:00:00	NVDA	Stock	43.277	43.569	43.253	43.4962	31755960.0
2023-07-12 13:00:00	NVDA	Stock	43.503	43.82	43.355	43.7428	32122870.0
2023-07-12 14:00:00	NVDA	Stock	43.749	43.935	43.636	43.8131	36010210.0
2023-07-12 15:00:00	NVDA	Stock	43.805	43.934	43.615	43.905	46269340.0
2023-07-12 16:00:00	NVDA	Stock	43.904	44.188	43.89	44.045	23743840.0
2023-07-12 17:00:00	NVDA	Stock	44.032	44.04	43.902	44.02	1229880.0
2023-07-12 18:00:00	NVDA	Stock	44.0277	44.0695	43.983	44.0445	392240.0
2023-07-12 19:00:00	NVDA	Stock	44.033	44.1862	44.026	44.169	1011800.0
2023-07-12 04:00:00	AMZN	Stock	129.1	129.23	129.05	129.15	10566.0
2023-07-12 05:00:00	AMZN	Stock	129.15	129.4	129.15	129.4	7692.0

> showing 50 of 61,308 rows — these rows as CSV

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