PREVIEW / stock_1hour / 2021-11-05

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-11-05.parquet
  size:    1.5 MB
  rows:    66,956
  symbols: 2,688

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
2021-11-05 04:00:00	AAPL	Stock	150.94	151.12	150.55	150.75	10144.0
2021-11-05 05:00:00	AAPL	Stock	150.69	151.1	150.66	151.04	11097.0
2021-11-05 06:00:00	AAPL	Stock	151.06	151.43	151.06	151.27	12673.0
2021-11-05 07:00:00	AAPL	Stock	151.24	151.33	150.82	151.11	68392.0
2021-11-05 08:00:00	AAPL	Stock	151.2304	151.48	150.364	151.3	438498.0
2021-11-05 09:00:00	AAPL	Stock	151.28	152.19	151.245	151.65	7414676.0
2021-11-05 10:00:00	AAPL	Stock	151.6399	151.78	150.81	151.133	6942083.0
2021-11-05 11:00:00	AAPL	Stock	151.13	151.33	150.85	150.9126	4798651.0
2021-11-05 12:00:00	AAPL	Stock	150.91	151.065	150.525	150.81	3700379.0
2021-11-05 13:00:00	AAPL	Stock	150.82	150.87	150.06	150.551	3856452.0
2021-11-05 14:00:00	AAPL	Stock	150.55	150.68	150.19	150.62	3716171.0
2021-11-05 15:00:00	AAPL	Stock	150.62	151.46	150.3401	151.27	8938540.0
2021-11-05 16:00:00	AAPL	Stock	151.28	151.28	150.45	151.25	9603242.0
2021-11-05 17:00:00	AAPL	Stock	151.23	151.23	151.07	151.15	25599.0
2021-11-05 18:00:00	AAPL	Stock	151.17	151.19	151.11	151.1201	16271.0
2021-11-05 19:00:00	AAPL	Stock	151.11	151.16	151.01	151.05	25056.0
2021-11-05 04:00:00	MSFT	Stock	337.67	338.56	337.15	337.37	2629.0
2021-11-05 05:00:00	MSFT	Stock	337.43	337.94	337.43	337.92	6665.0
2021-11-05 06:00:00	MSFT	Stock	337.94	338.0	337.26	337.26	8270.0
2021-11-05 07:00:00	MSFT	Stock	337.68	337.68	335.73	335.86	50604.0
2021-11-05 08:00:00	MSFT	Stock	337.8328	337.8328	335.73	337.45	51024.0
2021-11-05 09:00:00	MSFT	Stock	337.45	338.86	335.91	337.45	2312789.0
2021-11-05 10:00:00	MSFT	Stock	337.42	337.78	336.79	337.0	1768855.0
2021-11-05 11:00:00	MSFT	Stock	337.01	337.55	336.16	337.115	1533245.0
2021-11-05 12:00:00	MSFT	Stock	337.12	337.2	336.06	336.2497	1233809.0
2021-11-05 13:00:00	MSFT	Stock	336.25	336.4	334.4217	334.94	1740957.0
2021-11-05 14:00:00	MSFT	Stock	334.9017	335.92	334.835	335.85	1249409.0
2021-11-05 15:00:00	MSFT	Stock	335.86	337.01	335.28	336.11	2309975.0
2021-11-05 16:00:00	MSFT	Stock	336.06	336.85	336.0	336.06	3414302.0
2021-11-05 17:00:00	MSFT	Stock	336.0	336.2	336.0	336.15	5569.0
2021-11-05 18:00:00	MSFT	Stock	336.07	336.07	336.0	336.03	2067.0
2021-11-05 19:00:00	MSFT	Stock	335.9999	336.0	335.83	335.83	2207.0
2021-11-05 04:00:00	NVDA	Stock	30.0	30.771	29.85	30.544	1104060.0
2021-11-05 05:00:00	NVDA	Stock	30.644	30.943	30.64	30.938	510370.0
2021-11-05 06:00:00	NVDA	Stock	30.939	31.098	30.7	30.78	509800.0
2021-11-05 07:00:00	NVDA	Stock	30.736	30.805	30.35	30.598	1689830.0
2021-11-05 08:00:00	NVDA	Stock	30.699	30.8	30.0	30.235	5431180.0
2021-11-05 09:00:00	NVDA	Stock	30.23	31.235	30.029	30.468	111421010.0
2021-11-05 10:00:00	NVDA	Stock	30.464	31.2	30.318	30.783	100210890.0
2021-11-05 11:00:00	NVDA	Stock	30.782	31.4	30.7532	31.206	79697700.0
2021-11-05 12:00:00	NVDA	Stock	31.2088	31.338	30.05	30.378	83803240.0
2021-11-05 13:00:00	NVDA	Stock	30.3795	30.384	29.655	30.169	80213720.0
2021-11-05 14:00:00	NVDA	Stock	30.158	30.455	30.0	30.208	48021300.0
2021-11-05 15:00:00	NVDA	Stock	30.209	30.231	29.411	29.765	87712400.0
2021-11-05 16:00:00	NVDA	Stock	29.752	29.935	29.707	29.925	22123100.0
2021-11-05 17:00:00	NVDA	Stock	29.925	29.925	29.84	29.885	291000.0
2021-11-05 18:00:00	NVDA	Stock	29.87	29.9	29.87	29.885	231110.0
2021-11-05 19:00:00	NVDA	Stock	29.884	29.925	29.875	29.9	179640.0
2021-11-05 04:00:00	AMZN	Stock	173.173	173.4	173.173	173.4	4000.0
2021-11-05 06:00:00	AMZN	Stock	173.9	174.35	173.9	174.3	42340.0

> showing 50 of 66,956 rows — these rows as CSV

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