PREVIEW / etf_1hour / 2023-06-15

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-06-15.parquet
  size:    489 KB
  rows:    17,634

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
2023-06-15 04:00:00	SPY	ETF	437.11	437.18	436.33	436.39	38392.0
2023-06-15 05:00:00	SPY	ETF	436.39	436.51	436.01	436.22	25771.0
2023-06-15 06:00:00	SPY	ETF	436.22	436.3	435.49	435.64	54334.0
2023-06-15 07:00:00	SPY	ETF	435.64	435.91	435.4	435.79	146648.0
2023-06-15 08:00:00	SPY	ETF	435.47	437.49	434.92	435.96	684483.0
2023-06-15 09:00:00	SPY	ETF	436.0	438.88	435.84	438.7109	8664522.0
2023-06-15 10:00:00	SPY	ETF	438.72	439.83	438.37	439.415	11574820.0
2023-06-15 11:00:00	SPY	ETF	439.42	441.1301	439.22	440.72	9800438.0
2023-06-15 12:00:00	SPY	ETF	440.72	441.18	440.38	440.85	5222603.0
2023-06-15 13:00:00	SPY	ETF	440.86	441.91	440.11	441.735	5770448.0
2023-06-15 14:00:00	SPY	ETF	441.74	443.9	441.26	443.6301	10702212.0
2023-06-15 15:00:00	SPY	ETF	443.64	443.86	442.06	442.6	22144904.0
2023-06-15 16:00:00	SPY	ETF	442.59	442.61	441.9	442.15	5086690.0
2023-06-15 17:00:00	SPY	ETF	442.07	442.6	442.07	442.41	210456.0
2023-06-15 18:00:00	SPY	ETF	442.37	442.4	441.84	441.91	245305.0
2023-06-15 19:00:00	SPY	ETF	441.91	442.07	441.87	441.91	85541.0
2023-06-15 04:00:00	QQQ	ETF	365.82	365.88	364.22	364.28	75497.0
2023-06-15 05:00:00	QQQ	ETF	364.18	364.54	363.52	363.83	100006.0
2023-06-15 06:00:00	QQQ	ETF	363.82	363.97	363.25	363.57	112300.0
2023-06-15 07:00:00	QQQ	ETF	363.6	363.88	363.25	363.57	281893.0
2023-06-15 08:00:00	QQQ	ETF	363.62	366.1	362.85	364.18	883047.0
2023-06-15 09:00:00	QQQ	ETF	364.23	366.58	363.96	366.07	6898103.0
2023-06-15 10:00:00	QQQ	ETF	366.08	368.01	365.66	367.3879	7057815.0
2023-06-15 11:00:00	QQQ	ETF	367.39	369.02	367.03	368.58	5797053.0
2023-06-15 12:00:00	QQQ	ETF	368.58	368.8988	367.83	368.405	3147859.0
2023-06-15 13:00:00	QQQ	ETF	368.41	369.85	367.5101	369.66	3752719.0
2023-06-15 14:00:00	QQQ	ETF	369.66	371.77	368.93	371.45	7034252.0
2023-06-15 15:00:00	QQQ	ETF	371.46	371.67	369.83	370.26	13040811.0
2023-06-15 16:00:00	QQQ	ETF	370.25	370.6579	369.1425	370.13	3714851.0
2023-06-15 17:00:00	QQQ	ETF	370.13	370.19	370.0	370.08	39497.0
2023-06-15 18:00:00	QQQ	ETF	370.09	370.19	369.67	369.75	85344.0
2023-06-15 19:00:00	QQQ	ETF	369.74	369.9	369.74	369.81	41640.0
2023-06-15 04:00:00	IWM	ETF	185.72	185.89	185.54	185.55	16772.0
2023-06-15 05:00:00	IWM	ETF	185.58	185.67	185.4	185.51	12742.0
2023-06-15 06:00:00	IWM	ETF	185.56	185.58	184.91	184.93	26865.0
2023-06-15 07:00:00	IWM	ETF	184.99	185.64	184.95	185.53	77753.0
2023-06-15 08:00:00	IWM	ETF	185.43	185.68	184.28	184.83	270427.0
2023-06-15 09:00:00	IWM	ETF	184.88	186.16	184.7	186.14	3455349.0
2023-06-15 10:00:00	IWM	ETF	186.14	186.59	185.25	185.44	4094100.0
2023-06-15 11:00:00	IWM	ETF	185.4328	186.565	185.21	186.12	3743632.0
2023-06-15 12:00:00	IWM	ETF	186.12	186.24	185.81	186.08	2189626.0
2023-06-15 13:00:00	IWM	ETF	186.085	186.78	185.64	186.6894	2576882.0
2023-06-15 14:00:00	IWM	ETF	186.69	187.47	186.27	187.33	3243076.0
2023-06-15 15:00:00	IWM	ETF	187.325	187.57	186.85	187.5	5752350.0
2023-06-15 16:00:00	IWM	ETF	187.44	187.56	187.07	187.09	1826677.0
2023-06-15 17:00:00	IWM	ETF	187.11	187.39	187.11	187.2	5002.0
2023-06-15 18:00:00	IWM	ETF	187.18	187.27	186.98	187.0	34405.0
2023-06-15 19:00:00	IWM	ETF	186.99	187.11	186.9	186.91	52351.0
2023-06-15 04:00:00	DIA	ETF	340.23	340.45	340.23	340.3	1240.0
2023-06-15 05:00:00	DIA	ETF	340.28	340.28	340.28	340.28	300.0

> showing 50 of 17,634 rows — these rows as CSV

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