PREVIEW / etf_30min / 2000-01-11

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-01-11.parquet
  size:    10 KB
  rows:    232

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-11 09:30:00	SPY	ETF	145.8125	145.9688	145.375	145.9062	1007400.0
2000-01-11 10:00:00	SPY	ETF	145.8438	146.0	145.25	145.4688	934900.0
2000-01-11 10:30:00	SPY	ETF	145.5	145.9688	145.3438	145.75	301600.0
2000-01-11 11:00:00	SPY	ETF	145.9375	146.0938	145.5625	145.6875	268700.0
2000-01-11 11:30:00	SPY	ETF	145.8125	145.8125	145.3125	145.375	695900.0
2000-01-11 12:00:00	SPY	ETF	145.3125	145.6562	145.1875	145.4688	445200.0
2000-01-11 12:30:00	SPY	ETF	145.4062	145.5	144.9688	145.0	421000.0
2000-01-11 13:00:00	SPY	ETF	145.0	145.3125	144.7188	145.125	288400.0
2000-01-11 13:30:00	SPY	ETF	145.125	145.3438	144.9062	145.3438	193600.0
2000-01-11 14:00:00	SPY	ETF	145.3438	145.5625	145.0	145.125	496500.0
2000-01-11 14:30:00	SPY	ETF	145.0	145.3125	144.375	144.375	255700.0
2000-01-11 15:00:00	SPY	ETF	144.4062	144.6875	144.0625	144.125	807500.0
2000-01-11 15:30:00	SPY	ETF	144.0625	144.1875	143.5	144.0938	1060400.0
2000-01-11 16:00:00	SPY	ETF	143.9375	144.3438	143.7812	144.3125	122000.0
2000-01-11 17:00:00	SPY	ETF	144.5	144.5	144.5	144.5	70000.0
2000-01-11 09:30:00	QQQ	ETF	91.75	92.6875	91.5625	92.6562	3177200.0
2000-01-11 10:00:00	QQQ	ETF	92.6562	92.875	91.5781	91.875	2117000.0
2000-01-11 10:30:00	QQQ	ETF	91.75	92.3594	91.6562	92.25	1591000.0
2000-01-11 11:00:00	QQQ	ETF	92.3125	92.7812	92.0938	92.2969	1565600.0
2000-01-11 11:30:00	QQQ	ETF	92.2812	92.5	91.4375	91.5	2354000.0
2000-01-11 12:00:00	QQQ	ETF	91.4375	92.0	91.375	91.75	1741600.0
2000-01-11 12:30:00	QQQ	ETF	91.9688	91.9688	90.5	90.5	3219800.0
2000-01-11 13:00:00	QQQ	ETF	90.5	91.1875	90.0	90.9375	2655200.0
2000-01-11 13:30:00	QQQ	ETF	90.9375	91.3594	90.6562	91.25	1295600.0
2000-01-11 14:00:00	QQQ	ETF	91.3594	91.75	91.1562	91.1875	2283400.0
2000-01-11 14:30:00	QQQ	ETF	91.1406	91.25	90.1875	90.4375	1650200.0
2000-01-11 15:00:00	QQQ	ETF	90.1875	90.2188	89.375	89.4375	2714200.0
2000-01-11 15:30:00	QQQ	ETF	89.4375	89.5	87.625	88.2812	4656800.0
2000-01-11 16:00:00	QQQ	ETF	88.25	88.4375	88.0156	88.375	1167200.0
2000-01-11 16:30:00	QQQ	ETF	88.25	88.625	87.0	88.5	70000.0
2000-01-11 17:00:00	QQQ	ETF	88.625	88.75	87.5	87.5	62600.0
2000-01-11 17:30:00	QQQ	ETF	88.0	88.1875	87.5	87.875	6200.0
2000-01-11 18:00:00	QQQ	ETF	87.625	88.0	87.5	88.0	2600.0
2000-01-11 09:30:00	DIA	ETF	115.1562	116.125	115.1562	116.0	339300.0
2000-01-11 10:00:00	DIA	ETF	116.1875	116.2188	115.7812	115.9375	270300.0
2000-01-11 10:30:00	DIA	ETF	116.0938	116.4688	115.9062	116.4375	24800.0
2000-01-11 11:00:00	DIA	ETF	116.5	116.75	116.25	116.4062	57600.0
2000-01-11 11:30:00	DIA	ETF	116.4688	116.4688	115.875	116.0312	89500.0
2000-01-11 12:00:00	DIA	ETF	116.1562	116.4375	116.0625	116.3438	14000.0
2000-01-11 12:30:00	DIA	ETF	116.3438	116.3438	115.7812	115.7812	30400.0
2000-01-11 13:00:00	DIA	ETF	115.9688	116.3125	115.6875	116.0938	310100.0
2000-01-11 13:30:00	DIA	ETF	116.125	116.2812	115.9375	116.0625	27900.0
2000-01-11 14:00:00	DIA	ETF	116.125	116.375	116.0	116.0	32300.0
2000-01-11 14:30:00	DIA	ETF	115.9688	116.25	115.5	115.625	31400.0
2000-01-11 15:00:00	DIA	ETF	115.625	115.9375	115.5	115.625	91400.0
2000-01-11 15:30:00	DIA	ETF	115.375	115.6875	115.0938	115.125	321500.0
2000-01-11 16:00:00	DIA	ETF	115.0312	115.1875	115.0312	115.125	14000.0

> showing 47 of 232 rows — these rows as CSV

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