PREVIEW / etf_1hour / 2004-12-10

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-12-10.parquet
  size:    27 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-12-10 08:00:00	SPY	ETF	118.97	119.02	118.86	118.91	198500.0
2004-12-10 09:00:00	SPY	ETF	118.91	119.36	118.85	119.21	6533300.0
2004-12-10 10:00:00	SPY	ETF	119.2	119.34	118.87	118.96	10548900.0
2004-12-10 11:00:00	SPY	ETF	118.97	119.32	118.93	119.02	5557900.0
2004-12-10 12:00:00	SPY	ETF	119.03	119.25	118.99	119.2	3126400.0
2004-12-10 13:00:00	SPY	ETF	119.19	119.55	119.13	119.49	9466600.0
2004-12-10 14:00:00	SPY	ETF	119.49	119.56	119.12	119.24	5014900.0
2004-12-10 15:00:00	SPY	ETF	119.24	119.38	119.09	119.17	4830400.0
2004-12-10 16:00:00	SPY	ETF	119.15	119.35	119.13	119.3	1862000.0
2004-12-10 17:00:00	SPY	ETF	119.35	119.39	119.32	119.38	21500.0
2004-12-10 18:00:00	SPY	ETF	119.39	119.39	119.33	119.34	2700.0
2004-12-10 19:00:00	SPY	ETF	119.34	119.4	119.34	119.4	900.0
2004-12-10 08:00:00	QQQ	ETF	39.87	39.89	39.83	39.89	1060949.0
2004-12-10 09:00:00	QQQ	ETF	39.89	40.051	39.74	40.0	15463127.0
2004-12-10 10:00:00	QQQ	ETF	40.0	40.07	39.86	39.886	15411343.0
2004-12-10 11:00:00	QQQ	ETF	39.886	40.04	39.86	39.899	10547545.0
2004-12-10 12:00:00	QQQ	ETF	39.89	39.988	39.84	39.929	7344396.0
2004-12-10 13:00:00	QQQ	ETF	39.926	40.07	39.9	40.03	11369027.0
2004-12-10 14:00:00	QQQ	ETF	40.024	40.06	39.846	39.9184	11037488.0
2004-12-10 15:00:00	QQQ	ETF	39.92	39.98	39.84	39.91	10864612.0
2004-12-10 16:00:00	QQQ	ETF	39.91	39.998	39.9	39.97	2652084.0
2004-12-10 17:00:00	QQQ	ETF	39.98	40.01	39.95	39.98	83077.0
2004-12-10 18:00:00	QQQ	ETF	39.975	39.997	39.96	39.97	6020.0
2004-12-10 08:00:00	IWM	ETF	62.55	62.55	62.465	62.475	10800.0
2004-12-10 09:00:00	IWM	ETF	62.475	62.795	62.415	62.655	1586800.0
2004-12-10 10:00:00	IWM	ETF	62.65	62.79	62.545	62.605	1985600.0
2004-12-10 11:00:00	IWM	ETF	62.615	62.755	62.61	62.65	882600.0
2004-12-10 12:00:00	IWM	ETF	62.655	62.73	62.625	62.675	302000.0
2004-12-10 13:00:00	IWM	ETF	62.68	63.275	62.675	63.275	1314600.0
2004-12-10 14:00:00	IWM	ETF	63.295	63.3	62.965	62.985	1508600.0
2004-12-10 15:00:00	IWM	ETF	62.99	63.11	62.985	63.09	1411200.0
2004-12-10 16:00:00	IWM	ETF	63.09	63.15	63.075	63.095	992800.0
2004-12-10 08:00:00	DIA	ETF	105.21	105.22	105.16	105.16	5200.0
2004-12-10 09:00:00	DIA	ETF	105.19	105.6	105.11	105.48	580600.0
2004-12-10 10:00:00	DIA	ETF	105.49	105.58	105.21	105.24	1341100.0
2004-12-10 11:00:00	DIA	ETF	105.25	105.55	105.24	105.31	880600.0
2004-12-10 12:00:00	DIA	ETF	105.32	105.48	105.29	105.44	318700.0
2004-12-10 13:00:00	DIA	ETF	105.44	105.75	105.41	105.65	756200.0
2004-12-10 14:00:00	DIA	ETF	105.67	105.75	105.36	105.44	502900.0
2004-12-10 15:00:00	DIA	ETF	105.45	105.67	105.36	105.42	1263200.0
2004-12-10 16:00:00	DIA	ETF	105.42	105.58	105.4	105.58	69700.0
2004-12-10 17:00:00	DIA	ETF	105.59	105.6	105.55	105.6	2300.0
2004-12-10 18:00:00	DIA	ETF	105.55	105.55	105.55	105.55	1000.0
2004-12-10 19:00:00	DIA	ETF	105.55	105.55	105.55	105.55	4000.0
2004-12-10 09:00:00	GLD	ETF	43.37	43.48	43.31	43.35	452000.0
2004-12-10 10:00:00	GLD	ETF	43.36	43.6	43.36	43.49	848200.0
2004-12-10 11:00:00	GLD	ETF	43.49	43.6	43.46	43.5	281500.0
2004-12-10 12:00:00	GLD	ETF	43.5	43.52	43.42	43.51	190800.0
2004-12-10 13:00:00	GLD	ETF	43.49	43.5	43.39	43.42	124200.0
2004-12-10 14:00:00	GLD	ETF	43.42	43.47	43.4	43.45	191300.0

> showing 50 of 764 rows — these rows as CSV

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