PREVIEW / etf_1hour / 2004-09-27

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-09-27.parquet
  size:    24 KB
  rows:    684

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
2004-09-27 08:00:00	SPY	ETF	111.05	111.2	111.05	111.08	121800.0
2004-09-27 09:00:00	SPY	ETF	111.11	111.15	110.84	110.88	5299800.0
2004-09-27 10:00:00	SPY	ETF	110.87	110.97	110.71	110.78	5672600.0
2004-09-27 11:00:00	SPY	ETF	110.77	110.95	110.72	110.78	4068000.0
2004-09-27 12:00:00	SPY	ETF	110.8	111.2	110.77	111.15	4143900.0
2004-09-27 13:00:00	SPY	ETF	111.15	111.16	110.98	111.08	3565300.0
2004-09-27 14:00:00	SPY	ETF	111.09	111.11	110.67	110.9	4775400.0
2004-09-27 15:00:00	SPY	ETF	110.9	111.03	110.58	110.67	8605400.0
2004-09-27 16:00:00	SPY	ETF	110.68	110.895	110.63	110.8	1372100.0
2004-09-27 17:00:00	SPY	ETF	110.82	110.82	110.68	110.7	329600.0
2004-09-27 18:00:00	SPY	ETF	110.7	110.75	110.7	110.74	166800.0
2004-09-27 19:00:00	SPY	ETF	110.74	110.76	110.74	110.74	6500.0
2004-09-27 08:00:00	QQQ	ETF	34.65	34.71	34.63	34.64	82000.0
2004-09-27 09:00:00	QQQ	ETF	34.65	34.67	34.48	34.53	15923800.0
2004-09-27 10:00:00	QQQ	ETF	34.53	34.7	34.49	34.61	18022100.0
2004-09-27 11:00:00	QQQ	ETF	34.61	34.71	34.53	34.559	8341100.0
2004-09-27 12:00:00	QQQ	ETF	34.56	34.739	34.54	34.69	9187100.0
2004-09-27 13:00:00	QQQ	ETF	34.69	34.69	34.58	34.627	5932700.0
2004-09-27 14:00:00	QQQ	ETF	34.62	34.67	34.48	34.58	10828200.0
2004-09-27 15:00:00	QQQ	ETF	34.58	34.64	34.38	34.44	13256200.0
2004-09-27 16:00:00	QQQ	ETF	34.44	34.549	34.41	34.53	2690200.0
2004-09-27 17:00:00	QQQ	ETF	34.522	34.534	34.49	34.51	92900.0
2004-09-27 18:00:00	QQQ	ETF	34.51	34.53	34.5	34.52	17600.0
2004-09-27 19:00:00	QQQ	ETF	34.52	34.52	34.51	34.51	4100.0
2004-09-27 08:00:00	IWM	ETF	56.105	56.105	56.105	56.105	4000.0
2004-09-27 09:00:00	IWM	ETF	56.125	56.2	55.625	55.695	4496400.0
2004-09-27 10:00:00	IWM	ETF	55.69	55.83	55.57	55.72	2540200.0
2004-09-27 11:00:00	IWM	ETF	55.71	55.82	55.665	55.715	922200.0
2004-09-27 12:00:00	IWM	ETF	55.7	55.985	55.7	55.975	1681800.0
2004-09-27 13:00:00	IWM	ETF	55.985	56.02	55.835	55.875	687400.0
2004-09-27 14:00:00	IWM	ETF	55.88	55.905	55.7	55.835	1569000.0
2004-09-27 15:00:00	IWM	ETF	55.85	55.885	55.545	55.645	2406000.0
2004-09-27 16:00:00	IWM	ETF	55.635	55.8002	55.625	55.795	686600.0
2004-09-27 18:00:00	IWM	ETF	55.73	55.73	55.73	55.73	200.0
2004-09-27 08:00:00	DIA	ETF	100.46	100.48	100.4	100.42	7100.0
2004-09-27 09:00:00	DIA	ETF	100.42	100.43	100.24	100.24	629500.0
2004-09-27 10:00:00	DIA	ETF	100.24	100.34	100.13	100.22	1031800.0
2004-09-27 11:00:00	DIA	ETF	100.22	100.3	100.14	100.19	391800.0
2004-09-27 12:00:00	DIA	ETF	100.2	100.58	100.18	100.51	563500.0
2004-09-27 13:00:00	DIA	ETF	100.52	100.54	100.39	100.45	355300.0
2004-09-27 14:00:00	DIA	ETF	100.44	100.48	100.18	100.32	445600.0
2004-09-27 15:00:00	DIA	ETF	100.34	100.42	100.0	100.08	1094600.0
2004-09-27 16:00:00	DIA	ETF	100.07	100.17	100.03	100.17	201500.0
2004-09-27 17:00:00	DIA	ETF	100.12	100.12	100.12	100.12	200.0
2004-09-27 09:00:00	TLT	ETF	89.6	89.69	89.59	89.62	222700.0
2004-09-27 10:00:00	TLT	ETF	89.64	89.84	89.57	89.73	588700.0
2004-09-27 11:00:00	TLT	ETF	89.74	89.79	89.7	89.78	43800.0
2004-09-27 12:00:00	TLT	ETF	89.78	89.78	89.67	89.74	26300.0
2004-09-27 13:00:00	TLT	ETF	89.7	89.85	89.67	89.82	62400.0
2004-09-27 14:00:00	TLT	ETF	89.79	89.89	89.74	89.75	115600.0

> showing 50 of 684 rows — these rows as CSV

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