PREVIEW / etf_1hour / 2003-07-14

all etf 1-hour files

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

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-14 09:00:00	SPY	ETF	101.2	101.4	101.07	101.39	4023900.0
2003-07-14 10:00:00	SPY	ETF	101.37	101.88	101.32	101.83	7019400.0
2003-07-14 11:00:00	SPY	ETF	101.83	101.9	101.56	101.72	2347000.0
2003-07-14 12:00:00	SPY	ETF	101.74	101.8	101.37	101.55	2768700.0
2003-07-14 13:00:00	SPY	ETF	101.55	101.73	101.45	101.69	1689700.0
2003-07-14 14:00:00	SPY	ETF	101.7	101.8	101.43	101.52	3022100.0
2003-07-14 15:00:00	SPY	ETF	101.52	101.55	99.915	100.73	12449200.0
2003-07-14 16:00:00	SPY	ETF	100.72	101.4787	100.49	100.75	2114600.0
2003-07-14 17:00:00	SPY	ETF	100.75	100.83	100.7	100.71	32100.0
2003-07-14 18:00:00	SPY	ETF	100.72	100.8	100.72	100.8	19600.0
2003-07-14 19:00:00	SPY	ETF	100.78	100.78	100.74	100.78	13600.0
2003-07-14 09:00:00	QQQ	ETF	32.344	32.46	32.29	32.437	12995400.0
2003-07-14 10:00:00	QQQ	ETF	32.44	32.74	32.41	32.73	18768500.0
2003-07-14 11:00:00	QQQ	ETF	32.71	32.75	32.52	32.6	6303800.0
2003-07-14 12:00:00	QQQ	ETF	32.61	32.63	32.4	32.49	6024200.0
2003-07-14 13:00:00	QQQ	ETF	32.49	32.63	32.47	32.58	5139700.0
2003-07-14 14:00:00	QQQ	ETF	32.58	32.66	32.47	32.53	5699500.0
2003-07-14 15:00:00	QQQ	ETF	32.53	32.54	32.07	32.22	18865600.0
2003-07-14 16:00:00	QQQ	ETF	32.21	32.5166	32.15	32.29	2398400.0
2003-07-14 17:00:00	QQQ	ETF	32.29	32.31	32.28	32.28	43900.0
2003-07-14 18:00:00	QQQ	ETF	32.3	32.31	32.28	32.29	29500.0
2003-07-14 19:00:00	QQQ	ETF	32.32	32.32	32.27	32.31	17700.0
2003-07-14 09:00:00	IWM	ETF	47.735	47.9	47.3	47.775	636400.0
2003-07-14 10:00:00	IWM	ETF	47.795	48.15	47.775	48.01	809000.0
2003-07-14 11:00:00	IWM	ETF	48.01	48.05	47.89	47.97	189600.0
2003-07-14 12:00:00	IWM	ETF	47.98	47.98	47.765	47.795	750800.0
2003-07-14 13:00:00	IWM	ETF	47.815	47.9	47.795	47.87	182600.0
2003-07-14 14:00:00	IWM	ETF	47.91	48.0	47.845	47.9	520400.0
2003-07-14 15:00:00	IWM	ETF	47.9	48.0	47.6	47.74	1035400.0
2003-07-14 16:00:00	IWM	ETF	47.745	47.785	47.705	47.775	387600.0
2003-07-14 09:00:00	DIA	ETF	92.57	92.61	92.25	92.6	1410400.0
2003-07-14 10:00:00	DIA	ETF	92.589	92.94	92.571	92.9	773900.0
2003-07-14 11:00:00	DIA	ETF	92.77	93.0	92.65	92.76	522000.0
2003-07-14 12:00:00	DIA	ETF	92.8	92.85	92.52	92.67	359800.0
2003-07-14 13:00:00	DIA	ETF	92.67	92.8	92.57	92.8	370500.0
2003-07-14 14:00:00	DIA	ETF	92.8	92.85	92.5	92.61	375600.0
2003-07-14 15:00:00	DIA	ETF	92.6	92.65	91.599	91.89	1498900.0
2003-07-14 16:00:00	DIA	ETF	91.89	91.98	91.75	91.98	141400.0
2003-07-14 17:00:00	DIA	ETF	91.92	92.43	91.86	91.93	4400.0
2003-07-14 18:00:00	DIA	ETF	92.0	92.04	92.0	92.04	1100.0
2003-07-14 19:00:00	DIA	ETF	92.0	92.02	91.89	91.89	800.0
2003-07-14 09:00:00	TLT	ETF	90.68	90.68	90.57	90.63	39600.0
2003-07-14 10:00:00	TLT	ETF	90.62	90.87	90.62	90.63	24200.0
2003-07-14 11:00:00	TLT	ETF	90.63	90.73	90.46	90.52	46800.0
2003-07-14 12:00:00	TLT	ETF	90.39	90.55	90.39	90.54	17200.0
2003-07-14 13:00:00	TLT	ETF	90.5	90.55	90.09	90.09	115800.0
2003-07-14 14:00:00	TLT	ETF	90.1	90.18	89.63	89.65	116500.0
2003-07-14 15:00:00	TLT	ETF	89.75	89.89	89.67	89.75	79100.0
2003-07-14 16:00:00	TLT	ETF	89.75	89.75	89.75	89.75	3200.0

> showing 49 of 421 rows — these rows as CSV

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