PREVIEW / etf_1hour / 2022-07-07

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-07-07.parquet
  size:    445 KB
  rows:    16,057

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-07 04:00:00	SPY	ETF	384.49	385.16	383.92	384.35	48689.0
2022-07-07 05:00:00	SPY	ETF	384.07	384.81	383.95	383.95	39364.0
2022-07-07 06:00:00	SPY	ETF	383.98	384.44	383.43	384.44	42253.0
2022-07-07 07:00:00	SPY	ETF	384.42	384.95	383.87	384.92	219029.0
2022-07-07 08:00:00	SPY	ETF	384.05	385.25	383.88	384.95	387013.0
2022-07-07 09:00:00	SPY	ETF	384.93	387.6	384.75	387.385	6263880.0
2022-07-07 10:00:00	SPY	ETF	387.39	387.83	386.06	387.38	7087538.0
2022-07-07 11:00:00	SPY	ETF	387.37	388.25	386.98	387.885	4597615.0
2022-07-07 12:00:00	SPY	ETF	387.885	388.4	387.65	388.04	4384566.0
2022-07-07 13:00:00	SPY	ETF	388.05	388.49	387.34	388.42	3639478.0
2022-07-07 14:00:00	SPY	ETF	388.42	388.97	388.33	388.8615	4808004.0
2022-07-07 15:00:00	SPY	ETF	388.88	389.83	388.57	388.94	13177697.0
2022-07-07 16:00:00	SPY	ETF	388.94	388.99	388.3	388.38	3302269.0
2022-07-07 17:00:00	SPY	ETF	388.31	388.6	388.07	388.15	239593.0
2022-07-07 18:00:00	SPY	ETF	388.15	388.52	388.15	388.49	131084.0
2022-07-07 19:00:00	SPY	ETF	388.45	388.49	387.7	388.16	70352.0
2022-07-07 04:00:00	QQQ	ETF	289.85	290.73	289.54	290.42	94655.0
2022-07-07 05:00:00	QQQ	ETF	289.8	290.32	289.45	289.5	32858.0
2022-07-07 06:00:00	QQQ	ETF	289.52	289.93	288.98	289.93	39516.0
2022-07-07 07:00:00	QQQ	ETF	289.94	290.34	289.46	290.27	183010.0
2022-07-07 08:00:00	QQQ	ETF	289.88	290.36	289.016	289.94	551902.0
2022-07-07 09:00:00	QQQ	ETF	289.8901	292.81	289.52	292.44	5716986.0
2022-07-07 10:00:00	QQQ	ETF	292.45	293.27	291.37	292.83	5935560.0
2022-07-07 11:00:00	QQQ	ETF	292.84	293.77	292.28	293.77	4396574.0
2022-07-07 12:00:00	QQQ	ETF	293.78	294.24	293.43	294.0943	3326422.0
2022-07-07 13:00:00	QQQ	ETF	294.085	294.68	293.5385	294.671	2910008.0
2022-07-07 14:00:00	QQQ	ETF	294.69	295.17	294.42	294.875	3959158.0
2022-07-07 15:00:00	QQQ	ETF	294.89	295.7	294.6	294.94	9427861.0
2022-07-07 16:00:00	QQQ	ETF	294.94	295.6	294.42	294.54	3068665.0
2022-07-07 17:00:00	QQQ	ETF	294.48	294.58	294.36	294.36	64299.0
2022-07-07 18:00:00	QQQ	ETF	294.36	294.59	294.11	294.32	137051.0
2022-07-07 19:00:00	QQQ	ETF	294.32	294.37	294.01	294.21	158525.0
2022-07-07 04:00:00	IWM	ETF	172.46	172.58	171.83	172.21	25248.0
2022-07-07 05:00:00	IWM	ETF	172.01	172.48	172.01	172.11	6621.0
2022-07-07 06:00:00	IWM	ETF	172.04	172.25	171.71	172.23	4946.0
2022-07-07 07:00:00	IWM	ETF	172.17	172.44	171.84	172.44	39468.0
2022-07-07 08:00:00	IWM	ETF	172.2299	172.7	171.95	172.64	84474.0
2022-07-07 09:00:00	IWM	ETF	172.57	175.35	172.56	175.13	2706242.0
2022-07-07 10:00:00	IWM	ETF	175.12	175.65	174.1839	175.28	2666220.0
2022-07-07 11:00:00	IWM	ETF	175.29	175.67	175.07	175.38	1162234.0
2022-07-07 12:00:00	IWM	ETF	175.38	175.79	175.28	175.64	1147515.0
2022-07-07 13:00:00	IWM	ETF	175.65	175.89	175.445	175.85	1119684.0
2022-07-07 14:00:00	IWM	ETF	175.855	175.98	175.37	175.77	2084990.0
2022-07-07 15:00:00	IWM	ETF	175.77	175.91	175.29	175.64	4519983.0
2022-07-07 16:00:00	IWM	ETF	175.61	175.78	175.27	175.37	1946573.0
2022-07-07 17:00:00	IWM	ETF	175.27	175.45	175.2174	175.39	8137.0
2022-07-07 18:00:00	IWM	ETF	175.32	175.54	175.25	175.38	24461.0
2022-07-07 19:00:00	IWM	ETF	175.38	175.39	175.17	175.29	41142.0
2022-07-07 04:00:00	DIA	ETF	311.8	311.8	311.03	311.03	1230.0
2022-07-07 05:00:00	DIA	ETF	311.27	311.69	311.27	311.34	400.0

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

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