PREVIEW / etf_1hour / 2022-09-09

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-09-09.parquet
  size:    439 KB
  rows:    16,073

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-09-09 04:00:00	SPY	ETF	402.02	403.79	402.02	403.69	47610.0
2022-09-09 05:00:00	SPY	ETF	403.71	403.79	403.11	403.37	28639.0
2022-09-09 06:00:00	SPY	ETF	403.53	404.28	403.11	403.94	117058.0
2022-09-09 07:00:00	SPY	ETF	403.91	403.96	403.17	403.38	144195.0
2022-09-09 08:00:00	SPY	ETF	403.67	404.27	401.1	403.42	591347.0
2022-09-09 09:00:00	SPY	ETF	403.44	404.3	402.46	404.27	6796736.0
2022-09-09 10:00:00	SPY	ETF	404.28	406.19	404.11	405.95	11271087.0
2022-09-09 11:00:00	SPY	ETF	405.97	406.1701	404.81	405.64	6164988.0
2022-09-09 12:00:00	SPY	ETF	405.65	406.0	404.34	405.97	5465866.0
2022-09-09 13:00:00	SPY	ETF	405.98	406.82	405.47	406.54	4669063.0
2022-09-09 14:00:00	SPY	ETF	406.54	406.94	405.97	406.73	5031785.0
2022-09-09 15:00:00	SPY	ETF	406.74	407.51	406.48	406.55	12668067.0
2022-09-09 16:00:00	SPY	ETF	406.56	406.6901	405.7884	406.44	4875010.0
2022-09-09 17:00:00	SPY	ETF	406.51	406.51	406.2	406.47	94462.0
2022-09-09 18:00:00	SPY	ETF	406.45	406.58	406.29	406.38	56594.0
2022-09-09 19:00:00	SPY	ETF	406.36	406.44	406.2	406.2	18563.0
2022-09-09 04:00:00	QQQ	ETF	302.22	303.65	301.82	303.6	83299.0
2022-09-09 05:00:00	QQQ	ETF	303.54	303.84	303.4	303.63	43138.0
2022-09-09 06:00:00	QQQ	ETF	303.67	304.34	303.26	303.96	73276.0
2022-09-09 07:00:00	QQQ	ETF	303.96	303.96	303.24	303.51	151206.0
2022-09-09 08:00:00	QQQ	ETF	303.74	304.1696	300.745	303.5	648695.0
2022-09-09 09:00:00	QQQ	ETF	303.5	304.9	302.58	304.86	6653152.0
2022-09-09 10:00:00	QQQ	ETF	304.91	306.48	304.5	306.23	7309053.0
2022-09-09 11:00:00	QQQ	ETF	306.245	306.72	305.32	306.21	5357531.0
2022-09-09 12:00:00	QQQ	ETF	306.2	306.62	305.05	306.59	3792763.0
2022-09-09 13:00:00	QQQ	ETF	306.61	307.32	306.17	306.92	3386962.0
2022-09-09 14:00:00	QQQ	ETF	306.91	307.2	306.23	306.69	3190806.0
2022-09-09 15:00:00	QQQ	ETF	306.68	307.6	306.55	307.04	7651104.0
2022-09-09 16:00:00	QQQ	ETF	307.03	307.11	306.6	307.05	2803423.0
2022-09-09 17:00:00	QQQ	ETF	307.06	307.14	306.95	307.01	685706.0
2022-09-09 18:00:00	QQQ	ETF	307.0	307.08	306.99	307.06	22844.0
2022-09-09 19:00:00	QQQ	ETF	307.02	307.13	307.0	307.04	25016.0
2022-09-09 04:00:00	IWM	ETF	185.01	185.77	184.92	185.72	25397.0
2022-09-09 05:00:00	IWM	ETF	185.72	185.73	185.4	185.42	14735.0
2022-09-09 06:00:00	IWM	ETF	185.48	185.9	185.31	185.73	77133.0
2022-09-09 07:00:00	IWM	ETF	185.68	185.7	185.25	185.34	29998.0
2022-09-09 08:00:00	IWM	ETF	185.69	185.94	185.15	185.48	61681.0
2022-09-09 09:00:00	IWM	ETF	185.52	186.3999	185.1	186.37	1959631.0
2022-09-09 10:00:00	IWM	ETF	186.37	187.36	186.31	186.9	2640246.0
2022-09-09 11:00:00	IWM	ETF	186.92	186.98	186.32	186.73	1609722.0
2022-09-09 12:00:00	IWM	ETF	186.74	187.24	186.22	187.19	1180159.0
2022-09-09 13:00:00	IWM	ETF	187.2	187.49	186.95	187.29	1195409.0
2022-09-09 14:00:00	IWM	ETF	187.275	187.465	186.965	187.43	1175986.0
2022-09-09 15:00:00	IWM	ETF	187.43	187.63	187.2	187.4	3534889.0
2022-09-09 16:00:00	IWM	ETF	187.4	187.4	187.02	187.09	972742.0
2022-09-09 17:00:00	IWM	ETF	187.1	187.4	187.01	187.12	162072.0
2022-09-09 18:00:00	IWM	ETF	187.17	187.25	187.09	187.2	5606.0
2022-09-09 19:00:00	IWM	ETF	187.2	187.25	187.11	187.11	7175.0
2022-09-09 04:00:00	DIA	ETF	319.79	320.73	319.79	320.73	2569.0
2022-09-09 06:00:00	DIA	ETF	320.64	320.93	320.62	320.93	1100.0

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

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