PREVIEW / etf_1hour / 2003-05-14

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-05-14.parquet
  size:    16 KB
  rows:    392

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-14 08:00:00	SPY	ETF	94.98	95.18	94.85	95.1	127200.0
2003-05-14 09:00:00	SPY	ETF	95.08	95.24	94.5	94.55	4067800.0
2003-05-14 10:00:00	SPY	ETF	94.53	94.57	93.94	94.11	6697600.0
2003-05-14 11:00:00	SPY	ETF	94.11	94.33	94.07	94.32	2887700.0
2003-05-14 12:00:00	SPY	ETF	94.31	94.46	94.23	94.31	1869100.0
2003-05-14 13:00:00	SPY	ETF	94.3	94.56	94.18	94.34	2100400.0
2003-05-14 14:00:00	SPY	ETF	94.34	94.39	93.91	94.2	4216700.0
2003-05-14 15:00:00	SPY	ETF	94.2	94.5	94.02	94.36	4111800.0
2003-05-14 16:00:00	SPY	ETF	94.35	94.55	94.33	94.45	1066700.0
2003-05-14 17:00:00	SPY	ETF	94.46	94.47	94.41	94.43	37300.0
2003-05-14 18:00:00	SPY	ETF	94.44	94.49	94.42	94.42	2600.0
2003-05-14 19:00:00	SPY	ETF	94.43	94.5	94.42	94.5	2500.0
2003-05-14 08:00:00	QQQ	ETF	28.79	28.89	28.7	28.84	205100.0
2003-05-14 09:00:00	QQQ	ETF	28.84	28.97	28.59	28.65	10943100.0
2003-05-14 10:00:00	QQQ	ETF	28.65	28.67	28.36	28.36	17078300.0
2003-05-14 11:00:00	QQQ	ETF	28.37	28.5	28.36	28.49	6670800.0
2003-05-14 12:00:00	QQQ	ETF	28.49	28.55	28.46	28.49	4381800.0
2003-05-14 13:00:00	QQQ	ETF	28.49	28.58	28.44	28.5	2750300.0
2003-05-14 14:00:00	QQQ	ETF	28.52	28.55	28.38	28.48	3497600.0
2003-05-14 15:00:00	QQQ	ETF	28.47	28.63	28.4	28.55	5453200.0
2003-05-14 16:00:00	QQQ	ETF	28.53	28.64	28.4	28.61	2365200.0
2003-05-14 17:00:00	QQQ	ETF	28.62	28.63	28.58	28.59	396700.0
2003-05-14 18:00:00	QQQ	ETF	28.59	28.64	28.59	28.62	45600.0
2003-05-14 19:00:00	QQQ	ETF	28.63	28.67	28.62	28.64	24100.0
2003-05-14 09:00:00	IWM	ETF	42.045	42.05	41.84	41.84	623400.0
2003-05-14 10:00:00	IWM	ETF	41.82	41.83	41.705	41.755	674400.0
2003-05-14 11:00:00	IWM	ETF	41.73	41.805	41.725	41.8	85600.0
2003-05-14 12:00:00	IWM	ETF	41.83	41.91	41.83	41.89	40800.0
2003-05-14 13:00:00	IWM	ETF	41.89	41.96	41.835	41.89	188400.0
2003-05-14 14:00:00	IWM	ETF	41.9	41.925	41.785	41.82	149200.0
2003-05-14 15:00:00	IWM	ETF	41.82	42.015	41.815	41.86	313800.0
2003-05-14 16:00:00	IWM	ETF	41.875	41.89	41.83	41.83	10400.0
2003-05-14 08:00:00	DIA	ETF	87.34	87.43	87.19	87.31	12000.0
2003-05-14 09:00:00	DIA	ETF	87.35	87.54	86.76	86.77	1399500.0
2003-05-14 10:00:00	DIA	ETF	86.75	86.76	86.32	86.49	1766700.0
2003-05-14 11:00:00	DIA	ETF	86.5	86.69	86.43	86.66	952400.0
2003-05-14 12:00:00	DIA	ETF	86.67	86.8	86.58	86.69	423900.0
2003-05-14 13:00:00	DIA	ETF	86.69	86.9	86.53	86.72	270100.0
2003-05-14 14:00:00	DIA	ETF	86.7	86.7	86.35	86.6	1003700.0
2003-05-14 15:00:00	DIA	ETF	86.6	86.88	86.43	86.76	788000.0
2003-05-14 16:00:00	DIA	ETF	86.76	86.95	86.73	86.9	88700.0
2003-05-14 17:00:00	DIA	ETF	86.87	86.87	86.84	86.84	2300.0
2003-05-14 18:00:00	DIA	ETF	86.85	86.85	86.85	86.85	200.0
2003-05-14 09:00:00	TLT	ETF	91.83	92.07	91.62	91.99	181400.0
2003-05-14 10:00:00	TLT	ETF	91.99	92.26	91.99	92.18	100300.0
2003-05-14 11:00:00	TLT	ETF	92.14	92.29	92.1	92.29	123600.0
2003-05-14 12:00:00	TLT	ETF	92.31	92.31	92.1	92.25	154700.0
2003-05-14 13:00:00	TLT	ETF	92.35	92.7	92.25	92.7	100400.0
2003-05-14 14:00:00	TLT	ETF	92.82	92.98	92.55	92.55	346000.0
2003-05-14 15:00:00	TLT	ETF	92.5	92.87	92.5	92.77	167200.0

> showing 50 of 392 rows — these rows as CSV

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