PREVIEW / etf_1hour / 2006-08-22

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-08-22.parquet
  size:    50 KB
  rows:    1,584

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
2006-08-22 04:00:00	SPY	ETF	130.42	130.42	130.35	130.35	4800.0
2006-08-22 05:00:00	SPY	ETF	130.25	130.29	130.21	130.21	4000.0
2006-08-22 06:00:00	SPY	ETF	130.09	130.09	129.96	130.03	6000.0
2006-08-22 07:00:00	SPY	ETF	130.02	130.12	129.91	129.91	96600.0
2006-08-22 08:00:00	SPY	ETF	129.9	130.14	129.85	130.01	1336400.0
2006-08-22 09:00:00	SPY	ETF	130.04	130.35	129.9	130.23	7193000.0
2006-08-22 10:00:00	SPY	ETF	130.24	130.44	130.1	130.38	6430100.0
2006-08-22 11:00:00	SPY	ETF	130.39	130.52	130.28	130.36	5623600.0
2006-08-22 12:00:00	SPY	ETF	130.36	130.41	130.27	130.37	3705200.0
2006-08-22 13:00:00	SPY	ETF	130.36	130.36	129.75	129.92	12791000.0
2006-08-22 14:00:00	SPY	ETF	129.94	130.08	129.68	130.06	8495600.0
2006-08-22 15:00:00	SPY	ETF	130.06	130.27	130.06	130.13	10393300.0
2006-08-22 16:00:00	SPY	ETF	130.14	130.25	130.08	130.1	1010100.0
2006-08-22 17:00:00	SPY	ETF	130.12	130.16	130.12	130.15	1700.0
2006-08-22 18:00:00	SPY	ETF	130.13	130.13	130.13	130.13	500.0
2006-08-22 19:00:00	SPY	ETF	130.14	130.14	130.14	130.14	10000.0
2006-08-22 09:00:00	QQQ	ETF	38.36	38.64	38.35	38.6	10864300.0
2006-08-22 10:00:00	QQQ	ETF	38.6	38.72	38.55	38.67	17307200.0
2006-08-22 11:00:00	QQQ	ETF	38.67	38.81	38.6	38.72	13381800.0
2006-08-22 12:00:00	QQQ	ETF	38.72	38.73	38.6	38.65	9542300.0
2006-08-22 13:00:00	QQQ	ETF	38.65	38.65	38.26	38.39	19013400.0
2006-08-22 14:00:00	QQQ	ETF	38.39	38.47	38.2	38.47	13218400.0
2006-08-22 15:00:00	QQQ	ETF	38.47	38.52	38.41	38.42	11593800.0
2006-08-22 07:00:00	IWM	ETF	69.82	70.1	69.82	70.1	200.0
2006-08-22 08:00:00	IWM	ETF	69.97	70.26	69.97	70.2	150900.0
2006-08-22 09:00:00	IWM	ETF	70.18	70.35	69.97	70.28	2684600.0
2006-08-22 10:00:00	IWM	ETF	70.28	70.43	70.11	70.38	3917700.0
2006-08-22 11:00:00	IWM	ETF	70.37	70.62	70.29	70.53	2624500.0
2006-08-22 12:00:00	IWM	ETF	70.53	70.6	70.43	70.57	1998000.0
2006-08-22 13:00:00	IWM	ETF	70.57	70.57	69.99	70.16	5496700.0
2006-08-22 14:00:00	IWM	ETF	70.16	70.33	70.0	70.32	2070400.0
2006-08-22 15:00:00	IWM	ETF	70.33	70.44	70.3	70.42	3366600.0
2006-08-22 16:00:00	IWM	ETF	70.43	70.48	70.38	70.42	165900.0
2006-08-22 17:00:00	IWM	ETF	70.38	70.4	70.37	70.4	12500.0
2006-08-22 18:00:00	IWM	ETF	70.43	70.43	70.43	70.43	200.0
2006-08-22 07:00:00	DIA	ETF	113.28	113.28	113.28	113.28	100.0
2006-08-22 08:00:00	DIA	ETF	113.41	113.47	113.27	113.46	6900.0
2006-08-22 09:00:00	DIA	ETF	113.39	113.73	113.23	113.58	588000.0
2006-08-22 10:00:00	DIA	ETF	113.58	113.75	113.45	113.62	681500.0
2006-08-22 11:00:00	DIA	ETF	113.62	113.7	113.52	113.54	366100.0
2006-08-22 12:00:00	DIA	ETF	113.54	113.54	113.43	113.47	196500.0
2006-08-22 13:00:00	DIA	ETF	113.47	113.47	112.93	113.12	1058900.0
2006-08-22 14:00:00	DIA	ETF	113.12	113.21	112.96	113.2	535300.0
2006-08-22 15:00:00	DIA	ETF	113.21	113.43	113.21	113.32	478400.0
2006-08-22 16:00:00	DIA	ETF	113.32	113.35	113.2	113.24	9900.0
2006-08-22 18:00:00	DIA	ETF	113.3	113.3	113.3	113.3	100.0
2006-08-22 07:00:00	GLD	ETF	62.2	62.2	62.2	62.2	500.0
2006-08-22 08:00:00	GLD	ETF	62.1	62.2	61.82	61.96	158600.0
2006-08-22 09:00:00	GLD	ETF	61.91	62.1	61.8	61.98	575600.0
2006-08-22 10:00:00	GLD	ETF	62.0	62.04	61.61	61.84	1018800.0

> showing 50 of 1,584 rows — these rows as CSV

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