PREVIEW / etf_1hour / 2003-03-27

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-03-27.parquet
  size:    16 KB
  rows:    367

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-03-27 08:00:00	SPY	ETF	86.44	86.54	86.3	86.35	95600.0
2003-03-27 09:00:00	SPY	ETF	86.38	86.59	86.11	86.13	7097700.0
2003-03-27 10:00:00	SPY	ETF	86.13	86.44	85.99	86.24	5527200.0
2003-03-27 11:00:00	SPY	ETF	86.24	86.7	86.15	86.51	3515000.0
2003-03-27 12:00:00	SPY	ETF	86.52	87.24	86.44	87.11	4871200.0
2003-03-27 13:00:00	SPY	ETF	87.16	87.33	86.9	87.3	3564600.0
2003-03-27 14:00:00	SPY	ETF	87.31	87.66	87.17	87.25	9465600.0
2003-03-27 15:00:00	SPY	ETF	87.25	87.57	86.85	87.1	6734100.0
2003-03-27 16:00:00	SPY	ETF	87.09	87.15	87.0	87.1	1885100.0
2003-03-27 17:00:00	SPY	ETF	87.09	87.17	87.08	87.17	172200.0
2003-03-27 18:00:00	SPY	ETF	87.17	87.17	87.11	87.12	5400.0
2003-03-27 19:00:00	SPY	ETF	87.13	87.13	87.09	87.09	1800.0
2003-03-27 08:00:00	QQQ	ETF	26.33	26.34	26.23	26.26	109700.0
2003-03-27 09:00:00	QQQ	ETF	26.28	26.35	26.16	26.17	9336800.0
2003-03-27 10:00:00	QQQ	ETF	26.17	26.24	26.1	26.18	11149800.0
2003-03-27 11:00:00	QQQ	ETF	26.18	26.33	26.15	26.24	6603300.0
2003-03-27 12:00:00	QQQ	ETF	26.25	26.51	26.2	26.46	9521800.0
2003-03-27 13:00:00	QQQ	ETF	26.46	26.52	26.34	26.51	5608400.0
2003-03-27 14:00:00	QQQ	ETF	26.51	26.64	26.44	26.51	8003100.0
2003-03-27 15:00:00	QQQ	ETF	26.49	26.62	26.34	26.38	7593200.0
2003-03-27 16:00:00	QQQ	ETF	26.38	26.43	26.32	26.36	1371600.0
2003-03-27 17:00:00	QQQ	ETF	26.36	26.37	26.3	26.37	28400.0
2003-03-27 18:00:00	QQQ	ETF	26.36	26.4	26.35	26.4	24300.0
2003-03-27 19:00:00	QQQ	ETF	26.38	26.41	26.37	26.39	8500.0
2003-03-27 09:00:00	IWM	ETF	36.35	36.525	36.3	36.375	211000.0
2003-03-27 10:00:00	IWM	ETF	36.36	36.435	36.3	36.36	219200.0
2003-03-27 11:00:00	IWM	ETF	36.36	36.48	36.33	36.475	120400.0
2003-03-27 12:00:00	IWM	ETF	36.485	36.675	36.44	36.66	125600.0
2003-03-27 13:00:00	IWM	ETF	36.625	36.74	36.625	36.725	45800.0
2003-03-27 14:00:00	IWM	ETF	36.735	36.87	36.725	36.795	217200.0
2003-03-27 15:00:00	IWM	ETF	36.735	36.82	36.675	36.765	161200.0
2003-03-27 16:00:00	IWM	ETF	36.795	36.815	36.705	36.705	7800.0
2003-03-27 08:00:00	DIA	ETF	81.65	81.8	81.5	81.65	10100.0
2003-03-27 09:00:00	DIA	ETF	81.64	81.72	81.29	81.29	1732000.0
2003-03-27 10:00:00	DIA	ETF	81.28	81.65	81.17	81.43	1478700.0
2003-03-27 11:00:00	DIA	ETF	81.46	81.8	81.39	81.62	775000.0
2003-03-27 12:00:00	DIA	ETF	81.62	82.24	81.59	82.16	1029700.0
2003-03-27 13:00:00	DIA	ETF	82.16	82.35	81.91	82.35	777700.0
2003-03-27 14:00:00	DIA	ETF	82.35	82.61	82.21	82.27	1280700.0
2003-03-27 15:00:00	DIA	ETF	82.25	82.56	81.94	82.09	1217700.0
2003-03-27 16:00:00	DIA	ETF	82.08	82.15	82.03	82.11	73000.0
2003-03-27 17:00:00	DIA	ETF	82.11	82.12	82.08	82.12	1800.0
2003-03-27 18:00:00	DIA	ETF	82.1	82.1	82.05	82.1	2600.0
2003-03-27 19:00:00	DIA	ETF	82.13	82.13	82.1	82.1	1400.0
2003-03-27 09:00:00	TLT	ETF	87.75	87.79	87.6	87.74	2800.0
2003-03-27 10:00:00	TLT	ETF	87.8	87.81	87.66	87.72	26000.0
2003-03-27 11:00:00	TLT	ETF	87.75	87.87	87.61	87.65	63900.0
2003-03-27 12:00:00	TLT	ETF	87.63	87.63	87.39	87.39	13800.0
2003-03-27 13:00:00	TLT	ETF	87.38	87.45	87.34	87.41	10100.0
2003-03-27 14:00:00	TLT	ETF	87.38	87.41	87.36	87.41	28800.0

> showing 50 of 367 rows — these rows as CSV

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