PREVIEW / etf_30min / 2001-01-16

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-01-16.parquet
  size:    12 KB
  rows:    317

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
2001-01-16 09:30:00	SPY	ETF	132.0	132.25	131.5312	131.9062	924900.0
2001-01-16 10:00:00	SPY	ETF	131.9688	132.4688	131.875	132.0625	425500.0
2001-01-16 10:30:00	SPY	ETF	132.0	132.125	131.6875	131.9375	303400.0
2001-01-16 11:00:00	SPY	ETF	131.9375	132.25	131.8125	132.0625	271200.0
2001-01-16 11:30:00	SPY	ETF	132.0625	132.2188	131.75	131.9375	182400.0
2001-01-16 12:00:00	SPY	ETF	131.875	132.1562	131.6562	131.8125	165000.0
2001-01-16 12:30:00	SPY	ETF	131.7188	131.9062	131.5	131.6875	222400.0
2001-01-16 13:00:00	SPY	ETF	131.6875	132.1562	131.6875	132.0	253500.0
2001-01-16 13:30:00	SPY	ETF	132.0938	132.5938	132.0938	132.375	1291800.0
2001-01-16 14:00:00	SPY	ETF	132.4688	132.625	132.25	132.3125	98600.0
2001-01-16 14:30:00	SPY	ETF	132.4062	132.5938	132.0312	132.0625	574900.0
2001-01-16 15:00:00	SPY	ETF	132.0625	132.6562	131.9062	132.4688	745300.0
2001-01-16 15:30:00	SPY	ETF	132.375	133.1875	132.375	132.5625	1855000.0
2001-01-16 16:00:00	SPY	ETF	132.6875	132.8438	132.25	132.625	774300.0
2001-01-16 16:30:00	SPY	ETF	132.625	132.8438	132.625	132.8438	4200.0
2001-01-16 17:00:00	SPY	ETF	133.5	133.5	133.5	133.5	200.0
2001-01-16 17:30:00	SPY	ETF	132.9375	132.9375	132.9375	132.9375	500.0
2001-01-16 09:30:00	QQQ	ETF	62.5625	62.9062	61.625	61.8125	5460400.0
2001-01-16 10:00:00	QQQ	ETF	61.8125	62.375	61.5312	61.5312	2584000.0
2001-01-16 10:30:00	QQQ	ETF	61.6875	61.7188	60.8125	61.25	3532100.0
2001-01-16 11:00:00	QQQ	ETF	61.25	61.625	61.0625	61.375	1787500.0
2001-01-16 11:30:00	QQQ	ETF	61.375	61.5938	60.9688	61.25	1282800.0
2001-01-16 12:00:00	QQQ	ETF	61.1875	61.375	60.75	61.0	1181000.0
2001-01-16 12:30:00	QQQ	ETF	60.9375	61.1562	60.5625	60.75	817500.0
2001-01-16 13:00:00	QQQ	ETF	60.6875	61.3125	60.6875	61.25	1379500.0
2001-01-16 13:30:00	QQQ	ETF	61.25	61.75	61.1875	61.5312	2358800.0
2001-01-16 14:00:00	QQQ	ETF	61.5	61.75	61.0	61.125	1569800.0
2001-01-16 14:30:00	QQQ	ETF	61.125	61.4688	60.875	60.875	1309100.0
2001-01-16 15:00:00	QQQ	ETF	60.9688	61.5938	60.75	61.4062	1913100.0
2001-01-16 15:30:00	QQQ	ETF	61.4375	62.0	61.25	61.5	3428100.0
2001-01-16 16:00:00	QQQ	ETF	61.5625	62.5	61.0	62.5	1274700.0
2001-01-16 16:30:00	QQQ	ETF	62.5	62.9375	61.9688	62.125	445700.0
2001-01-16 17:00:00	QQQ	ETF	62.3125	62.875	62.25	62.625	310900.0
2001-01-16 17:30:00	QQQ	ETF	62.7188	63.4688	62.7188	63.25	132200.0
2001-01-16 18:00:00	QQQ	ETF	63.4062	63.5625	63.0	63.375	63100.0
2001-01-16 09:30:00	IWM	ETF	48.25	48.3438	48.0625	48.1875	46400.0
2001-01-16 10:00:00	IWM	ETF	48.3438	48.3438	48.1406	48.1562	13200.0
2001-01-16 10:30:00	IWM	ETF	48.3281	48.3281	48.0312	48.1875	25800.0
2001-01-16 11:00:00	IWM	ETF	48.1875	48.1875	48.1875	48.1875	6000.0
2001-01-16 11:30:00	IWM	ETF	48.3125	48.3438	48.3125	48.3438	10400.0
2001-01-16 12:00:00	IWM	ETF	48.3438	48.4062	48.3438	48.4062	6200.0
2001-01-16 12:30:00	IWM	ETF	48.25	48.5312	48.25	48.5312	17200.0
2001-01-16 13:00:00	IWM	ETF	48.3438	48.7188	48.3438	48.7188	51400.0
2001-01-16 13:30:00	IWM	ETF	48.875	49.0156	48.875	49.0	25400.0
2001-01-16 14:00:00	IWM	ETF	49.0312	49.0625	48.8125	48.875	37400.0
2001-01-16 14:30:00	IWM	ETF	48.8125	48.9375	48.7188	48.7188	38600.0
2001-01-16 15:00:00	IWM	ETF	48.6875	49.0	48.6875	48.8125	86400.0
2001-01-16 15:30:00	IWM	ETF	48.9688	49.25	48.9688	49.25	37400.0
2001-01-16 16:00:00	IWM	ETF	49.3125	49.3438	49.3125	49.3438	10600.0
2001-01-16 09:30:00	DIA	ETF	105.25	105.2812	104.8438	105.0938	88200.0

> showing 50 of 317 rows — these rows as CSV

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