PREVIEW / etf_1hour / 2022-12-01

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-12-01.parquet
  size:    474 KB
  rows:    17,356

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-01 04:00:00	SPY	ETF	407.46	407.8	406.58	407.07	86278.0
2022-12-01 05:00:00	SPY	ETF	407.1	407.4	406.88	406.91	40912.0
2022-12-01 06:00:00	SPY	ETF	406.91	407.36	406.8	407.25	111574.0
2022-12-01 07:00:00	SPY	ETF	407.3	407.91	407.14	407.91	359749.0
2022-12-01 08:00:00	SPY	ETF	407.94	409.74	406.85	408.78	1436835.0
2022-12-01 09:00:00	SPY	ETF	408.71	409.72	408.16	409.0928	7801246.0
2022-12-01 10:00:00	SPY	ETF	409.14	410.0	404.75	407.59	13431825.0
2022-12-01 11:00:00	SPY	ETF	407.59	407.645	405.9	406.83	5897047.0
2022-12-01 12:00:00	SPY	ETF	406.84	407.65	405.52	407.31	4813657.0
2022-12-01 13:00:00	SPY	ETF	407.31	408.04	406.27	407.1115	4464985.0
2022-12-01 14:00:00	SPY	ETF	407.1049	408.16	406.38	407.938	5021690.0
2022-12-01 15:00:00	SPY	ETF	407.95	408.47	407.06	407.38	12119011.0
2022-12-01 16:00:00	SPY	ETF	407.37	407.4	406.84	407.08	2331058.0
2022-12-01 17:00:00	SPY	ETF	407.09	407.23	406.89	407.15	248570.0
2022-12-01 18:00:00	SPY	ETF	407.13	407.25	406.95	407.01	112807.0
2022-12-01 19:00:00	SPY	ETF	407.01	407.01	406.08	406.15	155716.0
2022-12-01 04:00:00	QQQ	ETF	293.02	293.33	292.19	292.65	358589.0
2022-12-01 05:00:00	QQQ	ETF	292.7	292.92	292.4	292.43	30457.0
2022-12-01 06:00:00	QQQ	ETF	292.39	293.0	292.31	292.87	84940.0
2022-12-01 07:00:00	QQQ	ETF	292.89	293.56	292.83	293.51	366965.0
2022-12-01 08:00:00	QQQ	ETF	293.11	295.54	292.4104	294.14	1712322.0
2022-12-01 09:00:00	QQQ	ETF	294.2	295.56	293.0698	294.94	7345518.0
2022-12-01 10:00:00	QQQ	ETF	294.96	295.75	290.88	294.02	11011028.0
2022-12-01 11:00:00	QQQ	ETF	294.05	294.11	292.39	293.02	4505362.0
2022-12-01 12:00:00	QQQ	ETF	293.02	293.71	291.88	293.41	3368421.0
2022-12-01 13:00:00	QQQ	ETF	293.39	294.08	292.7	293.5158	3055286.0
2022-12-01 14:00:00	QQQ	ETF	293.53	294.39	292.9877	294.29	2733477.0
2022-12-01 15:00:00	QQQ	ETF	294.29	294.67	293.52	293.72	5366697.0
2022-12-01 16:00:00	QQQ	ETF	293.72	293.73	293.15	293.19	1315576.0
2022-12-01 17:00:00	QQQ	ETF	293.16	293.29	293.1	293.22	51869.0
2022-12-01 18:00:00	QQQ	ETF	293.15	293.42	293.09	293.21	27227.0
2022-12-01 19:00:00	QQQ	ETF	293.15	293.15	292.5	292.56	139595.0
2022-12-01 04:00:00	IWM	ETF	187.73	187.89	187.26	187.54	25968.0
2022-12-01 05:00:00	IWM	ETF	187.59	187.91	187.57	187.69	16714.0
2022-12-01 06:00:00	IWM	ETF	187.71	188.01	187.67	187.87	67295.0
2022-12-01 07:00:00	IWM	ETF	187.84	188.2	187.72	188.17	33241.0
2022-12-01 08:00:00	IWM	ETF	187.88	188.84	187.4286	188.02	311092.0
2022-12-01 09:00:00	IWM	ETF	188.02	189.24	187.61	188.54	3017507.0
2022-12-01 10:00:00	IWM	ETF	188.55	188.9	186.13	187.5	3247151.0
2022-12-01 11:00:00	IWM	ETF	187.52	187.73	186.9001	187.55	1484927.0
2022-12-01 12:00:00	IWM	ETF	187.54	187.63	186.49	186.87	1793453.0
2022-12-01 13:00:00	IWM	ETF	186.89	187.34	186.55	186.85	1066363.0
2022-12-01 14:00:00	IWM	ETF	186.85	187.4188	186.5	187.3087	1418946.0
2022-12-01 15:00:00	IWM	ETF	187.31	187.5794	186.89	186.97	2937221.0
2022-12-01 16:00:00	IWM	ETF	186.96	186.98	186.62	186.75	1773251.0
2022-12-01 17:00:00	IWM	ETF	186.68	186.96	186.68	186.86	9549.0
2022-12-01 18:00:00	IWM	ETF	186.82	186.89	186.74	186.83	7800.0
2022-12-01 19:00:00	IWM	ETF	186.71	186.71	186.27	186.4	19248.0
2022-12-01 04:00:00	DIA	ETF	345.57	345.57	345.32	345.32	1747.0
2022-12-01 06:00:00	DIA	ETF	345.5	345.5	345.5	345.5	476.0

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

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