PREVIEW / etf_30min / 2000-10-16

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-10-16.parquet
  size:    11 KB
  rows:    297

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
2000-10-16 09:30:00	SPY	ETF	137.4062	138.0938	137.1562	137.9375	1207300.0
2000-10-16 10:00:00	SPY	ETF	137.8438	138.2188	137.5312	137.9688	271300.0
2000-10-16 10:30:00	SPY	ETF	137.9688	138.1562	137.125	137.3125	291300.0
2000-10-16 11:00:00	SPY	ETF	137.375	137.4688	137.0312	137.4688	660200.0
2000-10-16 11:30:00	SPY	ETF	137.4688	137.5625	136.6875	136.8125	326700.0
2000-10-16 12:00:00	SPY	ETF	136.875	137.2812	136.6875	137.125	155600.0
2000-10-16 12:30:00	SPY	ETF	137.1562	137.5312	136.875	137.5	163700.0
2000-10-16 13:00:00	SPY	ETF	137.5	137.5	136.9688	137.1875	221000.0
2000-10-16 13:30:00	SPY	ETF	137.375	137.7188	137.1562	137.375	169300.0
2000-10-16 14:00:00	SPY	ETF	137.375	137.9375	137.375	137.875	182000.0
2000-10-16 14:30:00	SPY	ETF	137.875	138.2188	137.7188	138.0625	755300.0
2000-10-16 15:00:00	SPY	ETF	138.0	138.0	137.4688	137.8438	188300.0
2000-10-16 15:30:00	SPY	ETF	138.0	138.0938	137.2812	137.4688	432600.0
2000-10-16 16:00:00	SPY	ETF	137.4688	138.1875	137.4375	138.1875	456300.0
2000-10-16 16:30:00	SPY	ETF	138.1875	138.1875	138.1875	138.1875	400.0
2000-10-16 09:30:00	QQQ	ETF	81.125	82.3125	80.375	81.8125	4751900.0
2000-10-16 10:00:00	QQQ	ETF	81.875	82.0	80.8125	81.5312	3061400.0
2000-10-16 10:30:00	QQQ	ETF	81.5625	81.875	80.4375	80.75	1971800.0
2000-10-16 11:00:00	QQQ	ETF	80.7188	80.75	80.0	80.5625	2748500.0
2000-10-16 11:30:00	QQQ	ETF	80.5	80.8125	79.75	80.0625	1752400.0
2000-10-16 12:00:00	QQQ	ETF	80.125	80.9375	79.875	80.4375	1182400.0
2000-10-16 12:30:00	QQQ	ETF	80.4375	80.9375	80.125	80.9375	939900.0
2000-10-16 13:00:00	QQQ	ETF	80.9375	80.9688	80.2812	80.625	810600.0
2000-10-16 13:30:00	QQQ	ETF	80.625	81.0	80.3438	80.5312	886000.0
2000-10-16 14:00:00	QQQ	ETF	80.4688	81.875	80.4062	81.625	2036100.0
2000-10-16 14:30:00	QQQ	ETF	81.8438	82.25	81.25	81.5625	1952700.0
2000-10-16 15:00:00	QQQ	ETF	81.5625	81.6562	80.5625	81.1875	2497900.0
2000-10-16 15:30:00	QQQ	ETF	81.4688	81.6875	80.75	80.875	1751500.0
2000-10-16 16:00:00	QQQ	ETF	81.0	82.0	80.875	81.875	513200.0
2000-10-16 16:30:00	QQQ	ETF	81.5	81.75	81.125	81.5625	66100.0
2000-10-16 17:00:00	QQQ	ETF	81.5625	82.0	81.5625	82.0	11500.0
2000-10-16 17:30:00	QQQ	ETF	81.875	82.25	81.875	82.0	16400.0
2000-10-16 18:00:00	QQQ	ETF	82.0	82.25	82.0	82.25	15300.0
2000-10-16 09:30:00	IWM	ETF	48.0	48.0312	47.7188	48.0312	22600.0
2000-10-16 10:00:00	IWM	ETF	48.2188	48.2812	48.0625	48.2812	11200.0
2000-10-16 10:30:00	IWM	ETF	48.375	48.5156	48.375	48.4375	604200.0
2000-10-16 11:00:00	IWM	ETF	48.0938	48.25	48.0938	48.25	15200.0
2000-10-16 11:30:00	IWM	ETF	48.1562	48.2031	48.1562	48.1875	3200.0
2000-10-16 12:00:00	IWM	ETF	48.0938	48.2188	48.0625	48.1562	14800.0
2000-10-16 12:30:00	IWM	ETF	48.2188	48.3438	48.2188	48.3438	6200.0
2000-10-16 13:30:00	IWM	ETF	48.2812	48.4375	48.2812	48.4062	29400.0
2000-10-16 14:00:00	IWM	ETF	48.3438	48.5312	48.3438	48.4844	178800.0
2000-10-16 14:30:00	IWM	ETF	48.4219	48.4688	48.4219	48.4688	5200.0
2000-10-16 15:00:00	IWM	ETF	48.4375	48.4375	48.4375	48.4375	3600.0
2000-10-16 15:30:00	IWM	ETF	48.5156	48.5156	48.1875	48.1875	203200.0
2000-10-16 16:00:00	IWM	ETF	48.125	48.125	48.125	48.125	400.0
2000-10-16 09:30:00	DIA	ETF	102.2188	102.75	102.0625	102.5625	87300.0
2000-10-16 10:00:00	DIA	ETF	102.5312	102.75	102.4375	102.5625	78100.0
2000-10-16 10:30:00	DIA	ETF	102.5625	102.5938	102.125	102.25	33400.0
2000-10-16 11:00:00	DIA	ETF	102.25	102.375	102.125	102.2188	21400.0

> showing 50 of 297 rows — these rows as CSV

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