PREVIEW / etf_30min / 2000-11-02

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-11-02.parquet
  size:    12 KB
  rows:    300

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-11-02 09:30:00	SPY	ETF	143.1562	143.875	142.7188	143.625	949300.0
2000-11-02 10:00:00	SPY	ETF	143.5	143.75	143.0	143.25	583600.0
2000-11-02 10:30:00	SPY	ETF	143.125	143.5	142.875	143.0	471500.0
2000-11-02 11:00:00	SPY	ETF	143.1562	143.2188	142.5625	142.8125	269100.0
2000-11-02 11:30:00	SPY	ETF	142.625	143.1562	142.5	143.1562	110800.0
2000-11-02 12:00:00	SPY	ETF	143.0312	143.2188	142.9375	143.2188	164400.0
2000-11-02 12:30:00	SPY	ETF	143.0938	143.4062	143.0938	143.125	234600.0
2000-11-02 13:00:00	SPY	ETF	143.2188	143.25	142.7188	142.9062	149000.0
2000-11-02 13:30:00	SPY	ETF	142.7812	143.2188	142.6562	143.0	280400.0
2000-11-02 14:00:00	SPY	ETF	142.9375	143.4062	142.9375	143.3125	142200.0
2000-11-02 14:30:00	SPY	ETF	143.25	143.5	142.9062	143.1562	130100.0
2000-11-02 15:00:00	SPY	ETF	143.1875	143.4062	142.75	143.1875	225700.0
2000-11-02 15:30:00	SPY	ETF	143.3438	143.5	142.9688	143.0312	328300.0
2000-11-02 16:00:00	SPY	ETF	143.0938	143.1562	142.625	143.0938	7147600.0
2000-11-02 16:30:00	SPY	ETF	142.6875	142.6875	142.6875	142.6875	200.0
2000-11-02 17:00:00	SPY	ETF	142.8125	142.8125	142.8125	142.8125	100.0
2000-11-02 09:30:00	QQQ	ETF	82.1875	83.0	81.625	82.8438	5185900.0
2000-11-02 10:00:00	QQQ	ETF	82.8438	82.9062	82.25	82.8438	2046700.0
2000-11-02 10:30:00	QQQ	ETF	82.8438	83.25	82.125	82.125	1976200.0
2000-11-02 11:00:00	QQQ	ETF	82.125	82.4375	81.4375	81.625	3287100.0
2000-11-02 11:30:00	QQQ	ETF	81.5938	82.2188	81.25	82.0312	2268000.0
2000-11-02 12:00:00	QQQ	ETF	82.1875	82.9375	81.875	82.25	1056000.0
2000-11-02 12:30:00	QQQ	ETF	82.25	82.5	82.125	82.3125	1052200.0
2000-11-02 13:00:00	QQQ	ETF	82.25	82.2812	81.7812	81.875	945900.0
2000-11-02 13:30:00	QQQ	ETF	81.9375	82.375	81.7188	82.375	837100.0
2000-11-02 14:00:00	QQQ	ETF	82.375	82.5938	82.0312	82.5625	738600.0
2000-11-02 14:30:00	QQQ	ETF	82.5625	82.75	82.0625	82.3125	1631500.0
2000-11-02 15:00:00	QQQ	ETF	82.4375	82.5938	81.875	82.5	1513400.0
2000-11-02 15:30:00	QQQ	ETF	82.4688	82.875	82.1875	82.375	2211700.0
2000-11-02 16:00:00	QQQ	ETF	82.4375	82.5625	82.0	82.25	626900.0
2000-11-02 16:30:00	QQQ	ETF	82.25	82.5625	81.625	82.5	28100.0
2000-11-02 17:00:00	QQQ	ETF	82.5	82.6875	82.1562	82.1562	11100.0
2000-11-02 17:30:00	QQQ	ETF	82.5625	82.625	82.4375	82.625	5200.0
2000-11-02 18:00:00	QQQ	ETF	82.5312	82.5312	82.5	82.5312	700.0
2000-11-02 09:30:00	IWM	ETF	49.8906	50.2188	49.875	50.2188	5800.0
2000-11-02 10:00:00	IWM	ETF	50.0312	50.0312	50.0312	50.0312	1200.0
2000-11-02 10:30:00	IWM	ETF	50.0156	50.2188	50.0	50.0	23000.0
2000-11-02 11:00:00	IWM	ETF	50.1562	50.1562	49.9688	50.1406	26200.0
2000-11-02 11:30:00	IWM	ETF	50.0625	50.0625	50.0625	50.0625	2000.0
2000-11-02 12:00:00	IWM	ETF	50.25	50.25	50.25	50.25	10000.0
2000-11-02 12:30:00	IWM	ETF	50.25	50.5	50.25	50.5	45800.0
2000-11-02 13:00:00	IWM	ETF	50.4844	50.4844	50.4844	50.4844	800.0
2000-11-02 13:30:00	IWM	ETF	50.4688	50.4688	50.4688	50.4688	2000.0
2000-11-02 14:00:00	IWM	ETF	50.4844	50.5	50.4844	50.5	5000.0
2000-11-02 14:30:00	IWM	ETF	50.625	50.6875	50.5625	50.5625	28000.0
2000-11-02 15:00:00	IWM	ETF	50.5781	50.6562	50.5	50.6562	22200.0
2000-11-02 15:30:00	IWM	ETF	50.6562	50.8125	50.6562	50.8125	26600.0
2000-11-02 16:00:00	IWM	ETF	50.6875	50.7188	50.625	50.7188	12400.0
2000-11-02 09:30:00	DIA	ETF	109.2188	109.625	108.875	109.5625	367300.0
2000-11-02 10:00:00	DIA	ETF	109.4375	109.625	108.9062	109.125	106300.0

> showing 50 of 300 rows — these rows as CSV

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