PREVIEW / etf_30min / 2000-03-16

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-03-16.parquet
  size:    10 KB
  rows:    221

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-03-16 09:30:00	SPY	ETF	141.625	141.75	140.9375	141.5	3121700.0
2000-03-16 10:00:00	SPY	ETF	141.6562	141.6875	140.875	141.125	1181200.0
2000-03-16 10:30:00	SPY	ETF	141.25	141.9688	141.1875	141.6875	405400.0
2000-03-16 11:00:00	SPY	ETF	141.4688	141.9688	141.2812	141.9375	1039600.0
2000-03-16 11:30:00	SPY	ETF	142.0	144.0312	141.9375	143.625	3818400.0
2000-03-16 12:00:00	SPY	ETF	143.625	144.25	143.375	143.9688	1827200.0
2000-03-16 12:30:00	SPY	ETF	143.9375	144.875	143.8438	144.0	1802700.0
2000-03-16 13:00:00	SPY	ETF	143.9375	144.3438	143.4375	143.5	1008900.0
2000-03-16 13:30:00	SPY	ETF	143.7188	144.5	143.2188	144.0938	2556900.0
2000-03-16 14:00:00	SPY	ETF	144.0625	144.7188	143.75	144.625	1061700.0
2000-03-16 14:30:00	SPY	ETF	144.625	145.4375	144.2188	145.4375	1171100.0
2000-03-16 15:00:00	SPY	ETF	145.4688	146.5	145.25	146.125	1094600.0
2000-03-16 15:30:00	SPY	ETF	146.125	146.6875	145.3438	146.3125	1264000.0
2000-03-16 16:00:00	SPY	ETF	146.3125	146.8438	146.3125	146.5	820800.0
2000-03-16 16:30:00	SPY	ETF	145.5938	146.3438	145.5938	146.3438	2725000.0
2000-03-16 09:30:00	QQQ	ETF	105.375	106.0	104.0	104.5625	7607200.0
2000-03-16 10:00:00	QQQ	ETF	104.5938	104.75	102.5	102.5	4654400.0
2000-03-16 10:30:00	QQQ	ETF	102.625	103.0	101.5312	101.7188	3545800.0
2000-03-16 11:00:00	QQQ	ETF	101.9375	102.2812	101.0	102.125	4787400.0
2000-03-16 11:30:00	QQQ	ETF	102.1562	105.0625	102.125	103.7031	5579000.0
2000-03-16 12:00:00	QQQ	ETF	104.125	104.75	103.3438	104.75	1749400.0
2000-03-16 12:30:00	QQQ	ETF	104.7188	106.0625	104.2188	104.3125	3194400.0
2000-03-16 13:00:00	QQQ	ETF	104.25	104.7031	103.125	103.375	2882000.0
2000-03-16 13:30:00	QQQ	ETF	103.375	105.0469	103.2188	104.4375	2790800.0
2000-03-16 14:00:00	QQQ	ETF	104.4531	105.875	103.7656	105.75	2723600.0
2000-03-16 14:30:00	QQQ	ETF	105.875	107.375	105.125	107.25	3270800.0
2000-03-16 15:00:00	QQQ	ETF	107.25	109.25	106.8125	108.0625	5773600.0
2000-03-16 15:30:00	QQQ	ETF	108.2969	108.8125	107.0938	108.75	5400600.0
2000-03-16 16:00:00	QQQ	ETF	108.75	108.9688	108.625	108.625	903800.0
2000-03-16 16:30:00	QQQ	ETF	108.5	109.0625	108.5	108.625	13800.0
2000-03-16 17:00:00	QQQ	ETF	108.5	108.5	108.5	108.5	6200.0
2000-03-16 17:30:00	QQQ	ETF	108.75	108.75	108.75	108.75	200.0
2000-03-16 09:30:00	DIA	ETF	102.5625	103.1875	102.4062	103.1562	390300.0
2000-03-16 10:00:00	DIA	ETF	103.0625	103.5	102.7812	103.0625	165200.0
2000-03-16 10:30:00	DIA	ETF	103.25	104.0	103.2188	103.625	336100.0
2000-03-16 11:00:00	DIA	ETF	103.7812	104.2812	103.625	104.0312	242500.0
2000-03-16 11:30:00	DIA	ETF	104.0625	105.125	104.0625	104.7188	469900.0
2000-03-16 12:00:00	DIA	ETF	104.875	105.5312	104.6562	105.3125	466300.0
2000-03-16 12:30:00	DIA	ETF	105.3438	105.875	105.25	105.3125	711700.0
2000-03-16 13:00:00	DIA	ETF	105.4375	105.5625	104.9375	105.125	264400.0
2000-03-16 13:30:00	DIA	ETF	105.0	105.5	105.0	105.25	250200.0
2000-03-16 14:00:00	DIA	ETF	105.125	105.625	105.0	105.5312	213000.0
2000-03-16 14:30:00	DIA	ETF	105.625	106.0	105.375	105.75	204500.0
2000-03-16 15:00:00	DIA	ETF	105.8438	106.4688	105.5938	105.8125	538600.0
2000-03-16 15:30:00	DIA	ETF	105.8125	106.5	105.4062	106.5	414200.0
2000-03-16 16:00:00	DIA	ETF	106.4375	106.875	106.4375	106.7812	134200.0

> showing 46 of 221 rows — these rows as CSV

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