PREVIEW / etf_30min / 2000-08-28

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-08-28.parquet
  size:    11 KB
  rows:    273

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-08-28 09:30:00	SPY	ETF	151.25	151.625	151.25	151.4062	731100.0
2000-08-28 10:00:00	SPY	ETF	151.5312	152.2188	151.4062	152.1562	904700.0
2000-08-28 10:30:00	SPY	ETF	152.1562	152.5	152.1562	152.4688	877000.0
2000-08-28 11:00:00	SPY	ETF	152.4375	152.8438	152.2188	152.75	455900.0
2000-08-28 11:30:00	SPY	ETF	152.6875	152.875	152.5625	152.75	354600.0
2000-08-28 12:00:00	SPY	ETF	152.75	152.9062	152.5938	152.6875	104200.0
2000-08-28 12:30:00	SPY	ETF	152.6875	152.875	152.625	152.8125	87300.0
2000-08-28 13:00:00	SPY	ETF	152.8125	152.8125	152.5625	152.75	72600.0
2000-08-28 13:30:00	SPY	ETF	152.7188	152.75	152.375	152.625	116300.0
2000-08-28 14:00:00	SPY	ETF	152.5312	152.8125	152.5312	152.75	223600.0
2000-08-28 14:30:00	SPY	ETF	152.6562	152.6875	152.3125	152.375	332700.0
2000-08-28 15:00:00	SPY	ETF	152.4688	152.4688	152.0	152.1875	364800.0
2000-08-28 15:30:00	SPY	ETF	152.25	152.4062	151.7812	151.7812	398200.0
2000-08-28 16:00:00	SPY	ETF	151.8125	152.1562	151.75	151.75	440900.0
2000-08-28 09:30:00	QQQ	ETF	98.25	98.5938	97.9375	98.0625	1341100.0
2000-08-28 10:00:00	QQQ	ETF	98.0312	99.4688	98.0312	99.375	1918900.0
2000-08-28 10:30:00	QQQ	ETF	99.4688	99.5	99.0625	99.3125	1386800.0
2000-08-28 11:00:00	QQQ	ETF	99.3125	99.5625	99.125	99.4688	922500.0
2000-08-28 11:30:00	QQQ	ETF	99.375	99.4688	99.125	99.375	632300.0
2000-08-28 12:00:00	QQQ	ETF	99.3125	99.5	99.1875	99.375	543300.0
2000-08-28 12:30:00	QQQ	ETF	99.375	99.4688	99.125	99.1875	530400.0
2000-08-28 13:00:00	QQQ	ETF	99.1875	99.3125	98.875	99.2188	496900.0
2000-08-28 13:30:00	QQQ	ETF	99.25	99.25	98.8125	99.1875	793500.0
2000-08-28 14:00:00	QQQ	ETF	99.1875	99.3438	99.0	99.1875	354300.0
2000-08-28 14:30:00	QQQ	ETF	99.125	99.3125	98.75	99.0	640900.0
2000-08-28 15:00:00	QQQ	ETF	98.9375	99.0312	98.375	98.9375	1184100.0
2000-08-28 15:30:00	QQQ	ETF	98.9375	99.2188	98.625	98.6875	1100700.0
2000-08-28 16:00:00	QQQ	ETF	98.7188	98.7188	98.4375	98.5625	311100.0
2000-08-28 16:30:00	QQQ	ETF	98.4375	98.4375	98.3125	98.3125	1500.0
2000-08-28 17:00:00	QQQ	ETF	98.5	98.5	98.5	98.5	100.0
2000-08-28 17:30:00	QQQ	ETF	98.3125	98.3125	98.3125	98.3125	500.0
2000-08-28 18:00:00	QQQ	ETF	98.5	98.5	98.5	98.5	300.0
2000-08-28 09:30:00	IWM	ETF	52.8125	52.8438	52.8125	52.8281	34600.0
2000-08-28 10:00:00	IWM	ETF	52.9062	52.9062	52.9062	52.9062	400.0
2000-08-28 10:30:00	IWM	ETF	53.125	53.125	52.9062	53.0312	2200.0
2000-08-28 11:00:00	IWM	ETF	52.875	52.9062	52.875	52.9062	400.0
2000-08-28 11:30:00	IWM	ETF	52.875	52.875	52.875	52.875	200.0
2000-08-28 12:00:00	IWM	ETF	53.0	53.0	53.0	53.0	200.0
2000-08-28 13:00:00	IWM	ETF	52.9688	52.9688	52.8594	52.875	10600.0
2000-08-28 13:30:00	IWM	ETF	52.8594	52.8594	52.6875	52.6875	600.0
2000-08-28 14:00:00	IWM	ETF	52.7969	52.7969	52.7969	52.7969	200.0
2000-08-28 14:30:00	IWM	ETF	52.8281	52.8281	52.6719	52.6719	1200.0
2000-08-28 15:00:00	IWM	ETF	52.7969	52.8125	52.6875	52.8125	38600.0
2000-08-28 15:30:00	IWM	ETF	52.7812	52.7969	52.6094	52.7969	2600.0
2000-08-28 16:00:00	IWM	ETF	52.6562	52.6562	52.5625	52.5625	50200.0
2000-08-28 09:30:00	DIA	ETF	112.2188	112.4375	112.0625	112.375	139000.0
2000-08-28 10:00:00	DIA	ETF	112.3438	112.9375	112.3125	112.8438	100900.0
2000-08-28 10:30:00	DIA	ETF	112.9375	113.1875	112.7812	112.875	35800.0
2000-08-28 11:00:00	DIA	ETF	112.875	113.2188	112.875	113.2188	34800.0
2000-08-28 11:30:00	DIA	ETF	113.125	113.2188	113.0312	113.1562	23200.0

> showing 50 of 273 rows — these rows as CSV

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