PREVIEW / etf_1hour / 2003-07-30

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-07-30.parquet
  size:    16 KB
  rows:    398

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-30 08:00:00	SPY	ETF	99.58	99.78	99.45	99.78	62900.0
2003-07-30 09:00:00	SPY	ETF	99.77	99.8	99.15	99.19	3080500.0
2003-07-30 10:00:00	SPY	ETF	99.2	99.61	99.06	99.48	4710100.0
2003-07-30 11:00:00	SPY	ETF	99.49	99.64	98.93	99.2	3854200.0
2003-07-30 12:00:00	SPY	ETF	99.19	99.48	99.17	99.36	2357900.0
2003-07-30 13:00:00	SPY	ETF	99.37	99.52	99.17	99.27	2157200.0
2003-07-30 14:00:00	SPY	ETF	99.27	99.48	98.95	99.12	3782700.0
2003-07-30 15:00:00	SPY	ETF	99.11	99.28	99.0	99.11	3834600.0
2003-07-30 16:00:00	SPY	ETF	99.094	99.19	99.05	99.13	1727100.0
2003-07-30 17:00:00	SPY	ETF	99.14	99.15	99.13	99.15	1700.0
2003-07-30 18:00:00	SPY	ETF	99.16	99.18	99.13	99.16	62900.0
2003-07-30 19:00:00	SPY	ETF	99.15	99.15	99.15	99.15	1000.0
2003-07-30 08:00:00	QQQ	ETF	31.71	31.78	31.64	31.78	104200.0
2003-07-30 09:00:00	QQQ	ETF	31.78	31.79	31.45	31.49	8303900.0
2003-07-30 10:00:00	QQQ	ETF	31.49	31.64	31.37	31.569	12905200.0
2003-07-30 11:00:00	QQQ	ETF	31.54	31.62	31.35	31.47	5774000.0
2003-07-30 12:00:00	QQQ	ETF	31.48	31.58	31.45	31.52	3233600.0
2003-07-30 13:00:00	QQQ	ETF	31.52	31.57	31.44	31.46	3926400.0
2003-07-30 14:00:00	QQQ	ETF	31.46	31.58	31.38	31.41	6410600.0
2003-07-30 15:00:00	QQQ	ETF	31.41	31.5	31.33	31.41	6953800.0
2003-07-30 16:00:00	QQQ	ETF	31.41	31.7009	31.39	31.42	2999300.0
2003-07-30 17:00:00	QQQ	ETF	31.41	31.45	31.4	31.45	31200.0
2003-07-30 18:00:00	QQQ	ETF	31.42	31.45	31.42	31.45	15600.0
2003-07-30 19:00:00	QQQ	ETF	31.45	31.46	31.4	31.4	12200.0
2003-07-30 09:00:00	IWM	ETF	47.475	47.475	47.19	47.2	191800.0
2003-07-30 10:00:00	IWM	ETF	47.21	47.325	47.135	47.135	508000.0
2003-07-30 11:00:00	IWM	ETF	47.155	47.165	46.92	46.97	522600.0
2003-07-30 12:00:00	IWM	ETF	46.98	47.085	46.95	47.04	121400.0
2003-07-30 13:00:00	IWM	ETF	47.055	47.115	47.03	47.06	122400.0
2003-07-30 14:00:00	IWM	ETF	47.06	47.125	46.96	47.055	305200.0
2003-07-30 15:00:00	IWM	ETF	47.0	47.225	46.95	47.21	572000.0
2003-07-30 16:00:00	IWM	ETF	47.21	47.25	47.18	47.2	26200.0
2003-07-30 08:00:00	DIA	ETF	92.35	92.46	92.34	92.46	11200.0
2003-07-30 09:00:00	DIA	ETF	92.55	92.58	92.02	92.05	462300.0
2003-07-30 10:00:00	DIA	ETF	92.06	92.44	91.92	92.3	1205400.0
2003-07-30 11:00:00	DIA	ETF	92.34	92.4	91.78	91.96	870000.0
2003-07-30 12:00:00	DIA	ETF	91.95	92.21	91.92	92.12	238300.0
2003-07-30 13:00:00	DIA	ETF	92.13	92.25	91.94	92.05	269200.0
2003-07-30 14:00:00	DIA	ETF	92.06	92.2	91.75	91.93	777600.0
2003-07-30 15:00:00	DIA	ETF	91.9	92.2	91.81	92.08	935100.0
2003-07-30 16:00:00	DIA	ETF	92.06	92.16	92.04	92.12	166800.0
2003-07-30 17:00:00	DIA	ETF	92.11	92.12	92.11	92.12	1100.0
2003-07-30 09:00:00	TLT	ETF	83.74	84.0	83.7	83.7	271600.0
2003-07-30 10:00:00	TLT	ETF	83.69	84.18	83.57	84.1	453900.0
2003-07-30 11:00:00	TLT	ETF	84.09	84.72	84.09	84.64	554600.0
2003-07-30 12:00:00	TLT	ETF	84.51	84.685	84.4	84.4	125200.0
2003-07-30 13:00:00	TLT	ETF	84.4	84.61	84.22	84.5	123500.0
2003-07-30 14:00:00	TLT	ETF	84.43	84.6	84.35	84.36	110700.0
2003-07-30 15:00:00	TLT	ETF	84.37	84.39	84.15	84.2	207300.0
2003-07-30 16:00:00	TLT	ETF	84.18	84.2	84.18	84.2	5500.0

> showing 50 of 398 rows — these rows as CSV

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