PREVIEW / etf_30min / 2000-09-18

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-09-18.parquet
  size:    11 KB
  rows:    277

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-18 09:30:00	SPY	ETF	146.375	146.8125	146.2812	146.6875	512400.0
2000-09-18 10:00:00	SPY	ETF	146.5625	146.9062	146.375	146.6562	190500.0
2000-09-18 10:30:00	SPY	ETF	146.8125	146.9688	146.5	146.5	183400.0
2000-09-18 11:00:00	SPY	ETF	146.5	146.5	145.8125	145.9062	215500.0
2000-09-18 11:30:00	SPY	ETF	145.875	146.0	145.4688	145.6875	352700.0
2000-09-18 12:00:00	SPY	ETF	145.6875	145.75	145.25	145.3438	378900.0
2000-09-18 12:30:00	SPY	ETF	145.3125	145.625	145.25	145.25	121400.0
2000-09-18 13:00:00	SPY	ETF	145.25	145.4062	144.5938	144.5938	507500.0
2000-09-18 13:30:00	SPY	ETF	144.5938	145.25	144.5	145.2188	453600.0
2000-09-18 14:00:00	SPY	ETF	145.25	145.375	144.6875	144.75	554100.0
2000-09-18 14:30:00	SPY	ETF	144.7188	145.5625	144.6875	145.5	308000.0
2000-09-18 15:00:00	SPY	ETF	145.375	145.625	144.5312	144.5625	265000.0
2000-09-18 15:30:00	SPY	ETF	144.5	144.8438	144.1875	144.6875	491500.0
2000-09-18 16:00:00	SPY	ETF	144.8125	144.9375	144.5625	144.6562	201200.0
2000-09-18 09:30:00	QQQ	ETF	91.8125	93.0	91.25	92.0625	3179600.0
2000-09-18 10:00:00	QQQ	ETF	92.0312	92.9375	91.75	92.625	1756500.0
2000-09-18 10:30:00	QQQ	ETF	92.6562	92.9375	92.125	92.125	986400.0
2000-09-18 11:00:00	QQQ	ETF	92.125	92.2188	91.25	91.375	2182800.0
2000-09-18 11:30:00	QQQ	ETF	91.3125	91.4375	90.375	90.625	2365300.0
2000-09-18 12:00:00	QQQ	ETF	90.6875	91.125	89.5	89.9688	3261200.0
2000-09-18 12:30:00	QQQ	ETF	89.9375	90.25	89.25	89.25	1787000.0
2000-09-18 13:00:00	QQQ	ETF	89.375	89.625	88.625	88.625	2286900.0
2000-09-18 13:30:00	QQQ	ETF	88.6875	89.75	88.5	89.6875	1997300.0
2000-09-18 14:00:00	QQQ	ETF	89.8438	90.0625	89.0625	89.125	1767800.0
2000-09-18 14:30:00	QQQ	ETF	89.2188	90.6875	89.0	90.6875	1385300.0
2000-09-18 15:00:00	QQQ	ETF	90.6562	90.8125	89.0625	89.375	2858800.0
2000-09-18 15:30:00	QQQ	ETF	89.375	89.6875	88.8125	89.5	2523800.0
2000-09-18 16:00:00	QQQ	ETF	89.5	90.125	89.375	90.125	632300.0
2000-09-18 16:30:00	QQQ	ETF	89.8125	89.9688	89.5	89.875	3400.0
2000-09-18 17:00:00	QQQ	ETF	89.875	90.125	89.875	89.875	1800.0
2000-09-18 17:30:00	QQQ	ETF	89.875	89.9062	89.875	89.875	1000.0
2000-09-18 18:00:00	QQQ	ETF	89.875	89.875	89.875	89.875	500.0
2000-09-18 09:30:00	IWM	ETF	53.1406	53.1406	52.9062	52.9062	2600.0
2000-09-18 10:00:00	IWM	ETF	52.8438	52.9062	52.8438	52.9062	2000.0
2000-09-18 10:30:00	IWM	ETF	53.0	53.0	52.9062	52.9062	22400.0
2000-09-18 11:00:00	IWM	ETF	52.5	52.5	52.5	52.5	400.0
2000-09-18 11:30:00	IWM	ETF	52.5	52.5	52.25	52.375	4600.0
2000-09-18 12:00:00	IWM	ETF	52.1562	52.1562	51.8438	52.0625	32000.0
2000-09-18 12:30:00	IWM	ETF	52.0312	52.0312	52.0312	52.0312	3000.0
2000-09-18 13:00:00	IWM	ETF	51.9531	51.9688	51.8125	51.8125	4800.0
2000-09-18 13:30:00	IWM	ETF	51.875	51.875	51.875	51.875	200.0
2000-09-18 14:00:00	IWM	ETF	51.875	51.875	51.875	51.875	200.0
2000-09-18 14:30:00	IWM	ETF	51.75	51.9375	51.6875	51.9375	5600.0
2000-09-18 15:00:00	IWM	ETF	52.0781	52.0938	51.9219	51.9219	2000.0
2000-09-18 15:30:00	IWM	ETF	51.6875	51.6875	51.5156	51.6562	4200.0
2000-09-18 16:00:00	IWM	ETF	51.8125	51.8125	51.6562	51.6562	117400.0
2000-09-18 09:30:00	DIA	ETF	109.4375	109.4688	108.875	109.0312	144700.0
2000-09-18 10:00:00	DIA	ETF	108.9062	109.0938	108.8125	108.8438	38700.0
2000-09-18 10:30:00	DIA	ETF	108.8438	109.0312	108.7812	108.7812	15200.0
2000-09-18 11:00:00	DIA	ETF	108.75	108.75	108.4375	108.4688	63400.0

> showing 50 of 277 rows — these rows as CSV

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