PREVIEW / etf_1hour / 2022-07-21

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-07-21.parquet
  size:    434 KB
  rows:    16,148

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-07-21 04:00:00	SPY	ETF	394.0	394.16	393.25	393.97	40635.0
2022-07-21 05:00:00	SPY	ETF	393.9	394.45	393.68	394.41	34243.0
2022-07-21 06:00:00	SPY	ETF	394.28	394.95	393.95	394.14	84099.0
2022-07-21 07:00:00	SPY	ETF	394.28	394.5	393.63	394.1	179290.0
2022-07-21 08:00:00	SPY	ETF	396.35	396.6	393.3696	395.74	1259745.0
2022-07-21 09:00:00	SPY	ETF	395.7501	396.71	392.77	394.92	5692018.0
2022-07-21 10:00:00	SPY	ETF	394.96	395.76	391.63	394.405	8228467.0
2022-07-21 11:00:00	SPY	ETF	394.41	395.96	393.93	395.475	5228088.0
2022-07-21 12:00:00	SPY	ETF	395.46	397.66	395.38	397.325	4952086.0
2022-07-21 13:00:00	SPY	ETF	397.34	397.59	395.65	396.4799	5344898.0
2022-07-21 14:00:00	SPY	ETF	396.49	397.405	396.25	396.9526	4417062.0
2022-07-21 15:00:00	SPY	ETF	396.96	398.84	396.9	398.8	11527213.0
2022-07-21 16:00:00	SPY	ETF	398.82	399.03	397.05	397.72	3298035.0
2022-07-21 17:00:00	SPY	ETF	397.63	397.79	397.43	397.49	163216.0
2022-07-21 18:00:00	SPY	ETF	397.48	397.54	396.88	397.21	153619.0
2022-07-21 19:00:00	SPY	ETF	397.11	397.34	396.96	397.01	69222.0
2022-07-21 04:00:00	QQQ	ETF	302.43	302.5	301.62	302.3	29960.0
2022-07-21 05:00:00	QQQ	ETF	302.28	303.12	302.19	303.05	28654.0
2022-07-21 06:00:00	QQQ	ETF	303.12	303.81	302.98	303.15	74071.0
2022-07-21 07:00:00	QQQ	ETF	303.1	303.29	302.71	303.13	134702.0
2022-07-21 08:00:00	QQQ	ETF	303.04	305.25	301.9096	304.51	1361319.0
2022-07-21 09:00:00	QQQ	ETF	304.56	304.59	301.7	303.8	6851272.0
2022-07-21 10:00:00	QQQ	ETF	303.82	304.88	300.78	303.3	7716725.0
2022-07-21 11:00:00	QQQ	ETF	303.29	304.93	303.015	304.55	4299210.0
2022-07-21 12:00:00	QQQ	ETF	304.53	306.78	304.47	306.44	4179784.0
2022-07-21 13:00:00	QQQ	ETF	306.48	306.7301	304.96	305.76	4102604.0
2022-07-21 14:00:00	QQQ	ETF	305.78	306.7	305.62	306.33	3299452.0
2022-07-21 15:00:00	QQQ	ETF	306.34	307.435	306.1282	307.43	7721464.0
2022-07-21 16:00:00	QQQ	ETF	307.43	307.65	304.99	305.59	2819904.0
2022-07-21 17:00:00	QQQ	ETF	305.52	305.58	305.03	305.2	274002.0
2022-07-21 18:00:00	QQQ	ETF	305.28	305.35	304.76	305.18	330933.0
2022-07-21 19:00:00	QQQ	ETF	305.16	305.24	304.96	305.01	101906.0
2022-07-21 04:00:00	IWM	ETF	180.92	181.01	180.42	180.84	47479.0
2022-07-21 05:00:00	IWM	ETF	180.85	181.05	180.63	181.05	11606.0
2022-07-21 06:00:00	IWM	ETF	181.15	181.33	180.84	180.94	15435.0
2022-07-21 07:00:00	IWM	ETF	180.94	181.08	180.6	180.89	102564.0
2022-07-21 08:00:00	IWM	ETF	180.92	182.07	180.47	181.67	150484.0
2022-07-21 09:00:00	IWM	ETF	181.69	181.69	179.59	180.73	2229830.0
2022-07-21 10:00:00	IWM	ETF	180.72	181.06	178.845	180.51	3151932.0
2022-07-21 11:00:00	IWM	ETF	180.48	180.92	179.94	180.65	1637607.0
2022-07-21 12:00:00	IWM	ETF	180.64	181.29	180.59	181.22	1334853.0
2022-07-21 13:00:00	IWM	ETF	181.23	181.27	180.22	180.54	1707980.0
2022-07-21 14:00:00	IWM	ETF	180.55	181.34	180.44	180.8	1746710.0
2022-07-21 15:00:00	IWM	ETF	180.805	182.5	180.74	182.47	3739922.0
2022-07-21 16:00:00	IWM	ETF	182.42	182.47	181.82	182.15	1325328.0
2022-07-21 17:00:00	IWM	ETF	182.04	182.23	181.83	181.9	10654.0
2022-07-21 18:00:00	IWM	ETF	181.95	182.08	181.69	181.77	33057.0
2022-07-21 19:00:00	IWM	ETF	181.77	181.85	181.2	181.38	43247.0
2022-07-21 04:00:00	DIA	ETF	318.09	318.09	318.09	318.09	300.0
2022-07-21 05:00:00	DIA	ETF	318.19	318.19	318.19	318.19	200.0

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

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