PREVIEW / etf_1hour / 2012-04-20

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-04-20.parquet
  size:    179 KB
  rows:    5,530

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-04-20 04:00:00	SPY	ETF	138.17	138.19	137.74	137.74	8150.0
2012-04-20 05:00:00	SPY	ETF	137.86	137.88	137.86	137.88	660.0
2012-04-20 06:00:00	SPY	ETF	138.22	138.61	138.22	138.45	66400.0
2012-04-20 07:00:00	SPY	ETF	138.47	138.47	138.18	138.34	934498.0
2012-04-20 08:00:00	SPY	ETF	138.33	138.58	137.81	138.36	1907953.0
2012-04-20 09:00:00	SPY	ETF	138.35	138.53	138.14	138.53	25548923.0
2012-04-20 10:00:00	SPY	ETF	138.52	138.83	138.205	138.68	25939360.0
2012-04-20 11:00:00	SPY	ETF	138.68	138.69	138.54	138.68	11684429.0
2012-04-20 12:00:00	SPY	ETF	138.68	138.8	138.6	138.62	7969926.0
2012-04-20 13:00:00	SPY	ETF	138.62	138.67	138.18	138.269	9329925.0
2012-04-20 14:00:00	SPY	ETF	138.26	138.39	138.05	138.15	15344412.0
2012-04-20 15:00:00	SPY	ETF	138.15	138.45	137.87	137.93	30592537.0
2012-04-20 16:00:00	SPY	ETF	137.94	138.3705	137.88	138.02	11707075.0
2012-04-20 17:00:00	SPY	ETF	138.01	138.01	137.9248	137.99	727080.0
2012-04-20 18:00:00	SPY	ETF	137.99	137.99	137.85	137.87	98236.0
2012-04-20 19:00:00	SPY	ETF	137.86	137.87	137.46	137.46	234242.0
2012-04-20 05:00:00	QQQ	ETF	65.98	65.98	65.98	65.98	4000.0
2012-04-20 06:00:00	QQQ	ETF	66.23	66.24	66.13	66.21	1900.0
2012-04-20 07:00:00	QQQ	ETF	66.23	66.23	66.11	66.18	101000.0
2012-04-20 08:00:00	QQQ	ETF	66.16	66.3	66.13	66.16	1072507.0
2012-04-20 09:00:00	QQQ	ETF	66.16	66.43	65.98	66.43	11546482.0
2012-04-20 10:00:00	QQQ	ETF	66.43	66.51	66.24	66.362	8435309.0
2012-04-20 11:00:00	QQQ	ETF	66.36	66.37	66.22	66.33	3190754.0
2012-04-20 12:00:00	QQQ	ETF	66.3376	66.42	66.2	66.21	2639168.0
2012-04-20 13:00:00	QQQ	ETF	66.21	66.26	65.89	65.97	4989351.0
2012-04-20 14:00:00	QQQ	ETF	65.97	66.015	65.71	65.74	6937785.0
2012-04-20 15:00:00	QQQ	ETF	65.74	65.83	65.58	65.65	13542748.0
2012-04-20 16:00:00	QQQ	ETF	65.66	65.8892	65.64	65.74	3913533.0
2012-04-20 17:00:00	QQQ	ETF	65.76	65.76	65.64	65.68	24000.0
2012-04-20 18:00:00	QQQ	ETF	65.68	65.68	65.68	65.68	2720.0
2012-04-20 19:00:00	QQQ	ETF	65.7	65.7	65.52	65.52	13424.0
2012-04-20 04:00:00	IWM	ETF	79.96	80.03	79.73	79.73	2266.0
2012-04-20 05:00:00	IWM	ETF	79.73	79.99	79.73	79.99	8100.0
2012-04-20 06:00:00	IWM	ETF	80.01	80.25	80.01	80.25	13700.0
2012-04-20 07:00:00	IWM	ETF	80.25	80.25	80.05	80.18	30567.0
2012-04-20 08:00:00	IWM	ETF	80.16	80.35	80.16	80.19	182701.0
2012-04-20 09:00:00	IWM	ETF	80.2	80.7	80.17	80.6	7120013.0
2012-04-20 10:00:00	IWM	ETF	80.61	80.97	80.36	80.79	9352116.0
2012-04-20 11:00:00	IWM	ETF	80.79	80.85	80.64	80.74	3492804.0
2012-04-20 12:00:00	IWM	ETF	80.73	80.87	80.6175	80.625	2687789.0
2012-04-20 13:00:00	IWM	ETF	80.62	80.68	80.23	80.39	3986790.0
2012-04-20 14:00:00	IWM	ETF	80.38	80.48	80.18	80.33	3199122.0
2012-04-20 15:00:00	IWM	ETF	80.34	80.355	80.06	80.14	7949191.0
2012-04-20 16:00:00	IWM	ETF	80.15	80.65	80.15	80.23	3108636.0
2012-04-20 17:00:00	IWM	ETF	80.23	80.25	80.23	80.24	2920.0
2012-04-20 19:00:00	IWM	ETF	80.16	80.16	79.99	80.15	7211.0
2012-04-20 07:00:00	DIA	ETF	129.8	129.91	129.8	129.91	10625.0
2012-04-20 08:00:00	DIA	ETF	129.92	130.06	129.92	130.0	7500.0
2012-04-20 09:00:00	DIA	ETF	130.01	130.25	129.9	130.22	611444.0
2012-04-20 10:00:00	DIA	ETF	130.23	130.49	130.0	130.42	1538380.0

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

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