PREVIEW / etf_30min / 2000-07-25

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-07-25.parquet
  size:    11 KB
  rows:    267

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-07-25 09:30:00	SPY	ETF	147.75	147.75	147.25	147.7188	862000.0
2000-07-25 10:00:00	SPY	ETF	147.8125	147.8125	146.7812	147.0	505700.0
2000-07-25 10:30:00	SPY	ETF	147.0312	147.8125	146.875	147.3125	332900.0
2000-07-25 11:00:00	SPY	ETF	147.4688	147.5	147.125	147.2188	146900.0
2000-07-25 11:30:00	SPY	ETF	147.125	147.2188	146.8438	147.0	198700.0
2000-07-25 12:00:00	SPY	ETF	147.125	147.375	147.0625	147.1875	120200.0
2000-07-25 12:30:00	SPY	ETF	147.0938	147.5625	147.0625	147.3438	242000.0
2000-07-25 13:00:00	SPY	ETF	147.3125	147.5	147.25	147.25	356500.0
2000-07-25 13:30:00	SPY	ETF	147.25	147.3438	147.0	147.3438	275200.0
2000-07-25 14:00:00	SPY	ETF	147.375	147.625	147.25	147.5938	134900.0
2000-07-25 14:30:00	SPY	ETF	147.5	147.625	147.2188	147.5312	291600.0
2000-07-25 15:00:00	SPY	ETF	147.5625	147.8438	147.375	147.375	291800.0
2000-07-25 15:30:00	SPY	ETF	147.4688	147.8125	147.375	147.4375	474900.0
2000-07-25 16:00:00	SPY	ETF	147.4375	147.5938	147.1562	147.3125	768300.0
2000-07-25 09:30:00	QQQ	ETF	95.625	96.1875	95.5	95.8125	2633600.0
2000-07-25 10:00:00	QQQ	ETF	95.8125	96.0	93.8125	94.5	2730400.0
2000-07-25 10:30:00	QQQ	ETF	94.625	95.6875	94.375	95.25	1830000.0
2000-07-25 11:00:00	QQQ	ETF	95.3438	95.4688	94.75	94.75	1201600.0
2000-07-25 11:30:00	QQQ	ETF	94.75	95.2812	94.375	95.0625	1417500.0
2000-07-25 12:00:00	QQQ	ETF	95.125	95.375	94.875	95.0312	857100.0
2000-07-25 12:30:00	QQQ	ETF	95.0	95.8438	95.0	95.75	851100.0
2000-07-25 13:00:00	QQQ	ETF	95.8125	96.0	95.625	95.875	1131000.0
2000-07-25 13:30:00	QQQ	ETF	95.8438	96.0	95.125	95.7812	851500.0
2000-07-25 14:00:00	QQQ	ETF	95.5625	96.375	95.5	96.0625	842700.0
2000-07-25 14:30:00	QQQ	ETF	96.0312	96.5	95.75	96.4688	1265900.0
2000-07-25 15:00:00	QQQ	ETF	96.4375	96.7188	95.875	96.0	1483400.0
2000-07-25 15:30:00	QQQ	ETF	96.0312	96.4375	96.0	96.25	1353600.0
2000-07-25 16:00:00	QQQ	ETF	96.25	96.5	96.0625	96.125	568000.0
2000-07-25 16:30:00	QQQ	ETF	96.1875	96.1875	96.1875	96.1875	4000.0
2000-07-25 17:00:00	QQQ	ETF	96.25	96.25	96.25	96.25	1300.0
2000-07-25 17:30:00	QQQ	ETF	96.25	96.2812	96.125	96.25	1800.0
2000-07-25 18:00:00	QQQ	ETF	95.75	95.75	95.75	95.75	800.0
2000-07-25 09:30:00	IWM	ETF	51.6719	51.6719	51.5	51.5	2400.0
2000-07-25 10:00:00	IWM	ETF	51.5312	51.5312	51.0625	51.0625	1400.0
2000-07-25 10:30:00	IWM	ETF	51.0625	51.25	51.0625	51.25	3600.0
2000-07-25 11:30:00	IWM	ETF	51.2188	51.2188	51.2188	51.2188	20000.0
2000-07-25 12:00:00	IWM	ETF	51.2031	51.2031	51.2031	51.2031	1000.0
2000-07-25 14:00:00	IWM	ETF	51.1406	51.1406	51.1406	51.1406	200.0
2000-07-25 15:00:00	IWM	ETF	51.2812	51.2969	51.2812	51.2969	6400.0
2000-07-25 15:30:00	IWM	ETF	51.1719	51.375	51.1562	51.375	1800.0
2000-07-25 09:30:00	DIA	ETF	107.3438	107.3438	106.875	107.0312	105600.0
2000-07-25 10:00:00	DIA	ETF	107.125	107.1875	106.8438	106.9375	23500.0
2000-07-25 10:30:00	DIA	ETF	107.125	107.5	106.7812	107.25	10800.0
2000-07-25 11:00:00	DIA	ETF	107.25	107.25	106.875	106.875	20500.0
2000-07-25 11:30:00	DIA	ETF	106.9688	107.0	106.6875	106.875	17600.0
2000-07-25 12:00:00	DIA	ETF	106.9688	107.125	106.875	107.0312	33400.0
2000-07-25 12:30:00	DIA	ETF	107.0312	107.2188	106.9062	107.0	3100.0
2000-07-25 13:00:00	DIA	ETF	107.0	107.2188	107.0	107.2188	6000.0
2000-07-25 13:30:00	DIA	ETF	106.8125	107.0312	106.8125	107.0312	2300.0
2000-07-25 14:00:00	DIA	ETF	107.0625	107.4062	107.0625	107.3125	9600.0

> showing 50 of 267 rows — these rows as CSV

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