PREVIEW / etf_30min / 2000-03-27

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-03-27.parquet
  size:    9 KB
  rows:    208

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-27 09:30:00	SPY	ETF	153.375	153.5625	152.875	153.0312	1814500.0
2000-03-27 10:00:00	SPY	ETF	153.1875	153.7812	153.0	153.25	968000.0
2000-03-27 10:30:00	SPY	ETF	153.25	153.25	152.25	152.5	1190100.0
2000-03-27 11:00:00	SPY	ETF	152.4375	153.0	152.375	152.875	394100.0
2000-03-27 11:30:00	SPY	ETF	152.875	152.9375	152.375	152.625	270600.0
2000-03-27 12:00:00	SPY	ETF	152.6875	153.0625	152.5	152.75	151400.0
2000-03-27 12:30:00	SPY	ETF	152.5938	153.1562	152.5	153.1562	743000.0
2000-03-27 13:00:00	SPY	ETF	153.1875	153.3125	152.6875	152.8125	324900.0
2000-03-27 13:30:00	SPY	ETF	152.75	153.0625	152.625	152.625	61700.0
2000-03-27 14:00:00	SPY	ETF	152.8125	152.9375	152.0	152.25	665300.0
2000-03-27 14:30:00	SPY	ETF	152.3125	152.875	152.0625	152.5	284800.0
2000-03-27 15:00:00	SPY	ETF	152.375	152.9062	152.0625	152.5938	295000.0
2000-03-27 15:30:00	SPY	ETF	152.5	152.875	152.0625	152.5	925100.0
2000-03-27 16:00:00	SPY	ETF	152.5	152.5625	151.8125	151.9375	649800.0
2000-03-27 09:30:00	QQQ	ETF	118.0	118.5	117.125	117.625	1780400.0
2000-03-27 10:00:00	QQQ	ETF	117.5625	119.5	117.5	118.75	1561600.0
2000-03-27 10:30:00	QQQ	ETF	118.8125	118.9688	117.5625	117.7812	846900.0
2000-03-27 11:00:00	QQQ	ETF	117.75	119.0	117.75	118.625	561000.0
2000-03-27 11:30:00	QQQ	ETF	118.75	118.8438	118.0625	118.75	329900.0
2000-03-27 12:00:00	QQQ	ETF	118.75	119.0625	118.25	118.75	712500.0
2000-03-27 12:30:00	QQQ	ETF	118.6875	119.0	118.3125	119.0	527900.0
2000-03-27 13:00:00	QQQ	ETF	119.1875	119.375	118.25	118.625	736000.0
2000-03-27 13:30:00	QQQ	ETF	118.625	118.9688	118.25	118.4688	890100.0
2000-03-27 14:00:00	QQQ	ETF	118.5	118.6875	117.125	117.9062	1019000.0
2000-03-27 14:30:00	QQQ	ETF	117.8125	118.625	117.375	118.0	632600.0
2000-03-27 15:00:00	QQQ	ETF	117.9062	118.4375	117.25	117.875	877400.0
2000-03-27 15:30:00	QQQ	ETF	117.9688	118.4375	117.125	117.6875	1014300.0
2000-03-27 16:00:00	QQQ	ETF	117.6875	117.6875	117.125	117.3438	206400.0
2000-03-27 17:30:00	QQQ	ETF	117.5	117.5	117.5	117.5	100.0
2000-03-27 18:00:00	QQQ	ETF	117.75	117.75	117.75	117.75	300.0
2000-03-27 09:30:00	DIA	ETF	111.3438	111.6875	111.125	111.375	214400.0
2000-03-27 10:00:00	DIA	ETF	111.5938	111.9062	111.125	111.3125	127400.0
2000-03-27 10:30:00	DIA	ETF	111.125	111.2812	110.4375	110.5	132400.0
2000-03-27 11:00:00	DIA	ETF	110.5625	110.8438	110.5	110.625	103200.0
2000-03-27 11:30:00	DIA	ETF	110.6875	110.875	110.4062	110.875	80300.0
2000-03-27 12:00:00	DIA	ETF	110.875	110.875	110.4062	110.4375	99500.0
2000-03-27 12:30:00	DIA	ETF	110.625	110.875	110.5	110.8438	27200.0
2000-03-27 13:00:00	DIA	ETF	110.6562	110.9375	110.1875	110.25	71200.0
2000-03-27 13:30:00	DIA	ETF	110.25	110.5625	110.25	110.3438	32600.0
2000-03-27 14:00:00	DIA	ETF	110.25	110.375	109.6875	110.0	308200.0
2000-03-27 14:30:00	DIA	ETF	110.0	110.5938	109.8125	110.125	34400.0
2000-03-27 15:00:00	DIA	ETF	110.0	110.4062	109.9375	110.125	66800.0
2000-03-27 15:30:00	DIA	ETF	110.2812	110.4375	109.8438	110.1562	102600.0
2000-03-27 16:00:00	DIA	ETF	110.0625	110.2188	109.75	109.8125	27000.0

> showing 44 of 208 rows — these rows as CSV

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