PREVIEW / etf_1hour / 2022-06-24

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-06-24.parquet
  size:    451 KB
  rows:    16,383

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-06-24 04:00:00	SPY	ETF	380.77	381.25	380.0	380.84	55438.0
2022-06-24 05:00:00	SPY	ETF	380.8	381.28	380.65	381.28	28879.0
2022-06-24 06:00:00	SPY	ETF	381.31	381.7	380.95	381.11	115442.0
2022-06-24 07:00:00	SPY	ETF	381.07	381.6	380.6	380.84	377882.0
2022-06-24 08:00:00	SPY	ETF	381.2001	381.6	377.31	380.84	502737.0
2022-06-24 09:00:00	SPY	ETF	380.8	384.14	380.74	383.785	8545569.0
2022-06-24 10:00:00	SPY	ETF	383.83	387.17	383.8	386.49	13292274.0
2022-06-24 11:00:00	SPY	ETF	386.49	387.23	385.96	387.01	6991490.0
2022-06-24 12:00:00	SPY	ETF	387.02	387.46	386.54	387.225	4200974.0
2022-06-24 13:00:00	SPY	ETF	387.23	387.63	386.81	386.99	4854666.0
2022-06-24 14:00:00	SPY	ETF	386.9953	387.92	386.77	387.85	4828756.0
2022-06-24 15:00:00	SPY	ETF	387.87	390.09	387.62	390.05	20025948.0
2022-06-24 16:00:00	SPY	ETF	390.04	390.08	388.64	389.59	6880359.0
2022-06-24 17:00:00	SPY	ETF	389.64	390.08	389.12	389.33	974437.0
2022-06-24 18:00:00	SPY	ETF	389.35	389.58	389.3	389.55	18622.0
2022-06-24 19:00:00	SPY	ETF	389.55	389.94	389.3	389.63	49227.0
2022-06-24 04:00:00	QQQ	ETF	286.32	288.15	286.32	287.56	156690.0
2022-06-24 05:00:00	QQQ	ETF	287.51	287.84	287.29	287.84	40827.0
2022-06-24 06:00:00	QQQ	ETF	287.84	288.04	287.56	287.66	89624.0
2022-06-24 07:00:00	QQQ	ETF	287.55	287.91	286.88	287.05	363601.0
2022-06-24 08:00:00	QQQ	ETF	287.5299	287.92	285.063	287.16	442058.0
2022-06-24 09:00:00	QQQ	ETF	287.12	291.04	287.08	290.32	7395583.0
2022-06-24 10:00:00	QQQ	ETF	290.34	293.41	290.34	291.74	9480973.0
2022-06-24 11:00:00	QQQ	ETF	291.74	292.42	290.67	291.7466	4756068.0
2022-06-24 12:00:00	QQQ	ETF	291.76	292.17	291.25	292.07	2610545.0
2022-06-24 13:00:00	QQQ	ETF	292.06	292.32	291.37	291.58	2341818.0
2022-06-24 14:00:00	QQQ	ETF	291.62	292.8	291.4	292.74	3434012.0
2022-06-24 15:00:00	QQQ	ETF	292.74	295.0	292.311	294.99	9868645.0
2022-06-24 16:00:00	QQQ	ETF	294.98	295.04	293.8	294.56	5421829.0
2022-06-24 17:00:00	QQQ	ETF	294.3	294.49	294.13	294.34	169956.0
2022-06-24 18:00:00	QQQ	ETF	294.34	294.62	294.34	294.55	45466.0
2022-06-24 19:00:00	QQQ	ETF	294.57	294.9	294.15	294.51	47924.0
2022-06-24 04:00:00	IWM	ETF	170.34	171.22	170.34	171.12	30054.0
2022-06-24 05:00:00	IWM	ETF	171.14	171.53	171.01	171.53	12672.0
2022-06-24 06:00:00	IWM	ETF	171.61	171.8	171.17	171.3	39074.0
2022-06-24 07:00:00	IWM	ETF	171.25	171.57	171.08	171.23	42677.0
2022-06-24 08:00:00	IWM	ETF	171.31	171.38	170.92	170.94	49796.0
2022-06-24 09:00:00	IWM	ETF	170.99	173.04	170.9	172.87	2406673.0
2022-06-24 10:00:00	IWM	ETF	172.92	174.58	172.91	174.27	4085128.0
2022-06-24 11:00:00	IWM	ETF	174.29	174.49	173.55	174.22	1723271.0
2022-06-24 12:00:00	IWM	ETF	174.23	174.45	173.97	174.365	1419817.0
2022-06-24 13:00:00	IWM	ETF	174.37	174.51	174.18	174.24	1645340.0
2022-06-24 14:00:00	IWM	ETF	174.24	174.38	174.01	174.36	1908618.0
2022-06-24 15:00:00	IWM	ETF	174.36	175.1	174.2	175.06	9598168.0
2022-06-24 16:00:00	IWM	ETF	175.07	175.24	174.3	175.0	4605381.0
2022-06-24 17:00:00	IWM	ETF	174.78	175.05	174.41	174.62	39625.0
2022-06-24 18:00:00	IWM	ETF	174.6	174.98	174.6	174.95	29851.0
2022-06-24 19:00:00	IWM	ETF	174.8	175.25	174.75	175.1	15201.0
2022-06-24 04:00:00	DIA	ETF	308.53	308.53	308.05	308.05	500.0
2022-06-24 05:00:00	DIA	ETF	308.64	308.64	308.64	308.64	809.0

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

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