PREVIEW / etf_1hour / 2003-05-09

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-05-09.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-09 08:00:00	SPY	ETF	92.84	92.92	92.8	92.86	20000.0
2003-05-09 09:00:00	SPY	ETF	92.8	93.1	92.75	92.97	4230800.0
2003-05-09 10:00:00	SPY	ETF	92.98	93.17	92.61	93.15	4493000.0
2003-05-09 11:00:00	SPY	ETF	93.14	93.39	93.1	93.29	5736300.0
2003-05-09 12:00:00	SPY	ETF	93.27	93.8	93.25	93.65	4583500.0
2003-05-09 13:00:00	SPY	ETF	93.64	93.74	93.57	93.65	1611500.0
2003-05-09 14:00:00	SPY	ETF	93.64	93.79	93.26	93.6	4055200.0
2003-05-09 15:00:00	SPY	ETF	93.6	93.78	93.39	93.71	3066500.0
2003-05-09 16:00:00	SPY	ETF	93.7	93.85	93.63	93.76	1334500.0
2003-05-09 17:00:00	SPY	ETF	93.76	93.82	93.7	93.7	21200.0
2003-05-09 18:00:00	SPY	ETF	93.7	93.75	93.67	93.75	14400.0
2003-05-09 19:00:00	SPY	ETF	93.67	93.75	93.6	93.75	12100.0
2003-05-09 08:00:00	QQQ	ETF	27.97	28.07	27.97	28.01	114900.0
2003-05-09 09:00:00	QQQ	ETF	28.01	28.23	28.0	28.15	8466900.0
2003-05-09 10:00:00	QQQ	ETF	28.16	28.22	27.99	28.21	8684000.0
2003-05-09 11:00:00	QQQ	ETF	28.18	28.29	28.13	28.25	9253100.0
2003-05-09 12:00:00	QQQ	ETF	28.26	28.48	28.23	28.4	8578500.0
2003-05-09 13:00:00	QQQ	ETF	28.4	28.42	28.31	28.37	2902200.0
2003-05-09 14:00:00	QQQ	ETF	28.37	28.44	28.2	28.36	5135600.0
2003-05-09 15:00:00	QQQ	ETF	28.35	28.44	28.26	28.41	6716800.0
2003-05-09 16:00:00	QQQ	ETF	28.42	28.43	28.35	28.39	1560800.0
2003-05-09 17:00:00	QQQ	ETF	28.39	28.43	28.38	28.43	60900.0
2003-05-09 18:00:00	QQQ	ETF	28.43	28.44	28.41	28.42	41000.0
2003-05-09 19:00:00	QQQ	ETF	28.42	28.44	28.4	28.42	19200.0
2003-05-09 09:00:00	IWM	ETF	40.86	40.94	40.795	40.89	446000.0
2003-05-09 10:00:00	IWM	ETF	40.88	40.905	40.775	40.9	295000.0
2003-05-09 11:00:00	IWM	ETF	40.91	41.01	40.905	41.01	183200.0
2003-05-09 12:00:00	IWM	ETF	41.0	41.22	41.0	41.175	162200.0
2003-05-09 13:00:00	IWM	ETF	41.155	41.18	41.125	41.15	42800.0
2003-05-09 14:00:00	IWM	ETF	41.145	41.195	41.075	41.125	292000.0
2003-05-09 15:00:00	IWM	ETF	41.125	41.24	41.075	41.21	423800.0
2003-05-09 16:00:00	IWM	ETF	41.195	41.22	41.18	41.19	118800.0
2003-05-09 08:00:00	DIA	ETF	85.4	85.46	85.35	85.36	5200.0
2003-05-09 09:00:00	DIA	ETF	85.35	85.61	85.27	85.46	1008100.0
2003-05-09 10:00:00	DIA	ETF	85.46	85.78	85.2	85.73	749500.0
2003-05-09 11:00:00	DIA	ETF	85.73	85.98	85.69	85.89	1191700.0
2003-05-09 12:00:00	DIA	ETF	85.9	86.29	85.9	86.15	1160500.0
2003-05-09 13:00:00	DIA	ETF	86.15	86.23	86.03	86.14	428900.0
2003-05-09 14:00:00	DIA	ETF	86.16	86.23	85.8	86.11	777300.0
2003-05-09 15:00:00	DIA	ETF	86.1	86.25	85.9	86.2	620200.0
2003-05-09 16:00:00	DIA	ETF	86.2	86.23	86.12	86.21	164800.0
2003-05-09 17:00:00	DIA	ETF	86.2	86.2	86.15	86.15	900.0
2003-05-09 18:00:00	DIA	ETF	86.15	86.2	86.15	86.17	800.0
2003-05-09 19:00:00	DIA	ETF	86.15	86.15	86.15	86.15	1000.0
2003-05-09 09:00:00	TLT	ETF	90.3	90.35	90.2	90.22	48700.0
2003-05-09 10:00:00	TLT	ETF	90.21	90.41	90.2	90.41	12100.0
2003-05-09 11:00:00	TLT	ETF	90.31	90.44	90.3	90.4	9000.0
2003-05-09 12:00:00	TLT	ETF	90.24	90.27	90.24	90.25	5300.0
2003-05-09 13:00:00	TLT	ETF	90.27	90.32	90.25	90.28	2600.0
2003-05-09 14:00:00	TLT	ETF	90.35	90.57	90.35	90.5	7500.0

> showing 50 of 392 rows — these rows as CSV

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