PREVIEW / etf_30min / 2000-07-27

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-07-27.parquet
  size:    10 KB
  rows:    233

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-27 09:30:00	SPY	ETF	145.9375	146.625	145.625	146.3438	2023300.0
2000-07-27 10:00:00	SPY	ETF	146.2188	146.2812	144.6875	145.25	617900.0
2000-07-27 10:30:00	SPY	ETF	145.125	145.375	144.8125	145.2812	850100.0
2000-07-27 11:00:00	SPY	ETF	145.4375	145.625	145.1562	145.4688	204900.0
2000-07-27 11:30:00	SPY	ETF	145.3125	145.4062	145.0625	145.1562	170900.0
2000-07-27 12:00:00	SPY	ETF	145.125	145.5	145.0	145.5	120100.0
2000-07-27 12:30:00	SPY	ETF	145.375	145.6562	145.3125	145.4375	260300.0
2000-07-27 13:00:00	SPY	ETF	145.4062	145.7812	145.3125	145.625	181100.0
2000-07-27 13:30:00	SPY	ETF	145.5938	145.75	145.0625	145.1875	197200.0
2000-07-27 14:00:00	SPY	ETF	145.125	145.5	144.8125	145.3438	413300.0
2000-07-27 14:30:00	SPY	ETF	145.3438	145.7188	145.0312	145.625	155100.0
2000-07-27 15:00:00	SPY	ETF	145.75	146.125	145.4062	145.9688	790700.0
2000-07-27 15:30:00	SPY	ETF	145.9688	146.375	145.2188	145.5	815200.0
2000-07-27 16:00:00	SPY	ETF	145.2188	145.4375	145.125	145.375	594000.0
2000-07-27 09:30:00	QQQ	ETF	93.9375	95.0625	93.5625	94.125	3873200.0
2000-07-27 10:00:00	QQQ	ETF	94.125	94.375	92.375	93.0	3291100.0
2000-07-27 10:30:00	QQQ	ETF	93.0	93.125	92.0	92.8438	2214800.0
2000-07-27 11:00:00	QQQ	ETF	92.875	93.375	92.75	93.0625	1298000.0
2000-07-27 11:30:00	QQQ	ETF	93.0625	93.125	92.5	92.6875	706400.0
2000-07-27 12:00:00	QQQ	ETF	92.8438	92.9375	92.1875	92.875	1376100.0
2000-07-27 12:30:00	QQQ	ETF	92.875	93.4375	92.75	93.0938	2052800.0
2000-07-27 13:00:00	QQQ	ETF	93.0625	93.1875	92.625	92.8125	694800.0
2000-07-27 13:30:00	QQQ	ETF	92.875	93.125	92.375	92.375	860600.0
2000-07-27 14:00:00	QQQ	ETF	92.4062	92.75	92.0	92.25	944100.0
2000-07-27 14:30:00	QQQ	ETF	92.25	92.75	91.625	92.6875	1853000.0
2000-07-27 15:00:00	QQQ	ETF	92.625	93.1875	92.375	93.0	2259800.0
2000-07-27 15:30:00	QQQ	ETF	92.9688	93.875	91.875	91.9688	3349900.0
2000-07-27 16:00:00	QQQ	ETF	91.875	92.375	91.5625	91.75	1265100.0
2000-07-27 16:30:00	QQQ	ETF	91.625	91.75	91.5625	91.75	2700.0
2000-07-27 17:00:00	QQQ	ETF	91.75	91.75	91.625	91.625	4700.0
2000-07-27 17:30:00	QQQ	ETF	91.875	91.875	91.75	91.875	2800.0
2000-07-27 18:00:00	QQQ	ETF	91.875	91.875	91.875	91.875	600.0
2000-07-27 09:30:00	IWM	ETF	51.1719	51.1719	50.8906	50.8906	20400.0
2000-07-27 10:00:00	IWM	ETF	50.9375	50.9375	50.5625	50.5625	3400.0
2000-07-27 10:30:00	IWM	ETF	50.7031	50.7031	50.3438	50.3438	62400.0
2000-07-27 11:00:00	IWM	ETF	50.4375	50.4531	50.4219	50.4531	3200.0
2000-07-27 11:30:00	IWM	ETF	50.3125	50.3125	50.3125	50.3125	1000.0
2000-07-27 12:30:00	IWM	ETF	50.4375	50.4375	50.3125	50.3125	1400.0
2000-07-27 13:30:00	IWM	ETF	50.3594	50.3906	50.3438	50.3906	34200.0
2000-07-27 14:00:00	IWM	ETF	50.3125	50.3125	50.2656	50.2656	2200.0
2000-07-27 14:30:00	IWM	ETF	50.2812	50.3125	50.2812	50.3125	3400.0
2000-07-27 15:00:00	IWM	ETF	50.3281	50.4375	50.2188	50.3438	113400.0
2000-07-27 15:30:00	IWM	ETF	50.4844	50.5625	50.0	50.0	17200.0
2000-07-27 16:00:00	IWM	ETF	49.9062	50.0	49.875	49.875	12800.0
2000-07-27 09:30:00	DIA	ETF	105.5625	106.4688	105.5625	106.0938	97500.0
2000-07-27 10:00:00	DIA	ETF	105.9688	106.125	105.1562	105.75	247200.0
2000-07-27 10:30:00	DIA	ETF	105.7812	105.7812	105.4062	105.6875	15700.0
2000-07-27 11:00:00	DIA	ETF	105.7812	105.7812	105.5	105.625	58100.0
2000-07-27 11:30:00	DIA	ETF	105.75	105.75	105.3125	105.5	132600.0
2000-07-27 12:00:00	DIA	ETF	105.625	105.7188	105.4062	105.5938	14300.0

> showing 50 of 233 rows — these rows as CSV

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