PREVIEW / etf_1hour / 2004-08-11

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-08-11.parquet
  size:    25 KB
  rows:    689

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-08-11 08:00:00	SPY	ETF	107.46	107.64	107.46	107.63	153500.0
2004-08-11 09:00:00	SPY	ETF	107.65	107.7	107.31	107.39	6119800.0
2004-08-11 10:00:00	SPY	ETF	107.4	107.78	107.1	107.74	12260000.0
2004-08-11 11:00:00	SPY	ETF	107.73	108.08	107.59	107.63	9546100.0
2004-08-11 12:00:00	SPY	ETF	107.62	107.78	107.47	107.71	3831300.0
2004-08-11 13:00:00	SPY	ETF	107.7	107.98	107.57	107.71	4403900.0
2004-08-11 14:00:00	SPY	ETF	107.71	108.11	107.5	108.05	5258100.0
2004-08-11 15:00:00	SPY	ETF	108.08	108.33	107.91	108.09	7658400.0
2004-08-11 16:00:00	SPY	ETF	108.1	108.24	107.56	108.24	704400.0
2004-08-11 17:00:00	SPY	ETF	108.27	108.33	108.23	108.23	11000.0
2004-08-11 18:00:00	SPY	ETF	108.3	108.37	108.059	108.32	71100.0
2004-08-11 19:00:00	SPY	ETF	108.32	108.32	108.24	108.24	16700.0
2004-08-11 08:00:00	QQQ	ETF	32.94	32.94	32.79	32.86	414400.0
2004-08-11 09:00:00	QQQ	ETF	32.86	32.88	32.61	32.68	19117400.0
2004-08-11 10:00:00	QQQ	ETF	32.67	32.8	32.56	32.8	24689000.0
2004-08-11 11:00:00	QQQ	ETF	32.8	32.93	32.7	32.71	16895400.0
2004-08-11 12:00:00	QQQ	ETF	32.72	32.77	32.64	32.74	8853400.0
2004-08-11 13:00:00	QQQ	ETF	32.746	32.881	32.71	32.76	7754400.0
2004-08-11 14:00:00	QQQ	ETF	32.76	32.93	32.659	32.93	12432600.0
2004-08-11 15:00:00	QQQ	ETF	32.933	33.04	32.83	32.91	20932300.0
2004-08-11 16:00:00	QQQ	ETF	32.92	32.98	32.88	32.98	3288200.0
2004-08-11 17:00:00	QQQ	ETF	32.98	33.0	32.96	33.0	165600.0
2004-08-11 18:00:00	QQQ	ETF	33.0	33.02	32.98	33.02	22000.0
2004-08-11 19:00:00	QQQ	ETF	33.01	33.01	32.97	32.98	9100.0
2004-08-11 08:00:00	IWM	ETF	52.17	52.17	52.17	52.17	3000.0
2004-08-11 09:00:00	IWM	ETF	52.195	52.23	51.67	51.745	1382200.0
2004-08-11 10:00:00	IWM	ETF	51.7	52.155	51.56	52.13	2882600.0
2004-08-11 11:00:00	IWM	ETF	52.135	52.41	51.95	51.985	2010400.0
2004-08-11 12:00:00	IWM	ETF	51.995	52.145	51.965	52.095	419200.0
2004-08-11 13:00:00	IWM	ETF	52.085	52.31	52.06	52.14	1035600.0
2004-08-11 14:00:00	IWM	ETF	52.155	52.45	51.975	52.45	633800.0
2004-08-11 15:00:00	IWM	ETF	52.455	52.705	52.425	52.49	3295400.0
2004-08-11 16:00:00	IWM	ETF	52.44	52.5	52.385	52.5	185800.0
2004-08-11 08:00:00	DIA	ETF	99.08	99.1	99.04	99.1	19400.0
2004-08-11 09:00:00	DIA	ETF	99.17	99.21	98.95	99.03	748500.0
2004-08-11 10:00:00	DIA	ETF	99.02	99.33	98.72	99.32	999900.0
2004-08-11 11:00:00	DIA	ETF	99.3	99.64	99.18	99.24	1118900.0
2004-08-11 12:00:00	DIA	ETF	99.24	99.39	99.09	99.3	425500.0
2004-08-11 13:00:00	DIA	ETF	99.3	99.55	99.17	99.31	271300.0
2004-08-11 14:00:00	DIA	ETF	99.28	99.65	99.09	99.64	690700.0
2004-08-11 15:00:00	DIA	ETF	99.65	99.86	99.52	99.7	1693500.0
2004-08-11 16:00:00	DIA	ETF	99.68	99.77	99.66	99.76	28700.0
2004-08-11 18:00:00	DIA	ETF	99.7	99.7	99.65	99.65	400.0
2004-08-11 19:00:00	DIA	ETF	99.74	99.74	99.74	99.74	200.0
2004-08-11 09:00:00	TLT	ETF	85.82	85.95	85.73	85.95	562700.0
2004-08-11 10:00:00	TLT	ETF	85.92	85.97	85.88	85.93	111800.0
2004-08-11 11:00:00	TLT	ETF	85.93	86.02	85.88	86.02	54900.0
2004-08-11 12:00:00	TLT	ETF	86.0	86.07	85.94	85.99	44300.0
2004-08-11 13:00:00	TLT	ETF	85.95	86.16	85.95	86.12	22100.0
2004-08-11 14:00:00	TLT	ETF	86.16	86.27	86.13	86.14	54400.0

> showing 50 of 689 rows — these rows as CSV

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