PREVIEW / etf_1hour / 2004-10-12

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-10-12.parquet
  size:    25 KB
  rows:    703

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-10-12 08:00:00	SPY	ETF	112.07	112.25	112.07	112.22	195400.0
2004-10-12 09:00:00	SPY	ETF	112.23	112.32	112.02	112.06	4769500.0
2004-10-12 10:00:00	SPY	ETF	112.06	112.25	111.94	112.08	7237500.0
2004-10-12 11:00:00	SPY	ETF	112.07	112.42	112.05	112.36	5898100.0
2004-10-12 12:00:00	SPY	ETF	112.36	112.39	112.05	112.17	4038000.0
2004-10-12 13:00:00	SPY	ETF	112.17	112.33	112.1	112.27	2240700.0
2004-10-12 14:00:00	SPY	ETF	112.28	112.83	112.14	112.8	5679800.0
2004-10-12 15:00:00	SPY	ETF	112.8	112.82	112.52	112.53	6151500.0
2004-10-12 16:00:00	SPY	ETF	112.53	112.92	112.46	112.81	3916400.0
2004-10-12 17:00:00	SPY	ETF	112.82	112.88	112.56	112.88	181800.0
2004-10-12 18:00:00	SPY	ETF	112.84	112.94	112.84	112.94	50200.0
2004-10-12 19:00:00	SPY	ETF	112.92	112.93	112.9	112.9	6900.0
2004-10-12 08:00:00	QQQ	ETF	35.39	35.43	35.39	35.42	300200.0
2004-10-12 09:00:00	QQQ	ETF	35.42	35.55	35.3	35.33	12595000.0
2004-10-12 10:00:00	QQQ	ETF	35.32	35.45	35.2	35.35	19590200.0
2004-10-12 11:00:00	QQQ	ETF	35.36	35.59	35.35	35.54	12950600.0
2004-10-12 12:00:00	QQQ	ETF	35.531	35.54	35.37	35.4577	9524800.0
2004-10-12 13:00:00	QQQ	ETF	35.45	35.54	35.4	35.51	6418400.0
2004-10-12 14:00:00	QQQ	ETF	35.51	35.75	35.46	35.732	12082600.0
2004-10-12 15:00:00	QQQ	ETF	35.74	35.8	35.66	35.71	15871200.0
2004-10-12 16:00:00	QQQ	ETF	35.7	35.968	35.66	35.9	6004800.0
2004-10-12 17:00:00	QQQ	ETF	35.902	35.95	35.89	35.93	246600.0
2004-10-12 18:00:00	QQQ	ETF	35.93	35.96	35.91	35.95	283400.0
2004-10-12 19:00:00	QQQ	ETF	35.96	35.97	35.95	35.95	17400.0
2004-10-12 08:00:00	IWM	ETF	57.115	57.145	57.07	57.145	10400.0
2004-10-12 09:00:00	IWM	ETF	57.125	57.25	56.915	56.925	2635200.0
2004-10-12 10:00:00	IWM	ETF	56.925	57.115	56.79	57.035	2723800.0
2004-10-12 11:00:00	IWM	ETF	57.05	57.505	57.04	57.44	2473800.0
2004-10-12 12:00:00	IWM	ETF	57.44	57.44	57.235	57.29	974400.0
2004-10-12 13:00:00	IWM	ETF	57.285	57.375	57.265	57.375	373200.0
2004-10-12 14:00:00	IWM	ETF	57.395	57.67	57.315	57.665	1849400.0
2004-10-12 15:00:00	IWM	ETF	57.665	57.675	57.48	57.485	1450000.0
2004-10-12 16:00:00	IWM	ETF	57.49	57.695	57.375	57.695	1097200.0
2004-10-12 17:00:00	IWM	ETF	57.615	57.615	57.58	57.58	800.0
2004-10-12 08:00:00	DIA	ETF	100.47	100.61	100.47	100.61	18500.0
2004-10-12 09:00:00	DIA	ETF	100.59	100.66	100.45	100.51	563500.0
2004-10-12 10:00:00	DIA	ETF	100.52	100.64	100.36	100.52	689600.0
2004-10-12 11:00:00	DIA	ETF	100.51	100.79	100.48	100.74	841100.0
2004-10-12 12:00:00	DIA	ETF	100.74	100.74	100.52	100.61	383000.0
2004-10-12 13:00:00	DIA	ETF	100.61	100.77	100.57	100.72	309300.0
2004-10-12 14:00:00	DIA	ETF	100.73	101.25	100.62	101.23	816700.0
2004-10-12 15:00:00	DIA	ETF	101.22	101.23	100.99	101.01	763000.0
2004-10-12 16:00:00	DIA	ETF	101.02	101.24	100.93	101.22	169100.0
2004-10-12 17:00:00	DIA	ETF	101.16	101.28	101.16	101.2	8600.0
2004-10-12 18:00:00	DIA	ETF	101.2	101.2	101.2	101.2	200.0
2004-10-12 19:00:00	DIA	ETF	101.29	101.29	101.29	101.29	1000.0
2004-10-12 09:00:00	TLT	ETF	88.22	88.38	88.22	88.36	104000.0
2004-10-12 10:00:00	TLT	ETF	88.37	88.39	88.18	88.25	89700.0
2004-10-12 11:00:00	TLT	ETF	88.24	88.28	88.16	88.25	140000.0
2004-10-12 12:00:00	TLT	ETF	88.23	88.35	88.23	88.27	276200.0

> showing 50 of 703 rows — these rows as CSV

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