PREVIEW / etf_1hour / 2022-01-14

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-01-14.parquet
  size:    450 KB
  rows:    16,077

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-14 04:00:00	SPY	ETF	464.87	465.95	464.83	465.32	30147.0
2022-01-14 05:00:00	SPY	ETF	465.4	465.43	464.53	465.12	9266.0
2022-01-14 06:00:00	SPY	ETF	465.2	465.43	464.34	464.58	81117.0
2022-01-14 07:00:00	SPY	ETF	464.47	464.47	461.1	461.1	428190.0
2022-01-14 08:00:00	SPY	ETF	461.1	465.5296	459.98	460.68	1388293.0
2022-01-14 09:00:00	SPY	ETF	460.67	464.5	460.26	464.4	11060917.0
2022-01-14 10:00:00	SPY	ETF	464.38	464.86	461.8	462.6	10906422.0
2022-01-14 11:00:00	SPY	ETF	462.61	463.41	460.71	462.94	9238360.0
2022-01-14 12:00:00	SPY	ETF	462.95	463.29	460.53	460.64	5771534.0
2022-01-14 13:00:00	SPY	ETF	460.64	462.16	459.9	461.975	7743090.0
2022-01-14 14:00:00	SPY	ETF	461.97	463.14	461.43	462.24	7367069.0
2022-01-14 15:00:00	SPY	ETF	462.238	465.09	462.238	464.69	18111760.0
2022-01-14 16:00:00	SPY	ETF	464.67	465.72	464.62	465.67	4333741.0
2022-01-14 17:00:00	SPY	ETF	465.69	465.69	465.35	465.45	54539.0
2022-01-14 18:00:00	SPY	ETF	465.46	465.47	465.3	465.3	22511.0
2022-01-14 19:00:00	SPY	ETF	465.38	465.42	465.26	465.31	25301.0
2022-01-14 04:00:00	QQQ	ETF	377.66	378.58	377.36	378.19	135298.0
2022-01-14 05:00:00	QQQ	ETF	378.11	378.15	376.91	377.63	76149.0
2022-01-14 06:00:00	QQQ	ETF	377.7	377.92	376.7	377.1	106429.0
2022-01-14 07:00:00	QQQ	ETF	377.04	377.2	373.41	373.41	637530.0
2022-01-14 08:00:00	QQQ	ETF	373.5	378.6	373.23	374.22	965380.0
2022-01-14 09:00:00	QQQ	ETF	374.24	380.08	373.92	379.73	10477958.0
2022-01-14 10:00:00	QQQ	ETF	379.71	380.21	376.71	377.67	12386113.0
2022-01-14 11:00:00	QQQ	ETF	377.69	379.51	375.76	378.79	11469081.0
2022-01-14 12:00:00	QQQ	ETF	378.82	379.13	376.13	376.2695	4880403.0
2022-01-14 13:00:00	QQQ	ETF	376.27	378.36	375.4	378.11	5917210.0
2022-01-14 14:00:00	QQQ	ETF	378.09	378.84	377.04	377.67	6538990.0
2022-01-14 15:00:00	QQQ	ETF	377.67	380.35	377.67	380.06	8742559.0
2022-01-14 16:00:00	QQQ	ETF	380.08	380.67	379.88	380.6	1793724.0
2022-01-14 17:00:00	QQQ	ETF	380.46	380.65	380.3	380.35	20819.0
2022-01-14 18:00:00	QQQ	ETF	380.35	380.54	380.35	380.54	7107.0
2022-01-14 19:00:00	QQQ	ETF	380.54	380.56	380.1	380.4	27732.0
2022-01-14 04:00:00	IWM	ETF	214.13	214.75	214.01	214.25	33507.0
2022-01-14 05:00:00	IWM	ETF	214.18	214.26	213.84	214.15	19136.0
2022-01-14 06:00:00	IWM	ETF	214.18	214.32	213.5	213.74	48235.0
2022-01-14 07:00:00	IWM	ETF	213.59	213.66	212.09	212.13	112157.0
2022-01-14 08:00:00	IWM	ETF	214.0196	214.0196	210.96	211.72	413588.0
2022-01-14 09:00:00	IWM	ETF	211.67	214.12	211.46	213.67	5621694.0
2022-01-14 10:00:00	IWM	ETF	213.65	214.15	212.27	212.5	5552274.0
2022-01-14 11:00:00	IWM	ETF	212.49	212.9	211.4175	212.19	4258281.0
2022-01-14 12:00:00	IWM	ETF	212.19	212.42	210.9	211.13	2386570.0
2022-01-14 13:00:00	IWM	ETF	211.13	212.15	210.58	212.0372	3012999.0
2022-01-14 14:00:00	IWM	ETF	212.0	213.03	211.6	212.7	3731435.0
2022-01-14 15:00:00	IWM	ETF	212.74	214.4	212.67	214.3	5368905.0
2022-01-14 16:00:00	IWM	ETF	214.31	214.78	214.16	214.7	1163710.0
2022-01-14 17:00:00	IWM	ETF	214.57	214.68	214.47	214.47	31713.0
2022-01-14 18:00:00	IWM	ETF	214.47	214.5	214.31	214.5	25397.0
2022-01-14 19:00:00	IWM	ETF	214.5	214.55	214.4	214.41	7440.0
2022-01-14 04:00:00	DIA	ETF	361.85	361.91	361.74	361.91	856.0
2022-01-14 05:00:00	DIA	ETF	361.76	361.93	361.76	361.93	1700.0

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

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