PREVIEW / etf_30min / 2000-06-26

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-06-26.parquet
  size:    10 KB
  rows:    239

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-06-26 09:30:00	SPY	ETF	145.375	145.6875	144.875	145.6875	1809400.0
2000-06-26 10:00:00	SPY	ETF	145.5938	146.0	145.25	145.8438	383200.0
2000-06-26 10:30:00	SPY	ETF	145.9688	146.125	145.6875	145.9062	148400.0
2000-06-26 11:00:00	SPY	ETF	145.875	146.25	145.6562	146.0	92600.0
2000-06-26 11:30:00	SPY	ETF	145.9062	146.0938	145.625	145.7812	79600.0
2000-06-26 12:00:00	SPY	ETF	145.6875	145.7812	145.3125	145.5	112100.0
2000-06-26 12:30:00	SPY	ETF	145.5	145.75	145.3438	145.3438	358200.0
2000-06-26 13:00:00	SPY	ETF	145.375	145.75	145.375	145.4688	59000.0
2000-06-26 13:30:00	SPY	ETF	145.4688	145.4688	145.0625	145.375	101600.0
2000-06-26 14:00:00	SPY	ETF	145.25	145.4062	144.9062	145.25	162400.0
2000-06-26 14:30:00	SPY	ETF	145.25	145.5625	145.2188	145.4062	212200.0
2000-06-26 15:00:00	SPY	ETF	145.5	145.5	145.0312	145.4375	464900.0
2000-06-26 15:30:00	SPY	ETF	145.5	145.8125	145.3438	145.75	686600.0
2000-06-26 16:00:00	SPY	ETF	145.625	146.2188	145.4375	146.2188	416900.0
2000-06-26 17:00:00	SPY	ETF	146.2188	146.2188	146.2188	146.2188	39700.0
2000-06-26 09:30:00	QQQ	ETF	93.0625	93.4375	92.0	93.1875	5936900.0
2000-06-26 10:00:00	QQQ	ETF	93.0	93.4375	92.25	93.3125	2432300.0
2000-06-26 10:30:00	QQQ	ETF	93.375	93.9375	93.125	93.5	1620100.0
2000-06-26 11:00:00	QQQ	ETF	93.5625	94.4062	93.375	94.0625	1775700.0
2000-06-26 11:30:00	QQQ	ETF	94.125	94.25	93.5	93.5312	1107500.0
2000-06-26 12:00:00	QQQ	ETF	93.5	93.5938	92.5	93.1562	1127100.0
2000-06-26 12:30:00	QQQ	ETF	93.125	93.1875	92.75	92.8125	457100.0
2000-06-26 13:00:00	QQQ	ETF	92.9688	93.4062	92.875	93.0625	676300.0
2000-06-26 13:30:00	QQQ	ETF	93.0	93.0312	92.4688	92.6875	496900.0
2000-06-26 14:00:00	QQQ	ETF	92.6875	92.875	92.25	92.75	582200.0
2000-06-26 14:30:00	QQQ	ETF	92.8125	93.5	92.75	93.25	2043000.0
2000-06-26 15:00:00	QQQ	ETF	93.25	93.5	92.875	93.5	1146400.0
2000-06-26 15:30:00	QQQ	ETF	93.5	94.0625	93.3125	93.9375	1915100.0
2000-06-26 16:00:00	QQQ	ETF	93.9375	94.25	93.0	94.1875	819900.0
2000-06-26 16:30:00	QQQ	ETF	94.125	94.375	94.125	94.375	6300.0
2000-06-26 17:00:00	QQQ	ETF	94.0	94.0	94.0	94.0	100.0
2000-06-26 18:00:00	QQQ	ETF	94.0	94.0	94.0	94.0	500.0
2000-06-26 09:30:00	IWM	ETF	51.1094	51.2188	51.1094	51.2031	13200.0
2000-06-26 10:00:00	IWM	ETF	51.25	51.2969	51.25	51.2969	4400.0
2000-06-26 10:30:00	IWM	ETF	51.2969	51.2969	51.1406	51.25	10400.0
2000-06-26 11:00:00	IWM	ETF	51.125	51.125	51.125	51.125	1000.0
2000-06-26 11:30:00	IWM	ETF	51.0625	51.0625	51.0625	51.0625	5000.0
2000-06-26 12:00:00	IWM	ETF	50.9375	50.9375	50.9375	50.9375	3000.0
2000-06-26 12:30:00	IWM	ETF	50.9375	50.9375	50.9375	50.9375	200.0
2000-06-26 13:00:00	IWM	ETF	50.9844	50.9844	50.9844	50.9844	1000.0
2000-06-26 13:30:00	IWM	ETF	51.0781	51.0781	51.0781	51.0781	1000.0
2000-06-26 14:00:00	IWM	ETF	50.875	50.875	50.875	50.875	8000.0
2000-06-26 15:00:00	IWM	ETF	51.0469	51.0469	51.0469	51.0469	1000.0
2000-06-26 15:30:00	IWM	ETF	51.125	51.3125	51.0938	51.3125	30400.0
2000-06-26 16:00:00	IWM	ETF	51.5312	51.5312	51.5312	51.5312	15000.0
2000-06-26 09:30:00	DIA	ETF	104.9375	105.5938	104.7188	105.5	82700.0
2000-06-26 10:00:00	DIA	ETF	105.5938	105.7188	105.3125	105.625	149700.0
2000-06-26 10:30:00	DIA	ETF	105.625	105.8438	105.4375	105.5	225500.0
2000-06-26 11:00:00	DIA	ETF	105.5938	105.8125	105.375	105.625	37200.0
2000-06-26 11:30:00	DIA	ETF	105.5625	105.6875	105.4375	105.4688	79800.0

> showing 50 of 239 rows — these rows as CSV

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