PREVIEW / etf_30min / 2000-09-20

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-09-20.parquet
  size:    11 KB
  rows:    280

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-09-20 09:30:00	SPY	ETF	145.6875	146.0312	144.6875	144.875	515200.0
2000-09-20 10:00:00	SPY	ETF	145.0	145.3438	144.625	145.2188	206500.0
2000-09-20 10:30:00	SPY	ETF	145.1562	145.1875	144.25	144.5625	216800.0
2000-09-20 11:00:00	SPY	ETF	144.625	144.8125	144.0	144.25	389100.0
2000-09-20 11:30:00	SPY	ETF	144.125	144.6562	144.0938	144.4062	182400.0
2000-09-20 12:00:00	SPY	ETF	144.375	144.5	144.125	144.1562	84600.0
2000-09-20 12:30:00	SPY	ETF	144.25	144.25	143.6562	144.0312	332000.0
2000-09-20 13:00:00	SPY	ETF	144.0625	144.1875	143.375	143.4688	198300.0
2000-09-20 13:30:00	SPY	ETF	143.4062	143.875	143.1562	143.875	479500.0
2000-09-20 14:00:00	SPY	ETF	143.9062	144.6562	143.7812	144.4375	917100.0
2000-09-20 14:30:00	SPY	ETF	144.4375	145.6875	144.4062	145.4062	942800.0
2000-09-20 15:00:00	SPY	ETF	145.4062	145.7188	144.8125	144.875	786100.0
2000-09-20 15:30:00	SPY	ETF	144.9062	145.375	144.8125	145.2188	1042500.0
2000-09-20 16:00:00	SPY	ETF	145.1875	145.25	144.875	144.875	190200.0
2000-09-20 09:30:00	QQQ	ETF	93.375	94.3125	92.375	92.875	3031700.0
2000-09-20 10:00:00	QQQ	ETF	92.75	93.9375	92.4375	93.5625	2368800.0
2000-09-20 10:30:00	QQQ	ETF	93.5625	93.625	92.625	93.0938	2061900.0
2000-09-20 11:00:00	QQQ	ETF	93.0938	93.1875	92.125	92.4062	1814100.0
2000-09-20 11:30:00	QQQ	ETF	92.25	93.0	92.0625	92.5625	1746800.0
2000-09-20 12:00:00	QQQ	ETF	92.625	93.1875	92.5	92.625	1004000.0
2000-09-20 12:30:00	QQQ	ETF	92.625	92.7188	91.5	92.25	1793900.0
2000-09-20 13:00:00	QQQ	ETF	92.125	92.4375	91.5625	91.5625	2100000.0
2000-09-20 13:30:00	QQQ	ETF	91.5625	92.4375	91.3125	92.4375	2834400.0
2000-09-20 14:00:00	QQQ	ETF	92.4062	93.6875	92.3125	93.5	3510800.0
2000-09-20 14:30:00	QQQ	ETF	93.4375	94.9688	93.4375	94.5625	5263100.0
2000-09-20 15:00:00	QQQ	ETF	94.5625	95.2188	93.875	94.0625	2741200.0
2000-09-20 15:30:00	QQQ	ETF	94.0625	94.9688	93.875	94.5	2225100.0
2000-09-20 16:00:00	QQQ	ETF	94.5938	95.0	94.4375	94.625	391800.0
2000-09-20 16:30:00	QQQ	ETF	94.75	94.75	94.4375	94.75	3700.0
2000-09-20 17:00:00	QQQ	ETF	94.75	95.0	94.75	94.8125	4500.0
2000-09-20 17:30:00	QQQ	ETF	94.6875	94.75	94.5625	94.5625	2500.0
2000-09-20 18:00:00	QQQ	ETF	94.6875	94.6875	94.625	94.625	1600.0
2000-09-20 09:30:00	IWM	ETF	52.3125	52.3125	52.3125	52.3125	1400.0
2000-09-20 10:00:00	IWM	ETF	52.125	52.2656	51.9688	52.2656	4200.0
2000-09-20 10:30:00	IWM	ETF	52.0938	52.1875	52.0938	52.1875	2200.0
2000-09-20 11:00:00	IWM	ETF	52.1562	52.1875	52.1562	52.1875	3800.0
2000-09-20 11:30:00	IWM	ETF	52.0625	52.125	51.9062	52.0625	5800.0
2000-09-20 12:30:00	IWM	ETF	52.0	52.0	51.9375	51.9375	3000.0
2000-09-20 13:00:00	IWM	ETF	51.8125	51.8125	51.8125	51.8125	3000.0
2000-09-20 13:30:00	IWM	ETF	51.625	51.9062	51.625	51.9062	6200.0
2000-09-20 14:00:00	IWM	ETF	52.0312	52.0312	51.9062	52.0312	3800.0
2000-09-20 14:30:00	IWM	ETF	52.0938	52.2656	52.0938	52.1562	1800.0
2000-09-20 15:30:00	IWM	ETF	52.125	52.125	52.0625	52.0625	2400.0
2000-09-20 16:00:00	IWM	ETF	51.9062	51.9062	51.9062	51.9062	600.0
2000-09-20 09:30:00	DIA	ETF	108.0	108.375	107.5312	107.6562	503900.0
2000-09-20 10:00:00	DIA	ETF	107.7812	107.7812	107.2812	107.5625	223900.0
2000-09-20 10:30:00	DIA	ETF	107.5938	107.5938	106.875	107.1562	173900.0
2000-09-20 11:00:00	DIA	ETF	107.0625	107.3438	106.75	107.0	180100.0
2000-09-20 11:30:00	DIA	ETF	106.9375	107.1875	106.6875	106.875	201000.0
2000-09-20 12:00:00	DIA	ETF	106.875	106.9688	106.375	106.4375	135400.0

> showing 50 of 280 rows — these rows as CSV

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