PREVIEW / etf_1hour / 2022-07-28

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-07-28.parquet
  size:    448 KB
  rows:    16,232

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-28 04:00:00	SPY	ETF	401.04	401.04	399.5	399.61	54930.0
2022-07-28 05:00:00	SPY	ETF	399.72	399.93	399.19	399.9	73264.0
2022-07-28 06:00:00	SPY	ETF	399.94	400.24	399.72	400.0	38745.0
2022-07-28 07:00:00	SPY	ETF	399.99	400.36	399.99	400.1	166921.0
2022-07-28 08:00:00	SPY	ETF	400.21	401.65	399.06	400.81	1236311.0
2022-07-28 09:00:00	SPY	ETF	400.83	402.77	398.33	399.34	7146819.0
2022-07-28 10:00:00	SPY	ETF	399.38	401.6	398.15	401.56	8740763.0
2022-07-28 11:00:00	SPY	ETF	401.57	404.49	401.42	403.65	8083586.0
2022-07-28 12:00:00	SPY	ETF	403.65	404.42	403.33	404.0776	3635475.0
2022-07-28 13:00:00	SPY	ETF	404.07	406.42	403.61	406.15	5461557.0
2022-07-28 14:00:00	SPY	ETF	406.16	406.32	405.39	406.2	5730917.0
2022-07-28 15:00:00	SPY	ETF	406.22	406.8	405.52	406.01	11313599.0
2022-07-28 16:00:00	SPY	ETF	406.01	409.72	405.93	409.21	4496430.0
2022-07-28 17:00:00	SPY	ETF	409.13	409.45	408.85	409.11	228157.0
2022-07-28 18:00:00	SPY	ETF	409.1	409.1	408.0	408.14	134725.0
2022-07-28 19:00:00	SPY	ETF	408.19	408.35	407.85	408.31	44466.0
2022-07-28 04:00:00	QQQ	ETF	305.6	305.6	303.95	304.1	73945.0
2022-07-28 05:00:00	QQQ	ETF	304.2	304.61	303.57	304.53	150052.0
2022-07-28 06:00:00	QQQ	ETF	304.6	305.06	304.44	304.97	80365.0
2022-07-28 07:00:00	QQQ	ETF	305.0	305.3	304.79	304.92	285852.0
2022-07-28 08:00:00	QQQ	ETF	305.1	307.04	303.71	305.9	1605142.0
2022-07-28 09:00:00	QQQ	ETF	305.9	307.69	302.87	303.71	7451659.0
2022-07-28 10:00:00	QQQ	ETF	303.75	305.87	302.745	305.83	6818398.0
2022-07-28 11:00:00	QQQ	ETF	305.85	308.7205	305.76	307.99	6979189.0
2022-07-28 12:00:00	QQQ	ETF	307.99	308.34	307.275	307.49	3373955.0
2022-07-28 13:00:00	QQQ	ETF	307.49	309.77	306.9871	309.54	4453149.0
2022-07-28 14:00:00	QQQ	ETF	309.55	309.86	308.67	309.73	3984845.0
2022-07-28 15:00:00	QQQ	ETF	309.73	310.3965	309.11	309.76	6426954.0
2022-07-28 16:00:00	QQQ	ETF	309.76	314.88	309.6	314.29	3028772.0
2022-07-28 17:00:00	QQQ	ETF	314.32	314.58	313.58	314.2	416470.0
2022-07-28 18:00:00	QQQ	ETF	314.05	314.05	313.14	313.31	511787.0
2022-07-28 19:00:00	QQQ	ETF	313.29	313.63	313.07	313.6	114506.0
2022-07-28 04:00:00	IWM	ETF	183.49	183.62	183.24	183.25	21323.0
2022-07-28 05:00:00	IWM	ETF	183.36	183.48	183.13	183.43	57931.0
2022-07-28 06:00:00	IWM	ETF	183.48	183.53	183.31	183.42	7563.0
2022-07-28 07:00:00	IWM	ETF	183.5	183.73	183.48	183.55	36657.0
2022-07-28 08:00:00	IWM	ETF	183.55	184.12	182.97	183.61	175882.0
2022-07-28 09:00:00	IWM	ETF	183.69	185.45	182.81	183.04	3026674.0
2022-07-28 10:00:00	IWM	ETF	183.04	183.55	181.76	183.225	2794017.0
2022-07-28 11:00:00	IWM	ETF	183.235	185.22	183.14	184.92	2477825.0
2022-07-28 12:00:00	IWM	ETF	184.92	185.08	184.55	184.875	1588083.0
2022-07-28 13:00:00	IWM	ETF	184.87	185.56	184.635	185.39	1557933.0
2022-07-28 14:00:00	IWM	ETF	185.36	185.63	185.07	185.61	989832.0
2022-07-28 15:00:00	IWM	ETF	185.603	186.14	185.53	185.93	3280668.0
2022-07-28 16:00:00	IWM	ETF	185.93	186.74	185.61	186.21	870828.0
2022-07-28 17:00:00	IWM	ETF	186.22	186.7	186.19	186.35	68333.0
2022-07-28 18:00:00	IWM	ETF	186.35	186.35	185.78	185.92	64776.0
2022-07-28 19:00:00	IWM	ETF	185.87	186.08	185.76	185.95	19936.0
2022-07-28 04:00:00	DIA	ETF	321.74	321.74	321.51	321.51	1700.0
2022-07-28 05:00:00	DIA	ETF	321.5	321.66	321.26	321.66	1900.0

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

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