PREVIEW / etf_1hour / 2003-05-15

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-05-15.parquet
  size:    16 KB
  rows:    394

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-15 08:00:00	SPY	ETF	94.46	94.89	94.36	94.86	118500.0
2003-05-15 09:00:00	SPY	ETF	94.9	95.2	94.71	95.15	5633500.0
2003-05-15 10:00:00	SPY	ETF	95.16	95.32	94.43	94.61	8680500.0
2003-05-15 11:00:00	SPY	ETF	94.62	94.88	94.45	94.69	2441300.0
2003-05-15 12:00:00	SPY	ETF	94.69	94.74	94.25	94.68	4683700.0
2003-05-15 13:00:00	SPY	ETF	94.69	95.05	94.62	95.0	3351900.0
2003-05-15 14:00:00	SPY	ETF	94.98	95.13	94.8	95.0	7176800.0
2003-05-15 15:00:00	SPY	ETF	95.03	95.15	94.8	95.13	3850200.0
2003-05-15 16:00:00	SPY	ETF	95.11	95.16	94.63	95.04	1323900.0
2003-05-15 17:00:00	SPY	ETF	95.02	95.06	94.99	95.0	39500.0
2003-05-15 18:00:00	SPY	ETF	94.99	95.04	94.95	94.95	23900.0
2003-05-15 19:00:00	SPY	ETF	94.94	95.0	94.9	94.95	5300.0
2003-05-15 08:00:00	QQQ	ETF	28.6	28.8	28.6	28.8	146200.0
2003-05-15 09:00:00	QQQ	ETF	28.8	28.93	28.72	28.9	10297400.0
2003-05-15 10:00:00	QQQ	ETF	28.92	28.98	28.57	28.67	13786400.0
2003-05-15 11:00:00	QQQ	ETF	28.66	28.78	28.56	28.71	4767000.0
2003-05-15 12:00:00	QQQ	ETF	28.72	28.75	28.56	28.74	4212300.0
2003-05-15 13:00:00	QQQ	ETF	28.73	28.87	28.7	28.85	4488800.0
2003-05-15 14:00:00	QQQ	ETF	28.86	28.88	28.73	28.85	4015200.0
2003-05-15 15:00:00	QQQ	ETF	28.84	28.93	28.76	28.91	6908200.0
2003-05-15 16:00:00	QQQ	ETF	28.91	28.94	28.8	28.85	3491300.0
2003-05-15 17:00:00	QQQ	ETF	28.85	28.88	28.84	28.85	80700.0
2003-05-15 18:00:00	QQQ	ETF	28.85	28.9	28.85	28.86	160900.0
2003-05-15 19:00:00	QQQ	ETF	28.86	28.89	28.86	28.88	15600.0
2003-05-15 09:00:00	IWM	ETF	42.015	42.19	42.0	42.125	124800.0
2003-05-15 10:00:00	IWM	ETF	42.14	42.2	41.85	41.905	373600.0
2003-05-15 11:00:00	IWM	ETF	41.925	42.0	41.875	41.94	103200.0
2003-05-15 12:00:00	IWM	ETF	41.89	41.95	41.855	41.915	46600.0
2003-05-15 13:00:00	IWM	ETF	41.94	42.055	41.94	42.025	34000.0
2003-05-15 14:00:00	IWM	ETF	42.035	42.075	41.98	42.075	81400.0
2003-05-15 15:00:00	IWM	ETF	42.105	42.15	42.03	42.1	228800.0
2003-05-15 16:00:00	IWM	ETF	42.12	42.135	42.055	42.055	24600.0
2003-05-15 08:00:00	DIA	ETF	86.78	87.2	86.76	87.2	37700.0
2003-05-15 09:00:00	DIA	ETF	87.21	87.47	87.0	87.4	1221900.0
2003-05-15 10:00:00	DIA	ETF	87.41	87.51	86.76	86.97	2231100.0
2003-05-15 11:00:00	DIA	ETF	86.96	87.17	86.83	87.03	520100.0
2003-05-15 12:00:00	DIA	ETF	87.05	87.09	86.66	87.05	813100.0
2003-05-15 13:00:00	DIA	ETF	87.05	87.36	86.99	87.32	357400.0
2003-05-15 14:00:00	DIA	ETF	87.32	87.44	87.11	87.31	502800.0
2003-05-15 15:00:00	DIA	ETF	87.33	87.4	87.14	87.34	741300.0
2003-05-15 16:00:00	DIA	ETF	87.35	87.41	87.28	87.35	83800.0
2003-05-15 17:00:00	DIA	ETF	87.35	87.36	87.21	87.26	4100.0
2003-05-15 18:00:00	DIA	ETF	87.3	87.3	87.3	87.3	500.0
2003-05-15 19:00:00	DIA	ETF	87.27	87.27	87.27	87.27	1000.0
2003-05-15 09:00:00	TLT	ETF	92.6	93.0	92.6	92.84	126500.0
2003-05-15 10:00:00	TLT	ETF	92.76	93.22	92.72	93.18	100500.0
2003-05-15 11:00:00	TLT	ETF	93.15	93.36	93.08	93.25	120600.0
2003-05-15 12:00:00	TLT	ETF	93.15	93.55	93.15	93.28	146300.0
2003-05-15 13:00:00	TLT	ETF	93.27	93.32	92.89	92.98	98900.0
2003-05-15 14:00:00	TLT	ETF	93.08	93.2	92.85	92.85	75000.0

> showing 50 of 394 rows — these rows as CSV

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