PREVIEW / etf_1hour / 2003-06-24

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-06-24.parquet
  size:    17 KB
  rows:    413

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-06-24 08:00:00	SPY	ETF	98.38	98.63	98.38	98.49	28400.0
2003-06-24 09:00:00	SPY	ETF	98.5	98.87	98.02	98.81	8469400.0
2003-06-24 10:00:00	SPY	ETF	98.79	99.09	98.1	98.39	8427500.0
2003-06-24 11:00:00	SPY	ETF	98.4	98.53	98.14	98.44	2339900.0
2003-06-24 12:00:00	SPY	ETF	98.43	98.75	98.31	98.72	2509500.0
2003-06-24 13:00:00	SPY	ETF	98.72	98.94	98.55	98.93	2888200.0
2003-06-24 14:00:00	SPY	ETF	98.94	99.06	98.599	98.7	3657300.0
2003-06-24 15:00:00	SPY	ETF	98.7	99.01	98.56	98.65	3890900.0
2003-06-24 16:00:00	SPY	ETF	98.65	98.68	98.48	98.6	1092300.0
2003-06-24 17:00:00	SPY	ETF	98.63	98.63	98.6	98.6	5300.0
2003-06-24 18:00:00	SPY	ETF	98.63	98.63	98.6	98.6	1600.0
2003-06-24 19:00:00	SPY	ETF	98.59	98.63	98.58	98.58	17000.0
2003-06-24 08:00:00	QQQ	ETF	29.8	29.91	29.8	29.85	101400.0
2003-06-24 09:00:00	QQQ	ETF	29.86	30.04	29.68	29.951	10724300.0
2003-06-24 10:00:00	QQQ	ETF	29.95	30.1	29.53	29.64	18780400.0
2003-06-24 11:00:00	QQQ	ETF	29.65	29.7	29.54	29.62	7229400.0
2003-06-24 12:00:00	QQQ	ETF	29.616	29.84	29.56	29.811	6475200.0
2003-06-24 13:00:00	QQQ	ETF	29.81	29.978	29.74	29.95	8161300.0
2003-06-24 14:00:00	QQQ	ETF	29.96	30.001	29.62	29.69	9780900.0
2003-06-24 15:00:00	QQQ	ETF	29.682	29.86	29.62	29.71	10426600.0
2003-06-24 16:00:00	QQQ	ETF	29.7	29.73	29.61	29.69	2276400.0
2003-06-24 17:00:00	QQQ	ETF	29.69	29.71	29.673	29.71	50000.0
2003-06-24 18:00:00	QQQ	ETF	29.72	29.74	29.69	29.71	15700.0
2003-06-24 19:00:00	QQQ	ETF	29.71	29.73	29.7	29.72	17000.0
2003-06-24 09:00:00	IWM	ETF	43.71	44.075	43.71	44.025	420800.0
2003-06-24 10:00:00	IWM	ETF	44.025	44.1155	43.49	43.57	994800.0
2003-06-24 11:00:00	IWM	ETF	43.58	43.675	43.55	43.655	179600.0
2003-06-24 12:00:00	IWM	ETF	43.64	43.83	43.64	43.825	227400.0
2003-06-24 13:00:00	IWM	ETF	43.835	44.015	43.8	44.015	293800.0
2003-06-24 14:00:00	IWM	ETF	44.02	44.115	43.875	43.95	599200.0
2003-06-24 15:00:00	IWM	ETF	43.945	44.015	43.78	43.925	346800.0
2003-06-24 16:00:00	IWM	ETF	43.945	43.945	43.825	43.94	161800.0
2003-06-24 08:00:00	DIA	ETF	91.04	91.04	91.04	91.04	500.0
2003-06-24 09:00:00	DIA	ETF	90.91	91.38	90.61	91.32	1415400.0
2003-06-24 10:00:00	DIA	ETF	91.29	91.56	90.82	91.06	2927800.0
2003-06-24 11:00:00	DIA	ETF	91.06	91.2	90.88	91.1	548600.0
2003-06-24 12:00:00	DIA	ETF	91.09	91.34	90.99	91.29	679100.0
2003-06-24 13:00:00	DIA	ETF	91.28	91.39	91.1	91.39	506800.0
2003-06-24 14:00:00	DIA	ETF	91.39	91.52	91.14	91.25	703200.0
2003-06-24 15:00:00	DIA	ETF	91.28	91.48	91.16	91.25	922500.0
2003-06-24 16:00:00	DIA	ETF	91.25	91.3	91.15	91.22	386200.0
2003-06-24 17:00:00	DIA	ETF	91.24	91.24	91.24	91.24	800.0
2003-06-24 19:00:00	DIA	ETF	91.24	91.25	91.22	91.22	1500.0
2003-06-24 09:00:00	TLT	ETF	94.15	94.3	94.07	94.13	22300.0
2003-06-24 10:00:00	TLT	ETF	94.14	94.41	94.01	94.41	19100.0
2003-06-24 11:00:00	TLT	ETF	94.42	94.51	94.4	94.41	23800.0
2003-06-24 12:00:00	TLT	ETF	94.42	94.67	94.42	94.53	35200.0
2003-06-24 13:00:00	TLT	ETF	94.5	94.55	94.5	94.54	9500.0
2003-06-24 14:00:00	TLT	ETF	94.5	94.87	94.5	94.87	104300.0
2003-06-24 15:00:00	TLT	ETF	94.93	95.18	94.84	95.08	40300.0

> showing 50 of 413 rows — these rows as CSV

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