PREVIEW / etf_30min / 2000-07-14

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-07-14.parquet
  size:    10 KB
  rows:    259

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-07-14 09:30:00	SPY	ETF	150.4375	150.7188	150.1875	150.25	925500.0
2000-07-14 10:00:00	SPY	ETF	150.1875	150.1875	149.6562	150.0	538400.0
2000-07-14 10:30:00	SPY	ETF	150.0312	150.3438	149.875	150.0938	345000.0
2000-07-14 11:00:00	SPY	ETF	150.25	150.6875	150.0312	150.625	319600.0
2000-07-14 11:30:00	SPY	ETF	150.8125	150.8125	150.2812	150.5938	726600.0
2000-07-14 12:00:00	SPY	ETF	150.5938	150.625	150.2812	150.2812	178500.0
2000-07-14 12:30:00	SPY	ETF	150.2812	150.7188	150.2812	150.5	289000.0
2000-07-14 13:00:00	SPY	ETF	150.4062	150.5312	150.2812	150.5	186200.0
2000-07-14 13:30:00	SPY	ETF	150.5	150.6875	150.3438	150.625	387600.0
2000-07-14 14:00:00	SPY	ETF	150.5	150.7812	150.5	150.7188	64400.0
2000-07-14 14:30:00	SPY	ETF	150.7812	151.0938	150.625	151.0938	156000.0
2000-07-14 15:00:00	SPY	ETF	151.125	151.25	150.5	150.8125	397600.0
2000-07-14 15:30:00	SPY	ETF	150.6562	151.25	150.6562	150.875	378700.0
2000-07-14 16:00:00	SPY	ETF	150.9375	151.25	150.7812	151.25	234500.0
2000-07-14 16:30:00	SPY	ETF	151.25	151.25	151.25	151.25	1500.0
2000-07-14 09:30:00	QQQ	ETF	100.25	100.375	99.375	99.625	3975600.0
2000-07-14 10:00:00	QQQ	ETF	99.625	99.6875	98.8125	99.25	2126100.0
2000-07-14 10:30:00	QQQ	ETF	99.375	99.7812	99.1875	99.5	1368400.0
2000-07-14 11:00:00	QQQ	ETF	99.4375	100.125	99.375	100.0	1225300.0
2000-07-14 11:30:00	QQQ	ETF	100.125	100.2812	99.5625	100.0	1163800.0
2000-07-14 12:00:00	QQQ	ETF	100.0625	100.125	99.75	99.75	429400.0
2000-07-14 12:30:00	QQQ	ETF	99.7812	100.625	99.75	100.0625	673900.0
2000-07-14 13:00:00	QQQ	ETF	100.0625	100.1875	99.875	100.0312	463900.0
2000-07-14 13:30:00	QQQ	ETF	100.0312	100.3125	99.9375	100.0625	818500.0
2000-07-14 14:00:00	QQQ	ETF	100.125	100.4062	100.0312	100.25	347900.0
2000-07-14 14:30:00	QQQ	ETF	100.25	100.9375	100.25	100.9375	1247700.0
2000-07-14 15:00:00	QQQ	ETF	100.9062	101.125	100.0	100.375	1304700.0
2000-07-14 15:30:00	QQQ	ETF	100.3125	100.875	100.25	100.8438	1574500.0
2000-07-14 16:00:00	QQQ	ETF	100.8125	100.8438	100.5	100.625	463000.0
2000-07-14 16:30:00	QQQ	ETF	100.75	100.75	100.4375	100.5625	500.0
2000-07-14 17:00:00	QQQ	ETF	100.5625	100.5625	100.5625	100.5625	200.0
2000-07-14 17:30:00	QQQ	ETF	100.1875	100.1875	100.1875	100.1875	200.0
2000-07-14 18:00:00	QQQ	ETF	100.625	100.625	100.625	100.625	300.0
2000-07-14 09:30:00	IWM	ETF	54.5469	54.5469	54.4062	54.4062	18200.0
2000-07-14 10:00:00	IWM	ETF	54.0312	54.0469	53.875	53.9844	15200.0
2000-07-14 10:30:00	IWM	ETF	54.0469	54.125	53.9688	54.125	1400.0
2000-07-14 11:30:00	IWM	ETF	54.1875	54.2812	54.1875	54.2812	4400.0
2000-07-14 12:00:00	IWM	ETF	54.2031	54.2031	54.2031	54.2031	200.0
2000-07-14 12:30:00	IWM	ETF	54.2031	54.2812	54.2031	54.2812	1400.0
2000-07-14 13:00:00	IWM	ETF	54.2031	54.2031	54.1875	54.1875	1400.0
2000-07-14 13:30:00	IWM	ETF	54.1094	54.1406	54.1094	54.1406	800.0
2000-07-14 14:30:00	IWM	ETF	54.2031	54.2031	54.1719	54.1719	600.0
2000-07-14 15:00:00	IWM	ETF	54.1875	54.1875	54.1875	54.1875	600.0
2000-07-14 15:30:00	IWM	ETF	54.3125	54.3125	54.3125	54.3125	10600.0
2000-07-14 09:30:00	DIA	ETF	108.1875	108.3125	107.7188	107.75	131600.0
2000-07-14 10:00:00	DIA	ETF	107.7812	108.0	107.625	107.9688	77600.0
2000-07-14 10:30:00	DIA	ETF	107.8125	108.0625	107.7188	107.7188	53300.0
2000-07-14 11:00:00	DIA	ETF	107.75	108.2188	107.75	107.9375	6300.0
2000-07-14 11:30:00	DIA	ETF	108.0	108.0625	107.75	108.0	2600.0
2000-07-14 12:00:00	DIA	ETF	107.8438	108.0	107.75	107.9688	12600.0

> showing 50 of 259 rows — these rows as CSV

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