PREVIEW / etf_30min / 2000-07-28

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-07-28.parquet
  size:    11 KB
  rows:    272

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-28 09:30:00	SPY	ETF	145.7188	145.9062	145.0938	145.3125	463000.0
2000-07-28 10:00:00	SPY	ETF	145.375	145.4688	143.8125	144.0	371900.0
2000-07-28 10:30:00	SPY	ETF	144.0312	144.0312	142.5	142.5	574200.0
2000-07-28 11:00:00	SPY	ETF	142.5	143.1875	142.125	142.8438	750100.0
2000-07-28 11:30:00	SPY	ETF	142.875	143.5625	142.875	143.125	196900.0
2000-07-28 12:00:00	SPY	ETF	143.125	143.25	142.8125	142.9375	102900.0
2000-07-28 12:30:00	SPY	ETF	142.9688	143.2188	142.8438	143.0625	119300.0
2000-07-28 13:00:00	SPY	ETF	143.0625	143.3438	142.8125	143.3125	242200.0
2000-07-28 13:30:00	SPY	ETF	143.3125	143.4062	143.0	143.1875	317000.0
2000-07-28 14:00:00	SPY	ETF	143.125	143.25	142.5312	142.75	357800.0
2000-07-28 14:30:00	SPY	ETF	142.6875	142.7812	142.0938	142.625	506800.0
2000-07-28 15:00:00	SPY	ETF	142.625	143.0312	142.2188	142.5312	248700.0
2000-07-28 15:30:00	SPY	ETF	142.3125	142.875	141.5	142.25	1234300.0
2000-07-28 16:00:00	SPY	ETF	142.125	142.9375	142.0625	142.125	675900.0
2000-07-28 16:30:00	SPY	ETF	142.0938	142.0938	142.0938	142.0938	1600.0
2000-07-28 09:30:00	QQQ	ETF	92.1875	92.875	91.6875	91.9375	2687500.0
2000-07-28 10:00:00	QQQ	ETF	91.75	91.8438	89.375	89.5312	4705900.0
2000-07-28 10:30:00	QQQ	ETF	89.375	89.9062	87.125	87.375	4702500.0
2000-07-28 11:00:00	QQQ	ETF	87.3438	88.5	87.0312	88.0312	3780300.0
2000-07-28 11:30:00	QQQ	ETF	88.0	89.0	87.9688	88.375	2823500.0
2000-07-28 12:00:00	QQQ	ETF	88.5938	88.6875	88.0	88.2188	1099800.0
2000-07-28 12:30:00	QQQ	ETF	88.2188	88.7188	88.0625	88.3438	775100.0
2000-07-28 13:00:00	QQQ	ETF	88.3125	88.9688	88.0	88.9688	685400.0
2000-07-28 13:30:00	QQQ	ETF	88.9688	89.2188	88.5312	88.875	2179600.0
2000-07-28 14:00:00	QQQ	ETF	88.9375	88.9688	87.75	87.9375	1550400.0
2000-07-28 14:30:00	QQQ	ETF	87.75	88.1875	87.1875	87.8125	3196300.0
2000-07-28 15:00:00	QQQ	ETF	87.9062	88.375	87.25	87.6875	1880300.0
2000-07-28 15:30:00	QQQ	ETF	87.6875	88.0	86.0	86.875	5600200.0
2000-07-28 16:00:00	QQQ	ETF	86.75	87.0	86.625	87.0	564900.0
2000-07-28 16:30:00	QQQ	ETF	87.0	87.125	86.875	87.125	900.0
2000-07-28 17:00:00	QQQ	ETF	87.25	87.25	86.5	87.25	6100.0
2000-07-28 17:30:00	QQQ	ETF	86.9062	87.125	86.7812	86.7812	500.0
2000-07-28 18:00:00	QQQ	ETF	86.5	87.0	86.5	86.875	2300.0
2000-07-28 09:30:00	IWM	ETF	50.1562	50.1562	50.0469	50.0938	2000.0
2000-07-28 10:00:00	IWM	ETF	49.875	49.875	49.2188	49.2188	12800.0
2000-07-28 10:30:00	IWM	ETF	49.2188	49.2188	48.9375	48.9375	19400.0
2000-07-28 11:00:00	IWM	ETF	48.875	48.9375	48.875	48.9375	400.0
2000-07-28 11:30:00	IWM	ETF	48.8906	49.1562	48.8906	49.0312	29200.0
2000-07-28 12:00:00	IWM	ETF	49.1719	49.1719	49.0781	49.0781	600.0
2000-07-28 12:30:00	IWM	ETF	49.0938	49.2812	49.0938	49.2812	1400.0
2000-07-28 13:00:00	IWM	ETF	49.2812	49.2812	49.2812	49.2812	200.0
2000-07-28 13:30:00	IWM	ETF	49.2812	49.2812	49.2812	49.2812	2600.0
2000-07-28 14:30:00	IWM	ETF	49.0312	49.0469	49.0312	49.0469	400.0
2000-07-28 15:00:00	IWM	ETF	49.1562	49.1562	49.1562	49.1562	2200.0
2000-07-28 15:30:00	IWM	ETF	49.0312	49.0312	48.9375	48.9375	100200.0
2000-07-28 16:00:00	IWM	ETF	49.0	49.0	49.0	49.0	200.0
2000-07-28 09:30:00	DIA	ETF	106.25	106.5	106.0	106.125	83700.0
2000-07-28 10:00:00	DIA	ETF	106.125	106.3438	105.6562	105.6562	24600.0
2000-07-28 10:30:00	DIA	ETF	105.6562	105.6562	104.875	104.875	51100.0
2000-07-28 11:00:00	DIA	ETF	104.875	105.1875	104.5312	105.0625	105100.0

> showing 50 of 272 rows — these rows as CSV

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