PREVIEW / etf_1hour / 2010-09-10

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-09-10.parquet
  size:    154 KB
  rows:    4,800

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
2010-09-10 04:00:00	SPY	ETF	111.09	111.09	111.04	111.07	1000.0
2010-09-10 05:00:00	SPY	ETF	111.11	111.11	110.91	110.91	450.0
2010-09-10 06:00:00	SPY	ETF	110.95	111.13	110.95	111.11	75015.0
2010-09-10 07:00:00	SPY	ETF	111.12	111.35	111.11	111.26	1843857.0
2010-09-10 08:00:00	SPY	ETF	111.25	111.29	111.07	111.08	2851406.0
2010-09-10 09:00:00	SPY	ETF	111.09	111.41	110.87	111.25	16637533.0
2010-09-10 10:00:00	SPY	ETF	111.25	111.56	111.15	111.48	17649837.0
2010-09-10 11:00:00	SPY	ETF	111.48	111.5	111.05	111.13	14874913.0
2010-09-10 12:00:00	SPY	ETF	111.13	111.32	111.0	111.225	10083996.0
2010-09-10 13:00:00	SPY	ETF	111.23	111.42	111.21	111.327	12606264.0
2010-09-10 14:00:00	SPY	ETF	111.325	111.56	111.29	111.44	11877715.0
2010-09-10 15:00:00	SPY	ETF	111.45	111.61	111.36	111.52	25253317.0
2010-09-10 16:00:00	SPY	ETF	111.52	111.58	111.055	111.57	10309875.0
2010-09-10 17:00:00	SPY	ETF	111.57	111.66	111.51	111.57	86730.0
2010-09-10 18:00:00	SPY	ETF	111.56	111.58	111.54	111.57	34498.0
2010-09-10 19:00:00	SPY	ETF	111.57	111.62	111.55	111.6	32297.0
2010-09-10 04:00:00	QQQ	ETF	46.55	46.57	46.47	46.48	16935.0
2010-09-10 05:00:00	QQQ	ETF	46.46	46.46	46.45	46.45	9500.0
2010-09-10 06:00:00	QQQ	ETF	46.5	46.5	46.5	46.5	200.0
2010-09-10 07:00:00	QQQ	ETF	46.53	46.6	46.53	46.58	176765.0
2010-09-10 08:00:00	QQQ	ETF	46.6	46.6	46.51	46.51	1944634.0
2010-09-10 09:00:00	QQQ	ETF	46.51	46.63	46.33	46.52	8820611.0
2010-09-10 10:00:00	QQQ	ETF	46.52	46.67	46.43	46.59	10759925.0
2010-09-10 11:00:00	QQQ	ETF	46.59	46.6	46.33	46.365	5997046.0
2010-09-10 12:00:00	QQQ	ETF	46.37	46.4	46.25	46.3501	4811353.0
2010-09-10 13:00:00	QQQ	ETF	46.3537	46.44	46.33	46.41	4944753.0
2010-09-10 14:00:00	QQQ	ETF	46.41	46.63	46.4	46.56	7404050.0
2010-09-10 15:00:00	QQQ	ETF	46.57	46.64	46.5	46.58	9355495.0
2010-09-10 16:00:00	QQQ	ETF	46.59	46.65	46.315	46.58	6734845.0
2010-09-10 17:00:00	QQQ	ETF	46.59	46.63	46.58	46.58	17150.0
2010-09-10 18:00:00	QQQ	ETF	46.62	46.62	46.57	46.57	3605.0
2010-09-10 19:00:00	QQQ	ETF	46.6	46.63	46.58	46.62	12000.0
2010-09-10 04:00:00	IWM	ETF	63.68	63.68	63.68	63.68	100.0
2010-09-10 06:00:00	IWM	ETF	63.68	63.7	63.68	63.7	200.0
2010-09-10 07:00:00	IWM	ETF	63.78	63.86	63.72	63.86	12215.0
2010-09-10 08:00:00	IWM	ETF	63.85	63.87	63.74	63.75	873551.0
2010-09-10 09:00:00	IWM	ETF	63.77	64.1	63.53	63.9002	5560529.0
2010-09-10 10:00:00	IWM	ETF	63.91	64.11	63.75	63.96	8262051.0
2010-09-10 11:00:00	IWM	ETF	63.96	63.99	63.49	63.57	4046500.0
2010-09-10 12:00:00	IWM	ETF	63.56	63.62	63.35	63.48	2872919.0
2010-09-10 13:00:00	IWM	ETF	63.48	63.67	63.3772	63.61	5452118.0
2010-09-10 14:00:00	IWM	ETF	63.62	63.96	63.58	63.8535	5557390.0
2010-09-10 15:00:00	IWM	ETF	63.86	63.905	63.63	63.73	5505510.0
2010-09-10 16:00:00	IWM	ETF	63.73	63.7985	63.5	63.5515	3153320.0
2010-09-10 17:00:00	IWM	ETF	63.69	63.75	63.68	63.68	11000.0
2010-09-10 18:00:00	IWM	ETF	63.74	63.74	63.74	63.74	200.0
2010-09-10 19:00:00	IWM	ETF	63.72	63.72	63.71	63.71	1000.0
2010-09-10 07:00:00	DIA	ETF	104.43	104.5	104.43	104.5	12200.0
2010-09-10 08:00:00	DIA	ETF	104.2691	104.5	104.2691	104.36	436513.0
2010-09-10 09:00:00	DIA	ETF	104.39	104.59	104.15	104.45	562207.0

> showing 50 of 4,800 rows — these rows as CSV

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