PREVIEW / etf_30min / 2000-03-15

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-03-15.parquet
  size:    10 KB
  rows:    212

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-15 09:30:00	SPY	ETF	136.875	137.3125	136.0625	137.0	1377900.0
2000-03-15 10:00:00	SPY	ETF	137.125	137.6875	136.6562	136.8125	695700.0
2000-03-15 10:30:00	SPY	ETF	136.8125	138.0	136.75	137.5	294100.0
2000-03-15 11:00:00	SPY	ETF	137.4688	137.9375	137.25	137.625	500900.0
2000-03-15 11:30:00	SPY	ETF	137.4375	138.4062	136.8438	138.1875	271400.0
2000-03-15 12:00:00	SPY	ETF	138.0	138.3438	137.7812	137.8438	799900.0
2000-03-15 12:30:00	SPY	ETF	137.7812	137.9375	137.3125	137.7188	168900.0
2000-03-15 13:00:00	SPY	ETF	137.875	138.9688	137.875	138.8125	889400.0
2000-03-15 13:30:00	SPY	ETF	138.75	139.3125	138.4062	139.1562	327900.0
2000-03-15 14:00:00	SPY	ETF	139.25	139.8438	139.0	139.8438	814000.0
2000-03-15 14:30:00	SPY	ETF	139.8125	140.0	139.0625	139.5625	850300.0
2000-03-15 15:00:00	SPY	ETF	139.625	140.4375	139.3438	140.2812	1210500.0
2000-03-15 15:30:00	SPY	ETF	140.125	140.3438	138.75	139.5	1175500.0
2000-03-15 16:00:00	SPY	ETF	139.75	139.9062	139.2812	139.9062	402000.0
2000-03-15 16:30:00	SPY	ETF	139.75	139.8125	139.75	139.8125	507500.0
2000-03-15 09:30:00	QQQ	ETF	106.5	106.75	104.0	105.5625	7178400.0
2000-03-15 10:00:00	QQQ	ETF	105.8125	107.0	105.0	105.4062	6734000.0
2000-03-15 10:30:00	QQQ	ETF	105.4375	106.8125	105.0781	105.5	3673400.0
2000-03-15 11:00:00	QQQ	ETF	105.625	105.8594	104.5312	104.5312	3094200.0
2000-03-15 11:30:00	QQQ	ETF	104.5312	105.0	103.5	104.9062	3358200.0
2000-03-15 12:00:00	QQQ	ETF	104.8594	104.9844	103.5625	103.5938	1800200.0
2000-03-15 12:30:00	QQQ	ETF	103.5938	103.6875	102.5	103.5625	2920200.0
2000-03-15 13:00:00	QQQ	ETF	103.5625	105.375	103.5312	105.0625	4256800.0
2000-03-15 13:30:00	QQQ	ETF	105.0625	106.0	104.2031	105.5	3760000.0
2000-03-15 14:00:00	QQQ	ETF	106.0	106.0	104.9062	105.7188	2638200.0
2000-03-15 14:30:00	QQQ	ETF	105.5	105.75	103.5	104.3125	3059800.0
2000-03-15 15:00:00	QQQ	ETF	104.2812	105.0	103.75	104.0	3486200.0
2000-03-15 15:30:00	QQQ	ETF	104.2344	104.2344	101.875	103.0	3762200.0
2000-03-15 16:00:00	QQQ	ETF	102.75	103.25	102.625	102.9062	965000.0
2000-03-15 16:30:00	QQQ	ETF	102.9688	102.9688	102.9688	102.9688	1200.0
2000-03-15 17:00:00	QQQ	ETF	102.9688	102.9688	102.9688	102.9688	800.0
2000-03-15 18:00:00	QQQ	ETF	103.4375	103.4375	102.875	102.875	2000.0
2000-03-15 09:30:00	DIA	ETF	98.625	98.625	97.6562	98.5938	319600.0
2000-03-15 10:00:00	DIA	ETF	98.4375	98.7812	98.125	98.3125	99600.0
2000-03-15 10:30:00	DIA	ETF	98.2188	98.9688	98.2188	98.7812	53300.0
2000-03-15 11:00:00	DIA	ETF	98.875	99.4062	98.5625	99.25	46300.0
2000-03-15 11:30:00	DIA	ETF	99.2188	99.875	98.8125	99.5938	80200.0
2000-03-15 12:00:00	DIA	ETF	99.75	100.2188	99.5938	99.7812	161300.0
2000-03-15 12:30:00	DIA	ETF	99.8125	99.8438	99.5	99.75	71400.0
2000-03-15 13:00:00	DIA	ETF	99.75	100.375	99.75	100.0625	63500.0
2000-03-15 13:30:00	DIA	ETF	100.0625	100.75	100.0312	100.75	289600.0
2000-03-15 14:00:00	DIA	ETF	100.625	101.125	100.5312	101.125	87600.0
2000-03-15 14:30:00	DIA	ETF	101.25	101.25	100.6562	101.0938	200800.0
2000-03-15 15:00:00	DIA	ETF	101.0938	101.9688	100.9375	101.9688	211400.0
2000-03-15 15:30:00	DIA	ETF	101.9688	101.9688	101.0	101.4688	203800.0
2000-03-15 16:00:00	DIA	ETF	101.4375	101.75	101.2812	101.625	116000.0

> showing 46 of 212 rows — these rows as CSV

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