PREVIEW / etf_1hour / 2010-05-24

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-05-24.parquet
  size:    167 KB
  rows:    5,100

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-05-24 04:00:00	SPY	ETF	108.51	108.57	108.25	108.34	17686.0
2010-05-24 05:00:00	SPY	ETF	108.45	108.56	108.08	108.16	39000.0
2010-05-24 06:00:00	SPY	ETF	108.1	108.1	107.53	107.71	131754.0
2010-05-24 07:00:00	SPY	ETF	107.78	108.17	107.67	108.0	2097549.0
2010-05-24 08:00:00	SPY	ETF	107.98	109.26	107.54	108.49	4644304.0
2010-05-24 09:00:00	SPY	ETF	108.48	109.03	108.17	108.38	48011712.0
2010-05-24 10:00:00	SPY	ETF	108.3819	109.22	108.11	108.88	53509288.0
2010-05-24 11:00:00	SPY	ETF	108.88	109.16	108.55	109.06	23735675.0
2010-05-24 12:00:00	SPY	ETF	109.06	109.39	108.92	109.27	18798472.0
2010-05-24 13:00:00	SPY	ETF	109.27	109.37	108.58	108.8	21470135.0
2010-05-24 14:00:00	SPY	ETF	108.8	108.99	108.46	108.55	25472516.0
2010-05-24 15:00:00	SPY	ETF	108.55	108.69	107.61	107.7201	54434823.0
2010-05-24 16:00:00	SPY	ETF	107.73	109.12	107.17	107.33	13800509.0
2010-05-24 17:00:00	SPY	ETF	107.34	107.39	107.06	107.16	384622.0
2010-05-24 18:00:00	SPY	ETF	107.16	107.7	106.94	107.15	461376.0
2010-05-24 19:00:00	SPY	ETF	107.15	107.16	106.83	106.91	284475.0
2010-05-24 20:00:00	SPY	ETF	106.9	106.9	106.9	106.9	100.0
2010-05-24 04:00:00	QQQ	ETF	44.59	44.59	44.53	44.53	9999.0
2010-05-24 05:00:00	QQQ	ETF	44.61	44.61	44.47	44.47	1222.0
2010-05-24 06:00:00	QQQ	ETF	44.37	44.37	44.26	44.26	2649.0
2010-05-24 07:00:00	QQQ	ETF	44.36	44.54	44.3	44.45	251121.0
2010-05-24 08:00:00	QQQ	ETF	44.44	44.78	44.44	44.78	1530523.0
2010-05-24 09:00:00	QQQ	ETF	44.77	45.15	44.71	44.8919	20557877.0
2010-05-24 10:00:00	QQQ	ETF	44.9	45.28	44.79	45.09	18166553.0
2010-05-24 11:00:00	QQQ	ETF	45.09	45.19	44.96	45.13	7804092.0
2010-05-24 12:00:00	QQQ	ETF	45.13	45.325	45.05	45.28	7478276.0
2010-05-24 13:00:00	QQQ	ETF	45.28	45.32	45.08	45.1419	7746926.0
2010-05-24 14:00:00	QQQ	ETF	45.14	45.2599	45.07	45.15	5989213.0
2010-05-24 15:00:00	QQQ	ETF	45.14	45.17	44.64	44.66	18967592.0
2010-05-24 16:00:00	QQQ	ETF	44.66	45.0243	44.48	44.52	7969295.0
2010-05-24 17:00:00	QQQ	ETF	44.52	44.55	44.44	44.49	66473.0
2010-05-24 18:00:00	QQQ	ETF	44.49	44.49	44.41	44.48	66531.0
2010-05-24 19:00:00	QQQ	ETF	44.48	44.48	44.38	44.4	53760.0
2010-05-24 04:00:00	IWM	ETF	64.65	64.65	64.58	64.58	3326.0
2010-05-24 05:00:00	IWM	ETF	64.45	64.45	64.45	64.45	422.0
2010-05-24 06:00:00	IWM	ETF	64.29	64.29	64.09	64.12	6403.0
2010-05-24 07:00:00	IWM	ETF	64.23	64.53	64.18	64.42	170320.0
2010-05-24 08:00:00	IWM	ETF	64.4	65.34	64.21	64.87	989234.0
2010-05-24 09:00:00	IWM	ETF	64.87	65.23	64.41	64.59	13007732.0
2010-05-24 10:00:00	IWM	ETF	64.61	65.41	64.38	64.97	12198780.0
2010-05-24 11:00:00	IWM	ETF	64.96	65.26	64.67	65.13	8818472.0
2010-05-24 12:00:00	IWM	ETF	65.12	65.37	64.92	65.05	5293713.0
2010-05-24 13:00:00	IWM	ETF	65.05	65.16	64.6804	64.86	4684151.0
2010-05-24 14:00:00	IWM	ETF	64.87	65.15	64.75	64.81	5402922.0
2010-05-24 15:00:00	IWM	ETF	64.8	65.05	64.14	64.2	14062496.0
2010-05-24 16:00:00	IWM	ETF	64.2	64.9999	63.89	64.0	7250139.0
2010-05-24 17:00:00	IWM	ETF	64.0	64.08	63.83	63.97	379262.0
2010-05-24 18:00:00	IWM	ETF	63.9	64.18	63.83	63.89	13921.0
2010-05-24 19:00:00	IWM	ETF	63.83	63.92	63.73	63.79	18552.0
2010-05-24 06:00:00	DIA	ETF	100.87	100.87	100.85	100.85	200.0

> showing 50 of 5,100 rows — these rows as CSV

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