PREVIEW / etf_1hour / 2003-05-27

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-05-27.parquet
  size:    17 KB
  rows:    428

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-27 08:00:00	SPY	ETF	93.35	93.35	93.21	93.26	52900.0
2003-05-27 09:00:00	SPY	ETF	93.27	93.57	93.18	93.55	4928800.0
2003-05-27 10:00:00	SPY	ETF	93.55	94.9	93.38	94.89	10573100.0
2003-05-27 11:00:00	SPY	ETF	94.89	95.04	94.72	94.9	4179700.0
2003-05-27 12:00:00	SPY	ETF	94.87	95.26	94.87	95.03	3125100.0
2003-05-27 13:00:00	SPY	ETF	95.03	95.42	94.96	95.26	3171800.0
2003-05-27 14:00:00	SPY	ETF	95.25	95.44	95.1	95.43	2998800.0
2003-05-27 15:00:00	SPY	ETF	95.38	95.84	95.36	95.62	7598200.0
2003-05-27 16:00:00	SPY	ETF	95.61	95.69	95.4	95.46	2765500.0
2003-05-27 17:00:00	SPY	ETF	95.49	95.52	95.45	95.51	104200.0
2003-05-27 18:00:00	SPY	ETF	95.5	95.53	95.45	95.45	9300.0
2003-05-27 19:00:00	SPY	ETF	95.46	95.46	95.4	95.4	1600.0
2003-05-27 08:00:00	QQQ	ETF	27.97	27.97	27.9	27.93	95100.0
2003-05-27 09:00:00	QQQ	ETF	27.93	28.22	27.9	28.21	8027000.0
2003-05-27 10:00:00	QQQ	ETF	28.2	28.83	28.14	28.83	20181900.0
2003-05-27 11:00:00	QQQ	ETF	28.82	28.95	28.77	28.89	14529100.0
2003-05-27 12:00:00	QQQ	ETF	28.88	29.04	28.87	28.92	13031500.0
2003-05-27 13:00:00	QQQ	ETF	28.92	29.1	28.87	29.0	15420500.0
2003-05-27 14:00:00	QQQ	ETF	29.0	29.1	28.92	29.1	6061000.0
2003-05-27 15:00:00	QQQ	ETF	29.09	29.22	29.03	29.13	14185200.0
2003-05-27 16:00:00	QQQ	ETF	29.13	29.18	29.09	29.15	2025400.0
2003-05-27 17:00:00	QQQ	ETF	29.16	29.19	29.15	29.17	55800.0
2003-05-27 18:00:00	QQQ	ETF	29.17	29.2	29.14	29.16	121200.0
2003-05-27 19:00:00	QQQ	ETF	29.16	29.22	29.15	29.22	23600.0
2003-05-27 20:00:00	QQQ	ETF	29.22	29.22	29.22	29.22	100.0
2003-05-27 09:00:00	IWM	ETF	41.62	41.91	41.62	41.91	127400.0
2003-05-27 10:00:00	IWM	ETF	41.89	42.46	41.89	42.435	631200.0
2003-05-27 11:00:00	IWM	ETF	42.43	42.435	42.335	42.37	313200.0
2003-05-27 12:00:00	IWM	ETF	42.395	42.505	42.355	42.44	373400.0
2003-05-27 13:00:00	IWM	ETF	42.43	42.595	42.395	42.525	247800.0
2003-05-27 14:00:00	IWM	ETF	42.53	42.57	42.47	42.565	294000.0
2003-05-27 15:00:00	IWM	ETF	42.595	42.695	42.555	42.645	378000.0
2003-05-27 16:00:00	IWM	ETF	42.635	42.69	42.61	42.66	121000.0
2003-05-27 08:00:00	DIA	ETF	85.83	85.83	85.71	85.73	6900.0
2003-05-27 09:00:00	DIA	ETF	85.77	85.92	85.6	85.9	763200.0
2003-05-27 10:00:00	DIA	ETF	85.9	87.28	85.75	87.21	2882300.0
2003-05-27 11:00:00	DIA	ETF	87.23	87.41	87.1	87.28	820800.0
2003-05-27 12:00:00	DIA	ETF	87.28	87.66	87.27	87.47	1506400.0
2003-05-27 13:00:00	DIA	ETF	87.55	87.82	87.46	87.63	542400.0
2003-05-27 14:00:00	DIA	ETF	87.64	87.8	87.46	87.8	523800.0
2003-05-27 15:00:00	DIA	ETF	87.8	88.17	87.73	88.01	1872200.0
2003-05-27 16:00:00	DIA	ETF	88.05	88.07	87.85	87.9	343900.0
2003-05-27 17:00:00	DIA	ETF	87.94	87.96	87.9	87.91	2600.0
2003-05-27 18:00:00	DIA	ETF	87.9	87.9	87.87	87.87	1900.0
2003-05-27 19:00:00	DIA	ETF	87.9	87.9	87.9	87.9	100.0
2003-05-27 09:00:00	TLT	ETF	95.62	95.71	95.57	95.61	24300.0
2003-05-27 10:00:00	TLT	ETF	95.61	95.66	95.21	95.21	141200.0
2003-05-27 11:00:00	TLT	ETF	95.21	95.27	94.88	94.95	86900.0
2003-05-27 12:00:00	TLT	ETF	94.93	94.93	94.6	94.83	163300.0
2003-05-27 13:00:00	TLT	ETF	94.85	94.89	94.5	94.63	156000.0

> showing 50 of 428 rows — these rows as CSV

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