PREVIEW / etf_1hour / 2003-07-07

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-07-07.parquet
  size:    17 KB
  rows:    439

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-07-07 08:00:00	SPY	ETF	99.65	99.66	99.35	99.62	111200.0
2003-07-07 09:00:00	SPY	ETF	99.62	100.45	99.53	100.33	5180300.0
2003-07-07 10:00:00	SPY	ETF	100.38	100.84	100.24	100.62	6319600.0
2003-07-07 11:00:00	SPY	ETF	100.68	100.89	100.48	100.58	3350500.0
2003-07-07 12:00:00	SPY	ETF	100.58	100.78	100.5	100.55	1280500.0
2003-07-07 13:00:00	SPY	ETF	100.54	100.65	100.41	100.59	1966600.0
2003-07-07 14:00:00	SPY	ETF	100.59	100.9	100.58	100.8	3621600.0
2003-07-07 15:00:00	SPY	ETF	100.8	100.84	100.42	100.74	3269900.0
2003-07-07 16:00:00	SPY	ETF	100.74	101.0	100.66	100.7	1751400.0
2003-07-07 17:00:00	SPY	ETF	100.68	100.75	100.62	100.68	63000.0
2003-07-07 18:00:00	SPY	ETF	100.72	100.72	100.63	100.67	12400.0
2003-07-07 19:00:00	SPY	ETF	100.69	100.69	100.67	100.67	3500.0
2003-07-07 08:00:00	QQQ	ETF	30.98	30.99	30.89	30.97	142000.0
2003-07-07 09:00:00	QQQ	ETF	30.98	31.39	30.95	31.344	17160900.0
2003-07-07 10:00:00	QQQ	ETF	31.36	31.57	31.27	31.55	17054800.0
2003-07-07 11:00:00	QQQ	ETF	31.56	31.69	31.5	31.61	10765500.0
2003-07-07 12:00:00	QQQ	ETF	31.61	31.74	31.6	31.654	5709200.0
2003-07-07 13:00:00	QQQ	ETF	31.66	31.71	31.58	31.67	5337800.0
2003-07-07 14:00:00	QQQ	ETF	31.67	31.88	31.66	31.85	10671000.0
2003-07-07 15:00:00	QQQ	ETF	31.84	31.87	31.666	31.839	11390300.0
2003-07-07 16:00:00	QQQ	ETF	31.84	32.0	31.82	31.9	2953700.0
2003-07-07 17:00:00	QQQ	ETF	31.91	31.93	31.88	31.92	155900.0
2003-07-07 18:00:00	QQQ	ETF	31.92	31.93	31.9	31.91	63300.0
2003-07-07 19:00:00	QQQ	ETF	31.92	31.94	31.9	31.93	34200.0
2003-07-07 08:00:00	IWM	ETF	45.745	45.745	45.745	45.745	600.0
2003-07-07 09:00:00	IWM	ETF	45.935	46.23	45.925	46.23	519000.0
2003-07-07 10:00:00	IWM	ETF	46.2	46.385	46.135	46.315	399000.0
2003-07-07 11:00:00	IWM	ETF	46.32	46.38	46.265	46.295	634200.0
2003-07-07 12:00:00	IWM	ETF	46.295	46.325	46.225	46.24	286400.0
2003-07-07 13:00:00	IWM	ETF	46.245	46.275	46.185	46.24	222800.0
2003-07-07 14:00:00	IWM	ETF	46.225	46.38	46.225	46.335	218000.0
2003-07-07 15:00:00	IWM	ETF	46.33	46.46	46.26	46.415	564800.0
2003-07-07 16:00:00	IWM	ETF	46.435	46.495	46.395	46.495	606600.0
2003-07-07 08:00:00	DIA	ETF	91.55	91.6	91.43	91.53	2300.0
2003-07-07 09:00:00	DIA	ETF	91.51	92.36	91.51	92.27	1077300.0
2003-07-07 10:00:00	DIA	ETF	92.26	92.8	92.2	92.56	2907200.0
2003-07-07 11:00:00	DIA	ETF	92.55	92.67	92.28	92.43	467000.0
2003-07-07 12:00:00	DIA	ETF	92.43	92.54	92.3	92.35	230200.0
2003-07-07 13:00:00	DIA	ETF	92.31	92.39	92.2	92.34	372300.0
2003-07-07 14:00:00	DIA	ETF	92.33	92.54	92.27	92.41	486500.0
2003-07-07 15:00:00	DIA	ETF	92.42	92.48	92.06	92.36	638400.0
2003-07-07 16:00:00	DIA	ETF	92.35	92.44	92.3	92.36	168400.0
2003-07-07 17:00:00	DIA	ETF	92.38	92.38	92.24	92.38	400.0
2003-07-07 18:00:00	DIA	ETF	92.45	92.45	92.4	92.41	1700.0
2003-07-07 09:00:00	TLT	ETF	90.28	90.49	90.28	90.45	107700.0
2003-07-07 10:00:00	TLT	ETF	90.45	90.59	90.3	90.39	90900.0
2003-07-07 11:00:00	TLT	ETF	90.43	90.43	90.11	90.11	72500.0
2003-07-07 12:00:00	TLT	ETF	90.12	90.25	90.07	90.07	52700.0
2003-07-07 13:00:00	TLT	ETF	90.07	90.25	90.07	90.24	31100.0
2003-07-07 14:00:00	TLT	ETF	90.23	90.32	90.02	90.15	19700.0

> showing 50 of 439 rows — these rows as CSV

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