PREVIEW / etf_1hour / 2022-12-22

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-12-22.parquet
  size:    475 KB
  rows:    17,303

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-12-22 04:00:00	SPY	ETF	386.97	387.14	386.4	386.41	58450.0
2022-12-22 05:00:00	SPY	ETF	386.41	386.41	385.94	386.07	27847.0
2022-12-22 06:00:00	SPY	ETF	385.99	386.0	385.31	385.76	69254.0
2022-12-22 07:00:00	SPY	ETF	385.72	386.0	385.03	385.38	200722.0
2022-12-22 08:00:00	SPY	ETF	385.38	387.49	382.84	383.17	900351.0
2022-12-22 09:00:00	SPY	ETF	383.08	383.38	380.97	381.585	5990388.0
2022-12-22 10:00:00	SPY	ETF	381.57	381.57	378.92	379.0999	10654474.0
2022-12-22 11:00:00	SPY	ETF	379.1	379.61	378.22	378.68	5418813.0
2022-12-22 12:00:00	SPY	ETF	378.69	378.74	376.11	376.55	7184360.0
2022-12-22 13:00:00	SPY	ETF	376.55	376.55	374.77	375.53	8104779.0
2022-12-22 14:00:00	SPY	ETF	375.52	378.62	375.5	378.491	9412268.0
2022-12-22 15:00:00	SPY	ETF	378.4901	380.82	378.19	380.76	20229957.0
2022-12-22 16:00:00	SPY	ETF	380.75	381.44	379.846	380.54	4550112.0
2022-12-22 17:00:00	SPY	ETF	380.54	380.9	380.42	380.9	65006.0
2022-12-22 18:00:00	SPY	ETF	380.75	380.78	380.33	380.62	88098.0
2022-12-22 19:00:00	SPY	ETF	380.61	380.75	379.7	379.71	126755.0
2022-12-22 04:00:00	QQQ	ETF	274.32	274.32	273.7	273.7	56291.0
2022-12-22 05:00:00	QQQ	ETF	273.65	273.65	273.24	273.39	58782.0
2022-12-22 06:00:00	QQQ	ETF	273.41	273.42	272.8	273.2	47105.0
2022-12-22 07:00:00	QQQ	ETF	273.16	273.37	272.27	272.59	160202.0
2022-12-22 08:00:00	QQQ	ETF	273.28	274.61	270.14	270.41	845048.0
2022-12-22 09:00:00	QQQ	ETF	270.37	270.5149	267.7701	268.53	5168227.0
2022-12-22 10:00:00	QQQ	ETF	268.53	268.53	265.51	265.715	6937319.0
2022-12-22 11:00:00	QQQ	ETF	265.72	266.31	264.67	265.1	3940792.0
2022-12-22 12:00:00	QQQ	ETF	265.1	265.17	263.3	263.8301	5006672.0
2022-12-22 13:00:00	QQQ	ETF	263.83	263.83	262.455	263.22	4559976.0
2022-12-22 14:00:00	QQQ	ETF	263.22	265.33	263.1879	265.22	6396552.0
2022-12-22 15:00:00	QQQ	ETF	265.23	266.96	265.01	266.81	11454242.0
2022-12-22 16:00:00	QQQ	ETF	266.84	267.4	266.18	266.59	3511461.0
2022-12-22 17:00:00	QQQ	ETF	266.61	266.95	266.39	266.9	158827.0
2022-12-22 18:00:00	QQQ	ETF	266.94	267.0	266.53	266.71	124792.0
2022-12-22 19:00:00	QQQ	ETF	266.59	266.8	265.83	265.88	189703.0
2022-12-22 04:00:00	IWM	ETF	176.31	176.34	175.97	175.97	28065.0
2022-12-22 05:00:00	IWM	ETF	175.91	175.95	175.77	175.92	7971.0
2022-12-22 06:00:00	IWM	ETF	175.78	175.78	175.52	175.69	21652.0
2022-12-22 07:00:00	IWM	ETF	175.7	175.82	175.44	175.65	14811.0
2022-12-22 08:00:00	IWM	ETF	175.69	175.76	174.33	174.53	177265.0
2022-12-22 09:00:00	IWM	ETF	174.49	174.56	172.9	173.0401	2434679.0
2022-12-22 10:00:00	IWM	ETF	173.05	173.08	172.16	172.58	2823187.0
2022-12-22 11:00:00	IWM	ETF	172.56	172.85	172.05	172.24	1159004.0
2022-12-22 12:00:00	IWM	ETF	172.22	172.26	171.015	171.2827	1693805.0
2022-12-22 13:00:00	IWM	ETF	171.2901	171.295	170.67	171.17	1583850.0
2022-12-22 14:00:00	IWM	ETF	171.17	172.58	171.14	172.54	2114792.0
2022-12-22 15:00:00	IWM	ETF	172.55	173.7	172.38	173.61	4075783.0
2022-12-22 16:00:00	IWM	ETF	173.6	173.91	173.35	173.52	646367.0
2022-12-22 17:00:00	IWM	ETF	173.24	173.65	173.24	173.65	16368.0
2022-12-22 18:00:00	IWM	ETF	173.51	173.62	173.4	173.5	34862.0
2022-12-22 19:00:00	IWM	ETF	173.57	173.6	173.13	173.13	33326.0
2022-12-22 04:00:00	DIA	ETF	334.13	334.15	334.13	334.15	396.0
2022-12-22 05:00:00	DIA	ETF	333.57	333.57	333.57	333.57	899.0

> showing 50 of 17,303 rows — these rows as CSV

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