PREVIEW / etf_1hour / 2003-10-28

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-10-28.parquet
  size:    18 KB
  rows:    457

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-10-28 08:00:00	SPY	ETF	103.91	104.11	103.91	104.04	106900.0
2003-10-28 09:00:00	SPY	ETF	104.03	104.15	103.82	104.14	2745000.0
2003-10-28 10:00:00	SPY	ETF	104.14	104.33	103.98	104.09	5452700.0
2003-10-28 11:00:00	SPY	ETF	104.09	104.16	103.93	104.03	3357200.0
2003-10-28 12:00:00	SPY	ETF	104.03	104.16	103.92	104.06	1300000.0
2003-10-28 13:00:00	SPY	ETF	104.07	104.19	103.98	104.15	1420900.0
2003-10-28 14:00:00	SPY	ETF	104.14	104.55	103.96	104.52	5856300.0
2003-10-28 15:00:00	SPY	ETF	104.52	105.069	104.44	105.02	7330200.0
2003-10-28 16:00:00	SPY	ETF	105.07	105.15	104.1978	104.84	2146100.0
2003-10-28 17:00:00	SPY	ETF	104.84	104.89	101.84	104.89	214300.0
2003-10-28 18:00:00	SPY	ETF	104.85	104.88	104.8	104.88	8200.0
2003-10-28 19:00:00	SPY	ETF	104.87	104.9	104.86	104.86	1400.0
2003-10-28 08:00:00	QQQ	ETF	34.38	34.45	34.38	34.43	168400.0
2003-10-28 09:00:00	QQQ	ETF	34.41	34.54	34.37	34.54	8224800.0
2003-10-28 10:00:00	QQQ	ETF	34.52	34.66	34.49	34.56	15966700.0
2003-10-28 11:00:00	QQQ	ETF	34.56	34.63	34.48	34.606	8358200.0
2003-10-28 12:00:00	QQQ	ETF	34.61	34.72	34.6	34.67	5523600.0
2003-10-28 13:00:00	QQQ	ETF	34.67	34.79	34.65	34.76	7297000.0
2003-10-28 14:00:00	QQQ	ETF	34.76	34.96	34.63	34.937	20217600.0
2003-10-28 15:00:00	QQQ	ETF	34.94	35.3	34.9	35.29	24310300.0
2003-10-28 16:00:00	QQQ	ETF	35.28	35.41	34.2565	35.315	8479400.0
2003-10-28 17:00:00	QQQ	ETF	35.3	35.32	35.25	35.26	248400.0
2003-10-28 18:00:00	QQQ	ETF	35.28	35.31	35.25	35.28	44800.0
2003-10-28 19:00:00	QQQ	ETF	35.28	35.3	35.25	35.3	32000.0
2003-10-28 08:00:00	IWM	ETF	51.425	51.625	51.125	51.625	2600.0
2003-10-28 09:00:00	IWM	ETF	51.63	51.825	51.53	51.825	483600.0
2003-10-28 10:00:00	IWM	ETF	51.825	51.945	51.69	51.845	1501600.0
2003-10-28 11:00:00	IWM	ETF	51.84	51.87	51.74	51.79	368200.0
2003-10-28 12:00:00	IWM	ETF	51.78	51.865	51.78	51.805	441200.0
2003-10-28 13:00:00	IWM	ETF	51.8	51.9	51.775	51.85	213400.0
2003-10-28 14:00:00	IWM	ETF	51.85	52.041	51.75	52.025	823200.0
2003-10-28 15:00:00	IWM	ETF	52.035	52.446	52.005	52.42	1681400.0
2003-10-28 16:00:00	IWM	ETF	52.455	52.603	52.4	52.545	783600.0
2003-10-28 08:00:00	DIA	ETF	96.58	96.65	96.58	96.62	18400.0
2003-10-28 09:00:00	DIA	ETF	96.58	96.72	96.43	96.7	416200.0
2003-10-28 10:00:00	DIA	ETF	96.7	96.876	96.65	96.75	968200.0
2003-10-28 11:00:00	DIA	ETF	96.76	96.88	96.63	96.76	436200.0
2003-10-28 12:00:00	DIA	ETF	96.78	96.9	96.73	96.88	226800.0
2003-10-28 13:00:00	DIA	ETF	96.88	96.98	96.78	96.97	240100.0
2003-10-28 14:00:00	DIA	ETF	96.94	97.23	96.71	97.17	1345700.0
2003-10-28 15:00:00	DIA	ETF	97.23	97.65	97.17	97.65	1165500.0
2003-10-28 16:00:00	DIA	ETF	97.639	97.73	97.5	97.52	121400.0
2003-10-28 17:00:00	DIA	ETF	97.59	97.59	97.46	97.46	900.0
2003-10-28 18:00:00	DIA	ETF	97.29	97.36	97.29	97.29	1000.0
2003-10-28 09:00:00	TLT	ETF	84.85	84.95	84.8	84.87	118800.0
2003-10-28 10:00:00	TLT	ETF	84.94	85.17	84.85	85.06	75200.0
2003-10-28 11:00:00	TLT	ETF	85.04	85.06	84.82	84.82	523300.0
2003-10-28 12:00:00	TLT	ETF	84.88	84.88	84.65	84.75	51300.0
2003-10-28 13:00:00	TLT	ETF	84.75	84.78	84.57	84.68	34300.0
2003-10-28 14:00:00	TLT	ETF	84.72	85.69	84.65	85.69	1179100.0

> showing 50 of 457 rows — these rows as CSV

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