PREVIEW / etf_1hour / 2008-02-27

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-02-27.parquet
  size:    98 KB
  rows:    3,271

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
2008-02-27 04:00:00	SPY	ETF	138.11	138.16	138.02	138.02	5500.0
2008-02-27 05:00:00	SPY	ETF	137.9	138.16	137.9	138.16	4300.0
2008-02-27 06:00:00	SPY	ETF	138.2	138.32	138.0	138.31	98700.0
2008-02-27 07:00:00	SPY	ETF	138.2	138.25	137.85	137.9	973600.0
2008-02-27 08:00:00	SPY	ETF	137.93	138.21	137.3	137.57	6539600.0
2008-02-27 09:00:00	SPY	ETF	137.57	138.1	137.41	138.01	18552265.0
2008-02-27 10:00:00	SPY	ETF	138.01	139.14	137.58	138.67	46461452.0
2008-02-27 11:00:00	SPY	ETF	138.67	139.06	138.52	139.02	17006404.0
2008-02-27 12:00:00	SPY	ETF	139.03	139.03	138.56	138.89	11604132.0
2008-02-27 13:00:00	SPY	ETF	138.89	139.03	138.29	138.37	13774710.0
2008-02-27 14:00:00	SPY	ETF	138.37	138.63	137.66	138.31	23122071.0
2008-02-27 15:00:00	SPY	ETF	138.3	138.6	137.99	138.12	25148033.0
2008-02-27 16:00:00	SPY	ETF	138.09	138.4	137.65	138.27	2566500.0
2008-02-27 17:00:00	SPY	ETF	138.26	138.35	138.19	138.3	607900.0
2008-02-27 18:00:00	SPY	ETF	138.3	138.3	137.92	137.96	118200.0
2008-02-27 19:00:00	SPY	ETF	137.95	137.98	137.8	137.8	36800.0
2008-02-27 06:00:00	QQQ	ETF	44.06	44.08	44.02	44.08	50200.0
2008-02-27 07:00:00	QQQ	ETF	44.04	44.08	43.89	43.9	266824.0
2008-02-27 08:00:00	QQQ	ETF	43.92	43.99	43.71	43.75	2747870.0
2008-02-27 09:00:00	QQQ	ETF	43.77	44.0	43.67	43.95	18660739.0
2008-02-27 10:00:00	QQQ	ETF	43.95	44.43	43.8	44.2	26520478.0
2008-02-27 11:00:00	QQQ	ETF	44.2	44.45	44.15	44.43	16566875.0
2008-02-27 12:00:00	QQQ	ETF	44.4399	44.46	44.21	44.37	8623325.0
2008-02-27 13:00:00	QQQ	ETF	44.36	44.42	44.09	44.15	11464333.0
2008-02-27 14:00:00	QQQ	ETF	44.14	44.29	43.88	44.27	15033138.0
2008-02-27 15:00:00	QQQ	ETF	44.2701	44.41	44.14	44.27	18943614.0
2008-02-27 16:00:00	QQQ	ETF	44.27	44.4	44.12	44.38	6124517.0
2008-02-27 17:00:00	QQQ	ETF	44.39	44.47	44.39	44.44	628899.0
2008-02-27 18:00:00	QQQ	ETF	44.43	44.44	44.35	44.35	126988.0
2008-02-27 19:00:00	QQQ	ETF	44.38	44.38	44.29	44.3	74902.0
2008-02-27 07:00:00	IWM	ETF	71.16	71.23	71.05	71.05	26900.0
2008-02-27 08:00:00	IWM	ETF	71.09	71.09	70.74	70.78	580600.0
2008-02-27 09:00:00	IWM	ETF	70.8	71.34	70.71	71.29	9747467.0
2008-02-27 10:00:00	IWM	ETF	71.29	72.24	71.23	71.8	20140868.0
2008-02-27 11:00:00	IWM	ETF	71.8	72.07	71.66	71.85	6734440.0
2008-02-27 12:00:00	IWM	ETF	71.85	72.07	71.7	71.99	10737626.0
2008-02-27 13:00:00	IWM	ETF	71.99	72.09	71.2	71.38	9893499.0
2008-02-27 14:00:00	IWM	ETF	71.37	71.4	70.75	71.29	10537991.0
2008-02-27 15:00:00	IWM	ETF	71.29	71.58	71.14	71.45	6588973.0
2008-02-27 16:00:00	IWM	ETF	71.45	71.55	71.25	71.33	9360700.0
2008-02-27 17:00:00	IWM	ETF	71.48	71.5	71.43	71.43	2007800.0
2008-02-27 18:00:00	IWM	ETF	71.43	71.43	71.29	71.29	1800.0
2008-02-27 19:00:00	IWM	ETF	71.27	71.27	71.19	71.19	700.0
2008-02-27 07:00:00	DIA	ETF	126.71	126.78	126.49	126.6	20700.0
2008-02-27 08:00:00	DIA	ETF	126.61	126.61	126.06	126.24	117800.0
2008-02-27 09:00:00	DIA	ETF	126.28	126.63	126.11	126.55	1241326.0
2008-02-27 10:00:00	DIA	ETF	126.57	127.47	126.31	127.19	3251598.0
2008-02-27 11:00:00	DIA	ETF	127.17	127.51	127.1	127.47	1422759.0
2008-02-27 12:00:00	DIA	ETF	127.47	127.57	127.19	127.37	751576.0
2008-02-27 13:00:00	DIA	ETF	127.36	127.48	126.9	126.95	1092889.0

> showing 50 of 3,271 rows — these rows as CSV

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