PREVIEW / etf_1hour / 2012-05-08

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-05-08.parquet
  size:    191 KB
  rows:    5,908

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
2012-05-08 04:00:00	SPY	ETF	136.62	136.97	136.21	136.31	33891.0
2012-05-08 05:00:00	SPY	ETF	136.31	136.53	136.28	136.36	50790.0
2012-05-08 06:00:00	SPY	ETF	136.37	136.48	136.25	136.25	73770.0
2012-05-08 07:00:00	SPY	ETF	136.3	136.96	136.28	136.94	379353.0
2012-05-08 08:00:00	SPY	ETF	136.95	136.99	136.23	136.56	1830891.0
2012-05-08 09:00:00	SPY	ETF	136.56	136.58	136.0	136.23	21629905.0
2012-05-08 10:00:00	SPY	ETF	136.24	136.44	135.23	135.39	38166038.0
2012-05-08 11:00:00	SPY	ETF	135.39	135.71	134.92	135.59	38107900.0
2012-05-08 12:00:00	SPY	ETF	135.58	135.6	135.155	135.18	16873052.0
2012-05-08 13:00:00	SPY	ETF	135.1893	135.73	135.17	135.66	15065496.0
2012-05-08 14:00:00	SPY	ETF	135.67	136.12	135.45	136.01	19701362.0
2012-05-08 15:00:00	SPY	ETF	136.01	136.77	135.9	136.52	42157354.0
2012-05-08 16:00:00	SPY	ETF	136.51	137.1261	135.1599	136.52	15971818.0
2012-05-08 17:00:00	SPY	ETF	136.52	136.55	136.48	136.5	707293.0
2012-05-08 18:00:00	SPY	ETF	136.49	136.49	136.33	136.36	89645.0
2012-05-08 19:00:00	SPY	ETF	136.36	136.37	136.2	136.3	168631.0
2012-05-08 04:00:00	QQQ	ETF	64.54	64.54	64.38	64.38	292.0
2012-05-08 06:00:00	QQQ	ETF	64.36	64.39	64.31	64.31	400.0
2012-05-08 07:00:00	QQQ	ETF	64.36	64.6	64.36	64.59	23745.0
2012-05-08 08:00:00	QQQ	ETF	64.63	64.65	64.27	64.47	238499.0
2012-05-08 09:00:00	QQQ	ETF	64.43	64.52	64.17	64.25	6759488.0
2012-05-08 10:00:00	QQQ	ETF	64.25	64.265	63.57	63.76	12726444.0
2012-05-08 11:00:00	QQQ	ETF	63.75	64.03	63.48	63.92	11644275.0
2012-05-08 12:00:00	QQQ	ETF	63.92	63.94	63.66	63.68	4739664.0
2012-05-08 13:00:00	QQQ	ETF	63.69	64.09	63.68	64.06	6164535.0
2012-05-08 14:00:00	QQQ	ETF	64.06	64.41	63.98	64.34	5876991.0
2012-05-08 15:00:00	QQQ	ETF	64.33	64.74	64.24	64.52	11717998.0
2012-05-08 16:00:00	QQQ	ETF	64.51	64.754	64.3474	64.51	3981678.0
2012-05-08 17:00:00	QQQ	ETF	64.52	64.53	64.49	64.49	5600.0
2012-05-08 18:00:00	QQQ	ETF	64.51	64.53	64.48	64.48	21036.0
2012-05-08 19:00:00	QQQ	ETF	64.48	64.48	64.41	64.47	15552.0
2012-05-08 06:00:00	IWM	ETF	78.91	78.91	78.91	78.91	975.0
2012-05-08 07:00:00	IWM	ETF	78.86	79.3	78.86	79.3	34452.0
2012-05-08 08:00:00	IWM	ETF	79.33	79.35	78.74	78.9	572559.0
2012-05-08 09:00:00	IWM	ETF	78.9	79.05	78.43	78.83	5345541.0
2012-05-08 10:00:00	IWM	ETF	78.83	78.85	78.14	78.29	9775467.0
2012-05-08 11:00:00	IWM	ETF	78.29	78.9	77.97	78.684	9792611.0
2012-05-08 12:00:00	IWM	ETF	78.69	78.72	78.2	78.21	5840333.0
2012-05-08 13:00:00	IWM	ETF	78.2	78.71	78.2	78.58	4473941.0
2012-05-08 14:00:00	IWM	ETF	78.59	78.98	78.38	78.91	6800719.0
2012-05-08 15:00:00	IWM	ETF	78.9	79.3	78.7	79.22	11618645.0
2012-05-08 16:00:00	IWM	ETF	79.22	79.78	79.12	79.27	2545151.0
2012-05-08 17:00:00	IWM	ETF	79.26	79.27	79.26	79.26	300.0
2012-05-08 18:00:00	IWM	ETF	79.24	79.24	79.24	79.24	100.0
2012-05-08 19:00:00	IWM	ETF	79.11	79.12	78.97	79.02	7288.0
2012-05-08 07:00:00	DIA	ETF	129.19	129.61	129.19	129.6	6150.0
2012-05-08 08:00:00	DIA	ETF	129.62	129.66	129.05	129.4	15757.0
2012-05-08 09:00:00	DIA	ETF	129.38	129.38	128.93	129.11	603001.0
2012-05-08 10:00:00	DIA	ETF	129.13	129.14	128.19	128.36	1347971.0
2012-05-08 11:00:00	DIA	ETF	128.35	128.63	127.91	128.53	1271846.0

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

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