PREVIEW / etf_1hour / 2022-03-24

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-03-24.parquet
  size:    448 KB
  rows:    15,997

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	SPY	ETF	445.29	447.0	445.21	446.72	28053.0
2022-03-24 05:00:00	SPY	ETF	446.65	446.93	446.4	446.4	15273.0
2022-03-24 06:00:00	SPY	ETF	446.25	446.25	445.6	445.87	57937.0
2022-03-24 07:00:00	SPY	ETF	445.8	447.1	445.36	445.92	587237.0
2022-03-24 08:00:00	SPY	ETF	446.69	447.0	445.25	445.99	294539.0
2022-03-24 09:00:00	SPY	ETF	445.99	446.35	444.76	445.58	4885134.0
2022-03-24 10:00:00	SPY	ETF	445.5701	446.97	445.23	446.37	6977816.0
2022-03-24 11:00:00	SPY	ETF	446.36	448.94	446.2373	448.415	6645530.0
2022-03-24 12:00:00	SPY	ETF	448.41	448.57	446.805	447.7502	4530690.0
2022-03-24 13:00:00	SPY	ETF	447.75	448.55	447.4	448.24	3370726.0
2022-03-24 14:00:00	SPY	ETF	448.24	448.85	447.42	448.17	4282235.0
2022-03-24 15:00:00	SPY	ETF	448.16	450.46	447.7505	450.41	13061590.0
2022-03-24 16:00:00	SPY	ETF	450.4	450.79	450.17	450.64	3833032.0
2022-03-24 17:00:00	SPY	ETF	450.67	450.69	450.5	450.65	32928.0
2022-03-24 18:00:00	SPY	ETF	450.65	450.76	450.2	450.21	115122.0
2022-03-24 19:00:00	SPY	ETF	450.19	450.4	450.0	450.23	91252.0
2022-03-24 04:00:00	QQQ	ETF	353.33	354.88	353.33	354.6	113757.0
2022-03-24 05:00:00	QQQ	ETF	354.57	354.89	354.24	354.24	42842.0
2022-03-24 06:00:00	QQQ	ETF	354.17	354.17	353.35	353.58	90604.0
2022-03-24 07:00:00	QQQ	ETF	353.59	354.92	353.34	353.8	320920.0
2022-03-24 08:00:00	QQQ	ETF	353.8199	354.89	351.567	353.97	363237.0
2022-03-24 09:00:00	QQQ	ETF	353.94	354.47	352.51	352.76	7036606.0
2022-03-24 10:00:00	QQQ	ETF	352.78	354.57	351.5939	353.75	7333835.0
2022-03-24 11:00:00	QQQ	ETF	353.73	357.17	353.455	356.475	6903355.0
2022-03-24 12:00:00	QQQ	ETF	356.47	356.6	355.205	356.4	4153212.0
2022-03-24 13:00:00	QQQ	ETF	356.42	357.23	355.94	356.96	3434172.0
2022-03-24 14:00:00	QQQ	ETF	356.9497	357.72	356.371	357.28	3606552.0
2022-03-24 15:00:00	QQQ	ETF	357.28	359.7	356.78	359.64	8038082.0
2022-03-24 16:00:00	QQQ	ETF	359.66	359.73	353.71	359.53	1482519.0
2022-03-24 17:00:00	QQQ	ETF	359.54	359.7	359.48	359.65	365317.0
2022-03-24 18:00:00	QQQ	ETF	359.65	359.84	359.17	359.1796	128802.0
2022-03-24 19:00:00	QQQ	ETF	359.2	359.4	359.0	359.23	111029.0
2022-03-24 04:00:00	IWM	ETF	204.33	205.02	204.18	204.78	12716.0
2022-03-24 05:00:00	IWM	ETF	204.72	204.94	204.67	204.71	17309.0
2022-03-24 06:00:00	IWM	ETF	204.57	204.61	204.27	204.54	29076.0
2022-03-24 07:00:00	IWM	ETF	204.5	204.99	204.38	204.51	61206.0
2022-03-24 08:00:00	IWM	ETF	204.53	204.8401	203.95	204.4	37444.0
2022-03-24 09:00:00	IWM	ETF	204.38	204.57	202.9	203.57	2015905.0
2022-03-24 10:00:00	IWM	ETF	203.54	204.49	202.73	203.8	1915041.0
2022-03-24 11:00:00	IWM	ETF	203.8	205.07	203.71	204.87	2223843.0
2022-03-24 12:00:00	IWM	ETF	204.86	204.93	204.3	204.8	865320.0
2022-03-24 13:00:00	IWM	ETF	204.82	205.08	204.64	204.91	811598.0
2022-03-24 14:00:00	IWM	ETF	204.92	205.26	204.58	205.21	1000744.0
2022-03-24 15:00:00	IWM	ETF	205.2	205.87	204.975	205.86	3498360.0
2022-03-24 16:00:00	IWM	ETF	205.87	206.15	205.83	205.96	1067451.0
2022-03-24 17:00:00	IWM	ETF	205.98	206.13	205.84	205.89	96778.0
2022-03-24 18:00:00	IWM	ETF	205.95	206.04	205.69	205.74	30741.0
2022-03-24 19:00:00	IWM	ETF	205.77	205.81	205.58	205.63	34753.0
2022-03-24 04:00:00	DIA	ETF	344.47	344.67	344.47	344.67	761.0
2022-03-24 05:00:00	DIA	ETF	345.23	345.23	345.23	345.23	100.0

> showing 50 of 15,997 rows — these rows as CSV

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