PREVIEW / etf_1hour / 2023-01-30

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-01-30.parquet
  size:    477 KB
  rows:    17,570

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
2023-01-30 04:00:00	SPY	ETF	402.68	404.44	401.85	402.36	384874.0
2023-01-30 05:00:00	SPY	ETF	402.31	402.6	402.05	402.3	28873.0
2023-01-30 06:00:00	SPY	ETF	402.5	402.54	401.42	401.77	89011.0
2023-01-30 07:00:00	SPY	ETF	401.86	402.51	401.86	402.32	496546.0
2023-01-30 08:00:00	SPY	ETF	401.96	404.56	401.525	402.6	549481.0
2023-01-30 09:00:00	SPY	ETF	402.63	404.6	402.42	404.34	5327835.0
2023-01-30 10:00:00	SPY	ETF	404.325	405.13	401.93	403.01	9754844.0
2023-01-30 11:00:00	SPY	ETF	403.01	403.88	402.005	403.1981	5900279.0
2023-01-30 12:00:00	SPY	ETF	403.192	403.41	401.925	402.09	3587077.0
2023-01-30 13:00:00	SPY	ETF	402.09	403.065	401.7	402.25	4162344.0
2023-01-30 14:00:00	SPY	ETF	402.25	402.43	400.92	401.3201	6205085.0
2023-01-30 15:00:00	SPY	ETF	401.32	401.79	400.28	400.63	15044090.0
2023-01-30 16:00:00	SPY	ETF	400.63	401.49	400.551	401.33	6348317.0
2023-01-30 17:00:00	SPY	ETF	401.32	401.38	401.07	401.19	93326.0
2023-01-30 18:00:00	SPY	ETF	401.22	401.7	401.08	401.7	158118.0
2023-01-30 19:00:00	SPY	ETF	401.69	401.69	401.18	401.44	68860.0
2023-01-30 04:00:00	QQQ	ETF	293.1	295.37	292.25	292.68	92529.0
2023-01-30 05:00:00	QQQ	ETF	292.55	292.84	292.41	292.63	25553.0
2023-01-30 06:00:00	QQQ	ETF	292.76	292.76	291.87	292.36	115012.0
2023-01-30 07:00:00	QQQ	ETF	292.32	293.07	292.32	292.92	319375.0
2023-01-30 08:00:00	QQQ	ETF	292.43	296.482	291.94	292.98	602785.0
2023-01-30 09:00:00	QQQ	ETF	292.97	294.0925	292.33	293.8	4798082.0
2023-01-30 10:00:00	QQQ	ETF	293.76	294.38	290.46	291.5501	6906440.0
2023-01-30 11:00:00	QQQ	ETF	291.56	292.63	291.14	292.345	3910233.0
2023-01-30 12:00:00	QQQ	ETF	292.35	292.54	291.02	291.37	2619974.0
2023-01-30 13:00:00	QQQ	ETF	291.38	292.28	290.85	291.4299	3036127.0
2023-01-30 14:00:00	QQQ	ETF	291.42	291.73	290.475	290.9	3686127.0
2023-01-30 15:00:00	QQQ	ETF	290.8999	291.36	289.89	290.14	7797127.0
2023-01-30 16:00:00	QQQ	ETF	290.15	290.76	290.14	290.62	2221168.0
2023-01-30 17:00:00	QQQ	ETF	290.6	292.78	290.27	290.3	112541.0
2023-01-30 18:00:00	QQQ	ETF	290.35	290.95	290.35	290.92	152220.0
2023-01-30 19:00:00	QQQ	ETF	290.89	290.95	290.5	290.72	39624.0
2023-01-30 04:00:00	IWM	ETF	188.12	188.3	187.78	187.91	26220.0
2023-01-30 05:00:00	IWM	ETF	187.91	187.98	187.83	187.93	4530.0
2023-01-30 06:00:00	IWM	ETF	187.99	188.0	187.46	187.72	233721.0
2023-01-30 07:00:00	IWM	ETF	187.75	187.98	187.71	187.89	46490.0
2023-01-30 08:00:00	IWM	ETF	187.75	188.01	187.68	187.84	63084.0
2023-01-30 09:00:00	IWM	ETF	187.84	188.715	187.69	188.57	2220479.0
2023-01-30 10:00:00	IWM	ETF	188.54	189.61	187.62	188.005	2727819.0
2023-01-30 11:00:00	IWM	ETF	188.01	188.635	187.665	188.26	1424687.0
2023-01-30 12:00:00	IWM	ETF	188.24	188.53	187.84	188.0	611971.0
2023-01-30 13:00:00	IWM	ETF	187.98	188.63	187.83	188.0801	763884.0
2023-01-30 14:00:00	IWM	ETF	188.08	188.25	187.27	187.5	1047187.0
2023-01-30 15:00:00	IWM	ETF	187.48	187.69	186.83	186.99	3317006.0
2023-01-30 16:00:00	IWM	ETF	186.94	187.43	186.94	187.39	1395319.0
2023-01-30 17:00:00	IWM	ETF	187.16	187.33	187.13	187.15	7999.0
2023-01-30 18:00:00	IWM	ETF	187.24	187.64	187.24	187.58	34607.0
2023-01-30 19:00:00	IWM	ETF	187.59	187.66	187.41	187.58	36554.0
2023-01-30 04:00:00	DIA	ETF	338.93	338.93	337.53	337.77	1738.0
2023-01-30 05:00:00	DIA	ETF	337.66	337.71	337.66	337.71	200.0

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

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