PREVIEW / etf_30min / 2000-07-20

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-07-20.parquet
  size:    10 KB
  rows:    254

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-20 09:30:00	SPY	ETF	149.0	149.2812	148.8125	149.0312	512000.0
2000-07-20 10:00:00	SPY	ETF	148.9062	150.25	148.9062	150.0	853000.0
2000-07-20 10:30:00	SPY	ETF	150.0	150.5	150.0	150.2188	688800.0
2000-07-20 11:00:00	SPY	ETF	150.25	150.4375	149.8125	149.9062	313900.0
2000-07-20 11:30:00	SPY	ETF	149.9375	150.125	149.625	149.8438	195600.0
2000-07-20 12:00:00	SPY	ETF	149.875	149.9375	149.75	149.7812	48400.0
2000-07-20 12:30:00	SPY	ETF	149.875	150.0938	149.8125	150.0	264100.0
2000-07-20 13:00:00	SPY	ETF	149.875	149.9688	149.4062	149.5625	118700.0
2000-07-20 13:30:00	SPY	ETF	149.4375	149.75	149.4375	149.7188	60200.0
2000-07-20 14:00:00	SPY	ETF	149.7188	150.125	149.625	149.9688	130300.0
2000-07-20 14:30:00	SPY	ETF	149.8125	150.125	149.75	150.0312	269100.0
2000-07-20 15:00:00	SPY	ETF	149.9688	150.0625	149.5625	149.75	222900.0
2000-07-20 15:30:00	SPY	ETF	149.75	150.125	149.625	149.8125	336500.0
2000-07-20 16:00:00	SPY	ETF	149.7188	150.625	149.7188	150.5625	523700.0
2000-07-20 16:30:00	SPY	ETF	150.625	150.625	150.625	150.625	500.0
2000-07-20 09:30:00	QQQ	ETF	97.875	98.25	97.2812	97.3125	3352800.0
2000-07-20 10:00:00	QQQ	ETF	97.3125	99.4375	97.25	99.25	4383300.0
2000-07-20 10:30:00	QQQ	ETF	99.25	99.75	99.125	99.5	1890000.0
2000-07-20 11:00:00	QQQ	ETF	99.5	99.75	99.125	99.1875	1284800.0
2000-07-20 11:30:00	QQQ	ETF	99.25	99.375	98.9375	99.0312	673500.0
2000-07-20 12:00:00	QQQ	ETF	99.0	99.375	99.0	99.125	396700.0
2000-07-20 12:30:00	QQQ	ETF	99.125	99.5	99.125	99.1875	476800.0
2000-07-20 13:00:00	QQQ	ETF	99.1875	99.4375	99.0	99.0625	631000.0
2000-07-20 13:30:00	QQQ	ETF	99.0312	99.3125	99.0	99.1875	514200.0
2000-07-20 14:00:00	QQQ	ETF	99.1875	99.75	99.125	99.625	838300.0
2000-07-20 14:30:00	QQQ	ETF	99.625	99.875	99.375	99.625	1137500.0
2000-07-20 15:00:00	QQQ	ETF	99.6875	99.8438	99.25	99.5	1383800.0
2000-07-20 15:30:00	QQQ	ETF	99.5	99.75	99.25	99.5	1791000.0
2000-07-20 16:00:00	QQQ	ETF	99.5625	100.375	99.5625	100.375	618800.0
2000-07-20 16:30:00	QQQ	ETF	100.5	100.5	97.9375	97.9375	14800.0
2000-07-20 17:00:00	QQQ	ETF	97.5312	100.375	97.5312	100.375	24100.0
2000-07-20 09:30:00	IWM	ETF	53.125	53.125	53.125	53.125	1000.0
2000-07-20 10:00:00	IWM	ETF	53.2188	53.375	53.2188	53.375	2400.0
2000-07-20 10:30:00	IWM	ETF	53.4375	53.4375	53.4219	53.4219	14200.0
2000-07-20 11:30:00	IWM	ETF	53.375	53.375	53.375	53.375	11400.0
2000-07-20 12:00:00	IWM	ETF	53.375	53.375	53.375	53.375	200.0
2000-07-20 12:30:00	IWM	ETF	53.25	53.25	53.25	53.25	600.0
2000-07-20 13:30:00	IWM	ETF	53.375	53.375	53.375	53.375	3000.0
2000-07-20 14:30:00	IWM	ETF	53.3594	53.3594	53.3594	53.3594	100400.0
2000-07-20 15:30:00	IWM	ETF	53.3281	53.4688	53.3281	53.4688	17000.0
2000-07-20 16:00:00	IWM	ETF	53.5	53.5	53.5	53.5	200.0
2000-07-20 09:30:00	DIA	ETF	107.8125	108.1875	107.8125	107.8125	169800.0
2000-07-20 10:00:00	DIA	ETF	108.0	108.6875	108.0	108.4688	189600.0
2000-07-20 10:30:00	DIA	ETF	108.4375	108.7188	108.25	108.5938	68900.0
2000-07-20 11:00:00	DIA	ETF	108.5	108.6875	108.3125	108.3125	9300.0
2000-07-20 11:30:00	DIA	ETF	108.4375	108.5	108.2188	108.375	12500.0
2000-07-20 12:00:00	DIA	ETF	108.4062	108.5	108.375	108.375	5700.0
2000-07-20 12:30:00	DIA	ETF	108.375	108.5	108.375	108.375	13700.0
2000-07-20 13:00:00	DIA	ETF	108.375	108.5	108.375	108.375	6100.0
2000-07-20 13:30:00	DIA	ETF	108.375	108.5	108.2188	108.4375	3300.0

> showing 50 of 254 rows — these rows as CSV

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