PREVIEW / etf_1hour / 2003-04-28

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-04-28.parquet
  size:    16 KB
  rows:    394

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-04-28 08:00:00	SPY	ETF	90.49	90.66	90.49	90.58	66700.0
2003-04-28 09:00:00	SPY	ETF	90.55	90.9	90.3	90.9	5714700.0
2003-04-28 10:00:00	SPY	ETF	90.9	91.76	90.83	91.71	9724100.0
2003-04-28 11:00:00	SPY	ETF	91.71	91.98	91.6	91.68	5788400.0
2003-04-28 12:00:00	SPY	ETF	91.65	91.79	91.5	91.75	3343800.0
2003-04-28 13:00:00	SPY	ETF	91.76	91.8	91.39	91.66	3181800.0
2003-04-28 14:00:00	SPY	ETF	91.68	92.09	91.64	92.03	4828000.0
2003-04-28 15:00:00	SPY	ETF	92.0	92.19	91.62	91.86	7267100.0
2003-04-28 16:00:00	SPY	ETF	91.86	91.97	91.74	91.77	2279600.0
2003-04-28 17:00:00	SPY	ETF	91.75	91.81	91.72	91.81	8600.0
2003-04-28 18:00:00	SPY	ETF	91.81	91.85	91.72	91.72	28600.0
2003-04-28 19:00:00	SPY	ETF	91.77	91.8	91.77	91.8	1700.0
2003-04-28 08:00:00	QQQ	ETF	27.1	27.12	27.02	27.1	68900.0
2003-04-28 09:00:00	QQQ	ETF	27.08	27.25	26.95	27.22	8801700.0
2003-04-28 10:00:00	QQQ	ETF	27.22	27.48	27.15	27.46	13631100.0
2003-04-28 11:00:00	QQQ	ETF	27.46	27.56	27.43	27.5	8582100.0
2003-04-28 12:00:00	QQQ	ETF	27.48	27.5	27.4	27.47	4533700.0
2003-04-28 13:00:00	QQQ	ETF	27.48	27.52	27.37	27.47	3686900.0
2003-04-28 14:00:00	QQQ	ETF	27.47	27.62	27.44	27.54	5229400.0
2003-04-28 15:00:00	QQQ	ETF	27.54	27.63	27.47	27.52	7991700.0
2003-04-28 16:00:00	QQQ	ETF	27.52	27.55	27.44	27.44	2128100.0
2003-04-28 17:00:00	QQQ	ETF	27.44	27.48	27.42	27.46	196400.0
2003-04-28 18:00:00	QQQ	ETF	27.46	27.48	27.43	27.48	12700.0
2003-04-28 19:00:00	QQQ	ETF	27.45	27.49	27.44	27.47	17100.0
2003-04-28 09:00:00	IWM	ETF	38.9	38.99	38.78	38.99	381600.0
2003-04-28 10:00:00	IWM	ETF	38.995	39.34	38.995	39.315	297400.0
2003-04-28 11:00:00	IWM	ETF	39.34	39.395	39.25	39.27	118600.0
2003-04-28 12:00:00	IWM	ETF	39.255	39.28	39.2	39.28	49600.0
2003-04-28 13:00:00	IWM	ETF	39.275	39.295	39.175	39.255	177800.0
2003-04-28 14:00:00	IWM	ETF	39.25	39.375	39.245	39.325	221400.0
2003-04-28 15:00:00	IWM	ETF	39.365	39.46	39.285	39.38	367600.0
2003-04-28 16:00:00	IWM	ETF	39.395	39.395	39.3	39.39	111200.0
2003-04-28 08:00:00	DIA	ETF	83.36	83.52	83.36	83.47	3000.0
2003-04-28 09:00:00	DIA	ETF	83.5	83.77	83.19	83.75	749000.0
2003-04-28 10:00:00	DIA	ETF	83.72	84.62	83.72	84.61	1810600.0
2003-04-28 11:00:00	DIA	ETF	84.62	84.83	84.48	84.54	1092000.0
2003-04-28 12:00:00	DIA	ETF	84.57	84.73	84.44	84.69	641200.0
2003-04-28 13:00:00	DIA	ETF	84.7	84.75	84.41	84.69	460000.0
2003-04-28 14:00:00	DIA	ETF	84.67	85.0	84.59	84.9	684200.0
2003-04-28 15:00:00	DIA	ETF	84.9	85.15	84.7	84.81	1105400.0
2003-04-28 16:00:00	DIA	ETF	84.83	84.86	84.75	84.8	111400.0
2003-04-28 17:00:00	DIA	ETF	84.79	84.81	84.75	84.81	2800.0
2003-04-28 18:00:00	DIA	ETF	84.75	84.75	84.75	84.75	500.0
2003-04-28 19:00:00	DIA	ETF	84.7	84.8	84.7	84.8	1200.0
2003-04-28 09:00:00	TLT	ETF	89.09	89.09	89.08	89.08	4100.0
2003-04-28 10:00:00	TLT	ETF	88.96	89.0	88.96	88.98	2500.0
2003-04-28 11:00:00	TLT	ETF	88.78	88.97	88.78	88.97	3900.0
2003-04-28 12:00:00	TLT	ETF	88.86	88.98	88.86	88.98	3500.0
2003-04-28 13:00:00	TLT	ETF	88.89	89.09	88.89	89.01	4600.0
2003-04-28 14:00:00	TLT	ETF	89.0	89.0	88.82	88.89	55400.0

> showing 50 of 394 rows — these rows as CSV

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