PREVIEW / etf_30min / 2000-04-14

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-04-14.parquet
  size:    11 KB
  rows:    234

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-04-14 09:30:00	SPY	ETF	142.625	142.7188	140.4375	142.625	2715500.0
2000-04-14 10:00:00	SPY	ETF	142.375	142.8125	141.1562	141.8125	1182800.0
2000-04-14 10:30:00	SPY	ETF	141.875	142.3125	140.5625	142.0625	894500.0
2000-04-14 11:00:00	SPY	ETF	141.8125	141.9375	140.5	140.5	652600.0
2000-04-14 11:30:00	SPY	ETF	140.5	140.5938	138.7812	139.0	1285200.0
2000-04-14 12:00:00	SPY	ETF	138.9375	140.3438	138.3438	139.3125	2468100.0
2000-04-14 12:30:00	SPY	ETF	139.4688	140.2188	138.25	139.4062	636400.0
2000-04-14 13:00:00	SPY	ETF	139.3125	140.8125	139.3125	139.75	1639200.0
2000-04-14 13:30:00	SPY	ETF	139.75	140.0	138.375	139.25	1496500.0
2000-04-14 14:00:00	SPY	ETF	139.2188	139.5	137.3438	138.5312	1237200.0
2000-04-14 14:30:00	SPY	ETF	138.3125	138.4062	136.25	137.2188	1305200.0
2000-04-14 15:00:00	SPY	ETF	137.25	137.625	135.375	136.625	2237400.0
2000-04-14 15:30:00	SPY	ETF	136.4375	136.4375	133.625	135.8125	1741200.0
2000-04-14 16:00:00	SPY	ETF	135.25	136.2812	135.25	135.5625	659200.0
2000-04-14 17:00:00	SPY	ETF	138.3438	138.375	138.3438	138.375	2675000.0
2000-04-14 17:30:00	SPY	ETF	136.5	136.5	136.0	136.0	200.0
2000-04-14 09:30:00	QQQ	ETF	86.0625	88.5	84.0	87.8125	10028700.0
2000-04-14 10:00:00	QQQ	ETF	87.875	88.0625	85.75	86.6875	4047000.0
2000-04-14 10:30:00	QQQ	ETF	86.75	88.0	85.125	86.5	3074200.0
2000-04-14 11:00:00	QQQ	ETF	86.5	86.5	84.0	84.125	3767900.0
2000-04-14 11:30:00	QQQ	ETF	84.0625	84.5	82.125	82.25	5422900.0
2000-04-14 12:00:00	QQQ	ETF	82.125	85.0	81.0	83.8125	4162000.0
2000-04-14 12:30:00	QQQ	ETF	83.75	85.25	82.25	83.75	2259500.0
2000-04-14 13:00:00	QQQ	ETF	83.6875	86.75	83.5312	85.625	3785000.0
2000-04-14 13:30:00	QQQ	ETF	85.625	85.875	83.125	84.5	2740400.0
2000-04-14 14:00:00	QQQ	ETF	84.5	84.7812	82.0	83.25	3350600.0
2000-04-14 14:30:00	QQQ	ETF	83.0625	83.75	81.5	82.1875	4066200.0
2000-04-14 15:00:00	QQQ	ETF	82.0	82.5625	80.0	82.0	4657200.0
2000-04-14 15:30:00	QQQ	ETF	81.875	82.0	78.0	80.25	6593000.0
2000-04-14 16:00:00	QQQ	ETF	80.25	81.0	79.5	79.5	1280700.0
2000-04-14 16:30:00	QQQ	ETF	80.125	80.75	79.6875	79.6875	28300.0
2000-04-14 17:00:00	QQQ	ETF	79.6875	80.0	79.6875	79.75	9100.0
2000-04-14 17:30:00	QQQ	ETF	80.0625	80.0625	79.6875	79.6875	1500.0
2000-04-14 18:00:00	QQQ	ETF	79.75	80.375	79.75	80.375	2600.0
2000-04-14 09:30:00	DIA	ETF	107.4375	108.1875	106.3125	108.1562	490300.0
2000-04-14 10:00:00	DIA	ETF	108.0	108.25	106.7812	107.4375	246300.0
2000-04-14 10:30:00	DIA	ETF	107.3438	107.7812	106.6875	107.6562	118300.0
2000-04-14 11:00:00	DIA	ETF	107.6562	107.6562	106.5312	106.5312	198800.0
2000-04-14 11:30:00	DIA	ETF	106.5312	106.75	105.6562	105.6562	668000.0
2000-04-14 12:00:00	DIA	ETF	105.5625	106.625	105.3125	106.2188	226400.0
2000-04-14 12:30:00	DIA	ETF	106.2188	106.3438	105.2812	106.0625	88300.0
2000-04-14 13:00:00	DIA	ETF	106.0	106.8438	105.9062	106.375	234600.0
2000-04-14 13:30:00	DIA	ETF	106.0312	106.3125	105.0312	105.75	214700.0
2000-04-14 14:00:00	DIA	ETF	105.7812	105.7812	104.375	104.875	282800.0
2000-04-14 14:30:00	DIA	ETF	104.9375	105.0	103.6875	104.25	275800.0
2000-04-14 15:00:00	DIA	ETF	103.9375	104.625	102.5625	103.8125	734800.0
2000-04-14 15:30:00	DIA	ETF	103.5312	103.8438	101.5	103.1875	645700.0
2000-04-14 16:00:00	DIA	ETF	103.0312	103.375	102.5	102.5	78100.0

> showing 48 of 234 rows — these rows as CSV

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