PREVIEW / etf_1hour / 2005-05-24

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-05-24.parquet
  size:    29 KB
  rows:    866

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
2005-05-24 06:00:00	SPY	ETF	119.54	119.54	119.54	119.54	500.0
2005-05-24 07:00:00	SPY	ETF	119.51	119.52	119.41	119.44	12400.0
2005-05-24 08:00:00	SPY	ETF	119.44	119.49	119.39	119.44	132600.0
2005-05-24 09:00:00	SPY	ETF	119.44	119.54	119.27	119.48	6004000.0
2005-05-24 10:00:00	SPY	ETF	119.48	119.54	119.2	119.4	7019200.0
2005-05-24 11:00:00	SPY	ETF	119.4	119.67	119.2	119.27	9197700.0
2005-05-24 12:00:00	SPY	ETF	119.27	119.49	119.23	119.39	4639900.0
2005-05-24 13:00:00	SPY	ETF	119.41	119.46	119.29	119.41	2370500.0
2005-05-24 14:00:00	SPY	ETF	119.41	119.6	119.23	119.42	9365800.0
2005-05-24 15:00:00	SPY	ETF	119.45	119.83	119.33	119.65	9386400.0
2005-05-24 16:00:00	SPY	ETF	119.6	119.62	119.44	119.49	1099800.0
2005-05-24 17:00:00	SPY	ETF	119.49	119.5	119.45	119.45	77700.0
2005-05-24 18:00:00	SPY	ETF	119.45	119.45	119.41	119.44	10500.0
2005-05-24 19:00:00	SPY	ETF	119.41	119.44	119.4	119.44	1600.0
2005-05-24 09:00:00	QQQ	ETF	37.76	37.85	37.71	37.82	10938200.0
2005-05-24 10:00:00	QQQ	ETF	37.83	37.9	37.7	37.81	20612500.0
2005-05-24 11:00:00	QQQ	ETF	37.81	37.92	37.78	37.82	12802900.0
2005-05-24 12:00:00	QQQ	ETF	37.83	37.92	37.8	37.88	6860900.0
2005-05-24 13:00:00	QQQ	ETF	37.87	37.91	37.81	37.86	4725200.0
2005-05-24 14:00:00	QQQ	ETF	37.87	37.94	37.78	37.84	14624100.0
2005-05-24 15:00:00	QQQ	ETF	37.84	38.0	37.78	37.98	19254400.0
2005-05-24 08:00:00	IWM	ETF	60.8	60.8	60.8	60.8	2800.0
2005-05-24 09:00:00	IWM	ETF	60.76	60.895	60.655	60.88	1946600.0
2005-05-24 10:00:00	IWM	ETF	60.89	60.92	60.63	60.82	4610000.0
2005-05-24 11:00:00	IWM	ETF	60.82	60.99	60.75	60.845	4124600.0
2005-05-24 12:00:00	IWM	ETF	60.855	60.92	60.77	60.885	2110600.0
2005-05-24 13:00:00	IWM	ETF	60.875	60.91	60.79	60.85	1298800.0
2005-05-24 14:00:00	IWM	ETF	60.855	60.995	60.775	60.865	3291200.0
2005-05-24 15:00:00	IWM	ETF	60.86	61.125	60.79	60.955	3573000.0
2005-05-24 16:00:00	IWM	ETF	60.91	60.935	60.75	60.825	604200.0
2005-05-24 17:00:00	IWM	ETF	60.845	60.845	60.845	60.845	400.0
2005-05-24 18:00:00	IWM	ETF	60.825	60.825	60.825	60.825	600.0
2005-05-24 07:00:00	DIA	ETF	104.98	104.98	104.89	104.89	3800.0
2005-05-24 08:00:00	DIA	ETF	104.95	104.95	104.91	104.91	2200.0
2005-05-24 09:00:00	DIA	ETF	104.93	104.94	104.7	104.84	444300.0
2005-05-24 10:00:00	DIA	ETF	104.84	104.85	104.64	104.77	623800.0
2005-05-24 11:00:00	DIA	ETF	104.78	104.99	104.63	104.72	1153800.0
2005-05-24 12:00:00	DIA	ETF	104.7	104.81	104.65	104.74	308800.0
2005-05-24 13:00:00	DIA	ETF	104.74	104.81	104.7	104.8	157600.0
2005-05-24 14:00:00	DIA	ETF	104.8	104.98	104.63	104.8	1010200.0
2005-05-24 15:00:00	DIA	ETF	104.78	105.13	104.7	104.94	1347100.0
2005-05-24 16:00:00	DIA	ETF	104.95	104.95	104.81	104.82	19100.0
2005-05-24 17:00:00	DIA	ETF	104.78	104.78	104.78	104.78	300.0
2005-05-24 18:00:00	DIA	ETF	104.78	104.78	104.78	104.78	900.0
2005-05-24 08:00:00	GLD	ETF	41.85	41.85	41.78	41.78	11000.0
2005-05-24 09:00:00	GLD	ETF	41.8	41.83	41.73	41.74	736600.0
2005-05-24 10:00:00	GLD	ETF	41.74	41.75	41.68	41.68	122600.0
2005-05-24 11:00:00	GLD	ETF	41.69	41.71	41.67	41.7	119000.0
2005-05-24 12:00:00	GLD	ETF	41.68	41.72	41.67	41.69	78100.0
2005-05-24 13:00:00	GLD	ETF	41.69	41.69	41.65	41.69	63300.0

> showing 50 of 866 rows — these rows as CSV

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