PREVIEW / etf_30min / 2000-01-20

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-01-20.parquet
  size:    10 KB
  rows:    227

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-01-20 09:30:00	SPY	ETF	146.9688	146.9688	146.25	146.3438	451700.0
2000-01-20 10:00:00	SPY	ETF	146.375	146.75	145.9375	146.3125	182900.0
2000-01-20 10:30:00	SPY	ETF	146.25	146.625	146.125	146.2188	233900.0
2000-01-20 11:00:00	SPY	ETF	146.3125	146.5	146.0	146.25	107300.0
2000-01-20 11:30:00	SPY	ETF	146.25	146.25	145.1875	145.375	403500.0
2000-01-20 12:00:00	SPY	ETF	145.3125	145.3438	144.625	145.0	405000.0
2000-01-20 12:30:00	SPY	ETF	145.0	145.0	144.125	144.5	438100.0
2000-01-20 13:00:00	SPY	ETF	144.4375	144.8438	143.8125	144.75	295300.0
2000-01-20 13:30:00	SPY	ETF	144.75	144.9375	144.5312	144.8438	805100.0
2000-01-20 14:00:00	SPY	ETF	144.875	145.25	144.5625	144.9688	328800.0
2000-01-20 14:30:00	SPY	ETF	144.9688	145.4375	144.6875	144.6875	917100.0
2000-01-20 15:00:00	SPY	ETF	144.75	145.375	144.5	144.9375	458400.0
2000-01-20 15:30:00	SPY	ETF	144.9375	145.0312	144.5	144.5	291400.0
2000-01-20 16:00:00	SPY	ETF	144.5	144.9375	144.4062	144.75	459500.0
2000-01-20 09:30:00	QQQ	ETF	95.5	96.25	95.5	95.9844	2918400.0
2000-01-20 10:00:00	QQQ	ETF	95.9844	96.5938	95.875	96.2656	2134400.0
2000-01-20 10:30:00	QQQ	ETF	96.25	96.875	96.0625	96.5625	1456800.0
2000-01-20 11:00:00	QQQ	ETF	96.5938	96.6875	96.0312	96.4062	545000.0
2000-01-20 11:30:00	QQQ	ETF	96.4219	96.4219	95.5	95.6719	2183400.0
2000-01-20 12:00:00	QQQ	ETF	95.625	95.7344	95.0625	95.3125	2075000.0
2000-01-20 12:30:00	QQQ	ETF	95.3594	95.3594	94.25	94.8438	2564000.0
2000-01-20 13:00:00	QQQ	ETF	94.8438	95.5	94.25	95.375	2204600.0
2000-01-20 13:30:00	QQQ	ETF	95.3125	95.5625	94.875	95.4062	1093800.0
2000-01-20 14:00:00	QQQ	ETF	95.3125	96.375	95.1875	95.9688	1825200.0
2000-01-20 14:30:00	QQQ	ETF	96.0	96.5312	95.6875	95.6875	2441800.0
2000-01-20 15:00:00	QQQ	ETF	95.75	96.4375	95.3125	96.125	1960800.0
2000-01-20 15:30:00	QQQ	ETF	96.0938	96.2812	95.5625	95.7969	1482600.0
2000-01-20 16:00:00	QQQ	ETF	95.8125	95.8438	95.375	95.75	774200.0
2000-01-20 16:30:00	QQQ	ETF	95.625	95.625	95.5	95.5	7000.0
2000-01-20 17:30:00	QQQ	ETF	95.5	95.5	95.5	95.5	2000.0
2000-01-20 18:00:00	QQQ	ETF	95.0625	95.0625	95.0625	95.0625	400.0
2000-01-20 09:30:00	DIA	ETF	115.9375	115.9688	115.0	115.4062	119400.0
2000-01-20 10:00:00	DIA	ETF	115.3438	115.4688	114.875	115.1875	58600.0
2000-01-20 10:30:00	DIA	ETF	115.125	115.1875	114.8125	114.9062	79100.0
2000-01-20 11:00:00	DIA	ETF	114.9062	115.125	114.7188	114.8125	30200.0
2000-01-20 11:30:00	DIA	ETF	114.75	114.75	113.875	114.0938	150200.0
2000-01-20 12:00:00	DIA	ETF	114.0	114.0	113.4375	113.7812	91000.0
2000-01-20 12:30:00	DIA	ETF	113.7812	113.7812	113.25	113.5625	49400.0
2000-01-20 13:00:00	DIA	ETF	113.375	113.6562	112.6562	113.5	70800.0
2000-01-20 13:30:00	DIA	ETF	113.5	113.7188	113.375	113.625	84100.0
2000-01-20 14:00:00	DIA	ETF	113.5	113.9688	113.4375	113.7812	33300.0
2000-01-20 14:30:00	DIA	ETF	113.75	114.0938	113.625	113.875	23600.0
2000-01-20 15:00:00	DIA	ETF	113.5	114.25	113.5	114.0312	25000.0
2000-01-20 15:30:00	DIA	ETF	113.7188	113.9062	113.5	113.5	59000.0
2000-01-20 16:00:00	DIA	ETF	113.4688	113.7188	113.375	113.7188	11500.0

> showing 45 of 227 rows — these rows as CSV

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