PREVIEW / etf_1hour / 2003-08-20

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-08-20.parquet
  size:    17 KB
  rows:    413

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-20 08:00:00	SPY	ETF	100.5	100.55	100.38	100.38	42300.0
2003-08-20 09:00:00	SPY	ETF	100.36	100.54	100.24	100.33	2295600.0
2003-08-20 10:00:00	SPY	ETF	100.34	100.572	100.164	100.55	2158600.0
2003-08-20 11:00:00	SPY	ETF	100.54	100.89	100.52	100.8	3436000.0
2003-08-20 12:00:00	SPY	ETF	100.78	100.82	100.56	100.67	3229600.0
2003-08-20 13:00:00	SPY	ETF	100.67	100.89	100.63	100.7	1522000.0
2003-08-20 14:00:00	SPY	ETF	100.72	100.8	100.43	100.65	1915500.0
2003-08-20 15:00:00	SPY	ETF	100.64	100.82	100.41	100.5	2566800.0
2003-08-20 16:00:00	SPY	ETF	100.5	100.61	100.387	100.438	1325700.0
2003-08-20 17:00:00	SPY	ETF	100.489	100.557	100.46	100.54	1909100.0
2003-08-20 18:00:00	SPY	ETF	100.52	100.52	100.45	100.45	1200.0
2003-08-20 08:00:00	QQQ	ETF	32.11	32.12	32.07	32.09	141300.0
2003-08-20 09:00:00	QQQ	ETF	32.08	32.21	32.04	32.11	7019000.0
2003-08-20 10:00:00	QQQ	ETF	32.11	32.28	32.02	32.25	8100200.0
2003-08-20 11:00:00	QQQ	ETF	32.25	32.46	32.228	32.43	9793200.0
2003-08-20 12:00:00	QQQ	ETF	32.43	32.44	32.31	32.4	4899000.0
2003-08-20 13:00:00	QQQ	ETF	32.39	32.52	32.37	32.424	6634100.0
2003-08-20 14:00:00	QQQ	ETF	32.42	32.46	32.27	32.34	6410100.0
2003-08-20 15:00:00	QQQ	ETF	32.34	32.45	32.2	32.27	8528100.0
2003-08-20 16:00:00	QQQ	ETF	32.27	32.33	32.25	32.295	1675700.0
2003-08-20 17:00:00	QQQ	ETF	32.3	32.33	32.3	32.33	20100.0
2003-08-20 18:00:00	QQQ	ETF	32.33	32.36	32.32	32.34	30700.0
2003-08-20 19:00:00	QQQ	ETF	32.35	32.36	32.31	32.36	10200.0
2003-08-20 09:00:00	IWM	ETF	48.505	48.6	48.4	48.595	418800.0
2003-08-20 10:00:00	IWM	ETF	48.585	48.625	48.465	48.625	379600.0
2003-08-20 11:00:00	IWM	ETF	48.635	48.975	48.635	48.975	1325400.0
2003-08-20 12:00:00	IWM	ETF	48.97	48.97	48.81	48.855	335200.0
2003-08-20 13:00:00	IWM	ETF	48.86	48.99	48.85	48.945	774200.0
2003-08-20 14:00:00	IWM	ETF	48.94	48.96	48.84	48.905	386600.0
2003-08-20 15:00:00	IWM	ETF	48.905	48.98	48.76	48.805	820000.0
2003-08-20 16:00:00	IWM	ETF	48.805	49.0	48.805	48.93	25000.0
2003-08-20 08:00:00	DIA	ETF	94.01	94.04	93.99	94.01	8800.0
2003-08-20 09:00:00	DIA	ETF	94.03	94.24	93.87	94.03	576200.0
2003-08-20 10:00:00	DIA	ETF	94.04	94.13	93.84	94.1	715400.0
2003-08-20 11:00:00	DIA	ETF	94.1	94.49	94.1	94.4	731500.0
2003-08-20 12:00:00	DIA	ETF	94.4	94.4	94.16	94.25	401800.0
2003-08-20 13:00:00	DIA	ETF	94.24	94.4	94.19	94.25	102100.0
2003-08-20 14:00:00	DIA	ETF	94.27	94.34	94.03	94.21	654300.0
2003-08-20 15:00:00	DIA	ETF	94.19	94.39	94.01	94.18	1095400.0
2003-08-20 16:00:00	DIA	ETF	94.16	94.28	94.15	94.2	523400.0
2003-08-20 17:00:00	DIA	ETF	94.12	94.15	94.12	94.15	1100.0
2003-08-20 18:00:00	DIA	ETF	94.18	94.18	94.18	94.18	200.0
2003-08-20 19:00:00	DIA	ETF	94.22	94.22	94.22	94.22	200.0
2003-08-20 09:00:00	TLT	ETF	83.83	83.87	83.17	83.17	118500.0
2003-08-20 10:00:00	TLT	ETF	83.3	83.47	82.8	83.04	140700.0
2003-08-20 11:00:00	TLT	ETF	82.96	83.15	82.74	82.82	61100.0
2003-08-20 12:00:00	TLT	ETF	82.85	83.28	82.79	83.22	26100.0
2003-08-20 13:00:00	TLT	ETF	83.3	83.34	82.97	83.0	25300.0
2003-08-20 14:00:00	TLT	ETF	83.1	83.17	82.84	83.08	49200.0
2003-08-20 15:00:00	TLT	ETF	83.13	83.17	83.0	83.11	34500.0

> showing 50 of 413 rows — these rows as CSV

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