PREVIEW / etf_1hour / 2004-12-15

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-12-15.parquet
  size:    27 KB
  rows:    790

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-12-15 08:00:00	SPY	ETF	120.85	120.91	120.73	120.78	92900.0
2004-12-15 09:00:00	SPY	ETF	120.78	120.95	120.6	120.73	3971300.0
2004-12-15 10:00:00	SPY	ETF	120.73	121.03	120.73	120.75	6603700.0
2004-12-15 11:00:00	SPY	ETF	120.75	120.77	120.31	120.48	8029100.0
2004-12-15 12:00:00	SPY	ETF	120.48	120.65	120.48	120.59	3466700.0
2004-12-15 13:00:00	SPY	ETF	120.6	120.99	120.59	120.83	5797900.0
2004-12-15 14:00:00	SPY	ETF	120.83	120.94	120.58	120.72	3913100.0
2004-12-15 15:00:00	SPY	ETF	120.73	121.11	120.71	120.97	8239400.0
2004-12-15 16:00:00	SPY	ETF	120.97	120.99	120.763	120.88	2048200.0
2004-12-15 17:00:00	SPY	ETF	120.88	120.9	120.86	120.87	8100.0
2004-12-15 18:00:00	SPY	ETF	120.88	120.91	120.88	120.91	52100.0
2004-12-15 19:00:00	SPY	ETF	120.89	120.89	120.86	120.86	500.0
2004-12-15 08:00:00	QQQ	ETF	40.6	40.65	40.53	40.55	1359944.0
2004-12-15 09:00:00	QQQ	ETF	40.545	40.6	40.43	40.53	7892810.0
2004-12-15 10:00:00	QQQ	ETF	40.52	40.68	40.48	40.49	19487660.0
2004-12-15 11:00:00	QQQ	ETF	40.489	40.49	40.155	40.28	17606735.0
2004-12-15 12:00:00	QQQ	ETF	40.28	40.39	40.27	40.331	8687124.0
2004-12-15 13:00:00	QQQ	ETF	40.33	40.46	40.31	40.315	7843069.0
2004-12-15 14:00:00	QQQ	ETF	40.311	40.341	40.19	40.27	11253010.0
2004-12-15 15:00:00	QQQ	ETF	40.268	40.41	40.26	40.34	11341980.0
2004-12-15 16:00:00	QQQ	ETF	40.34	40.3978	40.32	40.33	7684192.0
2004-12-15 17:00:00	QQQ	ETF	40.35	40.355	40.34	40.35	34555.0
2004-12-15 18:00:00	QQQ	ETF	40.35	40.37	40.35	40.35	30250.0
2004-12-15 08:00:00	IWM	ETF	64.32	64.32	64.25	64.25	12200.0
2004-12-15 09:00:00	IWM	ETF	64.185	64.48	64.105	64.405	1660000.0
2004-12-15 10:00:00	IWM	ETF	64.405	64.655	64.405	64.5	2265800.0
2004-12-15 11:00:00	IWM	ETF	64.515	64.515	64.155	64.315	2208200.0
2004-12-15 12:00:00	IWM	ETF	64.32	64.38	64.28	64.335	378800.0
2004-12-15 13:00:00	IWM	ETF	64.34	64.57	64.295	64.45	568200.0
2004-12-15 14:00:00	IWM	ETF	64.435	64.505	64.37	64.475	791000.0
2004-12-15 15:00:00	IWM	ETF	64.47	64.745	64.47	64.645	1508600.0
2004-12-15 16:00:00	IWM	ETF	64.64	64.695	64.605	64.66	187200.0
2004-12-15 17:00:00	IWM	ETF	64.68	64.685	64.67	64.685	9200.0
2004-12-15 18:00:00	IWM	ETF	64.725	64.725	64.725	64.725	600.0
2004-12-15 08:00:00	DIA	ETF	106.77	106.79	106.71	106.71	4000.0
2004-12-15 09:00:00	DIA	ETF	106.7	106.89	106.59	106.75	1017900.0
2004-12-15 10:00:00	DIA	ETF	106.75	107.0	106.72	106.77	1940900.0
2004-12-15 11:00:00	DIA	ETF	106.76	106.76	106.35	106.54	1685300.0
2004-12-15 12:00:00	DIA	ETF	106.54	106.68	106.53	106.6	323200.0
2004-12-15 13:00:00	DIA	ETF	106.6	106.9	106.58	106.74	2248800.0
2004-12-15 14:00:00	DIA	ETF	106.73	106.86	106.58	106.75	400600.0
2004-12-15 15:00:00	DIA	ETF	106.75	107.06	106.73	106.91	1197400.0
2004-12-15 16:00:00	DIA	ETF	106.91	106.92	106.82	106.88	163700.0
2004-12-15 17:00:00	DIA	ETF	106.9	106.9	106.9	106.9	1000.0
2004-12-15 19:00:00	DIA	ETF	106.82	106.82	106.82	106.82	100.0
2004-12-15 09:00:00	GLD	ETF	44.1	44.12	43.96	43.96	302500.0
2004-12-15 10:00:00	GLD	ETF	43.95	44.12	43.92	44.12	357300.0
2004-12-15 11:00:00	GLD	ETF	44.12	44.16	44.08	44.13	302200.0
2004-12-15 12:00:00	GLD	ETF	44.12	44.17	43.95	43.99	766700.0
2004-12-15 13:00:00	GLD	ETF	43.99	44.08	43.97	44.08	413800.0

> showing 50 of 790 rows — these rows as CSV

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