PREVIEW / etf_1hour / 2022-01-04

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-01-04.parquet
  size:    459 KB
  rows:    16,448

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-01-04 04:00:00	SPY	ETF	478.49	478.72	478.43	478.68	19021.0
2022-01-04 05:00:00	SPY	ETF	478.81	479.61	478.81	479.5	30323.0
2022-01-04 06:00:00	SPY	ETF	479.47	479.84	479.41	479.41	19063.0
2022-01-04 07:00:00	SPY	ETF	479.4	479.45	478.65	479.06	172214.0
2022-01-04 08:00:00	SPY	ETF	479.3601	479.7704	478.068	479.35	340878.0
2022-01-04 09:00:00	SPY	ETF	479.35	479.98	479.055	479.69	5813148.0
2022-01-04 10:00:00	SPY	ETF	479.68	479.76	477.51	477.62	7458531.0
2022-01-04 11:00:00	SPY	ETF	477.63	477.99	476.42	477.49	6232889.0
2022-01-04 12:00:00	SPY	ETF	477.47	477.95	476.71	476.83	3210393.0
2022-01-04 13:00:00	SPY	ETF	476.81	477.33	475.58	475.72	3547709.0
2022-01-04 14:00:00	SPY	ETF	475.72	477.565	475.67	477.415	5636133.0
2022-01-04 15:00:00	SPY	ETF	477.42	478.96	477.38	477.51	13272199.0
2022-01-04 16:00:00	SPY	ETF	477.51	477.65	477.25	477.45	2987776.0
2022-01-04 17:00:00	SPY	ETF	477.44	477.54	477.34	477.4	57427.0
2022-01-04 18:00:00	SPY	ETF	477.38	477.55	476.9	477.03	210125.0
2022-01-04 19:00:00	SPY	ETF	476.95	477.03	476.63	476.84	54246.0
2022-01-04 04:00:00	QQQ	ETF	401.78	402.44	401.78	402.44	25603.0
2022-01-04 05:00:00	QQQ	ETF	402.55	403.18	402.53	403.16	19333.0
2022-01-04 06:00:00	QQQ	ETF	403.0	403.56	402.95	402.99	26158.0
2022-01-04 07:00:00	QQQ	ETF	402.94	403.02	401.88	402.4	140700.0
2022-01-04 08:00:00	QQQ	ETF	402.4	403.3404	401.92	402.58	149769.0
2022-01-04 09:00:00	QQQ	ETF	402.65	402.68	400.65	401.0701	4206970.0
2022-01-04 10:00:00	QQQ	ETF	401.07	401.16	395.28	395.37	9871845.0
2022-01-04 11:00:00	QQQ	ETF	395.38	395.97	393.83	394.89	8545809.0
2022-01-04 12:00:00	QQQ	ETF	394.86	395.5	394.12	394.32	4312260.0
2022-01-04 13:00:00	QQQ	ETF	394.31	395.26	393.288	393.41	5158479.0
2022-01-04 14:00:00	QQQ	ETF	393.405	395.45	393.33	395.3401	4409105.0
2022-01-04 15:00:00	QQQ	ETF	395.34	397.76	395.31	396.49	8018371.0
2022-01-04 16:00:00	QQQ	ETF	396.48	396.53	396.0	396.18	1672360.0
2022-01-04 17:00:00	QQQ	ETF	396.12	396.25	396.04	396.06	43998.0
2022-01-04 18:00:00	QQQ	ETF	396.09	396.33	395.4	395.55	127300.0
2022-01-04 19:00:00	QQQ	ETF	395.45	395.62	395.28	395.47	61071.0
2022-01-04 04:00:00	IWM	ETF	225.84	225.92	225.66	225.82	19306.0
2022-01-04 05:00:00	IWM	ETF	225.91	226.41	225.86	226.35	26802.0
2022-01-04 06:00:00	IWM	ETF	226.18	226.45	226.18	226.25	13710.0
2022-01-04 07:00:00	IWM	ETF	226.15	226.24	225.8	226.11	29377.0
2022-01-04 08:00:00	IWM	ETF	226.11	226.3696	225.8	226.24	209512.0
2022-01-04 09:00:00	IWM	ETF	226.2	227.13	225.8	226.35	3347127.0
2022-01-04 10:00:00	IWM	ETF	226.32	226.34	224.22	224.38	3729716.0
2022-01-04 11:00:00	IWM	ETF	224.39	225.37	223.38	225.05	2469457.0
2022-01-04 12:00:00	IWM	ETF	225.04	225.61	224.83	225.155	1415855.0
2022-01-04 13:00:00	IWM	ETF	225.16	225.31	223.85	223.98	1114830.0
2022-01-04 14:00:00	IWM	ETF	223.97	224.91	223.92	224.87	1020827.0
2022-01-04 15:00:00	IWM	ETF	224.87	225.495	224.83	224.99	2900701.0
2022-01-04 16:00:00	IWM	ETF	224.98	225.06	224.8	225.0	531726.0
2022-01-04 17:00:00	IWM	ETF	224.91	225.08	224.91	225.01	6341.0
2022-01-04 18:00:00	IWM	ETF	224.97	225.05	224.62	224.65	16329.0
2022-01-04 19:00:00	IWM	ETF	224.63	224.65	224.4	224.56	17648.0
2022-01-04 04:00:00	DIA	ETF	366.47	366.47	366.46	366.46	319.0
2022-01-04 05:00:00	DIA	ETF	367.14	367.14	367.14	367.14	140.0

> showing 50 of 16,448 rows — these rows as CSV

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