PREVIEW / etf_1hour / 2022-10-24

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-10-24.parquet
  size:    462 KB
  rows:    17,056

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-24 04:00:00	SPY	ETF	373.95	374.45	371.63	372.85	182403.0
2022-10-24 05:00:00	SPY	ETF	372.86	374.69	372.2	374.61	92064.0
2022-10-24 06:00:00	SPY	ETF	374.51	376.01	374.02	376.0	153545.0
2022-10-24 07:00:00	SPY	ETF	375.99	378.11	375.26	377.11	643235.0
2022-10-24 08:00:00	SPY	ETF	375.94	378.08	371.6896	377.15	898294.0
2022-10-24 09:00:00	SPY	ETF	377.15	378.76	375.09	377.68	10695757.0
2022-10-24 10:00:00	SPY	ETF	377.69	377.71	373.11	376.615	11687728.0
2022-10-24 11:00:00	SPY	ETF	376.62	378.2	375.46	378.08	7023746.0
2022-10-24 12:00:00	SPY	ETF	378.09	378.679	377.44	377.69	5175878.0
2022-10-24 13:00:00	SPY	ETF	377.7	377.82	376.61	377.16	4567012.0
2022-10-24 14:00:00	SPY	ETF	377.17	379.5	377.05	379.34	5659124.0
2022-10-24 15:00:00	SPY	ETF	379.35	380.06	378.13	378.84	13804881.0
2022-10-24 16:00:00	SPY	ETF	378.84	378.89	378.21	378.4	4844111.0
2022-10-24 17:00:00	SPY	ETF	378.37	378.75	378.35	378.47	190672.0
2022-10-24 18:00:00	SPY	ETF	378.47	379.24	378.3	379.24	151247.0
2022-10-24 19:00:00	SPY	ETF	379.23	379.44	378.71	378.86	108450.0
2022-10-24 04:00:00	QQQ	ETF	275.1	275.19	273.25	274.08	143711.0
2022-10-24 05:00:00	QQQ	ETF	273.99	275.57	273.58	275.42	98512.0
2022-10-24 06:00:00	QQQ	ETF	275.37	276.35	274.81	276.25	172090.0
2022-10-24 07:00:00	QQQ	ETF	276.2	277.8	275.71	276.96	373250.0
2022-10-24 08:00:00	QQQ	ETF	276.0505	277.8	273.3796	276.69	936583.0
2022-10-24 09:00:00	QQQ	ETF	276.67	277.27	274.23	275.71	11116910.0
2022-10-24 10:00:00	QQQ	ETF	275.73	275.75	271.97	275.49	9255537.0
2022-10-24 11:00:00	QQQ	ETF	275.49	277.13	274.725	277.065	5428323.0
2022-10-24 12:00:00	QQQ	ETF	277.07	277.95	276.4601	277.3	5118534.0
2022-10-24 13:00:00	QQQ	ETF	277.3098	277.37	275.96	276.49	4245075.0
2022-10-24 14:00:00	QQQ	ETF	276.49	278.57	276.37	278.52	3929965.0
2022-10-24 15:00:00	QQQ	ETF	278.51	279.4	277.92	278.54	7555732.0
2022-10-24 16:00:00	QQQ	ETF	278.53	278.6702	277.91	278.04	1587648.0
2022-10-24 17:00:00	QQQ	ETF	277.96	278.25	277.95	278.0	153457.0
2022-10-24 18:00:00	QQQ	ETF	278.0	278.6	277.96	278.6	115687.0
2022-10-24 19:00:00	QQQ	ETF	278.57	278.77	278.27	278.41	113642.0
2022-10-24 04:00:00	IWM	ETF	172.8	172.8	171.3	171.87	25843.0
2022-10-24 05:00:00	IWM	ETF	171.85	172.9	171.58	172.82	32522.0
2022-10-24 06:00:00	IWM	ETF	172.8	173.5	172.6	173.42	16938.0
2022-10-24 07:00:00	IWM	ETF	173.59	174.68	173.35	174.12	85289.0
2022-10-24 08:00:00	IWM	ETF	173.4094	174.47	171.38	174.0	129353.0
2022-10-24 09:00:00	IWM	ETF	173.94	174.0	171.93	173.37	3726760.0
2022-10-24 10:00:00	IWM	ETF	173.41	173.44	171.05	172.55	3491148.0
2022-10-24 11:00:00	IWM	ETF	172.58	173.56	171.77	173.53	2292517.0
2022-10-24 12:00:00	IWM	ETF	173.54	173.87	173.08	173.12	1865434.0
2022-10-24 13:00:00	IWM	ETF	173.13	173.3	172.5	172.72	1858497.0
2022-10-24 14:00:00	IWM	ETF	172.73	173.66	172.69	173.54	1476617.0
2022-10-24 15:00:00	IWM	ETF	173.56	174.0	173.34	173.46	4032062.0
2022-10-24 16:00:00	IWM	ETF	173.46	173.62	173.3668	173.45	2036979.0
2022-10-24 17:00:00	IWM	ETF	173.41	173.62	173.41	173.56	18239.0
2022-10-24 18:00:00	IWM	ETF	173.5	173.88	173.4	173.88	20867.0
2022-10-24 19:00:00	IWM	ETF	173.88	174.02	173.61	173.75	38032.0
2022-10-24 04:00:00	DIA	ETF	310.0	310.03	309.02	310.03	1601.0
2022-10-24 05:00:00	DIA	ETF	309.91	311.11	309.49	311.11	5630.0

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

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