PREVIEW / etf_1hour / 2003-07-08

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-07-08.parquet
  size:    17 KB
  rows:    429

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-08 08:00:00	SPY	ETF	100.6	100.6	100.29	100.37	75000.0
2003-07-08 09:00:00	SPY	ETF	100.36	100.79	100.35	100.396	3276900.0
2003-07-08 10:00:00	SPY	ETF	100.4	100.97	100.17	100.83	5590800.0
2003-07-08 11:00:00	SPY	ETF	100.85	101.0	100.68	100.92	2537000.0
2003-07-08 12:00:00	SPY	ETF	100.93	100.95	100.48	100.75	4020700.0
2003-07-08 13:00:00	SPY	ETF	100.73	100.85	100.55	100.59	1385500.0
2003-07-08 14:00:00	SPY	ETF	100.6	100.89	100.48	100.82	1975200.0
2003-07-08 15:00:00	SPY	ETF	100.82	101.29	100.68	101.03	6206200.0
2003-07-08 16:00:00	SPY	ETF	101.03	101.2	100.95	101.099	2140900.0
2003-07-08 17:00:00	SPY	ETF	101.05	101.06	101.0	101.0	2248100.0
2003-07-08 18:00:00	SPY	ETF	101.01	101.05	101.0	101.05	5500.0
2003-07-08 19:00:00	SPY	ETF	101.06	101.06	101.06	101.06	100.0
2003-07-08 08:00:00	QQQ	ETF	31.85	31.87	31.72	31.76	147800.0
2003-07-08 09:00:00	QQQ	ETF	31.76	31.98	31.696	31.72	10273800.0
2003-07-08 10:00:00	QQQ	ETF	31.719	31.96	31.62	31.9	16633200.0
2003-07-08 11:00:00	QQQ	ETF	31.93	32.08	31.86	32.08	9259900.0
2003-07-08 12:00:00	QQQ	ETF	32.07	32.08	31.83	32.0	7945600.0
2003-07-08 13:00:00	QQQ	ETF	32.0	32.06	31.93	31.993	5389900.0
2003-07-08 14:00:00	QQQ	ETF	32.0	32.15	31.92	32.08	6887000.0
2003-07-08 15:00:00	QQQ	ETF	32.11	32.31	32.04	32.221	17479800.0
2003-07-08 16:00:00	QQQ	ETF	32.18	32.31	31.9908	32.21	2681300.0
2003-07-08 17:00:00	QQQ	ETF	32.22	32.22	31.944	32.16	497300.0
2003-07-08 18:00:00	QQQ	ETF	32.16	32.19	32.13	32.17	34600.0
2003-07-08 19:00:00	QQQ	ETF	32.18	32.18	32.13	32.15	27100.0
2003-07-08 09:00:00	IWM	ETF	46.4	46.565	46.344	46.42	471000.0
2003-07-08 10:00:00	IWM	ETF	46.43	46.8	46.365	46.75	516400.0
2003-07-08 11:00:00	IWM	ETF	46.745	46.925	46.735	46.925	469200.0
2003-07-08 12:00:00	IWM	ETF	46.935	46.935	46.805	46.92	230800.0
2003-07-08 13:00:00	IWM	ETF	46.91	46.99	46.85	46.97	723200.0
2003-07-08 14:00:00	IWM	ETF	46.99	47.24	46.95	47.195	315800.0
2003-07-08 15:00:00	IWM	ETF	47.21	47.38	47.16	47.225	679200.0
2003-07-08 16:00:00	IWM	ETF	47.295	47.295	47.185	47.25	128000.0
2003-07-08 08:00:00	DIA	ETF	92.18	92.18	91.98	92.03	8100.0
2003-07-08 09:00:00	DIA	ETF	92.08	92.33	91.99	92.01	803800.0
2003-07-08 10:00:00	DIA	ETF	92.01	92.37	91.761	92.25	898900.0
2003-07-08 11:00:00	DIA	ETF	92.27	92.47	92.15	92.38	463600.0
2003-07-08 12:00:00	DIA	ETF	92.33	92.37	91.96	92.22	487200.0
2003-07-08 13:00:00	DIA	ETF	92.22	92.31	92.02	92.07	230200.0
2003-07-08 14:00:00	DIA	ETF	92.1	92.29	91.96	92.19	313100.0
2003-07-08 15:00:00	DIA	ETF	92.21	92.55	92.05	92.37	1032500.0
2003-07-08 16:00:00	DIA	ETF	92.36	92.49	92.31	92.44	100500.0
2003-07-08 17:00:00	DIA	ETF	92.43	92.43	92.43	92.43	500.0
2003-07-08 19:00:00	DIA	ETF	92.39	92.4	92.39	92.39	1700.0
2003-07-08 09:00:00	TLT	ETF	90.43	90.43	90.25	90.33	26800.0
2003-07-08 10:00:00	TLT	ETF	90.4	90.48	90.08	90.25	61400.0
2003-07-08 11:00:00	TLT	ETF	90.15	90.19	89.82	89.82	43800.0
2003-07-08 12:00:00	TLT	ETF	89.85	89.89	89.74	89.82	24100.0
2003-07-08 13:00:00	TLT	ETF	89.82	89.84	89.63	89.84	99600.0
2003-07-08 14:00:00	TLT	ETF	89.84	89.9	89.77	89.9	5700.0
2003-07-08 15:00:00	TLT	ETF	90.03	90.17	89.95	90.17	103100.0

> showing 50 of 429 rows — these rows as CSV

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