PREVIEW / etf_1hour / 2003-06-02

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-06-02.parquet
  size:    18 KB
  rows:    453

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-06-02 08:00:00	SPY	ETF	97.35	97.65	97.23	97.6	77500.0
2003-06-02 09:00:00	SPY	ETF	97.6	97.76	97.39	97.48	8203900.0
2003-06-02 10:00:00	SPY	ETF	97.47	98.1	97.25	97.86	8860300.0
2003-06-02 11:00:00	SPY	ETF	97.87	98.26	97.76	98.21	3682900.0
2003-06-02 12:00:00	SPY	ETF	98.22	98.34	98.01	98.1	2829400.0
2003-06-02 13:00:00	SPY	ETF	98.1	98.45	98.07	98.31	2925100.0
2003-06-02 14:00:00	SPY	ETF	98.3	98.36	97.51	97.52	5090500.0
2003-06-02 15:00:00	SPY	ETF	97.53	97.75	97.03	97.18	9405000.0
2003-06-02 16:00:00	SPY	ETF	97.16	97.4	96.5	97.09	3087400.0
2003-06-02 17:00:00	SPY	ETF	97.1	97.15	97.03	97.11	573800.0
2003-06-02 18:00:00	SPY	ETF	97.12	97.13	97.06	97.07	31200.0
2003-06-02 19:00:00	SPY	ETF	97.06	97.06	97.04	97.05	8700.0
2003-06-02 08:00:00	QQQ	ETF	30.02	30.18	30.0	30.18	126600.0
2003-06-02 09:00:00	QQQ	ETF	30.19	30.19	29.87	30.04	13306000.0
2003-06-02 10:00:00	QQQ	ETF	30.02	30.2	29.87	30.09	19489000.0
2003-06-02 11:00:00	QQQ	ETF	30.09	30.16	30.03	30.14	5893700.0
2003-06-02 12:00:00	QQQ	ETF	30.15	30.19	30.01	30.04	5728300.0
2003-06-02 13:00:00	QQQ	ETF	30.04	30.18	30.03	30.1	4880800.0
2003-06-02 14:00:00	QQQ	ETF	30.08	30.1	29.59	29.62	18036200.0
2003-06-02 15:00:00	QQQ	ETF	29.6	29.69	29.31	29.44	21381500.0
2003-06-02 16:00:00	QQQ	ETF	29.44	29.59	29.3	29.43	3977300.0
2003-06-02 17:00:00	QQQ	ETF	29.43	29.44	29.38	29.42	395100.0
2003-06-02 18:00:00	QQQ	ETF	29.42	29.44	29.4	29.43	73000.0
2003-06-02 19:00:00	QQQ	ETF	29.42	29.45	29.4	29.45	14900.0
2003-06-02 09:00:00	IWM	ETF	44.375	44.535	44.32	44.39	1153000.0
2003-06-02 10:00:00	IWM	ETF	44.375	44.725	44.37	44.585	1187000.0
2003-06-02 11:00:00	IWM	ETF	44.585	44.68	44.535	44.625	632800.0
2003-06-02 12:00:00	IWM	ETF	44.63	44.675	44.58	44.6	498400.0
2003-06-02 13:00:00	IWM	ETF	44.6	44.62	44.565	44.62	208600.0
2003-06-02 14:00:00	IWM	ETF	44.585	44.66	44.305	44.305	802600.0
2003-06-02 15:00:00	IWM	ETF	44.325	44.4	44.07	44.145	1200000.0
2003-06-02 16:00:00	IWM	ETF	44.155	44.245	44.155	44.245	41600.0
2003-06-02 08:00:00	DIA	ETF	89.22	89.45	89.15	89.45	24100.0
2003-06-02 09:00:00	DIA	ETF	89.43	89.55	89.28	89.38	1466400.0
2003-06-02 10:00:00	DIA	ETF	89.43	89.98	89.23	89.77	2276100.0
2003-06-02 11:00:00	DIA	ETF	89.8	90.19	89.73	90.1	787000.0
2003-06-02 12:00:00	DIA	ETF	90.1	90.2	89.88	89.95	754100.0
2003-06-02 13:00:00	DIA	ETF	89.94	90.27	89.92	90.18	576000.0
2003-06-02 14:00:00	DIA	ETF	90.12	90.19	89.5	89.5	841500.0
2003-06-02 15:00:00	DIA	ETF	89.5	89.55	89.05	89.25	1640400.0
2003-06-02 16:00:00	DIA	ETF	89.19	89.4	89.06	89.13	310000.0
2003-06-02 17:00:00	DIA	ETF	89.13	89.19	88.95	89.03	18600.0
2003-06-02 18:00:00	DIA	ETF	88.96	89.05	88.96	89.01	4100.0
2003-06-02 19:00:00	DIA	ETF	89.02	89.05	88.98	88.98	2400.0
2003-06-02 09:00:00	TLT	ETF	93.88	93.88	93.68	93.73	76800.0
2003-06-02 10:00:00	TLT	ETF	93.75	93.84	93.32	93.4	118800.0
2003-06-02 11:00:00	TLT	ETF	93.57	93.57	93.32	93.32	27400.0
2003-06-02 12:00:00	TLT	ETF	93.31	93.37	93.2	93.35	68500.0
2003-06-02 13:00:00	TLT	ETF	93.38	93.38	93.09	93.1	37600.0
2003-06-02 14:00:00	TLT	ETF	93.1	93.45	93.1	93.35	54000.0

> showing 50 of 453 rows — these rows as CSV

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