PREVIEW / etf_1hour / 2001-08-08

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-08-08.parquet
  size:    11 KB
  rows:    216

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-08-08 09:00:00	SPY	ETF	120.12	120.5	120.05	120.48	783400.0
2001-08-08 10:00:00	SPY	ETF	120.45	120.98	120.23	120.94	1762800.0
2001-08-08 11:00:00	SPY	ETF	120.95	121.16	120.64	120.77	2008100.0
2001-08-08 12:00:00	SPY	ETF	120.76	120.77	120.41	120.56	854400.0
2001-08-08 13:00:00	SPY	ETF	120.54	120.58	120.01	120.07	1143600.0
2001-08-08 14:00:00	SPY	ETF	120.09	120.09	119.07	119.29	2907600.0
2001-08-08 15:00:00	SPY	ETF	119.3	119.3	118.43	118.65	3791000.0
2001-08-08 16:00:00	SPY	ETF	118.71	118.73	118.5	118.64	1090700.0
2001-08-08 17:00:00	SPY	ETF	118.5	118.5	118.5	118.5	100.0
2001-08-08 09:00:00	QQQ	ETF	41.85	42.2	41.72	42.12	7483300.0
2001-08-08 10:00:00	QQQ	ETF	42.13	42.55	41.95	42.45	12590900.0
2001-08-08 11:00:00	QQQ	ETF	42.45	42.65	42.25	42.36	6617500.0
2001-08-08 12:00:00	QQQ	ETF	42.36	42.38	41.96	42.0	5008000.0
2001-08-08 13:00:00	QQQ	ETF	42.0	42.03	41.3	41.46	8338000.0
2001-08-08 14:00:00	QQQ	ETF	41.47	41.5	40.55	40.71	16250800.0
2001-08-08 15:00:00	QQQ	ETF	40.69	40.77	40.3	40.49	15765400.0
2001-08-08 16:00:00	QQQ	ETF	40.5	42.4	40.4	40.51	1220500.0
2001-08-08 17:00:00	QQQ	ETF	40.53	40.55	40.4	40.45	57700.0
2001-08-08 18:00:00	QQQ	ETF	40.49	40.5	40.41	40.41	13900.0
2001-08-08 09:00:00	IWM	ETF	47.5	47.795	47.5	47.795	28600.0
2001-08-08 10:00:00	IWM	ETF	47.875	48.095	47.825	48.07	33200.0
2001-08-08 11:00:00	IWM	ETF	48.095	48.16	47.995	47.995	12800.0
2001-08-08 12:00:00	IWM	ETF	47.94	47.94	47.85	47.87	3000.0
2001-08-08 13:00:00	IWM	ETF	47.86	47.86	47.625	47.625	23200.0
2001-08-08 14:00:00	IWM	ETF	47.625	47.625	47.17	47.175	647200.0
2001-08-08 15:00:00	IWM	ETF	47.17	47.225	46.875	47.075	214600.0
2001-08-08 16:00:00	IWM	ETF	47.0	47.025	46.875	46.875	71800.0
2001-08-08 09:00:00	DIA	ETF	104.19	104.38	104.0	104.38	351800.0
2001-08-08 10:00:00	DIA	ETF	104.38	104.78	104.16	104.75	421000.0
2001-08-08 11:00:00	DIA	ETF	104.74	104.93	104.46	104.56	294700.0
2001-08-08 12:00:00	DIA	ETF	104.57	104.57	104.35	104.45	103000.0
2001-08-08 13:00:00	DIA	ETF	104.46	104.46	104.05	104.1	57300.0
2001-08-08 14:00:00	DIA	ETF	104.08	104.08	103.33	103.43	846700.0
2001-08-08 15:00:00	DIA	ETF	103.45	103.46	102.7	102.92	1513500.0
2001-08-08 16:00:00	DIA	ETF	102.92	103.0	102.8	102.98	267100.0

> showing 35 of 216 rows — these rows as CSV

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