PREVIEW / etf_1hour / 2003-12-09

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-12-09.parquet
  size:    19 KB
  rows:    509

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
2003-12-09 08:00:00	SPY	ETF	107.88	107.93	107.84	107.85	31100.0
2003-12-09 09:00:00	SPY	ETF	107.88	107.93	107.56	107.64	2558000.0
2003-12-09 10:00:00	SPY	ETF	107.63	107.72	107.35	107.36	3361300.0
2003-12-09 11:00:00	SPY	ETF	107.34	107.46	107.18	107.4	3880200.0
2003-12-09 12:00:00	SPY	ETF	107.4	107.44	107.21	107.42	2351300.0
2003-12-09 13:00:00	SPY	ETF	107.4	107.43	107.19	107.31	2678800.0
2003-12-09 14:00:00	SPY	ETF	107.29	107.62	106.75	106.85	15267200.0
2003-12-09 15:00:00	SPY	ETF	106.84	107.05	106.54	106.62	6849400.0
2003-12-09 16:00:00	SPY	ETF	106.64	106.81	106.58	106.74	1809400.0
2003-12-09 17:00:00	SPY	ETF	106.72	106.75	106.68	106.68	1726700.0
2003-12-09 18:00:00	SPY	ETF	106.73	106.73	106.7	106.7	700.0
2003-12-09 19:00:00	SPY	ETF	106.72	106.72	106.7	106.7	3200.0
2003-12-09 08:00:00	QQQ	ETF	35.44	35.44	35.38	35.38	163200.0
2003-12-09 09:00:00	QQQ	ETF	35.38	35.46	35.21	35.26	9629100.0
2003-12-09 10:00:00	QQQ	ETF	35.26	35.34	35.07	35.11	12056000.0
2003-12-09 11:00:00	QQQ	ETF	35.11	35.13	34.87	35.03	14952600.0
2003-12-09 12:00:00	QQQ	ETF	35.03	35.04	34.91	35.02	7080400.0
2003-12-09 13:00:00	QQQ	ETF	35.03	35.04	34.85	34.93	5987400.0
2003-12-09 14:00:00	QQQ	ETF	34.921	35.06	34.59	34.62	25844200.0
2003-12-09 15:00:00	QQQ	ETF	34.619	34.75	34.37	34.42	25707100.0
2003-12-09 16:00:00	QQQ	ETF	34.42	34.45	34.38	34.43	2495600.0
2003-12-09 17:00:00	QQQ	ETF	34.43	34.44	34.419	34.42	78900.0
2003-12-09 18:00:00	QQQ	ETF	34.43	34.45	34.42	34.45	21600.0
2003-12-09 19:00:00	QQQ	ETF	34.46	34.48	34.45	34.45	19800.0
2003-12-09 09:00:00	IWM	ETF	54.41	54.475	53.99	54.13	805600.0
2003-12-09 10:00:00	IWM	ETF	54.13	54.17	53.75	53.805	667000.0
2003-12-09 11:00:00	IWM	ETF	53.765	54.035	53.585	53.925	570200.0
2003-12-09 12:00:00	IWM	ETF	53.92	54.025	53.845	54.005	1059000.0
2003-12-09 13:00:00	IWM	ETF	54.015	54.05	53.865	53.95	219800.0
2003-12-09 14:00:00	IWM	ETF	53.955	54.09	53.51	53.615	966400.0
2003-12-09 15:00:00	IWM	ETF	53.6	53.805	53.232	53.25	2055600.0
2003-12-09 16:00:00	IWM	ETF	53.248	53.31	53.2	53.25	524600.0
2003-12-09 08:00:00	DIA	ETF	100.0	100.0	99.93	99.96	5000.0
2003-12-09 09:00:00	DIA	ETF	100.0	100.15	99.96	100.03	1593800.0
2003-12-09 10:00:00	DIA	ETF	100.02	100.13	99.77	99.85	1721100.0
2003-12-09 11:00:00	DIA	ETF	99.84	99.95	99.73	99.93	967100.0
2003-12-09 12:00:00	DIA	ETF	99.94	99.96	99.79	99.92	386800.0
2003-12-09 13:00:00	DIA	ETF	99.95	99.98	99.8	99.9	198100.0
2003-12-09 14:00:00	DIA	ETF	99.86	100.14	99.43	99.53	2408100.0
2003-12-09 15:00:00	DIA	ETF	99.52	99.66	99.28	99.36	1452400.0
2003-12-09 16:00:00	DIA	ETF	99.34	99.49	99.32	99.44	677700.0
2003-12-09 17:00:00	DIA	ETF	99.44	99.44	99.44	99.44	100.0
2003-12-09 19:00:00	DIA	ETF	99.45	99.45	99.45	99.45	700.0
2003-12-09 09:00:00	TLT	ETF	85.45	85.58	85.45	85.56	8900.0
2003-12-09 10:00:00	TLT	ETF	85.55	85.56	85.3	85.37	62100.0
2003-12-09 11:00:00	TLT	ETF	85.42	85.55	85.35	85.54	83600.0
2003-12-09 12:00:00	TLT	ETF	85.53	85.58	85.5	85.55	30500.0
2003-12-09 13:00:00	TLT	ETF	85.56	85.65	85.54	85.56	71700.0
2003-12-09 14:00:00	TLT	ETF	85.54	85.7	84.36	84.62	577200.0
2003-12-09 15:00:00	TLT	ETF	84.59	84.705	84.45	84.65	96700.0

> showing 50 of 509 rows — these rows as CSV

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