PREVIEW / stock_1hour / 2022-03-24

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-03-24.parquet
  size:    1.4 MB
  rows:    64,153
  symbols: 2,478

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
2022-03-24 04:00:00	AAPL	Stock	170.63	171.86	170.63	171.45	43407.0
2022-03-24 05:00:00	AAPL	Stock	171.45	171.8	171.43	171.43	16741.0
2022-03-24 06:00:00	AAPL	Stock	171.31	171.35	171.0	171.02	11834.0
2022-03-24 07:00:00	AAPL	Stock	170.95	171.68	170.91	171.18	130316.0
2022-03-24 08:00:00	AAPL	Stock	171.6	171.69	170.635	171.27	505815.0
2022-03-24 09:00:00	AAPL	Stock	171.28	172.35	170.72	170.9	10003137.0
2022-03-24 10:00:00	AAPL	Stock	170.8901	171.61	170.21	170.76	9969760.0
2022-03-24 11:00:00	AAPL	Stock	170.75	172.27	170.5999	171.8811	8032602.0
2022-03-24 12:00:00	AAPL	Stock	171.88	171.91	171.02	171.35	4997064.0
2022-03-24 13:00:00	AAPL	Stock	171.345	172.87	171.28	172.1557	10999215.0
2022-03-24 14:00:00	AAPL	Stock	172.16	172.64	171.8	172.57	7549275.0
2022-03-24 15:00:00	AAPL	Stock	172.565	174.14	172.39	174.1	17402971.0
2022-03-24 16:00:00	AAPL	Stock	174.09	174.2	173.91	173.9625	8539021.0
2022-03-24 17:00:00	AAPL	Stock	173.9761	174.0	173.7409	173.82	70269.0
2022-03-24 18:00:00	AAPL	Stock	173.8433	173.92	173.5	173.5	48988.0
2022-03-24 19:00:00	AAPL	Stock	173.48	173.85	173.35	173.83	55819.0
2022-03-24 04:00:00	MSFT	Stock	299.99	302.0	299.99	302.0	5057.0
2022-03-24 05:00:00	MSFT	Stock	301.72	301.72	301.48	301.48	2418.0
2022-03-24 06:00:00	MSFT	Stock	301.25	301.25	300.94	300.94	210.0
2022-03-24 07:00:00	MSFT	Stock	300.9	301.61	300.51	300.8	17890.0
2022-03-24 08:00:00	MSFT	Stock	300.9	301.58	299.49	300.95	33765.0
2022-03-24 09:00:00	MSFT	Stock	300.79	301.2	298.315	299.226	2101249.0
2022-03-24 10:00:00	MSFT	Stock	299.34	300.49	298.35	299.3877	1770706.0
2022-03-24 11:00:00	MSFT	Stock	299.39	301.72	299.07	301.1943	1634756.0
2022-03-24 12:00:00	MSFT	Stock	301.18	301.74	300.2715	300.71	1133895.0
2022-03-24 13:00:00	MSFT	Stock	300.73	301.25	300.44	300.925	1159634.0
2022-03-24 14:00:00	MSFT	Stock	300.915	301.95	300.84	301.8401	1286461.0
2022-03-24 15:00:00	MSFT	Stock	301.87	304.2	301.5	304.11	3205039.0
2022-03-24 16:00:00	MSFT	Stock	304.11	304.36	303.96	304.15	4076388.0
2022-03-24 17:00:00	MSFT	Stock	304.12	304.2199	304.1	304.1	6633.0
2022-03-24 18:00:00	MSFT	Stock	304.2	304.2	303.93	304.01	12960.0
2022-03-24 19:00:00	MSFT	Stock	304.0	304.0	303.5	303.88	20161.0
2022-03-24 04:00:00	NVDA	Stock	25.919	26.1	25.88	26.05	146360.0
2022-03-24 05:00:00	NVDA	Stock	26.05	26.148	26.03	26.032	137500.0
2022-03-24 06:00:00	NVDA	Stock	26.02	26.05	25.93	25.995	109110.0
2022-03-24 07:00:00	NVDA	Stock	26.008	26.117	25.975	26.06	436190.0
2022-03-24 08:00:00	NVDA	Stock	25.9986	26.2	25.698	26.1	1404160.0
2022-03-24 09:00:00	NVDA	Stock	26.09	26.589	25.907	26.402	66472080.0
2022-03-24 10:00:00	NVDA	Stock	26.4036	27.231	26.377	27.088	114488350.0
2022-03-24 11:00:00	NVDA	Stock	27.092	28.025	27.031	27.774	134157310.0
2022-03-24 12:00:00	NVDA	Stock	27.7728	27.985	27.568	27.8934	78389480.0
2022-03-24 13:00:00	NVDA	Stock	27.881	28.32	27.78	28.17	76452050.0
2022-03-24 14:00:00	NVDA	Stock	28.166	28.2845	27.848	27.997	76741820.0
2022-03-24 15:00:00	NVDA	Stock	28.0045	28.182	27.842	28.155	85886110.0
2022-03-24 16:00:00	NVDA	Stock	28.15	28.188	28.06	28.099	24197220.0
2022-03-24 17:00:00	NVDA	Stock	28.08	28.1	28.075	28.084	362500.0
2022-03-24 18:00:00	NVDA	Stock	28.09	28.131	28.08	28.12	535850.0
2022-03-24 19:00:00	NVDA	Stock	28.112	28.13	28.1	28.115	487380.0
2022-03-24 06:00:00	AMZN	Stock	163.85	163.85	163.65	163.65	14040.0
2022-03-24 07:00:00	AMZN	Stock	164.0025	164.15	163.575	163.575	50260.0

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

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