PREVIEW / etf_1hour / 2001-05-01

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-05-01.parquet
  size:    11 KB
  rows:    212

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-05-01 09:00:00	SPY	ETF	125.07	125.34	124.6	125.27	1550200.0
2001-05-01 10:00:00	SPY	ETF	125.25	125.64	124.6	125.4	1823300.0
2001-05-01 11:00:00	SPY	ETF	125.4	125.5	124.86	125.39	791400.0
2001-05-01 12:00:00	SPY	ETF	125.39	125.48	124.87	125.3	536700.0
2001-05-01 13:00:00	SPY	ETF	125.44	125.88	125.3	125.51	1072700.0
2001-05-01 14:00:00	SPY	ETF	125.65	126.5	125.48	126.5	1054800.0
2001-05-01 15:00:00	SPY	ETF	126.59	126.97	126.11	126.94	2468800.0
2001-05-01 16:00:00	SPY	ETF	126.96	127.15	125.65	127.09	429300.0
2001-05-01 17:00:00	SPY	ETF	127.2	127.2	127.03	127.1	101900.0
2001-05-01 18:00:00	SPY	ETF	127.27	127.3	127.03	127.3	300.0
2001-05-01 09:00:00	QQQ	ETF	46.2	46.3	45.75	46.0	6303800.0
2001-05-01 10:00:00	QQQ	ETF	45.98	46.34	45.4	46.06	8519900.0
2001-05-01 11:00:00	QQQ	ETF	46.05	46.09	45.63	46.0	3757900.0
2001-05-01 12:00:00	QQQ	ETF	46.05	46.1	45.6	45.95	3139900.0
2001-05-01 13:00:00	QQQ	ETF	45.93	46.5	45.88	46.2	5153900.0
2001-05-01 14:00:00	QQQ	ETF	46.22	47.3	46.1	47.3	10836400.0
2001-05-01 15:00:00	QQQ	ETF	47.3	47.9	47.0	47.85	12232200.0
2001-05-01 16:00:00	QQQ	ETF	47.9	48.4	47.79	48.27	1668100.0
2001-05-01 17:00:00	QQQ	ETF	48.2	48.31	48.05	48.25	171300.0
2001-05-01 18:00:00	QQQ	ETF	48.29	48.47	48.05	48.4	36100.0
2001-05-01 09:00:00	IWM	ETF	48.325	48.5	48.325	48.5	38600.0
2001-05-01 10:00:00	IWM	ETF	48.3	48.42	48.015	48.2	122200.0
2001-05-01 11:00:00	IWM	ETF	48.25	48.3	48.165	48.25	25800.0
2001-05-01 12:00:00	IWM	ETF	48.3	48.3	48.11	48.11	20400.0
2001-05-01 13:00:00	IWM	ETF	48.3	48.6	48.225	48.35	64000.0
2001-05-01 14:00:00	IWM	ETF	48.525	48.8	48.525	48.775	21400.0
2001-05-01 15:00:00	IWM	ETF	48.85	49.1	48.8	49.1	262200.0
2001-05-01 16:00:00	IWM	ETF	49.1	49.1	49.1	49.1	200.0
2001-05-01 09:00:00	DIA	ETF	107.45	107.74	107.3	107.74	499000.0
2001-05-01 10:00:00	DIA	ETF	107.7	108.25	107.3	108.2	553200.0
2001-05-01 11:00:00	DIA	ETF	108.25	108.4	107.8	108.16	279500.0
2001-05-01 12:00:00	DIA	ETF	108.17	108.3	107.85	108.3	111200.0
2001-05-01 13:00:00	DIA	ETF	108.3	108.73	108.22	108.49	349600.0
2001-05-01 14:00:00	DIA	ETF	108.41	109.0	108.4	108.96	456200.0
2001-05-01 15:00:00	DIA	ETF	108.9	109.1	108.6	108.85	1133100.0
2001-05-01 16:00:00	DIA	ETF	108.95	109.0	108.7	108.9	246800.0
2001-05-01 17:00:00	DIA	ETF	109.0	109.0	109.0	109.0	10000.0

> showing 37 of 212 rows — these rows as CSV

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