PREVIEW / etf_1hour / 2001-06-13

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-06-13.parquet
  size:    11 KB
  rows:    217

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-06-13 09:00:00	SPY	ETF	126.17	126.49	125.62	126.32	1123500.0
2001-06-13 10:00:00	SPY	ETF	126.3	126.37	125.53	126.19	1350400.0
2001-06-13 11:00:00	SPY	ETF	126.19	126.58	126.12	126.3	799200.0
2001-06-13 12:00:00	SPY	ETF	126.33	126.39	125.95	126.03	954300.0
2001-06-13 13:00:00	SPY	ETF	126.03	126.07	125.45	125.49	505200.0
2001-06-13 14:00:00	SPY	ETF	125.5	125.6	125.04	125.13	1052300.0
2001-06-13 15:00:00	SPY	ETF	125.2	125.22	124.67	124.74	1285200.0
2001-06-13 16:00:00	SPY	ETF	124.76	124.85	123.6	124.65	372900.0
2001-06-13 17:00:00	SPY	ETF	124.95	124.95	124.95	124.95	100.0
2001-06-13 18:00:00	SPY	ETF	124.9	124.9	124.9	124.9	200.0
2001-06-13 09:00:00	QQQ	ETF	46.27	46.75	45.72	46.6	12045800.0
2001-06-13 10:00:00	QQQ	ETF	46.6	46.64	45.87	46.33	12401600.0
2001-06-13 11:00:00	QQQ	ETF	46.35	46.66	46.24	46.42	7254000.0
2001-06-13 12:00:00	QQQ	ETF	46.45	46.65	46.0	46.07	4803700.0
2001-06-13 13:00:00	QQQ	ETF	46.1	46.1	45.47	45.49	7947300.0
2001-06-13 14:00:00	QQQ	ETF	45.47	45.51	44.98	45.16	8292800.0
2001-06-13 15:00:00	QQQ	ETF	45.14	45.16	44.55	44.58	12779000.0
2001-06-13 16:00:00	QQQ	ETF	44.6	45.3	44.51	44.52	1109400.0
2001-06-13 17:00:00	QQQ	ETF	44.51	44.6	44.49	44.6	64200.0
2001-06-13 18:00:00	QQQ	ETF	44.6	44.62	44.57	44.57	8000.0
2001-06-13 09:00:00	IWM	ETF	50.625	50.825	50.5	50.825	73400.0
2001-06-13 10:00:00	IWM	ETF	50.825	50.875	50.65	50.825	33600.0
2001-06-13 11:00:00	IWM	ETF	50.9	50.995	50.68	50.8	21600.0
2001-06-13 12:00:00	IWM	ETF	50.82	51.0	50.805	50.825	219600.0
2001-06-13 13:00:00	IWM	ETF	50.825	50.825	50.77	50.82	10400.0
2001-06-13 14:00:00	IWM	ETF	50.7	50.76	50.56	50.595	312600.0
2001-06-13 15:00:00	IWM	ETF	50.6	50.6	50.2	50.33	44600.0
2001-06-13 16:00:00	IWM	ETF	50.37	50.37	50.3	50.33	40600.0
2001-06-13 09:00:00	DIA	ETF	109.75	110.15	109.42	109.85	388500.0
2001-06-13 10:00:00	DIA	ETF	109.95	110.05	109.47	109.87	313600.0
2001-06-13 11:00:00	DIA	ETF	109.86	110.25	109.81	110.05	263400.0
2001-06-13 12:00:00	DIA	ETF	110.04	110.05	109.77	109.88	81100.0
2001-06-13 13:00:00	DIA	ETF	109.86	110.09	109.6	109.7	105800.0
2001-06-13 14:00:00	DIA	ETF	109.65	109.75	109.15	109.16	575400.0
2001-06-13 15:00:00	DIA	ETF	109.35	109.35	108.76	108.84	454400.0
2001-06-13 16:00:00	DIA	ETF	108.76	109.0	107.8	107.8	78300.0

> showing 36 of 217 rows — these rows as CSV

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