PREVIEW / etf_30min / 2000-01-14

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-01-14.parquet
  size:    10 KB
  rows:    219

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-14 09:30:00	SPY	ETF	146.5312	147.3125	146.4688	147.25	1449600.0
2000-01-14 10:00:00	SPY	ETF	147.0938	147.375	146.6875	147.1875	840700.0
2000-01-14 10:30:00	SPY	ETF	147.25	147.4375	147.0	147.25	159700.0
2000-01-14 11:00:00	SPY	ETF	147.3125	147.4688	146.9375	147.125	368800.0
2000-01-14 11:30:00	SPY	ETF	147.0312	147.125	146.5	147.0938	549800.0
2000-01-14 12:00:00	SPY	ETF	147.0938	147.0938	145.9688	146.25	809300.0
2000-01-14 12:30:00	SPY	ETF	146.375	146.6875	146.1875	146.5	462300.0
2000-01-14 13:00:00	SPY	ETF	146.3438	146.9688	146.3438	146.7188	93000.0
2000-01-14 13:30:00	SPY	ETF	146.7812	146.9375	146.5	146.7812	140800.0
2000-01-14 14:00:00	SPY	ETF	146.7812	146.9062	146.5625	146.8125	43000.0
2000-01-14 14:30:00	SPY	ETF	146.8125	147.125	146.3125	146.5	769600.0
2000-01-14 15:00:00	SPY	ETF	146.375	146.75	146.125	146.5625	264800.0
2000-01-14 15:30:00	SPY	ETF	146.5625	147.0	146.3125	146.5	868600.0
2000-01-14 16:00:00	SPY	ETF	146.5312	146.9688	146.4688	146.9688	573700.0
2000-01-14 09:30:00	QQQ	ETF	93.0	93.375	92.5	92.5	4921800.0
2000-01-14 10:00:00	QQQ	ETF	92.5625	93.375	92.25	93.125	1954000.0
2000-01-14 10:30:00	QQQ	ETF	93.375	93.5	92.875	93.375	1531800.0
2000-01-14 11:00:00	QQQ	ETF	93.4219	93.625	92.875	93.0156	1433400.0
2000-01-14 11:30:00	QQQ	ETF	93.0625	93.1875	92.5938	93.0625	1128200.0
2000-01-14 12:00:00	QQQ	ETF	93.0	93.0625	92.0	92.4375	1557800.0
2000-01-14 12:30:00	QQQ	ETF	92.5	92.9375	92.375	92.5156	1000000.0
2000-01-14 13:00:00	QQQ	ETF	92.625	93.375	92.5625	93.125	866400.0
2000-01-14 13:30:00	QQQ	ETF	93.125	93.25	92.6875	93.0469	500600.0
2000-01-14 14:00:00	QQQ	ETF	93.0312	93.375	92.8438	93.25	841800.0
2000-01-14 14:30:00	QQQ	ETF	93.1562	93.4844	92.5	92.875	1663800.0
2000-01-14 15:00:00	QQQ	ETF	92.875	93.0	92.1875	92.8125	1383800.0
2000-01-14 15:30:00	QQQ	ETF	92.75	93.4375	92.4375	92.5	2159000.0
2000-01-14 16:00:00	QQQ	ETF	92.5312	92.875	92.4531	92.75	278400.0
2000-01-14 16:30:00	QQQ	ETF	92.6875	92.6875	92.6875	92.6875	4000.0
2000-01-14 18:00:00	QQQ	ETF	93.25	93.375	93.25	93.375	600.0
2000-01-14 09:30:00	DIA	ETF	117.4688	117.4688	116.9062	117.0625	295100.0
2000-01-14 10:00:00	DIA	ETF	117.3438	117.3438	116.875	117.0625	63800.0
2000-01-14 10:30:00	DIA	ETF	117.25	117.2812	116.9375	117.0	20300.0
2000-01-14 11:00:00	DIA	ETF	117.125	117.4375	117.0	117.125	42600.0
2000-01-14 11:30:00	DIA	ETF	117.3125	117.3125	116.875	117.0625	67100.0
2000-01-14 12:00:00	DIA	ETF	117.0	117.0	116.125	116.7188	937300.0
2000-01-14 12:30:00	DIA	ETF	116.6875	116.8125	116.5	116.8125	21500.0
2000-01-14 13:00:00	DIA	ETF	116.75	117.25	116.75	117.1875	74700.0
2000-01-14 13:30:00	DIA	ETF	117.1875	117.2188	117.0625	117.0938	5300.0
2000-01-14 14:00:00	DIA	ETF	117.0938	117.3438	117.0	117.25	31800.0
2000-01-14 14:30:00	DIA	ETF	117.3438	117.5	116.8125	117.0312	187300.0
2000-01-14 15:00:00	DIA	ETF	117.0	117.2188	116.8438	117.0625	14600.0
2000-01-14 15:30:00	DIA	ETF	117.3125	117.3438	116.9688	117.0312	160300.0
2000-01-14 16:00:00	DIA	ETF	117.1562	117.5	117.1562	117.5	11000.0

> showing 44 of 219 rows — these rows as CSV

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