PREVIEW / etf_1hour / 2022-07-15

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-07-15.parquet
  size:    438 KB
  rows:    15,968

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-07-15 04:00:00	SPY	ETF	378.14	379.38	377.59	378.89	30757.0
2022-07-15 05:00:00	SPY	ETF	378.87	379.41	378.5	378.66	17473.0
2022-07-15 06:00:00	SPY	ETF	378.38	379.06	378.35	378.85	38367.0
2022-07-15 07:00:00	SPY	ETF	378.87	379.5	378.7	378.7	119980.0
2022-07-15 08:00:00	SPY	ETF	378.89	381.82	377.0	381.31	1084139.0
2022-07-15 09:00:00	SPY	ETF	381.26	383.34	380.54	381.41	7614778.0
2022-07-15 10:00:00	SPY	ETF	381.64	384.33	381.43	383.71	9911120.0
2022-07-15 11:00:00	SPY	ETF	383.6969	384.85	383.58	384.0	5583733.0
2022-07-15 12:00:00	SPY	ETF	384.01	384.31	383.22	383.77	3763554.0
2022-07-15 13:00:00	SPY	ETF	383.78	384.78	383.76	384.19	3790360.0
2022-07-15 14:00:00	SPY	ETF	384.19	384.78	383.7137	384.35	4017642.0
2022-07-15 15:00:00	SPY	ETF	384.3501	385.25	383.6	385.1	11134227.0
2022-07-15 16:00:00	SPY	ETF	385.1	385.36	384.81	385.25	4174936.0
2022-07-15 17:00:00	SPY	ETF	385.25	385.37	384.96	385.2	472442.0
2022-07-15 18:00:00	SPY	ETF	385.19	385.27	385.02	385.05	13079.0
2022-07-15 19:00:00	SPY	ETF	385.09	385.29	385.06	385.2	19925.0
2022-07-15 04:00:00	QQQ	ETF	286.82	288.0	286.44	287.59	100539.0
2022-07-15 05:00:00	QQQ	ETF	287.59	287.91	287.11	287.11	68651.0
2022-07-15 06:00:00	QQQ	ETF	287.08	287.47	286.95	287.38	29574.0
2022-07-15 07:00:00	QQQ	ETF	287.37	287.77	286.86	286.87	156924.0
2022-07-15 08:00:00	QQQ	ETF	286.93	289.34	285.2645	288.96	1323664.0
2022-07-15 09:00:00	QQQ	ETF	289.0	291.23	288.08	289.25	7797238.0
2022-07-15 10:00:00	QQQ	ETF	289.28	291.33	289.01	290.31	7787453.0
2022-07-15 11:00:00	QQQ	ETF	290.31	291.62	290.16	290.5901	4373047.0
2022-07-15 12:00:00	QQQ	ETF	290.6	290.87	289.93	290.53	3645191.0
2022-07-15 13:00:00	QQQ	ETF	290.54	291.41	290.4302	291.18	2847007.0
2022-07-15 14:00:00	QQQ	ETF	291.19	291.575	290.57	291.19	2770705.0
2022-07-15 15:00:00	QQQ	ETF	291.188	291.98	290.6	291.9	6581605.0
2022-07-15 16:00:00	QQQ	ETF	291.89	292.15	291.63	292.09	2502681.0
2022-07-15 17:00:00	QQQ	ETF	292.07	292.32	291.87	292.05	187045.0
2022-07-15 18:00:00	QQQ	ETF	292.02	292.1	291.87	291.98	597342.0
2022-07-15 19:00:00	QQQ	ETF	291.98	292.08	291.82	292.08	57192.0
2022-07-15 04:00:00	IWM	ETF	169.61	170.37	169.42	170.1	18971.0
2022-07-15 05:00:00	IWM	ETF	170.17	170.4	169.94	169.99	5436.0
2022-07-15 06:00:00	IWM	ETF	170.0	170.2	169.9	170.14	15503.0
2022-07-15 07:00:00	IWM	ETF	170.1	170.33	169.97	169.97	25320.0
2022-07-15 08:00:00	IWM	ETF	170.31	171.18	169.22	170.83	165965.0
2022-07-15 09:00:00	IWM	ETF	170.87	172.355	169.31	169.79	3380744.0
2022-07-15 10:00:00	IWM	ETF	169.81	171.64	169.81	171.19	2538585.0
2022-07-15 11:00:00	IWM	ETF	171.17	172.5	171.11	172.43	1956832.0
2022-07-15 12:00:00	IWM	ETF	172.435	173.08	172.37	172.89	2109733.0
2022-07-15 13:00:00	IWM	ETF	172.89	173.345	172.85	172.93	1596926.0
2022-07-15 14:00:00	IWM	ETF	172.93	173.12	172.6	172.92	1708391.0
2022-07-15 15:00:00	IWM	ETF	172.92	173.21	172.66	173.09	4188881.0
2022-07-15 16:00:00	IWM	ETF	173.09	173.31	173.02	173.16	1973246.0
2022-07-15 17:00:00	IWM	ETF	173.17	173.33	173.09	173.27	368174.0
2022-07-15 18:00:00	IWM	ETF	173.21	173.28	173.09	173.22	496236.0
2022-07-15 19:00:00	IWM	ETF	173.21	173.46	173.21	173.35	43756.0
2022-07-15 04:00:00	DIA	ETF	306.31	307.14	306.08	306.92	2979.0
2022-07-15 05:00:00	DIA	ETF	306.8	306.8	306.68	306.68	580.0

> showing 50 of 15,968 rows — these rows as CSV

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