PREVIEW / stock_1hour / 2021-09-22

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-09-22.parquet
  size:    1.4 MB
  rows:    63,964
  symbols: 2,700

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-22 04:00:00	AAPL	Stock	143.71	144.27	143.71	144.22	12904.0
2021-09-22 05:00:00	AAPL	Stock	144.19	144.19	144.0	144.1	7212.0
2021-09-22 06:00:00	AAPL	Stock	144.11	144.22	144.11	144.16	11387.0
2021-09-22 07:00:00	AAPL	Stock	144.13	144.17	143.78	143.83	150376.0
2021-09-22 08:00:00	AAPL	Stock	144.0499	144.16	143.78	144.05	218400.0
2021-09-22 09:00:00	AAPL	Stock	144.07	144.89	143.7001	144.585	7765363.0
2021-09-22 10:00:00	AAPL	Stock	144.59	145.29	144.59	144.905	9289327.0
2021-09-22 11:00:00	AAPL	Stock	144.91	145.89	144.91	145.53	7209880.0
2021-09-22 12:00:00	AAPL	Stock	145.52	145.695	145.19	145.2341	4415603.0
2021-09-22 13:00:00	AAPL	Stock	145.2301	145.39	145.03	145.3	4339234.0
2021-09-22 14:00:00	AAPL	Stock	145.0	146.4294	144.75	145.41	12873927.0
2021-09-22 15:00:00	AAPL	Stock	145.41	146.43	145.22	145.83	13423112.0
2021-09-22 16:00:00	AAPL	Stock	145.85	146.03	145.8201	145.89	7758188.0
2021-09-22 17:00:00	AAPL	Stock	145.9	146.0	145.86	145.98	20635.0
2021-09-22 18:00:00	AAPL	Stock	145.98	146.12	145.95	146.11	77326.0
2021-09-22 19:00:00	AAPL	Stock	146.01	146.25	146.01	146.25	57056.0
2021-09-22 04:00:00	MSFT	Stock	295.1	295.87	295.1	295.75	1858.0
2021-09-22 05:00:00	MSFT	Stock	295.94	295.94	295.67	295.7	499.0
2021-09-22 06:00:00	MSFT	Stock	295.89	295.9	295.89	295.9	847.0
2021-09-22 07:00:00	MSFT	Stock	295.66	295.73	295.29	295.49	11337.0
2021-09-22 08:00:00	MSFT	Stock	295.6999	296.3699	295.3	296.0	41333.0
2021-09-22 09:00:00	MSFT	Stock	296.05	297.0	294.51	296.2	2074535.0
2021-09-22 10:00:00	MSFT	Stock	296.21	299.61	296.1	298.82	3396772.0
2021-09-22 11:00:00	MSFT	Stock	298.83	299.93	298.3777	299.03	1753281.0
2021-09-22 12:00:00	MSFT	Stock	299.02	299.06	298.1	298.23	1171357.0
2021-09-22 13:00:00	MSFT	Stock	298.225	298.24	297.03	297.5	1116181.0
2021-09-22 14:00:00	MSFT	Stock	296.38	299.3672	296.24	297.9501	3008533.0
2021-09-22 15:00:00	MSFT	Stock	298.01	300.22	297.64	298.58	3394482.0
2021-09-22 16:00:00	MSFT	Stock	298.58	298.8	298.26	298.48	3092522.0
2021-09-22 17:00:00	MSFT	Stock	298.7574	298.97	298.7	298.85	1476.0
2021-09-22 18:00:00	MSFT	Stock	298.99	299.01	298.79	299.01	1769.0
2021-09-22 19:00:00	MSFT	Stock	299.24	299.71	299.24	299.48	5994.0
2021-09-22 04:00:00	NVDA	Stock	21.339	21.394	21.339	21.394	57610.0
2021-09-22 05:00:00	NVDA	Stock	21.37	21.396	21.358	21.358	12300.0
2021-09-22 06:00:00	NVDA	Stock	21.34	21.357	21.34	21.357	12500.0
2021-09-22 07:00:00	NVDA	Stock	21.36	21.36	21.3	21.325	130640.0
2021-09-22 08:00:00	NVDA	Stock	21.323	21.41	21.276	21.4	525290.0
2021-09-22 09:00:00	NVDA	Stock	21.4	21.498	21.196	21.4468	25197180.0
2021-09-22 10:00:00	NVDA	Stock	21.45	21.608	21.423	21.5903	33767570.0
2021-09-22 11:00:00	NVDA	Stock	21.595	21.739	21.513	21.712	22380420.0
2021-09-22 12:00:00	NVDA	Stock	21.714	21.887	21.682	21.76	28245980.0
2021-09-22 13:00:00	NVDA	Stock	21.761	21.843	21.707	21.75	16702690.0
2021-09-22 14:00:00	NVDA	Stock	21.747	21.96	21.616	21.731	32874020.0
2021-09-22 15:00:00	NVDA	Stock	21.733	21.957	21.699	21.942	31853560.0
2021-09-22 16:00:00	NVDA	Stock	21.943	22.0	21.4474	21.978	17765620.0
2021-09-22 17:00:00	NVDA	Stock	21.995	21.995	21.963	21.994	139900.0
2021-09-22 18:00:00	NVDA	Stock	21.992	22.047	21.992	22.032	181970.0
2021-09-22 19:00:00	NVDA	Stock	22.045	22.1	22.0	22.0	255210.0
2021-09-22 07:00:00	AMZN	Stock	167.5	167.7	167.495	167.65	34800.0
2021-09-22 08:00:00	AMZN	Stock	167.818	167.818	167.4998	167.7445	36300.0

> showing 50 of 63,964 rows — these rows as CSV

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