PREVIEW / etf_1hour / 2022-01-10

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-01-10.parquet
  size:    465 KB
  rows:    16,838

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-10 04:00:00	SPY	ETF	466.5	466.86	465.85	466.22	13814.0
2022-01-10 05:00:00	SPY	ETF	466.0	466.8	465.72	465.82	8918.0
2022-01-10 06:00:00	SPY	ETF	465.95	465.95	464.95	465.6	13435.0
2022-01-10 07:00:00	SPY	ETF	465.65	465.77	462.74	462.74	300173.0
2022-01-10 08:00:00	SPY	ETF	464.5515	467.0	462.59	462.94	456298.0
2022-01-10 09:00:00	SPY	ETF	462.95	463.26	459.01	459.36	10941671.0
2022-01-10 10:00:00	SPY	ETF	459.34	459.58	456.5973	457.79	16308063.0
2022-01-10 11:00:00	SPY	ETF	457.77	460.175	457.08	459.48	10864150.0
2022-01-10 12:00:00	SPY	ETF	459.47	460.18	457.95	459.23	8055965.0
2022-01-10 13:00:00	SPY	ETF	459.24	462.1762	459.09	461.88	9392456.0
2022-01-10 14:00:00	SPY	ETF	461.89	463.87	461.67	462.96	8839054.0
2022-01-10 15:00:00	SPY	ETF	462.96	465.74	461.58	465.54	18295038.0
2022-01-10 16:00:00	SPY	ETF	465.54	465.78	465.28	465.51	4086703.0
2022-01-10 17:00:00	SPY	ETF	465.51	465.89	465.37	465.66	111548.0
2022-01-10 18:00:00	SPY	ETF	465.68	466.14	465.31	465.83	122048.0
2022-01-10 19:00:00	SPY	ETF	465.83	466.16	465.02	465.98	116291.0
2022-01-10 04:00:00	QQQ	ETF	380.25	380.25	379.36	379.77	52393.0
2022-01-10 05:00:00	QQQ	ETF	379.66	380.15	378.69	378.74	19508.0
2022-01-10 06:00:00	QQQ	ETF	378.99	379.0	377.81	378.58	89959.0
2022-01-10 07:00:00	QQQ	ETF	378.65	378.88	374.63	374.64	644349.0
2022-01-10 08:00:00	QQQ	ETF	378.71	381.49	374.54	375.08	1045987.0
2022-01-10 09:00:00	QQQ	ETF	375.04	375.71	371.47	371.9	11991292.0
2022-01-10 10:00:00	QQQ	ETF	371.88	372.21	369.31	370.4001	13316001.0
2022-01-10 11:00:00	QQQ	ETF	370.39	373.64	369.92	372.9401	8841211.0
2022-01-10 12:00:00	QQQ	ETF	372.93	373.29	370.57	372.37	6705503.0
2022-01-10 13:00:00	QQQ	ETF	372.35	376.06	372.13	375.58	7903767.0
2022-01-10 14:00:00	QQQ	ETF	375.58	378.02	375.43	376.89	7032965.0
2022-01-10 15:00:00	QQQ	ETF	376.9	380.64	375.49	380.34	12613539.0
2022-01-10 16:00:00	QQQ	ETF	380.34	380.76	379.86	380.6	3677113.0
2022-01-10 17:00:00	QQQ	ETF	380.47	380.7	380.11	380.7	214153.0
2022-01-10 18:00:00	QQQ	ETF	380.7	381.19	380.29	380.8	94053.0
2022-01-10 19:00:00	QQQ	ETF	380.91	381.18	380.16	381.02	162596.0
2022-01-10 04:00:00	IWM	ETF	216.09	216.76	215.94	216.43	208138.0
2022-01-10 05:00:00	IWM	ETF	216.35	216.83	216.11	216.22	145964.0
2022-01-10 06:00:00	IWM	ETF	216.28	216.32	215.66	216.12	173454.0
2022-01-10 07:00:00	IWM	ETF	216.08	216.2	214.25	214.37	222974.0
2022-01-10 08:00:00	IWM	ETF	214.4	216.69	214.26	214.66	471138.0
2022-01-10 09:00:00	IWM	ETF	214.67	215.01	212.22	212.57	5248571.0
2022-01-10 10:00:00	IWM	ETF	212.54	213.49	211.47	212.15	6206892.0
2022-01-10 11:00:00	IWM	ETF	212.12	213.42	211.58	213.2	3983512.0
2022-01-10 12:00:00	IWM	ETF	213.18	213.2981	211.11	211.93	3392858.0
2022-01-10 13:00:00	IWM	ETF	211.93	213.33	211.745	213.11	4130451.0
2022-01-10 14:00:00	IWM	ETF	213.11	214.38	213.05	213.54	3100872.0
2022-01-10 15:00:00	IWM	ETF	213.55	215.385	212.99	215.29	5319429.0
2022-01-10 16:00:00	IWM	ETF	215.32	216.07	215.0	215.18	1896995.0
2022-01-10 17:00:00	IWM	ETF	215.28	215.44	215.05	215.29	235138.0
2022-01-10 18:00:00	IWM	ETF	215.28	215.5	215.02	215.35	74107.0
2022-01-10 19:00:00	IWM	ETF	215.35	215.41	214.67	215.24	35656.0
2022-01-10 04:00:00	DIA	ETF	362.28	362.63	362.28	362.47	845.0
2022-01-10 05:00:00	DIA	ETF	362.57	362.57	362.36	362.36	441.0

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

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