PREVIEW / stock_1hour / 2021-09-15

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-09-15.parquet
  size:    1.4 MB
  rows:    64,720
  symbols: 2,734

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-09-15 04:00:00	AAPL	Stock	148.2	148.82	148.2	148.75	21451.0
2021-09-15 05:00:00	AAPL	Stock	148.68	148.81	148.59	148.78	12187.0
2021-09-15 06:00:00	AAPL	Stock	148.8	148.8	148.44	148.44	11445.0
2021-09-15 07:00:00	AAPL	Stock	148.48	148.55	148.22	148.3	62148.0
2021-09-15 08:00:00	AAPL	Stock	148.41	148.79	148.15	148.43	273912.0
2021-09-15 09:00:00	AAPL	Stock	148.41	149.09	146.95	147.44	11458585.0
2021-09-15 10:00:00	AAPL	Stock	147.45	147.575	146.37	147.22	13092143.0
2021-09-15 11:00:00	AAPL	Stock	147.22	147.4	146.77	147.26	6998636.0
2021-09-15 12:00:00	AAPL	Stock	147.25	148.17	147.12	148.045	7403988.0
2021-09-15 13:00:00	AAPL	Stock	148.045	148.5599	147.86	148.133	5998938.0
2021-09-15 14:00:00	AAPL	Stock	148.13	148.59	148.09	148.45	5047626.0
2021-09-15 15:00:00	AAPL	Stock	148.45	149.44	148.35	149.09	12011247.0
2021-09-15 16:00:00	AAPL	Stock	149.08	149.1	148.5	148.75	8893670.0
2021-09-15 17:00:00	AAPL	Stock	148.75	148.92	148.73	148.92	48629.0
2021-09-15 18:00:00	AAPL	Stock	148.92	148.97	148.9	148.96	27387.0
2021-09-15 19:00:00	AAPL	Stock	148.96	148.97	148.92	148.97	31418.0
2021-09-15 04:00:00	MSFT	Stock	303.2	303.6	303.0	303.6	7084.0
2021-09-15 05:00:00	MSFT	Stock	303.5	303.79	303.5	303.79	2997.0
2021-09-15 06:00:00	MSFT	Stock	303.79	304.27	303.64	303.66	9025.0
2021-09-15 07:00:00	MSFT	Stock	303.8	303.8	303.24	303.43	38821.0
2021-09-15 08:00:00	MSFT	Stock	303.6512	304.1	303.2	303.99	113496.0
2021-09-15 09:00:00	MSFT	Stock	303.99	305.32	302.27	302.88	4410659.0
2021-09-15 10:00:00	MSFT	Stock	302.91	303.73	301.82	303.45	2569523.0
2021-09-15 11:00:00	MSFT	Stock	303.445	303.69	302.02	302.62	1606326.0
2021-09-15 12:00:00	MSFT	Stock	302.61	304.495	302.13	304.31	2119265.0
2021-09-15 13:00:00	MSFT	Stock	304.3399	304.84	304.14	304.165	1430547.0
2021-09-15 14:00:00	MSFT	Stock	304.15	304.58	304.03	304.396	1052158.0
2021-09-15 15:00:00	MSFT	Stock	304.4	305.25	304.335	304.84	3251356.0
2021-09-15 16:00:00	MSFT	Stock	304.82	305.0	304.343	305.0	4412468.0
2021-09-15 17:00:00	MSFT	Stock	304.95	305.4	304.85	305.2	22745.0
2021-09-15 18:00:00	MSFT	Stock	305.29	305.32	305.17	305.2	3911.0
2021-09-15 19:00:00	MSFT	Stock	305.17	305.32	305.1	305.31	6715.0
2021-09-15 04:00:00	NVDA	Stock	22.273	22.299	22.273	22.299	8110.0
2021-09-15 05:00:00	NVDA	Stock	22.312	22.325	22.299	22.325	12270.0
2021-09-15 06:00:00	NVDA	Stock	22.27	22.27	22.27	22.27	1080.0
2021-09-15 07:00:00	NVDA	Stock	22.276	22.284	22.2	22.26	208620.0
2021-09-15 08:00:00	NVDA	Stock	22.2838	22.3	22.1864	22.25	186850.0
2021-09-15 09:00:00	NVDA	Stock	22.255	22.367	21.9912	22.094	24968680.0
2021-09-15 10:00:00	NVDA	Stock	22.097	22.185	21.994	22.09	25376330.0
2021-09-15 11:00:00	NVDA	Stock	22.09	22.111	21.966	22.044	13773070.0
2021-09-15 12:00:00	NVDA	Stock	22.0391	22.18	21.996	22.131	13408380.0
2021-09-15 13:00:00	NVDA	Stock	22.134	22.23	22.113	22.19	9025110.0
2021-09-15 14:00:00	NVDA	Stock	22.188	22.298	22.184	22.2845	10125730.0
2021-09-15 15:00:00	NVDA	Stock	22.286	22.35	22.258	22.345	16175230.0
2021-09-15 16:00:00	NVDA	Stock	22.349	22.355	22.33	22.341	13398290.0
2021-09-15 17:00:00	NVDA	Stock	22.34	22.35	22.322	22.322	57090.0
2021-09-15 18:00:00	NVDA	Stock	22.322	22.345	22.322	22.341	16830.0
2021-09-15 19:00:00	NVDA	Stock	22.339	22.356	22.339	22.356	56460.0
2021-09-15 07:00:00	AMZN	Stock	172.6605	172.6605	172.5995	172.5995	8000.0
2021-09-15 08:00:00	AMZN	Stock	172.6625	172.6995	172.4215	172.4905	177780.0

> showing 50 of 64,720 rows — these rows as CSV

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