PREVIEW / etf_30min / 2001-01-10

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-01-10.parquet
  size:    12 KB
  rows:    325

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
2001-01-10 09:30:00	SPY	ETF	129.0	129.4688	128.8125	129.4688	650500.0
2001-01-10 10:00:00	SPY	ETF	129.4688	130.0938	129.0938	129.75	549400.0
2001-01-10 10:30:00	SPY	ETF	129.875	130.7188	129.7188	130.0312	699900.0
2001-01-10 11:00:00	SPY	ETF	130.125	131.25	130.0	130.875	816500.0
2001-01-10 11:30:00	SPY	ETF	130.8438	131.4688	130.6562	131.4688	250000.0
2001-01-10 12:00:00	SPY	ETF	131.4688	131.5938	130.2188	130.875	1314400.0
2001-01-10 12:30:00	SPY	ETF	130.8438	131.125	130.375	130.5	258100.0
2001-01-10 13:00:00	SPY	ETF	130.5	130.5	129.5	130.1875	1347300.0
2001-01-10 13:30:00	SPY	ETF	130.1875	130.7188	130.125	130.25	306000.0
2001-01-10 14:00:00	SPY	ETF	130.25	130.7188	130.0312	130.625	136800.0
2001-01-10 14:30:00	SPY	ETF	130.6875	130.8125	130.3438	130.5	272100.0
2001-01-10 15:00:00	SPY	ETF	130.4688	131.25	130.4688	131.2188	344000.0
2001-01-10 15:30:00	SPY	ETF	131.1875	131.8125	131.0938	131.6562	820900.0
2001-01-10 16:00:00	SPY	ETF	131.625	132.125	131.5938	131.8438	317500.0
2001-01-10 16:30:00	SPY	ETF	132.125	132.125	131.7812	131.7812	2500.0
2001-01-10 17:30:00	SPY	ETF	131.5	131.7812	131.375	131.375	2200.0
2001-01-10 09:30:00	QQQ	ETF	56.125	56.875	55.75	56.7188	5691800.0
2001-01-10 10:00:00	QQQ	ETF	56.7812	57.875	56.5	57.5	4737300.0
2001-01-10 10:30:00	QQQ	ETF	57.5	58.9375	57.4375	58.3125	4719500.0
2001-01-10 11:00:00	QQQ	ETF	58.3125	59.5938	58.1875	59.3125	4900600.0
2001-01-10 11:30:00	QQQ	ETF	59.2812	59.8125	59.0	59.75	4848000.0
2001-01-10 12:00:00	QQQ	ETF	59.6875	60.0	57.4375	58.5	9364900.0
2001-01-10 12:30:00	QQQ	ETF	58.5	59.0	57.6562	57.75	3872300.0
2001-01-10 13:00:00	QQQ	ETF	57.75	57.9688	56.75	57.9062	5490300.0
2001-01-10 13:30:00	QQQ	ETF	57.875	58.625	57.6875	58.0938	3276500.0
2001-01-10 14:00:00	QQQ	ETF	58.25	59.0	57.875	59.0	3425800.0
2001-01-10 14:30:00	QQQ	ETF	58.9688	59.2188	58.3125	58.5	3369500.0
2001-01-10 15:00:00	QQQ	ETF	58.5938	59.625	58.5	59.5	4881200.0
2001-01-10 15:30:00	QQQ	ETF	59.5	60.375	59.4375	60.125	8690300.0
2001-01-10 16:00:00	QQQ	ETF	60.1875	60.375	58.25	60.1875	1744200.0
2001-01-10 16:30:00	QQQ	ETF	60.125	60.5	59.5	59.8125	227100.0
2001-01-10 17:00:00	QQQ	ETF	59.75	59.8125	59.0	59.4375	272900.0
2001-01-10 17:30:00	QQQ	ETF	59.625	60.25	59.5	59.875	123100.0
2001-01-10 18:00:00	QQQ	ETF	60.0	60.0	59.5	59.5	67800.0
2001-01-10 09:30:00	IWM	ETF	45.6875	46.1719	45.6875	46.0625	49800.0
2001-01-10 10:00:00	IWM	ETF	46.1094	46.4844	46.1094	46.4844	24800.0
2001-01-10 10:30:00	IWM	ETF	46.6719	46.6719	46.6719	46.6719	400.0
2001-01-10 11:00:00	IWM	ETF	46.7031	46.9062	46.6875	46.8125	475000.0
2001-01-10 11:30:00	IWM	ETF	46.9688	47.0156	46.8281	46.8281	16400.0
2001-01-10 12:00:00	IWM	ETF	46.8438	46.8438	46.5938	46.75	15800.0
2001-01-10 12:30:00	IWM	ETF	46.8125	46.875	46.7656	46.7656	59000.0
2001-01-10 13:00:00	IWM	ETF	46.75	46.75	46.6562	46.75	62800.0
2001-01-10 13:30:00	IWM	ETF	46.8906	46.8906	46.7031	46.8594	52800.0
2001-01-10 14:00:00	IWM	ETF	46.8125	46.875	46.7812	46.875	22600.0
2001-01-10 14:30:00	IWM	ETF	46.9062	47.0	46.9062	47.0	23200.0
2001-01-10 15:00:00	IWM	ETF	47.0312	47.1562	47.0	47.0	1000.0
2001-01-10 15:30:00	IWM	ETF	47.25	47.5625	47.25	47.375	192800.0
2001-01-10 16:00:00	IWM	ETF	47.4688	47.5938	47.4688	47.5938	10400.0
2001-01-10 09:30:00	DIA	ETF	105.125	105.2812	104.5938	105.0	193200.0
2001-01-10 10:00:00	DIA	ETF	105.0938	105.375	104.9375	105.125	106200.0

> showing 50 of 325 rows — these rows as CSV

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