PREVIEW / etf_1hour / 2003-05-12

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-05-12.parquet
  size:    17 KB
  rows:    430

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-12 08:00:00	SPY	ETF	93.52	93.72	93.48	93.49	81700.0
2003-05-12 09:00:00	SPY	ETF	93.49	93.71	93.28	93.64	3493200.0
2003-05-12 10:00:00	SPY	ETF	93.65	94.39	93.55	94.31	7283200.0
2003-05-12 11:00:00	SPY	ETF	94.32	94.8	94.17	94.78	6892800.0
2003-05-12 12:00:00	SPY	ETF	94.76	94.95	94.67	94.81	3019100.0
2003-05-12 13:00:00	SPY	ETF	94.82	94.95	94.62	94.69	2506000.0
2003-05-12 14:00:00	SPY	ETF	94.7	95.07	94.67	95.06	3118800.0
2003-05-12 15:00:00	SPY	ETF	95.05	95.12	94.81	94.9	4554900.0
2003-05-12 16:00:00	SPY	ETF	94.9	94.96	94.81	94.86	1393600.0
2003-05-12 17:00:00	SPY	ETF	94.86	94.88	94.8	94.84	14300.0
2003-05-12 18:00:00	SPY	ETF	94.78	94.81	94.74	94.74	12100.0
2003-05-12 19:00:00	SPY	ETF	94.74	94.82	94.73	94.75	6900.0
2003-05-12 08:00:00	QQQ	ETF	28.45	28.51	28.37	28.37	106700.0
2003-05-12 09:00:00	QQQ	ETF	28.36	28.42	28.17	28.31	8470900.0
2003-05-12 10:00:00	QQQ	ETF	28.33	28.75	28.28	28.71	13658400.0
2003-05-12 11:00:00	QQQ	ETF	28.7	28.9	28.63	28.85	11865700.0
2003-05-12 12:00:00	QQQ	ETF	28.86	28.9	28.78	28.82	5653000.0
2003-05-12 13:00:00	QQQ	ETF	28.8	28.88	28.74	28.8	6293100.0
2003-05-12 14:00:00	QQQ	ETF	28.79	28.94	28.76	28.93	6049700.0
2003-05-12 15:00:00	QQQ	ETF	28.92	28.96	28.82	28.85	9050500.0
2003-05-12 16:00:00	QQQ	ETF	28.84	28.89	28.77	28.83	1611300.0
2003-05-12 17:00:00	QQQ	ETF	28.84	28.86	28.82	28.84	96200.0
2003-05-12 18:00:00	QQQ	ETF	28.85	28.86	28.79	28.8	82200.0
2003-05-12 19:00:00	QQQ	ETF	28.8	28.87	28.78	28.86	13400.0
2003-05-12 09:00:00	IWM	ETF	41.18	41.275	41.15	41.26	319000.0
2003-05-12 10:00:00	IWM	ETF	41.23	41.645	41.23	41.56	261600.0
2003-05-12 11:00:00	IWM	ETF	41.53	41.68	41.46	41.665	323600.0
2003-05-12 12:00:00	IWM	ETF	41.665	41.665	41.6	41.635	103000.0
2003-05-12 13:00:00	IWM	ETF	41.64	41.67	41.575	41.575	96000.0
2003-05-12 14:00:00	IWM	ETF	41.575	41.68	41.565	41.67	290200.0
2003-05-12 15:00:00	IWM	ETF	41.665	41.725	41.65	41.67	869600.0
2003-05-12 16:00:00	IWM	ETF	41.69	41.765	41.66	41.67	192200.0
2003-05-12 08:00:00	DIA	ETF	86.08	86.08	85.93	85.93	3400.0
2003-05-12 09:00:00	DIA	ETF	85.9	86.19	85.81	86.05	1965500.0
2003-05-12 10:00:00	DIA	ETF	86.05	86.73	85.97	86.73	1323700.0
2003-05-12 11:00:00	DIA	ETF	86.67	87.18	86.52	87.15	1571600.0
2003-05-12 12:00:00	DIA	ETF	87.17	87.38	87.1	87.25	611900.0
2003-05-12 13:00:00	DIA	ETF	87.26	87.37	87.1	87.13	475100.0
2003-05-12 14:00:00	DIA	ETF	87.16	87.5	87.12	87.47	511900.0
2003-05-12 15:00:00	DIA	ETF	87.47	87.59	87.3	87.39	886000.0
2003-05-12 16:00:00	DIA	ETF	87.41	87.43	87.23	87.3	183500.0
2003-05-12 17:00:00	DIA	ETF	87.3	87.3	87.29	87.29	2200.0
2003-05-12 18:00:00	DIA	ETF	87.29	87.29	87.2	87.2	1900.0
2003-05-12 19:00:00	DIA	ETF	87.17	87.17	87.17	87.17	3200.0
2003-05-12 09:00:00	TLT	ETF	91.14	91.19	90.97	91.08	77600.0
2003-05-12 10:00:00	TLT	ETF	91.06	91.08	90.9	90.92	130900.0
2003-05-12 11:00:00	TLT	ETF	90.9	90.98	90.8	90.85	11000.0
2003-05-12 12:00:00	TLT	ETF	90.87	90.91	90.79	90.83	14300.0
2003-05-12 13:00:00	TLT	ETF	90.75	90.9	90.73	90.9	10100.0
2003-05-12 14:00:00	TLT	ETF	91.02	91.1	90.95	91.05	40900.0

> showing 50 of 430 rows — these rows as CSV

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