PREVIEW / etf_1hour / 2003-05-07

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-05-07.parquet
  size:    17 KB
  rows:    408

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-07 08:00:00	SPY	ETF	93.97	93.98	93.52	93.6	50000.0
2003-05-07 09:00:00	SPY	ETF	93.6	93.6	93.07	93.24	6358500.0
2003-05-07 10:00:00	SPY	ETF	93.23	93.79	92.97	93.64	6427800.0
2003-05-07 11:00:00	SPY	ETF	93.64	94.14	93.49	94.0	5666100.0
2003-05-07 12:00:00	SPY	ETF	94.0	94.03	93.62	93.79	2567600.0
2003-05-07 13:00:00	SPY	ETF	93.82	93.83	93.2	93.22	2937300.0
2003-05-07 14:00:00	SPY	ETF	93.22	93.44	93.12	93.24	2949300.0
2003-05-07 15:00:00	SPY	ETF	93.28	93.54	93.04	93.31	4417600.0
2003-05-07 16:00:00	SPY	ETF	93.32	93.46	93.24	93.33	1965200.0
2003-05-07 17:00:00	SPY	ETF	93.33	93.33	93.24	93.25	11100.0
2003-05-07 18:00:00	SPY	ETF	93.21	93.21	93.15	93.15	15500.0
2003-05-07 19:00:00	SPY	ETF	93.24	93.24	93.21	93.21	900.0
2003-05-07 08:00:00	QQQ	ETF	28.7	28.7	28.45	28.5	98500.0
2003-05-07 09:00:00	QQQ	ETF	28.49	28.5	28.29	28.34	11656700.0
2003-05-07 10:00:00	QQQ	ETF	28.36	28.53	28.22	28.48	11014600.0
2003-05-07 11:00:00	QQQ	ETF	28.48	28.69	28.4	28.61	9052500.0
2003-05-07 12:00:00	QQQ	ETF	28.61	28.61	28.43	28.48	4516900.0
2003-05-07 13:00:00	QQQ	ETF	28.5	28.5	28.26	28.27	6052600.0
2003-05-07 14:00:00	QQQ	ETF	28.28	28.33	28.15	28.2	8773600.0
2003-05-07 15:00:00	QQQ	ETF	28.2	28.38	28.12	28.27	8305100.0
2003-05-07 16:00:00	QQQ	ETF	28.28	28.33	28.24	28.25	1087600.0
2003-05-07 17:00:00	QQQ	ETF	28.26	28.27	28.22	28.22	33700.0
2003-05-07 18:00:00	QQQ	ETF	28.23	28.23	28.21	28.21	13800.0
2003-05-07 19:00:00	QQQ	ETF	28.25	28.27	28.24	28.26	5600.0
2003-05-07 20:00:00	QQQ	ETF	28.24	28.24	28.24	28.24	2100.0
2003-05-07 09:00:00	IWM	ETF	41.01	41.1	40.875	40.965	183200.0
2003-05-07 10:00:00	IWM	ETF	40.925	41.07	40.87	41.06	296800.0
2003-05-07 11:00:00	IWM	ETF	41.06	41.195	41.02	41.19	393200.0
2003-05-07 12:00:00	IWM	ETF	41.16	41.18	41.02	41.105	276600.0
2003-05-07 13:00:00	IWM	ETF	41.075	41.1	40.96	40.97	371000.0
2003-05-07 14:00:00	IWM	ETF	40.975	41.075	40.95	40.995	472200.0
2003-05-07 15:00:00	IWM	ETF	40.99	41.04	40.93	40.93	864400.0
2003-05-07 16:00:00	IWM	ETF	40.935	40.975	40.935	40.975	16200.0
2003-05-07 08:00:00	DIA	ETF	86.06	86.06	85.75	85.79	7500.0
2003-05-07 09:00:00	DIA	ETF	85.72	85.9	85.41	85.56	1415100.0
2003-05-07 10:00:00	DIA	ETF	85.6	86.22	85.38	86.05	2049100.0
2003-05-07 11:00:00	DIA	ETF	86.01	86.46	85.93	86.39	929700.0
2003-05-07 12:00:00	DIA	ETF	86.33	86.38	85.95	86.08	559100.0
2003-05-07 13:00:00	DIA	ETF	86.09	86.1	85.5	85.59	754000.0
2003-05-07 14:00:00	DIA	ETF	85.52	85.81	85.48	85.7	791300.0
2003-05-07 15:00:00	DIA	ETF	85.64	85.93	85.5	85.74	900100.0
2003-05-07 16:00:00	DIA	ETF	85.78	85.88	85.73	85.82	102100.0
2003-05-07 17:00:00	DIA	ETF	85.76	85.78	85.75	85.75	1000.0
2003-05-07 18:00:00	DIA	ETF	85.72	85.72	85.66	85.66	2100.0
2003-05-07 09:00:00	TLT	ETF	90.0	90.1	89.82	89.99	28100.0
2003-05-07 10:00:00	TLT	ETF	89.9	90.16	89.9	90.07	72900.0
2003-05-07 11:00:00	TLT	ETF	90.14	90.14	90.02	90.02	11500.0
2003-05-07 12:00:00	TLT	ETF	89.99	90.04	89.87	89.92	27200.0
2003-05-07 13:00:00	TLT	ETF	89.97	90.2	89.97	90.2	66100.0
2003-05-07 14:00:00	TLT	ETF	90.22	90.29	90.12	90.29	20900.0

> showing 50 of 408 rows — these rows as CSV

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