PREVIEW / etf_1hour / 2004-11-24

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-11-24.parquet
  size:    26 KB
  rows:    764

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
2004-11-24 08:00:00	SPY	ETF	118.44	118.48	118.3	118.32	112600.0
2004-11-24 09:00:00	SPY	ETF	118.31	118.59	118.18	118.18	5068300.0
2004-11-24 10:00:00	SPY	ETF	118.22	118.42	118.07	118.32	4721300.0
2004-11-24 11:00:00	SPY	ETF	118.32	118.44	118.15	118.37	4852400.0
2004-11-24 12:00:00	SPY	ETF	118.38	118.42	118.23	118.27	2164900.0
2004-11-24 13:00:00	SPY	ETF	118.27	118.42	118.15	118.2	2930500.0
2004-11-24 14:00:00	SPY	ETF	118.2	118.44	118.16	118.35	1754200.0
2004-11-24 15:00:00	SPY	ETF	118.3362	118.55	118.29	118.54	4972500.0
2004-11-24 16:00:00	SPY	ETF	118.54	118.55	118.352	118.39	1656800.0
2004-11-24 17:00:00	SPY	ETF	118.39	118.4	118.37	118.4	3900.0
2004-11-24 18:00:00	SPY	ETF	118.39	118.39	118.34	118.36	5700.0
2004-11-24 19:00:00	SPY	ETF	118.45	118.45	118.41	118.41	1200.0
2004-11-24 08:00:00	QQQ	ETF	39.17	39.17	39.1	39.1	253900.0
2004-11-24 09:00:00	QQQ	ETF	39.1	39.27	39.09	39.11	16159600.0
2004-11-24 10:00:00	QQQ	ETF	39.11	39.22	39.07	39.177	12992700.0
2004-11-24 11:00:00	QQQ	ETF	39.18	39.34	39.15	39.28	9663200.0
2004-11-24 12:00:00	QQQ	ETF	39.28	39.3	39.21	39.23	5993400.0
2004-11-24 13:00:00	QQQ	ETF	39.23	39.31	39.17	39.219	5399800.0
2004-11-24 14:00:00	QQQ	ETF	39.22	39.32	39.19	39.28	5488300.0
2004-11-24 15:00:00	QQQ	ETF	39.278	39.39	39.25	39.36	12690200.0
2004-11-24 16:00:00	QQQ	ETF	39.36	39.37	39.2479	39.28	2639900.0
2004-11-24 17:00:00	QQQ	ETF	39.28	39.3	39.27	39.29	19600.0
2004-11-24 18:00:00	QQQ	ETF	39.3	39.32	39.29	39.32	32500.0
2004-11-24 19:00:00	QQQ	ETF	39.31	39.31	39.31	39.31	700.0
2004-11-24 08:00:00	IWM	ETF	62.535	62.565	62.47	62.48	18400.0
2004-11-24 09:00:00	IWM	ETF	62.53	62.685	62.4	62.46	2391400.0
2004-11-24 10:00:00	IWM	ETF	62.455	62.68	62.325	62.615	2060200.0
2004-11-24 11:00:00	IWM	ETF	62.625	62.8	62.55	62.74	1783800.0
2004-11-24 12:00:00	IWM	ETF	62.76	62.76	62.655	62.665	432400.0
2004-11-24 13:00:00	IWM	ETF	62.67	62.75	62.58	62.68	585000.0
2004-11-24 14:00:00	IWM	ETF	62.675	62.75	62.65	62.71	921800.0
2004-11-24 15:00:00	IWM	ETF	62.73	62.95	62.725	62.895	1614400.0
2004-11-24 16:00:00	IWM	ETF	62.9	62.9	62.71	62.755	142200.0
2004-11-24 08:00:00	DIA	ETF	105.19	105.25	105.12	105.12	2000.0
2004-11-24 09:00:00	DIA	ETF	105.12	105.15	104.86	104.86	1541700.0
2004-11-24 10:00:00	DIA	ETF	104.86	105.05	104.71	104.92	1265900.0
2004-11-24 11:00:00	DIA	ETF	104.92	105.04	104.77	105.0	1056800.0
2004-11-24 12:00:00	DIA	ETF	104.99	105.01	104.84	104.87	204900.0
2004-11-24 13:00:00	DIA	ETF	104.85	104.99	104.79	104.79	378100.0
2004-11-24 14:00:00	DIA	ETF	104.79	104.96	104.72	104.84	813200.0
2004-11-24 15:00:00	DIA	ETF	104.85	105.12	104.82	105.1	615700.0
2004-11-24 16:00:00	DIA	ETF	105.09	105.11	105.0	105.0	178900.0
2004-11-24 17:00:00	DIA	ETF	104.98	104.98	104.98	104.98	500.0
2004-11-24 09:00:00	GLD	ETF	44.93	44.95	44.9	44.93	997800.0
2004-11-24 10:00:00	GLD	ETF	44.94	44.94	44.79	44.83	734300.0
2004-11-24 11:00:00	GLD	ETF	44.84	44.93	44.83	44.9	2474200.0
2004-11-24 12:00:00	GLD	ETF	44.91	45.0	44.89	44.97	399800.0
2004-11-24 13:00:00	GLD	ETF	44.95	45.05	44.93	45.03	424400.0
2004-11-24 14:00:00	GLD	ETF	45.03	45.04	44.96	44.99	414300.0
2004-11-24 15:00:00	GLD	ETF	44.98	45.05	44.98	45.01	602300.0

> showing 50 of 764 rows — these rows as CSV

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