PREVIEW / etf_1hour / 2022-07-11

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-07-11.parquet
  size:    440 KB
  rows:    16,027

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-11 04:00:00	SPY	ETF	385.86	386.57	385.63	386.19	54959.0
2022-07-11 05:00:00	SPY	ETF	386.05	386.77	386.05	386.24	9552.0
2022-07-11 06:00:00	SPY	ETF	386.27	387.06	386.07	386.53	34149.0
2022-07-11 07:00:00	SPY	ETF	386.59	386.98	385.67	385.83	156985.0
2022-07-11 08:00:00	SPY	ETF	386.88	386.95	385.49	386.07	272792.0
2022-07-11 09:00:00	SPY	ETF	386.06	386.87	383.67	384.6301	6913087.0
2022-07-11 10:00:00	SPY	ETF	384.655	385.54	383.66	384.1	7778138.0
2022-07-11 11:00:00	SPY	ETF	384.11	385.37	384.01	384.59	4244814.0
2022-07-11 12:00:00	SPY	ETF	384.59	385.245	384.24	385.0299	3229276.0
2022-07-11 13:00:00	SPY	ETF	385.02	386.82	384.91	386.415	4359950.0
2022-07-11 14:00:00	SPY	ETF	386.4	386.47	384.59	384.59	4834988.0
2022-07-11 15:00:00	SPY	ETF	384.59	384.76	383.5	384.28	10433587.0
2022-07-11 16:00:00	SPY	ETF	384.29	384.87	384.23	384.65	3316404.0
2022-07-11 17:00:00	SPY	ETF	384.65	384.8	384.23	384.65	89357.0
2022-07-11 18:00:00	SPY	ETF	384.66	384.67	384.01	384.18	81767.0
2022-07-11 19:00:00	SPY	ETF	384.08	385.0	384.08	384.84	80629.0
2022-07-11 04:00:00	QQQ	ETF	293.0	293.38	292.56	293.0	75824.0
2022-07-11 05:00:00	QQQ	ETF	292.96	293.46	292.85	292.88	55829.0
2022-07-11 06:00:00	QQQ	ETF	292.81	293.64	292.74	293.11	81036.0
2022-07-11 07:00:00	QQQ	ETF	293.2	293.56	292.54	292.73	203379.0
2022-07-11 08:00:00	QQQ	ETF	293.48	295.571	292.21	293.31	303508.0
2022-07-11 09:00:00	QQQ	ETF	293.3	293.47	288.2	288.91	7637672.0
2022-07-11 10:00:00	QQQ	ETF	288.91	290.905	288.14	289.4799	7292709.0
2022-07-11 11:00:00	QQQ	ETF	289.47	290.72	289.21	289.67	3849915.0
2022-07-11 12:00:00	QQQ	ETF	289.64	290.38	289.31	290.0	2454963.0
2022-07-11 13:00:00	QQQ	ETF	290.0167	291.79	289.95	291.31	3263650.0
2022-07-11 14:00:00	QQQ	ETF	291.31	291.3799	289.39	289.39	3956509.0
2022-07-11 15:00:00	QQQ	ETF	289.38	289.555	288.21	288.98	8285569.0
2022-07-11 16:00:00	QQQ	ETF	288.99	289.6	288.84	289.25	1809784.0
2022-07-11 17:00:00	QQQ	ETF	289.21	289.28	289.04	289.14	220316.0
2022-07-11 18:00:00	QQQ	ETF	289.14	289.26	288.65	288.75	159833.0
2022-07-11 19:00:00	QQQ	ETF	288.75	289.34	288.73	289.27	109575.0
2022-07-11 04:00:00	IWM	ETF	174.04	174.46	173.94	174.33	20958.0
2022-07-11 05:00:00	IWM	ETF	174.35	174.7	174.26	174.42	27408.0
2022-07-11 06:00:00	IWM	ETF	174.36	174.88	174.33	174.7	10038.0
2022-07-11 07:00:00	IWM	ETF	174.7	174.85	174.2	174.23	19406.0
2022-07-11 08:00:00	IWM	ETF	174.6396	174.85	174.07	174.26	156624.0
2022-07-11 09:00:00	IWM	ETF	174.27	174.97	172.31	173.03	2242097.0
2022-07-11 10:00:00	IWM	ETF	173.03	173.2998	171.82	172.16	3155245.0
2022-07-11 11:00:00	IWM	ETF	172.165	172.98	172.09	172.28	1508496.0
2022-07-11 12:00:00	IWM	ETF	172.29	172.5387	171.94	172.275	1446560.0
2022-07-11 13:00:00	IWM	ETF	172.275	173.41	172.23	173.16	1302808.0
2022-07-11 14:00:00	IWM	ETF	173.15	173.18	172.35	172.35	1095261.0
2022-07-11 15:00:00	IWM	ETF	172.34	172.5	171.6	172.02	3189475.0
2022-07-11 16:00:00	IWM	ETF	172.06	172.42	172.03	172.29	2575521.0
2022-07-11 17:00:00	IWM	ETF	172.42	172.42	172.06	172.22	1086115.0
2022-07-11 18:00:00	IWM	ETF	172.3	172.3	171.97	172.02	20362.0
2022-07-11 19:00:00	IWM	ETF	172.06	172.43	172.05	172.42	24888.0
2022-07-11 04:00:00	DIA	ETF	311.25	311.66	311.25	311.62	3100.0
2022-07-11 05:00:00	DIA	ETF	312.01	312.01	312.01	312.01	600.0

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

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