PREVIEW / etf_1hour / 2022-03-16

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-03-16.parquet
  size:    470 KB
  rows:    17,090

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-16 04:00:00	SPY	ETF	429.17	430.74	426.9	430.16	98557.0
2022-03-16 05:00:00	SPY	ETF	430.27	431.04	430.25	430.28	82199.0
2022-03-16 06:00:00	SPY	ETF	430.25	431.8	430.2	431.16	182292.0
2022-03-16 07:00:00	SPY	ETF	431.29	431.52	430.56	431.45	424436.0
2022-03-16 08:00:00	SPY	ETF	431.28	431.75	425.5	430.15	751548.0
2022-03-16 09:00:00	SPY	ETF	430.1	432.67	429.52	431.93	10123155.0
2022-03-16 10:00:00	SPY	ETF	431.93	434.55	430.734	433.31	17429207.0
2022-03-16 11:00:00	SPY	ETF	433.31	433.48	432.18	433.03	7202850.0
2022-03-16 12:00:00	SPY	ETF	433.05	433.58	431.15	431.665	5831859.0
2022-03-16 13:00:00	SPY	ETF	431.6608	431.9	430.02	431.3465	7706254.0
2022-03-16 14:00:00	SPY	ETF	430.99	431.46	424.8	429.95	24387092.0
2022-03-16 15:00:00	SPY	ETF	429.93	435.68	429.39	435.61	26143813.0
2022-03-16 16:00:00	SPY	ETF	435.6	437.2	435.0	436.75	6126432.0
2022-03-16 17:00:00	SPY	ETF	436.8	436.8	435.62	436.65	325169.0
2022-03-16 18:00:00	SPY	ETF	436.61	436.61	435.53	435.89	150006.0
2022-03-16 19:00:00	SPY	ETF	435.83	436.3	435.43	436.25	104109.0
2022-03-16 04:00:00	QQQ	ETF	330.06	333.57	330.06	333.2	151355.0
2022-03-16 05:00:00	QQQ	ETF	333.27	334.17	333.22	333.52	92009.0
2022-03-16 06:00:00	QQQ	ETF	333.48	335.0	333.47	334.1	141359.0
2022-03-16 07:00:00	QQQ	ETF	334.06	334.26	333.33	334.14	284587.0
2022-03-16 08:00:00	QQQ	ETF	334.16	334.51	328.0	332.89	891121.0
2022-03-16 09:00:00	QQQ	ETF	332.89	335.27	332.01	334.63	7643868.0
2022-03-16 10:00:00	QQQ	ETF	334.64	338.16	333.89	337.372	11857660.0
2022-03-16 11:00:00	QQQ	ETF	337.35	337.63	336.33	336.94	4075786.0
2022-03-16 12:00:00	QQQ	ETF	336.95	337.3	334.4	334.79	4610876.0
2022-03-16 13:00:00	QQQ	ETF	334.8	335.48	333.24	335.28	5586044.0
2022-03-16 14:00:00	QQQ	ETF	335.27	336.18	328.401	334.96	21623924.0
2022-03-16 15:00:00	QQQ	ETF	334.97	340.44	334.17	340.39	15702816.0
2022-03-16 16:00:00	QQQ	ETF	340.39	342.01	339.92	341.41	3889314.0
2022-03-16 17:00:00	QQQ	ETF	341.38	341.49	340.32	341.23	576214.0
2022-03-16 18:00:00	QQQ	ETF	341.2	341.25	340.38	340.45	222092.0
2022-03-16 19:00:00	QQQ	ETF	340.4	341.2	340.14	340.95	151783.0
2022-03-16 04:00:00	IWM	ETF	197.31	197.99	197.01	197.74	30179.0
2022-03-16 05:00:00	IWM	ETF	197.94	198.13	197.43	197.55	29583.0
2022-03-16 06:00:00	IWM	ETF	197.55	198.43	197.53	198.18	67956.0
2022-03-16 07:00:00	IWM	ETF	198.05	198.2	197.63	198.2	72101.0
2022-03-16 08:00:00	IWM	ETF	197.8399	198.35	195.77	197.75	119611.0
2022-03-16 09:00:00	IWM	ETF	197.74	199.59	197.5	199.19	3058483.0
2022-03-16 10:00:00	IWM	ETF	199.21	200.91	198.95	199.48	4040878.0
2022-03-16 11:00:00	IWM	ETF	199.49	200.17	198.89	200.135	1430326.0
2022-03-16 12:00:00	IWM	ETF	200.14	200.68	199.47	200.08	1195858.0
2022-03-16 13:00:00	IWM	ETF	200.11	200.25	199.08	199.73	1741338.0
2022-03-16 14:00:00	IWM	ETF	199.72	199.7622	196.15	199.35	5588869.0
2022-03-16 15:00:00	IWM	ETF	199.35	201.91	199.15	201.89	5865219.0
2022-03-16 16:00:00	IWM	ETF	201.94	202.8	201.64	202.58	1282593.0
2022-03-16 17:00:00	IWM	ETF	202.5	202.68	201.94	202.3	80837.0
2022-03-16 18:00:00	IWM	ETF	202.45	202.55	202.02	202.28	93201.0
2022-03-16 19:00:00	IWM	ETF	202.27	202.59	202.06	202.59	45051.0
2022-03-16 04:00:00	DIA	ETF	338.36	338.86	338.34	338.54	5113.0
2022-03-16 05:00:00	DIA	ETF	338.92	339.06	338.83	339.06	1100.0

> showing 50 of 17,090 rows — these rows as CSV

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