PREVIEW / etf_1hour / 2000-10-06

all etf 1-hour files

  file:    by_date/etf_1hour/2000/2000-10-06.parquet
  size:    9 KB
  rows:    170

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-10-06 09:00:00	SPY	ETF	143.875	144.625	143.875	144.125	694600.0
2000-10-06 10:00:00	SPY	ETF	144.1562	144.3125	141.375	141.875	1463200.0
2000-10-06 11:00:00	SPY	ETF	141.8438	142.4375	141.5	141.9375	1126300.0
2000-10-06 12:00:00	SPY	ETF	141.8438	142.2812	141.5312	141.8125	1454700.0
2000-10-06 13:00:00	SPY	ETF	141.875	141.9062	140.875	141.4062	1123900.0
2000-10-06 14:00:00	SPY	ETF	141.375	141.7188	140.5	140.8438	1194600.0
2000-10-06 15:00:00	SPY	ETF	140.6875	141.2188	139.75	141.0	2407500.0
2000-10-06 16:00:00	SPY	ETF	141.0938	141.25	141.0	141.0625	335700.0
2000-10-06 09:00:00	QQQ	ETF	85.5625	86.5625	85.125	85.3125	2523300.0
2000-10-06 10:00:00	QQQ	ETF	85.375	85.875	82.8125	83.4375	7592600.0
2000-10-06 11:00:00	QQQ	ETF	83.0625	84.125	82.625	83.4375	4788500.0
2000-10-06 12:00:00	QQQ	ETF	83.375	83.9375	83.0	83.125	2168600.0
2000-10-06 13:00:00	QQQ	ETF	83.125	83.6875	82.3438	83.375	5734800.0
2000-10-06 14:00:00	QQQ	ETF	83.3438	83.5	81.8125	82.0938	4332700.0
2000-10-06 15:00:00	QQQ	ETF	82.1875	83.0	81.25	82.7188	7768600.0
2000-10-06 16:00:00	QQQ	ETF	82.625	83.0	82.25	82.75	1195700.0
2000-10-06 17:00:00	QQQ	ETF	83.0	83.0625	82.75	83.0	6100.0
2000-10-06 18:00:00	QQQ	ETF	82.5625	83.0	82.5625	83.0	400.0
2000-10-06 09:00:00	IWM	ETF	50.1562	50.1562	50.125	50.125	8000.0
2000-10-06 10:00:00	IWM	ETF	50.0	50.0	49.4375	49.4375	4000.0
2000-10-06 11:00:00	IWM	ETF	49.4375	49.4688	49.2812	49.3125	1800.0
2000-10-06 12:00:00	IWM	ETF	49.2812	49.4062	49.2812	49.3125	4200.0
2000-10-06 13:00:00	IWM	ETF	49.1875	49.2188	49.0	49.0156	28800.0
2000-10-06 14:00:00	IWM	ETF	49.25	49.25	48.9375	48.9375	5200.0
2000-10-06 15:00:00	IWM	ETF	48.9062	49.0781	48.7812	49.0781	133400.0
2000-10-06 16:00:00	IWM	ETF	48.8438	48.8438	48.8438	48.8438	200.0
2000-10-06 09:00:00	DIA	ETF	107.25	107.875	107.25	107.625	154700.0
2000-10-06 10:00:00	DIA	ETF	107.75	107.9688	106.0938	106.375	155400.0
2000-10-06 11:00:00	DIA	ETF	106.3125	106.6875	106.2812	106.5312	69800.0
2000-10-06 12:00:00	DIA	ETF	106.4375	106.7812	106.3125	106.3438	49700.0
2000-10-06 13:00:00	DIA	ETF	106.375	106.8125	105.9062	106.2188	294800.0
2000-10-06 14:00:00	DIA	ETF	106.25	106.4062	105.5625	105.8125	141800.0
2000-10-06 15:00:00	DIA	ETF	105.8125	106.2188	105.2188	106.125	423100.0
2000-10-06 16:00:00	DIA	ETF	105.9688	106.1875	105.9688	106.1875	17400.0

> showing 34 of 170 rows — these rows as CSV

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