PREVIEW / etf_30min / 2001-01-09

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-01-09.parquet
  size:    12 KB
  rows:    296

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-09 09:30:00	SPY	ETF	131.0312	131.25	130.25	130.3438	1074400.0
2001-01-09 10:00:00	SPY	ETF	130.375	131.4688	130.25	131.4688	274600.0
2001-01-09 10:30:00	SPY	ETF	131.5	131.5	130.6875	130.875	577400.0
2001-01-09 11:00:00	SPY	ETF	130.875	130.9688	130.125	130.2188	216100.0
2001-01-09 11:30:00	SPY	ETF	130.3438	130.6562	130.2188	130.5	212500.0
2001-01-09 12:00:00	SPY	ETF	130.5	130.5	130.0938	130.4375	124700.0
2001-01-09 12:30:00	SPY	ETF	130.2812	130.4375	129.6875	130.1875	437600.0
2001-01-09 13:00:00	SPY	ETF	130.0312	130.4062	129.7812	130.25	261000.0
2001-01-09 13:30:00	SPY	ETF	130.375	130.625	130.0	130.0	480000.0
2001-01-09 14:00:00	SPY	ETF	130.0	130.3125	129.625	130.1562	237200.0
2001-01-09 14:30:00	SPY	ETF	130.1875	130.7812	130.0	130.75	199000.0
2001-01-09 15:00:00	SPY	ETF	130.8125	130.8438	130.2188	130.7188	495300.0
2001-01-09 15:30:00	SPY	ETF	130.7188	130.8125	130.125	130.125	382900.0
2001-01-09 16:00:00	SPY	ETF	130.0312	130.5625	129.4062	129.875	541800.0
2001-01-09 09:30:00	QQQ	ETF	57.75	58.375	57.0312	57.6875	10106500.0
2001-01-09 10:00:00	QQQ	ETF	57.625	59.125	57.5625	59.0625	6324400.0
2001-01-09 10:30:00	QQQ	ETF	58.9688	59.125	57.75	58.125	4123900.0
2001-01-09 11:00:00	QQQ	ETF	58.1875	58.1875	57.375	57.4375	3735900.0
2001-01-09 11:30:00	QQQ	ETF	57.4375	58.125	57.4062	57.9375	3313100.0
2001-01-09 12:00:00	QQQ	ETF	57.875	58.0312	57.2812	57.5	1505800.0
2001-01-09 12:30:00	QQQ	ETF	57.5625	57.6875	56.625	57.0625	2996700.0
2001-01-09 13:00:00	QQQ	ETF	57.0625	57.625	56.75	57.4688	1905500.0
2001-01-09 13:30:00	QQQ	ETF	57.4688	58.1875	57.4062	57.5	2916900.0
2001-01-09 14:00:00	QQQ	ETF	57.5312	57.8438	57.0312	57.5	1732800.0
2001-01-09 14:30:00	QQQ	ETF	57.5	58.375	57.3438	58.25	2366800.0
2001-01-09 15:00:00	QQQ	ETF	58.25	58.4375	57.5938	58.1875	4520900.0
2001-01-09 15:30:00	QQQ	ETF	58.25	58.25	57.3125	57.4375	3481200.0
2001-01-09 16:00:00	QQQ	ETF	57.4375	57.6875	57.0	57.1875	1147900.0
2001-01-09 16:30:00	QQQ	ETF	57.125	57.3125	57.0	57.1875	35000.0
2001-01-09 17:00:00	QQQ	ETF	57.1875	57.375	57.125	57.3125	14500.0
2001-01-09 17:30:00	QQQ	ETF	57.25	57.375	57.25	57.3125	4500.0
2001-01-09 18:00:00	QQQ	ETF	57.25	57.375	57.25	57.3438	15700.0
2001-01-09 09:30:00	IWM	ETF	46.1875	46.5312	46.1875	46.2812	33600.0
2001-01-09 10:00:00	IWM	ETF	46.2188	46.5	46.2188	46.5	19200.0
2001-01-09 10:30:00	IWM	ETF	46.5625	46.5625	46.4375	46.4844	36800.0
2001-01-09 11:00:00	IWM	ETF	46.4375	46.4375	46.0	46.0	55800.0
2001-01-09 11:30:00	IWM	ETF	45.9688	46.125	45.9688	46.125	4400.0
2001-01-09 12:00:00	IWM	ETF	46.0	46.0312	45.9219	46.0312	7400.0
2001-01-09 13:00:00	IWM	ETF	45.9062	46.0938	45.8438	46.0938	31600.0
2001-01-09 13:30:00	IWM	ETF	46.0312	46.1875	45.9062	46.1875	9000.0
2001-01-09 14:00:00	IWM	ETF	46.0	46.0	45.9844	46.0	32400.0
2001-01-09 14:30:00	IWM	ETF	46.0312	46.3125	46.0312	46.3125	50600.0
2001-01-09 15:00:00	IWM	ETF	46.4062	46.4062	46.1562	46.1562	6400.0
2001-01-09 15:30:00	IWM	ETF	46.2188	46.4062	46.2188	46.4062	14200.0
2001-01-09 16:00:00	IWM	ETF	46.1875	46.1875	46.1094	46.1094	5200.0
2001-01-09 09:30:00	DIA	ETF	106.9375	106.9688	106.25	106.5	187400.0
2001-01-09 10:00:00	DIA	ETF	106.5	106.9688	106.1875	106.875	320900.0
2001-01-09 10:30:00	DIA	ETF	106.875	106.875	106.375	106.4375	46800.0
2001-01-09 11:00:00	DIA	ETF	106.5	106.5	105.5938	105.6875	77400.0
2001-01-09 11:30:00	DIA	ETF	105.6875	106.125	105.6875	106.0	65100.0

> showing 50 of 296 rows — these rows as CSV

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