PREVIEW / etf_30min / 2000-09-06

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-09-06.parquet
  size:    11 KB
  rows:    291

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-09-06 09:30:00	SPY	ETF	151.1875	151.7812	151.125	151.625	674800.0
2000-09-06 10:00:00	SPY	ETF	151.5625	151.7188	151.0938	151.2812	347100.0
2000-09-06 10:30:00	SPY	ETF	151.2812	151.4688	151.0	151.125	203400.0
2000-09-06 11:00:00	SPY	ETF	151.125	151.125	150.625	150.625	207300.0
2000-09-06 11:30:00	SPY	ETF	150.6875	151.0938	150.6562	151.0625	163700.0
2000-09-06 12:00:00	SPY	ETF	151.0938	151.125	150.875	150.875	87000.0
2000-09-06 12:30:00	SPY	ETF	151.0	151.3125	150.9688	151.1875	62000.0
2000-09-06 13:00:00	SPY	ETF	151.1875	151.25	150.5312	150.5312	100400.0
2000-09-06 13:30:00	SPY	ETF	150.5312	150.75	150.25	150.25	223500.0
2000-09-06 14:00:00	SPY	ETF	150.3125	150.75	150.25	150.5	186300.0
2000-09-06 14:30:00	SPY	ETF	150.5625	150.5625	150.0	150.2188	324600.0
2000-09-06 15:00:00	SPY	ETF	150.2188	150.2188	149.75	150.0625	431800.0
2000-09-06 15:30:00	SPY	ETF	150.0625	150.1875	149.6875	149.6875	744500.0
2000-09-06 16:00:00	SPY	ETF	149.5938	149.7812	149.5312	149.5625	441300.0
2000-09-06 09:30:00	QQQ	ETF	99.25	99.4688	98.5312	99.25	3079000.0
2000-09-06 10:00:00	QQQ	ETF	99.2812	99.4688	98.25	98.5	1967800.0
2000-09-06 10:30:00	QQQ	ETF	98.5	98.8438	98.0625	98.1562	1465000.0
2000-09-06 11:00:00	QQQ	ETF	98.1875	98.25	97.75	97.8125	1433200.0
2000-09-06 11:30:00	QQQ	ETF	97.8125	98.25	97.75	98.0	957300.0
2000-09-06 12:00:00	QQQ	ETF	98.0625	98.3125	97.8125	98.0625	859900.0
2000-09-06 12:30:00	QQQ	ETF	98.0625	98.75	98.0312	98.4375	605800.0
2000-09-06 13:00:00	QQQ	ETF	98.4375	98.4688	97.25	97.3438	1319700.0
2000-09-06 13:30:00	QQQ	ETF	97.25	97.6875	97.0	97.0312	1369500.0
2000-09-06 14:00:00	QQQ	ETF	97.0625	97.625	97.0	97.4062	916600.0
2000-09-06 14:30:00	QQQ	ETF	97.375	97.5	96.6875	96.9375	1286900.0
2000-09-06 15:00:00	QQQ	ETF	96.875	96.9375	96.0625	96.5312	2059900.0
2000-09-06 15:30:00	QQQ	ETF	96.5625	96.6875	95.75	95.875	2641700.0
2000-09-06 16:00:00	QQQ	ETF	95.9062	96.1562	95.75	96.0	782100.0
2000-09-06 16:30:00	QQQ	ETF	96.0	96.4375	95.75	95.75	5600.0
2000-09-06 17:00:00	QQQ	ETF	95.9375	96.0	95.75	95.8125	8800.0
2000-09-06 17:30:00	QQQ	ETF	95.9375	96.0	95.5	96.0	1700.0
2000-09-06 18:00:00	QQQ	ETF	96.0	96.0	96.0	96.0	400.0
2000-09-06 09:30:00	IWM	ETF	54.0625	54.0625	53.8438	53.8438	1800.0
2000-09-06 10:00:00	IWM	ETF	53.9375	53.9844	53.625	53.625	182200.0
2000-09-06 10:30:00	IWM	ETF	53.5938	53.7656	53.5938	53.7656	21000.0
2000-09-06 11:00:00	IWM	ETF	53.625	53.6562	53.5	53.5	3000.0
2000-09-06 12:00:00	IWM	ETF	53.625	53.6562	53.625	53.6562	1400.0
2000-09-06 12:30:00	IWM	ETF	53.8125	53.8125	53.8125	53.8125	1200.0
2000-09-06 13:30:00	IWM	ETF	53.625	53.625	53.625	53.625	400.0
2000-09-06 14:30:00	IWM	ETF	53.625	53.7656	53.5938	53.5938	600.0
2000-09-06 15:00:00	IWM	ETF	53.7812	53.7812	53.5469	53.5469	4200.0
2000-09-06 15:30:00	IWM	ETF	53.7812	53.7812	53.5781	53.5781	1400.0
2000-09-06 16:00:00	IWM	ETF	53.7656	53.7656	53.5781	53.5781	600.0
2000-09-06 09:30:00	DIA	ETF	113.0312	113.9062	113.0312	113.6875	53800.0
2000-09-06 10:00:00	DIA	ETF	113.75	113.875	113.3125	113.4688	45100.0
2000-09-06 10:30:00	DIA	ETF	113.5312	113.8438	113.5	113.5938	157200.0
2000-09-06 11:00:00	DIA	ETF	113.5938	113.6562	113.375	113.4062	25100.0
2000-09-06 11:30:00	DIA	ETF	113.4688	113.6875	113.4062	113.5	31400.0
2000-09-06 12:00:00	DIA	ETF	113.5938	113.8125	113.5625	113.75	12700.0
2000-09-06 12:30:00	DIA	ETF	113.7188	114.0938	113.6875	114.0625	100700.0

> showing 50 of 291 rows — these rows as CSV

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