PREVIEW / etf_1hour / 2022-08-31

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-08-31.parquet
  size:    444 KB
  rows:    16,314

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-08-31 04:00:00	SPY	ETF	398.98	399.52	398.18	398.66	45401.0
2022-08-31 05:00:00	SPY	ETF	398.62	398.62	397.58	398.0	51633.0
2022-08-31 06:00:00	SPY	ETF	398.06	399.92	397.59	399.35	83081.0
2022-08-31 07:00:00	SPY	ETF	399.26	399.84	398.76	399.32	157363.0
2022-08-31 08:00:00	SPY	ETF	399.25	401.11	397.7696	399.91	556825.0
2022-08-31 09:00:00	SPY	ETF	399.99	401.24	398.2	399.6018	7111148.0
2022-08-31 10:00:00	SPY	ETF	399.61	399.74	397.55	398.29	7362268.0
2022-08-31 11:00:00	SPY	ETF	398.28	399.2801	396.75	399.0168	5298560.0
2022-08-31 12:00:00	SPY	ETF	399.02	399.2199	397.28	397.6975	3642393.0
2022-08-31 13:00:00	SPY	ETF	397.68	398.378	396.1601	396.7553	3768153.0
2022-08-31 14:00:00	SPY	ETF	396.755	397.27	395.24	395.908	6000634.0
2022-08-31 15:00:00	SPY	ETF	395.91	397.95	395.04	395.13	16343890.0
2022-08-31 16:00:00	SPY	ETF	395.13	395.73	394.86	395.59	5606014.0
2022-08-31 17:00:00	SPY	ETF	395.5	395.64	395.06	395.2	126680.0
2022-08-31 18:00:00	SPY	ETF	395.2	395.56	393.75	394.23	208857.0
2022-08-31 19:00:00	SPY	ETF	394.19	394.19	392.52	393.18	199666.0
2022-08-31 04:00:00	QQQ	ETF	302.14	302.55	301.4	302.0	84815.0
2022-08-31 05:00:00	QQQ	ETF	301.87	301.93	301.24	301.7	74086.0
2022-08-31 06:00:00	QQQ	ETF	301.7	303.84	301.62	303.46	137333.0
2022-08-31 07:00:00	QQQ	ETF	303.16	303.46	302.43	303.02	250017.0
2022-08-31 08:00:00	QQQ	ETF	302.94	303.93	301.245	303.49	690982.0
2022-08-31 09:00:00	QQQ	ETF	303.55	304.91	301.97	303.565	6232799.0
2022-08-31 10:00:00	QQQ	ETF	303.57	303.79	301.01	301.22	5171461.0
2022-08-31 11:00:00	QQQ	ETF	301.2	302.27	299.77	301.94	4154553.0
2022-08-31 12:00:00	QQQ	ETF	301.95	302.17	300.5	300.8299	2139987.0
2022-08-31 13:00:00	QQQ	ETF	300.82	301.45	299.38	300.08	2934980.0
2022-08-31 14:00:00	QQQ	ETF	300.08	300.79	299.16	299.69	3363629.0
2022-08-31 15:00:00	QQQ	ETF	299.66	301.8356	299.2	299.26	9545689.0
2022-08-31 16:00:00	QQQ	ETF	299.27	299.95	299.2	299.88	2256970.0
2022-08-31 17:00:00	QQQ	ETF	299.81	299.83	299.01	299.22	528445.0
2022-08-31 18:00:00	QQQ	ETF	299.3	299.54	297.48	297.95	423116.0
2022-08-31 19:00:00	QQQ	ETF	297.93	297.93	296.15	296.79	313063.0
2022-08-31 04:00:00	IWM	ETF	185.14	185.28	184.5	184.98	14194.0
2022-08-31 05:00:00	IWM	ETF	184.5	184.5	184.08	184.23	8664.0
2022-08-31 06:00:00	IWM	ETF	184.15	185.2	184.05	184.86	43353.0
2022-08-31 07:00:00	IWM	ETF	184.88	185.16	184.62	184.91	26618.0
2022-08-31 08:00:00	IWM	ETF	185.1399	186.2	184.75	185.18	41043.0
2022-08-31 09:00:00	IWM	ETF	185.25	185.74	184.4	184.57	1950643.0
2022-08-31 10:00:00	IWM	ETF	184.53	184.99	183.81	184.19	1998675.0
2022-08-31 11:00:00	IWM	ETF	184.18	184.94	183.45	184.85	1372031.0
2022-08-31 12:00:00	IWM	ETF	184.88	184.93	183.95	184.18	729477.0
2022-08-31 13:00:00	IWM	ETF	184.16	184.6	183.45	183.73	842483.0
2022-08-31 14:00:00	IWM	ETF	183.71	184.03	183.19	183.51	1493821.0
2022-08-31 15:00:00	IWM	ETF	183.51	184.47	183.36	183.47	5147611.0
2022-08-31 16:00:00	IWM	ETF	183.45	183.54	183.3	183.52	1705328.0
2022-08-31 17:00:00	IWM	ETF	183.64	183.69	183.25	183.39	734355.0
2022-08-31 18:00:00	IWM	ETF	183.39	183.6	182.65	182.86	184868.0
2022-08-31 19:00:00	IWM	ETF	182.9	182.9	182.07	182.35	49184.0
2022-08-31 04:00:00	DIA	ETF	319.01	319.01	318.18	318.28	1090.0
2022-08-31 05:00:00	DIA	ETF	317.76	317.76	317.53	317.53	600.0

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

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