PREVIEW / etf_1hour / 2022-10-21

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-10-21.parquet
  size:    454 KB
  rows:    16,721

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-21 04:00:00	SPY	ETF	364.0	364.22	363.07	363.18	44018.0
2022-10-21 05:00:00	SPY	ETF	363.36	363.79	362.75	363.69	94893.0
2022-10-21 06:00:00	SPY	ETF	363.63	364.1	363.12	363.92	58307.0
2022-10-21 07:00:00	SPY	ETF	363.91	364.49	363.3	363.35	446602.0
2022-10-21 08:00:00	SPY	ETF	363.66	365.67	362.2	363.59	1464009.0
2022-10-21 09:00:00	SPY	ETF	363.59	369.125	363.42	369.08	13984598.0
2022-10-21 10:00:00	SPY	ETF	369.11	370.63	366.285	366.784	13250941.0
2022-10-21 11:00:00	SPY	ETF	366.79	370.0378	365.79	370.0299	8313537.0
2022-10-21 12:00:00	SPY	ETF	370.03	371.92	369.24	371.29	9584684.0
2022-10-21 13:00:00	SPY	ETF	371.32	372.66	370.71	372.6	7023132.0
2022-10-21 14:00:00	SPY	ETF	372.62	373.36	372.04	372.9	7496395.0
2022-10-21 15:00:00	SPY	ETF	372.9	374.8	372.73	374.28	17029290.0
2022-10-21 16:00:00	SPY	ETF	374.285	375.15	374.1	375.02	7529747.0
2022-10-21 17:00:00	SPY	ETF	375.0	375.4	374.29	375.16	145093.0
2022-10-21 18:00:00	SPY	ETF	375.19	375.6	375.11	375.5	50811.0
2022-10-21 19:00:00	SPY	ETF	375.48	375.6	375.28	375.45	75194.0
2022-10-21 04:00:00	QQQ	ETF	267.02	267.48	266.39	266.58	74810.0
2022-10-21 05:00:00	QQQ	ETF	266.74	267.09	266.16	266.94	113120.0
2022-10-21 06:00:00	QQQ	ETF	266.92	267.14	266.52	267.0	80712.0
2022-10-21 07:00:00	QQQ	ETF	266.97	267.57	266.47	266.51	392161.0
2022-10-21 08:00:00	QQQ	ETF	266.9	269.311	265.43	266.53	1149038.0
2022-10-21 09:00:00	QQQ	ETF	266.5	270.75	266.5	270.75	12366084.0
2022-10-21 10:00:00	QQQ	ETF	270.75	272.38	268.85	269.1	9744801.0
2022-10-21 11:00:00	QQQ	ETF	269.11	272.1	268.19	272.07	5852875.0
2022-10-21 12:00:00	QQQ	ETF	272.1	273.15	271.28	272.58	5927276.0
2022-10-21 13:00:00	QQQ	ETF	272.63	273.99	272.33	273.985	4463722.0
2022-10-21 14:00:00	QQQ	ETF	273.99	274.68	273.54	274.25	4707833.0
2022-10-21 15:00:00	QQQ	ETF	274.27	275.969	274.06	275.47	9921300.0
2022-10-21 16:00:00	QQQ	ETF	275.46	276.21	275.35	276.04	3566271.0
2022-10-21 17:00:00	QQQ	ETF	276.08	276.29	275.91	276.05	172800.0
2022-10-21 18:00:00	QQQ	ETF	276.03	276.25	275.42	276.21	430935.0
2022-10-21 19:00:00	QQQ	ETF	276.21	276.6	275.42	276.58	77352.0
2022-10-21 04:00:00	IWM	ETF	168.58	168.78	168.08	168.15	11093.0
2022-10-21 05:00:00	IWM	ETF	168.21	168.55	167.97	168.53	39717.0
2022-10-21 06:00:00	IWM	ETF	168.48	168.75	168.22	168.7	13024.0
2022-10-21 07:00:00	IWM	ETF	168.67	168.95	168.37	168.37	56289.0
2022-10-21 08:00:00	IWM	ETF	168.55	169.82	167.67	168.46	260833.0
2022-10-21 09:00:00	IWM	ETF	168.42	170.49	168.19	170.45	4634314.0
2022-10-21 10:00:00	IWM	ETF	170.47	171.36	168.48	168.86	3712425.0
2022-10-21 11:00:00	IWM	ETF	168.87	170.85	168.35	170.77	3044029.0
2022-10-21 12:00:00	IWM	ETF	170.79	172.29	170.63	171.83	3415170.0
2022-10-21 13:00:00	IWM	ETF	171.89	172.53	171.62	172.38	1583433.0
2022-10-21 14:00:00	IWM	ETF	172.39	172.62	171.91	172.32	1858859.0
2022-10-21 15:00:00	IWM	ETF	172.33	173.2	172.21	172.79	5371856.0
2022-10-21 16:00:00	IWM	ETF	172.7	173.18	172.7	173.06	5768861.0
2022-10-21 17:00:00	IWM	ETF	173.04	173.25	173.0	173.01	45571.0
2022-10-21 18:00:00	IWM	ETF	173.01	173.64	172.7	173.33	381460.0
2022-10-21 19:00:00	IWM	ETF	173.34	173.76	172.7	173.26	15817.0
2022-10-21 04:00:00	DIA	ETF	301.95	301.95	301.95	301.95	300.0
2022-10-21 05:00:00	DIA	ETF	301.8	301.92	301.8	301.92	400.0

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

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