PREVIEW / etf_1hour / 2003-08-12

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-08-12.parquet
  size:    17 KB
  rows:    404

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-08-12 08:00:00	SPY	ETF	98.9	98.9	98.78	98.79	23600.0
2003-08-12 09:00:00	SPY	ETF	98.79	98.81	98.48	98.62	2265300.0
2003-08-12 10:00:00	SPY	ETF	98.6	98.9	98.56	98.6	2855800.0
2003-08-12 11:00:00	SPY	ETF	98.64	98.77	98.42	98.65	1680100.0
2003-08-12 12:00:00	SPY	ETF	98.65	98.74	98.57	98.69	813900.0
2003-08-12 13:00:00	SPY	ETF	98.7	98.72	98.53	98.66	915800.0
2003-08-12 14:00:00	SPY	ETF	98.659	99.29	98.45	99.06	11167200.0
2003-08-12 15:00:00	SPY	ETF	99.08	99.56	98.89	99.54	6269200.0
2003-08-12 16:00:00	SPY	ETF	99.54	99.65	98.87	99.55	1581100.0
2003-08-12 17:00:00	SPY	ETF	99.54	99.55	99.44	99.5	191500.0
2003-08-12 18:00:00	SPY	ETF	99.52	99.57	99.5	99.5	11100.0
2003-08-12 19:00:00	SPY	ETF	99.45	99.5	99.44	99.5	11400.0
2003-08-12 08:00:00	QQQ	ETF	30.55	30.57	30.53	30.54	68600.0
2003-08-12 09:00:00	QQQ	ETF	30.53	30.57	30.326	30.4	5687700.0
2003-08-12 10:00:00	QQQ	ETF	30.41	30.55	30.4	30.44	6461800.0
2003-08-12 11:00:00	QQQ	ETF	30.44	30.51	30.41	30.45	2737500.0
2003-08-12 12:00:00	QQQ	ETF	30.45	30.54	30.44	30.51	1943100.0
2003-08-12 13:00:00	QQQ	ETF	30.51	30.54	30.45	30.503	2029900.0
2003-08-12 14:00:00	QQQ	ETF	30.513	30.77	30.46	30.67	15378300.0
2003-08-12 15:00:00	QQQ	ETF	30.666	30.89	30.59	30.863	15391900.0
2003-08-12 16:00:00	QQQ	ETF	30.88	30.9	30.79	30.83	4286100.0
2003-08-12 17:00:00	QQQ	ETF	30.819	30.82	30.74	30.81	250000.0
2003-08-12 18:00:00	QQQ	ETF	30.82	30.844	30.8	30.81	70300.0
2003-08-12 19:00:00	QQQ	ETF	30.81	30.84	30.8	30.82	13700.0
2003-08-12 09:00:00	IWM	ETF	45.845	46.05	45.757	45.85	909400.0
2003-08-12 10:00:00	IWM	ETF	45.875	46.08	45.875	45.955	402200.0
2003-08-12 11:00:00	IWM	ETF	45.95	46.1	45.93	46.1	609600.0
2003-08-12 12:00:00	IWM	ETF	46.1	46.14	46.06	46.14	31600.0
2003-08-12 13:00:00	IWM	ETF	46.14	46.18	46.085	46.155	548200.0
2003-08-12 14:00:00	IWM	ETF	46.155	46.4	46.11	46.375	909800.0
2003-08-12 15:00:00	IWM	ETF	46.375	46.62	46.29	46.595	1569000.0
2003-08-12 16:00:00	IWM	ETF	46.64	46.645	46.575	46.645	19200.0
2003-08-12 08:00:00	DIA	ETF	92.61	92.61	92.53	92.53	2800.0
2003-08-12 09:00:00	DIA	ETF	92.49	92.53	92.27	92.35	377300.0
2003-08-12 10:00:00	DIA	ETF	92.34	92.6	92.34	92.45	631200.0
2003-08-12 11:00:00	DIA	ETF	92.47	92.55	92.25	92.45	635800.0
2003-08-12 12:00:00	DIA	ETF	92.44	92.5	92.37	92.47	214200.0
2003-08-12 13:00:00	DIA	ETF	92.44	92.47	92.3	92.47	258800.0
2003-08-12 14:00:00	DIA	ETF	92.48	92.93	92.21	92.75	1621500.0
2003-08-12 15:00:00	DIA	ETF	92.77	93.22	92.61	93.22	1308200.0
2003-08-12 16:00:00	DIA	ETF	93.2	93.31	93.16	93.27	164300.0
2003-08-12 17:00:00	DIA	ETF	93.23	93.25	93.18	93.23	24800.0
2003-08-12 18:00:00	DIA	ETF	93.23	93.25	93.23	93.25	700.0
2003-08-12 19:00:00	DIA	ETF	93.19	93.19	93.11	93.11	400.0
2003-08-12 09:00:00	TLT	ETF	83.42	83.42	83.13	83.13	75100.0
2003-08-12 10:00:00	TLT	ETF	83.12	83.12	82.99	83.1	167000.0
2003-08-12 11:00:00	TLT	ETF	83.13	83.31	83.11	83.16	181200.0
2003-08-12 12:00:00	TLT	ETF	83.19	83.44	83.19	83.29	71100.0
2003-08-12 13:00:00	TLT	ETF	83.33	83.34	83.14	83.24	54200.0
2003-08-12 14:00:00	TLT	ETF	83.2	83.65	83.02	83.24	339300.0

> showing 50 of 404 rows — these rows as CSV

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