PREVIEW / etf_1hour / 2004-07-23

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-07-23.parquet
  size:    25 KB
  rows:    683

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-07-23 08:00:00	SPY	ETF	109.69	109.82	109.59	109.69	53400.0
2004-07-23 09:00:00	SPY	ETF	109.69	109.7	109.35	109.41	5016500.0
2004-07-23 10:00:00	SPY	ETF	109.41	109.64	109.03	109.55	9095200.0
2004-07-23 11:00:00	SPY	ETF	109.55	109.56	109.18	109.4	5171700.0
2004-07-23 12:00:00	SPY	ETF	109.41	109.41	109.01	109.2	3395500.0
2004-07-23 13:00:00	SPY	ETF	109.21	109.45	109.19	109.23	2570200.0
2004-07-23 14:00:00	SPY	ETF	109.24	109.24	108.84	109.01	6508500.0
2004-07-23 15:00:00	SPY	ETF	109.0	109.39	108.69	108.92	11566300.0
2004-07-23 16:00:00	SPY	ETF	108.92	109.11	108.82	109.0	1830200.0
2004-07-23 17:00:00	SPY	ETF	109.0	109.0	109.0	109.0	1000.0
2004-07-23 18:00:00	SPY	ETF	108.97	109.0	108.97	109.0	200.0
2004-07-23 19:00:00	SPY	ETF	109.0	109.0	109.0	109.0	1000.0
2004-07-23 08:00:00	QQQ	ETF	34.68	34.69	34.63	34.67	287600.0
2004-07-23 09:00:00	QQQ	ETF	34.66	34.67	34.503	34.51	12440600.0
2004-07-23 10:00:00	QQQ	ETF	34.51	34.64	34.36	34.58	20951700.0
2004-07-23 11:00:00	QQQ	ETF	34.58	34.61	34.37	34.5	10571600.0
2004-07-23 12:00:00	QQQ	ETF	34.49	34.5	34.24	34.327	9674900.0
2004-07-23 13:00:00	QQQ	ETF	34.32	34.45	34.31	34.32	6596700.0
2004-07-23 14:00:00	QQQ	ETF	34.32	34.32	34.14	34.23	14086700.0
2004-07-23 15:00:00	QQQ	ETF	34.232	34.37	34.03	34.16	24216200.0
2004-07-23 16:00:00	QQQ	ETF	34.174	34.24	34.15	34.24	4685200.0
2004-07-23 17:00:00	QQQ	ETF	34.23	34.24	34.22	34.22	32700.0
2004-07-23 18:00:00	QQQ	ETF	34.23	34.3	34.22	34.3	24600.0
2004-07-23 19:00:00	QQQ	ETF	34.23	34.25	34.23	34.25	2000.0
2004-07-23 08:00:00	IWM	ETF	54.265	54.265	54.265	54.265	200.0
2004-07-23 09:00:00	IWM	ETF	54.355	54.355	53.845	53.87	1179200.0
2004-07-23 10:00:00	IWM	ETF	53.865	54.435	53.75	54.4	2726600.0
2004-07-23 11:00:00	IWM	ETF	54.4	54.4	54.085	54.165	1860000.0
2004-07-23 12:00:00	IWM	ETF	54.21	54.21	53.955	54.12	1210400.0
2004-07-23 13:00:00	IWM	ETF	54.105	54.275	54.075	54.085	491400.0
2004-07-23 14:00:00	IWM	ETF	54.085	54.09	53.7908	53.92	5651600.0
2004-07-23 15:00:00	IWM	ETF	53.92	54.05	53.7	53.705	3264200.0
2004-07-23 16:00:00	IWM	ETF	53.7	53.82	53.7	53.745	804400.0
2004-07-23 08:00:00	DIA	ETF	100.37	100.45	100.29	100.45	5300.0
2004-07-23 09:00:00	DIA	ETF	100.39	100.39	100.02	100.11	523200.0
2004-07-23 10:00:00	DIA	ETF	100.1	100.32	99.73	100.24	1335400.0
2004-07-23 11:00:00	DIA	ETF	100.23	100.24	100.02	100.19	713300.0
2004-07-23 12:00:00	DIA	ETF	100.19	100.2	99.88	100.05	915400.0
2004-07-23 13:00:00	DIA	ETF	100.03	100.21	100.02	100.06	339400.0
2004-07-23 14:00:00	DIA	ETF	100.07	100.07	99.67	99.76	784200.0
2004-07-23 15:00:00	DIA	ETF	99.76	100.1	99.5	99.8	1651400.0
2004-07-23 16:00:00	DIA	ETF	99.78	99.87	99.7	99.85	359500.0
2004-07-23 18:00:00	DIA	ETF	99.8	99.8	99.8	99.8	300.0
2004-07-23 09:00:00	TLT	ETF	84.78	84.83	84.78	84.83	3100.0
2004-07-23 10:00:00	TLT	ETF	84.85	84.9	84.85	84.88	76200.0
2004-07-23 11:00:00	TLT	ETF	84.82	84.89	84.8	84.81	12100.0
2004-07-23 12:00:00	TLT	ETF	84.81	84.85	84.81	84.85	16800.0
2004-07-23 13:00:00	TLT	ETF	84.85	84.88	84.81	84.81	13400.0
2004-07-23 14:00:00	TLT	ETF	84.79	84.95	84.79	84.92	19700.0
2004-07-23 15:00:00	TLT	ETF	84.91	84.97	84.88	84.95	66200.0

> showing 50 of 683 rows — these rows as CSV

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