PREVIEW / stock_1hour / 2021-10-15

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-10-15.parquet
  size:    1.4 MB
  rows:    65,953
  symbols: 2,685

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-10-15 04:00:00	AAPL	Stock	143.91	144.23	143.89	144.17	24768.0
2021-10-15 05:00:00	AAPL	Stock	144.1	144.21	144.0	144.21	17909.0
2021-10-15 06:00:00	AAPL	Stock	144.18	144.29	144.1	144.14	17154.0
2021-10-15 07:00:00	AAPL	Stock	144.1	144.38	144.04	144.18	91987.0
2021-10-15 08:00:00	AAPL	Stock	144.1699	144.37	143.401	144.11	367600.0
2021-10-15 09:00:00	AAPL	Stock	144.11	144.69	143.495	144.3316	11490637.0
2021-10-15 10:00:00	AAPL	Stock	144.335	144.39	143.8	144.3739	8732560.0
2021-10-15 11:00:00	AAPL	Stock	144.3735	144.44	143.66	143.735	6251503.0
2021-10-15 12:00:00	AAPL	Stock	143.7301	144.27	143.67	144.2275	4725453.0
2021-10-15 13:00:00	AAPL	Stock	144.222	144.52	144.04	144.415	4624736.0
2021-10-15 14:00:00	AAPL	Stock	144.4114	144.67	144.36	144.635	4783321.0
2021-10-15 15:00:00	AAPL	Stock	144.64	144.895	144.2801	144.83	10300423.0
2021-10-15 16:00:00	AAPL	Stock	144.84	144.95	144.7	144.89	7832415.0
2021-10-15 17:00:00	AAPL	Stock	144.9	144.92	144.84	144.86	37393.0
2021-10-15 18:00:00	AAPL	Stock	144.8599	144.9	144.8	144.81	16664.0
2021-10-15 19:00:00	AAPL	Stock	144.82	144.97	144.81	144.95	30375.0
2021-10-15 04:00:00	MSFT	Stock	302.75	303.48	302.75	303.34	1617.0
2021-10-15 05:00:00	MSFT	Stock	303.32	303.32	303.01	303.08	1746.0
2021-10-15 06:00:00	MSFT	Stock	303.28	303.47	303.28	303.47	6896.0
2021-10-15 07:00:00	MSFT	Stock	303.5	303.8	303.4	303.4	14161.0
2021-10-15 08:00:00	MSFT	Stock	303.55	303.85	302.75	302.95	53943.0
2021-10-15 09:00:00	MSFT	Stock	302.9	303.19	301.08	301.38	3442719.0
2021-10-15 10:00:00	MSFT	Stock	301.41	301.44	300.5191	301.1099	2251460.0
2021-10-15 11:00:00	MSFT	Stock	301.1299	301.85	300.9201	301.12	1625294.0
2021-10-15 12:00:00	MSFT	Stock	301.11	303.36	301.0838	303.16	1908013.0
2021-10-15 13:00:00	MSFT	Stock	303.165	304.29	302.785	304.26	1828975.0
2021-10-15 14:00:00	MSFT	Stock	304.26	304.45	303.7927	304.18	1360896.0
2021-10-15 15:00:00	MSFT	Stock	304.15	304.4	303.31	304.21	2355695.0
2021-10-15 16:00:00	MSFT	Stock	304.21	304.39	304.02	304.24	4174903.0
2021-10-15 17:00:00	MSFT	Stock	304.21	304.25	304.21	304.21	77402.0
2021-10-15 18:00:00	MSFT	Stock	304.21	304.3	304.2	304.2	81796.0
2021-10-15 19:00:00	MSFT	Stock	304.21	304.39	304.21	304.3	1305.0
2021-10-15 04:00:00	NVDA	Stock	21.843	21.939	21.843	21.9	64030.0
2021-10-15 05:00:00	NVDA	Stock	21.9	21.9	21.849	21.865	34490.0
2021-10-15 06:00:00	NVDA	Stock	21.865	21.892	21.82	21.82	40170.0
2021-10-15 07:00:00	NVDA	Stock	21.839	21.92	21.83	21.875	337030.0
2021-10-15 08:00:00	NVDA	Stock	21.8723	21.935	21.746	21.88	809180.0
2021-10-15 09:00:00	NVDA	Stock	21.878	21.931	21.662	21.843	34025360.0
2021-10-15 10:00:00	NVDA	Stock	21.847	21.895	21.674	21.894	33873810.0
2021-10-15 11:00:00	NVDA	Stock	21.893	21.913	21.7285	21.756	20049580.0
2021-10-15 12:00:00	NVDA	Stock	21.759	21.845	21.737	21.8255	12933960.0
2021-10-15 13:00:00	NVDA	Stock	21.823	21.886	21.789	21.8844	14389480.0
2021-10-15 14:00:00	NVDA	Stock	21.885	21.898	21.8179	21.8479	13535800.0
2021-10-15 15:00:00	NVDA	Stock	21.847	21.868	21.786	21.862	20600840.0
2021-10-15 16:00:00	NVDA	Stock	21.862	21.869	21.815	21.862	22553080.0
2021-10-15 17:00:00	NVDA	Stock	21.825	21.849	21.811	21.825	36210.0
2021-10-15 18:00:00	NVDA	Stock	21.825	21.838	21.815	21.83	72800.0
2021-10-15 19:00:00	NVDA	Stock	21.838	21.862	21.816	21.852	76710.0
2021-10-15 06:00:00	AMZN	Stock	165.4995	165.4995	165.4995	165.4995	2000.0
2021-10-15 07:00:00	AMZN	Stock	165.5	165.5975	165.5	165.5975	10660.0

> showing 50 of 65,953 rows — these rows as CSV

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