PREVIEW / etf_1hour / 2003-07-02

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-07-02.parquet
  size:    17 KB
  rows:    406

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-02 08:00:00	SPY	ETF	98.88	98.95	98.69	98.75	65800.0
2003-07-02 09:00:00	SPY	ETF	98.7	99.2	98.57	99.19	5473400.0
2003-07-02 10:00:00	SPY	ETF	99.17	99.28	98.74	99.1	5788300.0
2003-07-02 11:00:00	SPY	ETF	99.09	99.21	98.76	99.13	2600200.0
2003-07-02 12:00:00	SPY	ETF	99.15	99.41	99.08	99.37	3285500.0
2003-07-02 13:00:00	SPY	ETF	99.35	99.56	99.09	99.4	3674200.0
2003-07-02 14:00:00	SPY	ETF	99.39	99.5	99.0	99.49	3887900.0
2003-07-02 15:00:00	SPY	ETF	99.49	99.68	99.3	99.6	5157500.0
2003-07-02 16:00:00	SPY	ETF	99.57	99.79	99.3246	99.73	1806200.0
2003-07-02 17:00:00	SPY	ETF	99.7	99.73	99.69	99.71	21100.0
2003-07-02 18:00:00	SPY	ETF	99.73	99.75	99.71	99.71	900.0
2003-07-02 19:00:00	SPY	ETF	99.75	99.75	99.75	99.75	1100.0
2003-07-02 08:00:00	QQQ	ETF	30.47	30.51	30.4	30.45	105600.0
2003-07-02 09:00:00	QQQ	ETF	30.44	30.621	30.38	30.62	13012800.0
2003-07-02 10:00:00	QQQ	ETF	30.61	30.73	30.5	30.682	14082900.0
2003-07-02 11:00:00	QQQ	ETF	30.69	30.73	30.51	30.68	6161700.0
2003-07-02 12:00:00	QQQ	ETF	30.68	30.84	30.67	30.82	8127400.0
2003-07-02 13:00:00	QQQ	ETF	30.84	30.89	30.71	30.82	10797300.0
2003-07-02 14:00:00	QQQ	ETF	30.81	30.84	30.67	30.83	8621000.0
2003-07-02 15:00:00	QQQ	ETF	30.82	30.93	30.69	30.91	11580200.0
2003-07-02 16:00:00	QQQ	ETF	30.91	30.99	30.88	30.93	2754000.0
2003-07-02 17:00:00	QQQ	ETF	30.92	30.94	30.91	30.93	30900.0
2003-07-02 18:00:00	QQQ	ETF	30.93	30.95	30.93	30.95	9900.0
2003-07-02 19:00:00	QQQ	ETF	30.93	30.97	30.93	30.96	24000.0
2003-07-02 20:00:00	QQQ	ETF	30.95	30.95	30.95	30.95	100.0
2003-07-02 09:00:00	IWM	ETF	44.81	45.175	44.81	45.145	368400.0
2003-07-02 10:00:00	IWM	ETF	45.135	45.25	45.025	45.2	1069400.0
2003-07-02 11:00:00	IWM	ETF	45.21	45.31	45.13	45.31	629000.0
2003-07-02 12:00:00	IWM	ETF	45.31	45.58	45.31	45.58	421800.0
2003-07-02 13:00:00	IWM	ETF	45.585	45.68	45.465	45.665	285800.0
2003-07-02 14:00:00	IWM	ETF	45.655	45.655	45.5	45.585	460600.0
2003-07-02 15:00:00	IWM	ETF	45.6	45.75	45.555	45.715	665400.0
2003-07-02 16:00:00	IWM	ETF	45.75	45.875	45.715	45.875	102200.0
2003-07-02 08:00:00	DIA	ETF	90.95	90.95	90.75	90.81	2200.0
2003-07-02 09:00:00	DIA	ETF	90.78	91.13	90.722	91.119	631200.0
2003-07-02 10:00:00	DIA	ETF	91.11	91.19	90.72	91.02	890800.0
2003-07-02 11:00:00	DIA	ETF	91.04	91.09	90.76	91.08	308600.0
2003-07-02 12:00:00	DIA	ETF	91.09	91.37	91.04	91.33	679600.0
2003-07-02 13:00:00	DIA	ETF	91.35	91.49	91.05	91.4	424800.0
2003-07-02 14:00:00	DIA	ETF	91.39	91.477	91.12	91.43	404700.0
2003-07-02 15:00:00	DIA	ETF	91.44	91.68	91.32	91.61	677400.0
2003-07-02 16:00:00	DIA	ETF	91.6	91.68	91.56	91.65	118300.0
2003-07-02 17:00:00	DIA	ETF	91.68	91.7	91.65	91.7	6200.0
2003-07-02 18:00:00	DIA	ETF	91.66	91.66	91.52	91.52	300.0
2003-07-02 09:00:00	TLT	ETF	91.2	91.3	91.11	91.23	100600.0
2003-07-02 10:00:00	TLT	ETF	91.26	91.57	91.26	91.57	80600.0
2003-07-02 11:00:00	TLT	ETF	91.52	91.69	91.49	91.6	20000.0
2003-07-02 12:00:00	TLT	ETF	91.65	91.73	91.5	91.68	16000.0
2003-07-02 13:00:00	TLT	ETF	91.7	91.87	91.66	91.87	31800.0
2003-07-02 14:00:00	TLT	ETF	91.94	92.07	91.86	91.87	17700.0

> showing 50 of 406 rows — these rows as CSV

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