PREVIEW / etf_1hour / 2023-07-07

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-07-07.parquet
  size:    478 KB
  rows:    17,203

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-07-07 04:00:00	SPY	ETF	439.02	439.28	438.69	439.25	26385.0
2023-07-07 05:00:00	SPY	ETF	439.24	439.73	439.24	439.56	12328.0
2023-07-07 06:00:00	SPY	ETF	439.4	439.51	439.17	439.46	8582.0
2023-07-07 07:00:00	SPY	ETF	439.55	439.67	439.33	439.33	57122.0
2023-07-07 08:00:00	SPY	ETF	439.6	440.49	438.6039	439.07	1383548.0
2023-07-07 09:00:00	SPY	ETF	439.03	440.2	438.3	440.16	5144909.0
2023-07-07 10:00:00	SPY	ETF	440.16	440.25	438.82	439.87	6113866.0
2023-07-07 11:00:00	SPY	ETF	439.86	440.4	439.69	440.37	4301659.0
2023-07-07 12:00:00	SPY	ETF	440.38	442.29	440.36	442.26	8844175.0
2023-07-07 13:00:00	SPY	ETF	442.255	442.64	441.5	441.79	6432540.0
2023-07-07 14:00:00	SPY	ETF	441.799	441.87	441.07	441.19	4689710.0
2023-07-07 15:00:00	SPY	ETF	441.195	441.2599	438.3	438.521	21144470.0
2023-07-07 16:00:00	SPY	ETF	438.545	439.1	438.4783	438.85	7469339.0
2023-07-07 17:00:00	SPY	ETF	438.88	438.92	438.55	438.72	525288.0
2023-07-07 18:00:00	SPY	ETF	438.72	438.8895	438.7	438.81	10799.0
2023-07-07 19:00:00	SPY	ETF	438.81	438.93	438.7	438.73	26117.0
2023-07-07 04:00:00	QQQ	ETF	366.6	367.08	366.27	366.99	67179.0
2023-07-07 05:00:00	QQQ	ETF	367.06	367.34	367.04	367.08	27459.0
2023-07-07 06:00:00	QQQ	ETF	367.05	367.05	366.67	366.99	36560.0
2023-07-07 07:00:00	QQQ	ETF	367.0	367.16	366.79	366.79	64644.0
2023-07-07 08:00:00	QQQ	ETF	367.0096	369.41	366.45	367.13	1682809.0
2023-07-07 09:00:00	QQQ	ETF	367.11	368.52	366.33	368.45	5011077.0
2023-07-07 10:00:00	QQQ	ETF	368.45	368.57	366.21	367.6043	5579272.0
2023-07-07 11:00:00	QQQ	ETF	367.57	368.62	367.5	368.6	3100440.0
2023-07-07 12:00:00	QQQ	ETF	368.6	369.94	368.58	369.8407	4146365.0
2023-07-07 13:00:00	QQQ	ETF	369.85	370.48	369.46	369.74	3785366.0
2023-07-07 14:00:00	QQQ	ETF	369.7475	369.795	368.85	369.07	3268417.0
2023-07-07 15:00:00	QQQ	ETF	369.08	369.115	366.01	366.25	8706129.0
2023-07-07 16:00:00	QQQ	ETF	366.24	366.74	366.19	366.45	956975.0
2023-07-07 17:00:00	QQQ	ETF	366.45	366.7	366.4	366.53	36051.0
2023-07-07 18:00:00	QQQ	ETF	366.53	366.69	366.46	366.55	16535.0
2023-07-07 19:00:00	QQQ	ETF	366.6	366.6	366.3	366.38	19351.0
2023-07-07 04:00:00	IWM	ETF	182.12	182.45	181.96	182.41	13132.0
2023-07-07 05:00:00	IWM	ETF	182.48	182.83	182.45	182.75	9276.0
2023-07-07 06:00:00	IWM	ETF	182.61	182.92	182.61	182.82	21400.0
2023-07-07 07:00:00	IWM	ETF	182.79	182.97	182.72	182.84	51010.0
2023-07-07 08:00:00	IWM	ETF	182.76	183.2	182.0	182.96	408785.0
2023-07-07 09:00:00	IWM	ETF	182.87	184.91	182.37	184.615	4271600.0
2023-07-07 10:00:00	IWM	ETF	184.615	185.37	184.25	185.28	3193618.0
2023-07-07 11:00:00	IWM	ETF	185.28	185.95	185.24	185.41	3179777.0
2023-07-07 12:00:00	IWM	ETF	185.415	186.37	185.29	186.3311	2652149.0
2023-07-07 13:00:00	IWM	ETF	186.34	186.49	185.775	185.93	2865168.0
2023-07-07 14:00:00	IWM	ETF	185.94	186.19	185.65	185.79	1736642.0
2023-07-07 15:00:00	IWM	ETF	185.78	185.895	184.74	184.92	5539631.0
2023-07-07 16:00:00	IWM	ETF	184.71	185.05	184.67	184.77	1272592.0
2023-07-07 17:00:00	IWM	ETF	184.79	184.79	184.63	184.65	4938.0
2023-07-07 18:00:00	IWM	ETF	184.71	184.8	184.66	184.8	7167.0
2023-07-07 19:00:00	IWM	ETF	184.8	184.87	184.73	184.73	5432.0
2023-07-07 04:00:00	DIA	ETF	338.87	338.87	338.87	338.87	100.0
2023-07-07 07:00:00	DIA	ETF	339.26	339.33	339.16	339.16	1500.0

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

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