PREVIEW / etf_1hour / 2022-10-06

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-10-06.parquet
  size:    444 KB
  rows:    16,490

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-10-06 04:00:00	SPY	ETF	377.06	377.48	375.43	375.5	64938.0
2022-10-06 05:00:00	SPY	ETF	375.54	375.79	374.5	374.5	63258.0
2022-10-06 06:00:00	SPY	ETF	374.55	374.68	374.0	374.4	72837.0
2022-10-06 07:00:00	SPY	ETF	374.45	375.49	374.45	375.17	304467.0
2022-10-06 08:00:00	SPY	ETF	375.13	379.4	374.0596	376.34	813983.0
2022-10-06 09:00:00	SPY	ETF	376.35	378.72	375.33	376.23	8045604.0
2022-10-06 10:00:00	SPY	ETF	376.24	376.49	373.41	376.42	11923397.0
2022-10-06 11:00:00	SPY	ETF	376.43	376.94	374.5809	374.68	9065398.0
2022-10-06 12:00:00	SPY	ETF	374.68	376.31	373.98	375.46	6030678.0
2022-10-06 13:00:00	SPY	ETF	375.47	375.9524	374.7	375.41	4975447.0
2022-10-06 14:00:00	SPY	ETF	375.41	375.45	372.74	373.46	7125028.0
2022-10-06 15:00:00	SPY	ETF	373.4445	374.5929	372.68	373.22	12997956.0
2022-10-06 16:00:00	SPY	ETF	373.21	373.65	372.59	372.71	3647221.0
2022-10-06 17:00:00	SPY	ETF	372.67	373.2	372.42	372.65	77378.0
2022-10-06 18:00:00	SPY	ETF	372.57	372.7	371.81	372.18	107584.0
2022-10-06 19:00:00	SPY	ETF	372.15	372.94	372.01	372.19	71050.0
2022-10-06 04:00:00	QQQ	ETF	282.46	282.46	280.46	280.65	72072.0
2022-10-06 05:00:00	QQQ	ETF	280.78	281.0	279.83	279.87	64328.0
2022-10-06 06:00:00	QQQ	ETF	279.83	280.04	279.38	279.84	121351.0
2022-10-06 07:00:00	QQQ	ETF	279.92	280.93	279.85	280.74	346799.0
2022-10-06 08:00:00	QQQ	ETF	280.45	283.7	279.7604	281.71	934233.0
2022-10-06 09:00:00	QQQ	ETF	281.71	284.18	280.63	282.13	6979652.0
2022-10-06 10:00:00	QQQ	ETF	282.14	282.29	279.43	282.2104	9853339.0
2022-10-06 11:00:00	QQQ	ETF	282.2301	282.88	280.75	280.83	6145732.0
2022-10-06 12:00:00	QQQ	ETF	280.81	282.24	280.27	281.57	4041645.0
2022-10-06 13:00:00	QQQ	ETF	281.59	282.15	280.9	281.83	3014589.0
2022-10-06 14:00:00	QQQ	ETF	281.84	281.88	279.47	280.14	4004827.0
2022-10-06 15:00:00	QQQ	ETF	280.12	280.9186	279.44	279.8	6733710.0
2022-10-06 16:00:00	QQQ	ETF	279.8	280.1	278.91	278.98	1787370.0
2022-10-06 17:00:00	QQQ	ETF	278.99	279.76	278.68	278.79	146656.0
2022-10-06 18:00:00	QQQ	ETF	278.66	279.1	278.25	278.6	213546.0
2022-10-06 19:00:00	QQQ	ETF	278.63	279.26	278.62	278.75	131196.0
2022-10-06 04:00:00	IWM	ETF	174.68	175.02	173.92	174.01	31084.0
2022-10-06 05:00:00	IWM	ETF	174.04	174.18	173.46	173.46	27832.0
2022-10-06 06:00:00	IWM	ETF	173.46	173.61	173.23	173.39	19132.0
2022-10-06 07:00:00	IWM	ETF	173.49	173.95	173.4	173.78	21619.0
2022-10-06 08:00:00	IWM	ETF	173.74	175.07	173.39	174.3	324199.0
2022-10-06 09:00:00	IWM	ETF	174.24	176.165	173.4	174.94	2901776.0
2022-10-06 10:00:00	IWM	ETF	174.97	174.9898	172.91	174.42	2622345.0
2022-10-06 11:00:00	IWM	ETF	174.405	174.83	173.59	173.62	1572313.0
2022-10-06 12:00:00	IWM	ETF	173.61	174.78	173.45	174.36	1393748.0
2022-10-06 13:00:00	IWM	ETF	174.39	174.68	174.04	174.51	1285590.0
2022-10-06 14:00:00	IWM	ETF	174.51	174.54	173.2	173.57	1718083.0
2022-10-06 15:00:00	IWM	ETF	173.56	174.12	173.33	173.72	2738359.0
2022-10-06 16:00:00	IWM	ETF	173.72	173.99	173.55	173.79	831653.0
2022-10-06 17:00:00	IWM	ETF	173.78	173.78	173.43	173.59	100873.0
2022-10-06 18:00:00	IWM	ETF	173.52	173.74	173.3	173.5	61767.0
2022-10-06 19:00:00	IWM	ETF	173.45	173.82	173.31	173.32	36835.0
2022-10-06 04:00:00	DIA	ETF	302.47	302.66	301.63	301.66	3384.0
2022-10-06 05:00:00	DIA	ETF	301.68	301.68	300.98	300.98	680.0

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

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