PREVIEW / etf_1hour / 2003-05-06

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-05-06.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-05-06 08:00:00	SPY	ETF	93.32	93.37	93.1	93.13	42100.0
2003-05-06 09:00:00	SPY	ETF	93.12	93.61	93.0	93.39	4135300.0
2003-05-06 10:00:00	SPY	ETF	93.42	93.75	93.28	93.48	3943200.0
2003-05-06 11:00:00	SPY	ETF	93.47	93.88	93.41	93.86	3740700.0
2003-05-06 12:00:00	SPY	ETF	93.85	94.07	93.78	94.05	3455900.0
2003-05-06 13:00:00	SPY	ETF	94.02	94.16	93.92	93.97	2636200.0
2003-05-06 14:00:00	SPY	ETF	93.97	94.38	93.62	93.65	10807700.0
2003-05-06 15:00:00	SPY	ETF	93.63	93.88	93.17	93.8	7912300.0
2003-05-06 16:00:00	SPY	ETF	93.79	93.97	93.77	93.79	1737900.0
2003-05-06 17:00:00	SPY	ETF	93.84	93.89	93.7	93.84	129300.0
2003-05-06 18:00:00	SPY	ETF	93.83	93.84	93.7	93.77	93500.0
2003-05-06 19:00:00	SPY	ETF	93.7	93.75	93.65	93.65	1600.0
2003-05-06 08:00:00	QQQ	ETF	28.33	28.36	28.27	28.27	84200.0
2003-05-06 09:00:00	QQQ	ETF	28.28	28.54	28.21	28.45	7672000.0
2003-05-06 10:00:00	QQQ	ETF	28.45	28.58	28.37	28.46	6769600.0
2003-05-06 11:00:00	QQQ	ETF	28.46	28.65	28.43	28.65	7021000.0
2003-05-06 12:00:00	QQQ	ETF	28.65	28.78	28.61	28.72	9508300.0
2003-05-06 13:00:00	QQQ	ETF	28.74	28.83	28.69	28.73	6291800.0
2003-05-06 14:00:00	QQQ	ETF	28.76	28.9	28.57	28.58	12623300.0
2003-05-06 15:00:00	QQQ	ETF	28.59	28.67	28.39	28.63	13713700.0
2003-05-06 16:00:00	QQQ	ETF	28.66	28.7	28.5	28.61	2256600.0
2003-05-06 17:00:00	QQQ	ETF	28.61	28.69	28.5	28.6	901000.0
2003-05-06 18:00:00	QQQ	ETF	28.59	28.61	28.56	28.59	106600.0
2003-05-06 19:00:00	QQQ	ETF	28.57	28.58	28.54	28.56	16400.0
2003-05-06 09:00:00	IWM	ETF	40.93	41.145	40.895	41.095	230200.0
2003-05-06 10:00:00	IWM	ETF	41.085	41.145	40.97	41.03	373400.0
2003-05-06 11:00:00	IWM	ETF	41.045	41.135	41.025	41.13	67400.0
2003-05-06 12:00:00	IWM	ETF	41.165	41.225	41.15	41.21	83000.0
2003-05-06 13:00:00	IWM	ETF	41.215	41.285	41.185	41.185	180800.0
2003-05-06 14:00:00	IWM	ETF	41.2	41.285	41.09	41.13	603600.0
2003-05-06 15:00:00	IWM	ETF	41.115	41.14	40.96	41.03	819800.0
2003-05-06 16:00:00	IWM	ETF	41.06	41.225	41.035	41.225	30200.0
2003-05-06 17:00:00	IWM	ETF	41.225	41.225	41.225	41.225	37800.0
2003-05-06 08:00:00	DIA	ETF	85.74	85.74	85.6	85.62	2700.0
2003-05-06 09:00:00	DIA	ETF	85.5	85.9	85.44	85.66	1530700.0
2003-05-06 10:00:00	DIA	ETF	85.65	85.98	85.57	85.77	865000.0
2003-05-06 11:00:00	DIA	ETF	85.77	86.1	85.72	86.1	515800.0
2003-05-06 12:00:00	DIA	ETF	86.1	86.3	86.02	86.25	541900.0
2003-05-06 13:00:00	DIA	ETF	86.2	86.4	86.12	86.15	982500.0
2003-05-06 14:00:00	DIA	ETF	86.16	86.58	85.78	85.89	1682400.0
2003-05-06 15:00:00	DIA	ETF	85.82	86.09	85.4	86.02	2288800.0
2003-05-06 16:00:00	DIA	ETF	86.0	86.18	85.95	86.04	72800.0
2003-05-06 17:00:00	DIA	ETF	86.0	86.0	85.9	85.96	6000.0
2003-05-06 18:00:00	DIA	ETF	86.04	86.04	85.92	85.92	300.0
2003-05-06 19:00:00	DIA	ETF	85.91	85.91	85.91	85.91	300.0
2003-05-06 09:00:00	TLT	ETF	88.84	88.84	88.65	88.74	1400.0
2003-05-06 10:00:00	TLT	ETF	88.7	88.81	88.65	88.81	11200.0
2003-05-06 11:00:00	TLT	ETF	88.74	88.78	88.7	88.78	1400.0
2003-05-06 12:00:00	TLT	ETF	88.78	88.78	88.66	88.66	300.0
2003-05-06 13:00:00	TLT	ETF	88.62	88.62	88.59	88.59	1200.0

> showing 50 of 413 rows — these rows as CSV

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