PREVIEW / etf_1hour / 2003-07-25

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-07-25.parquet
  size:    17 KB
  rows:    416

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-07-25 08:00:00	SPY	ETF	98.73	98.98	98.67	98.67	103300.0
2003-07-25 09:00:00	SPY	ETF	98.66	99.07	98.47	99.05	4706300.0
2003-07-25 10:00:00	SPY	ETF	99.05	99.17	98.04	98.3	7756100.0
2003-07-25 11:00:00	SPY	ETF	98.32	98.95	98.2	98.87	5155300.0
2003-07-25 12:00:00	SPY	ETF	98.91	99.06	98.82	99.02	2696600.0
2003-07-25 13:00:00	SPY	ETF	98.996	99.519	98.94	99.3	4978600.0
2003-07-25 14:00:00	SPY	ETF	99.29	100.01	99.24	99.9	4953300.0
2003-07-25 15:00:00	SPY	ETF	99.94	100.29	99.86	100.23	5367300.0
2003-07-25 16:00:00	SPY	ETF	100.23	100.34	100.1	100.33	3663600.0
2003-07-25 17:00:00	SPY	ETF	100.33	100.5	100.2	100.5	17300.0
2003-07-25 18:00:00	SPY	ETF	100.54	100.59	100.4	100.4	75100.0
2003-07-25 19:00:00	SPY	ETF	100.38	100.4	100.37	100.38	2700.0
2003-07-25 08:00:00	QQQ	ETF	31.21	31.3	31.11	31.13	528500.0
2003-07-25 09:00:00	QQQ	ETF	31.12	31.33	31.07	31.27	7494500.0
2003-07-25 10:00:00	QQQ	ETF	31.26	31.277	30.769	30.87	15963100.0
2003-07-25 11:00:00	QQQ	ETF	30.885	31.15	30.839	31.13	8844700.0
2003-07-25 12:00:00	QQQ	ETF	31.14	31.2	31.04	31.131	4185200.0
2003-07-25 13:00:00	QQQ	ETF	31.13	31.51	31.11	31.367	10544600.0
2003-07-25 14:00:00	QQQ	ETF	31.38	31.66	31.34	31.61	6057500.0
2003-07-25 15:00:00	QQQ	ETF	31.61	31.781	31.55	31.77	14145200.0
2003-07-25 16:00:00	QQQ	ETF	31.77	31.87	31.75	31.85	3600000.0
2003-07-25 17:00:00	QQQ	ETF	31.86	31.92	31.85	31.9	175500.0
2003-07-25 18:00:00	QQQ	ETF	31.91	31.93	31.8	31.92	229100.0
2003-07-25 19:00:00	QQQ	ETF	31.87	31.89	31.83	31.83	18800.0
2003-07-25 09:00:00	IWM	ETF	46.475	46.745	46.45	46.71	315400.0
2003-07-25 10:00:00	IWM	ETF	46.68	46.735	46.145	46.21	821200.0
2003-07-25 11:00:00	IWM	ETF	46.21	46.39	46.155	46.39	356600.0
2003-07-25 12:00:00	IWM	ETF	46.375	46.425	46.335	46.335	73400.0
2003-07-25 13:00:00	IWM	ETF	46.375	46.54	46.35	46.35	150400.0
2003-07-25 14:00:00	IWM	ETF	46.375	46.75	46.34	46.745	101400.0
2003-07-25 15:00:00	IWM	ETF	46.74	46.93	46.73	46.77	681200.0
2003-07-25 16:00:00	IWM	ETF	46.758	46.77	46.71	46.77	51400.0
2003-07-25 08:00:00	DIA	ETF	91.5	91.65	91.25	91.41	10000.0
2003-07-25 09:00:00	DIA	ETF	91.47	91.77	91.21	91.729	734600.0
2003-07-25 10:00:00	DIA	ETF	91.74	91.85	90.92	91.07	2142000.0
2003-07-25 11:00:00	DIA	ETF	91.063	91.65	90.96	91.62	740500.0
2003-07-25 12:00:00	DIA	ETF	91.63	91.75	91.54	91.67	500800.0
2003-07-25 13:00:00	DIA	ETF	91.7	92.26	91.65	91.97	1632900.0
2003-07-25 14:00:00	DIA	ETF	91.99	92.64	91.9	92.54	700200.0
2003-07-25 15:00:00	DIA	ETF	92.58	92.93	92.46	92.884	1108100.0
2003-07-25 16:00:00	DIA	ETF	92.88	93.05	92.83	93.05	130300.0
2003-07-25 17:00:00	DIA	ETF	92.95	93.1	92.95	93.1	700.0
2003-07-25 18:00:00	DIA	ETF	93.0	93.0	93.0	93.0	1300.0
2003-07-25 19:00:00	DIA	ETF	93.0	93.0	92.98	93.0	500.0
2003-07-25 09:00:00	TLT	ETF	85.98	86.12	85.9	85.9	176300.0
2003-07-25 10:00:00	TLT	ETF	85.96	86.62	85.96	86.55	199200.0
2003-07-25 11:00:00	TLT	ETF	86.5	86.5	86.04	86.08	372900.0
2003-07-25 12:00:00	TLT	ETF	86.06	86.13	85.499	85.66	125800.0
2003-07-25 13:00:00	TLT	ETF	85.68	85.87	85.61	85.86	61100.0
2003-07-25 14:00:00	TLT	ETF	85.93	85.93	85.46	85.65	136600.0

> showing 50 of 416 rows — these rows as CSV

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