PREVIEW / etf_1hour / 2013-09-27

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-09-27.parquet
  size:    199 KB
  rows:    6,262

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
2013-09-27 04:00:00	SPY	ETF	169.65	169.65	169.26	169.26	121605.0
2013-09-27 05:00:00	SPY	ETF	169.25	169.3	169.02	169.06	53535.0
2013-09-27 06:00:00	SPY	ETF	169.08	169.24	168.92	168.96	105303.0
2013-09-27 07:00:00	SPY	ETF	168.96	169.08	168.9	169.04	308401.0
2013-09-27 08:00:00	SPY	ETF	169.04	169.09	168.85	169.07	833698.0
2013-09-27 09:00:00	SPY	ETF	169.07	169.11	168.59	168.72	14245500.0
2013-09-27 10:00:00	SPY	ETF	168.72	169.04	168.47	168.9095	15158606.0
2013-09-27 11:00:00	SPY	ETF	168.91	169.14	168.64	168.95	12813993.0
2013-09-27 12:00:00	SPY	ETF	168.96	169.13	168.85	169.03	5876650.0
2013-09-27 13:00:00	SPY	ETF	169.03	169.13	168.88	168.92	4437790.0
2013-09-27 14:00:00	SPY	ETF	168.92	168.96	168.68	168.78	10042408.0
2013-09-27 15:00:00	SPY	ETF	168.78	169.11	168.64	168.94	19827879.0
2013-09-27 16:00:00	SPY	ETF	168.97	169.6569	168.8734	168.98	7175861.0
2013-09-27 17:00:00	SPY	ETF	168.98	169.03	168.91	168.94	1020491.0
2013-09-27 18:00:00	SPY	ETF	168.92	168.97	168.8621	168.97	279706.0
2013-09-27 19:00:00	SPY	ETF	168.95	169.06	168.95	169.01	145782.0
2013-09-27 04:00:00	QQQ	ETF	79.11	79.11	79.05	79.05	17100.0
2013-09-27 05:00:00	QQQ	ETF	79.06	79.07	78.85	78.88	28111.0
2013-09-27 06:00:00	QQQ	ETF	78.87	78.96	78.86	78.86	27400.0
2013-09-27 07:00:00	QQQ	ETF	78.87	78.93	78.84	78.88	40743.0
2013-09-27 08:00:00	QQQ	ETF	78.88	78.9	78.82	78.89	184274.0
2013-09-27 09:00:00	QQQ	ETF	78.89	78.9	78.59	78.75	5010946.0
2013-09-27 10:00:00	QQQ	ETF	78.75	79.11	78.67	79.06	4222156.0
2013-09-27 11:00:00	QQQ	ETF	79.06	79.19	78.95	79.11	2901882.0
2013-09-27 12:00:00	QQQ	ETF	79.11	79.21	79.08	79.1714	1235610.0
2013-09-27 13:00:00	QQQ	ETF	79.18	79.2	79.065	79.091	1041629.0
2013-09-27 14:00:00	QQQ	ETF	79.1	79.1	78.934	78.96	2445885.0
2013-09-27 15:00:00	QQQ	ETF	78.9599	79.14	78.89	79.07	5062002.0
2013-09-27 16:00:00	QQQ	ETF	79.07	79.1819	78.744	79.07	2125530.0
2013-09-27 17:00:00	QQQ	ETF	79.08	79.14	79.05	79.05	54300.0
2013-09-27 18:00:00	QQQ	ETF	79.12	79.12	78.9429	78.9429	255303.0
2013-09-27 19:00:00	QQQ	ETF	79.13	79.13	79.1	79.1	200.0
2013-09-27 05:00:00	IWM	ETF	106.81	106.81	106.61	106.61	300.0
2013-09-27 07:00:00	IWM	ETF	106.68	106.71	106.61	106.71	8320.0
2013-09-27 08:00:00	IWM	ETF	106.7	106.7	106.52	106.65	198368.0
2013-09-27 09:00:00	IWM	ETF	106.66	106.67	106.21	106.44	4630716.0
2013-09-27 10:00:00	IWM	ETF	106.43	107.05	106.25	106.87	5715578.0
2013-09-27 11:00:00	IWM	ETF	106.865	106.99	106.59	106.63	2496002.0
2013-09-27 12:00:00	IWM	ETF	106.62	106.81	106.58	106.61	2138777.0
2013-09-27 13:00:00	IWM	ETF	106.62	106.76	106.53	106.638	1936956.0
2013-09-27 14:00:00	IWM	ETF	106.63	106.695	106.47	106.545	3032841.0
2013-09-27 15:00:00	IWM	ETF	106.54	106.8	106.46	106.55	6022316.0
2013-09-27 16:00:00	IWM	ETF	106.55	107.0321	106.55	106.62	2772845.0
2013-09-27 17:00:00	IWM	ETF	106.64	106.67	106.53	106.53	32100.0
2013-09-27 18:00:00	IWM	ETF	106.5692	106.5692	106.56	106.56	557061.0
2013-09-27 19:00:00	IWM	ETF	106.67	106.75	106.67	106.75	11071.0
2013-09-27 04:00:00	DIA	ETF	153.2	153.2	153.2	153.2	200.0
2013-09-27 07:00:00	DIA	ETF	152.41	152.5	152.41	152.5	3991.0
2013-09-27 08:00:00	DIA	ETF	152.44	152.54	152.44	152.47	7950.0
2013-09-27 09:00:00	DIA	ETF	152.55	152.55	151.95	152.09	1200145.0

> showing 50 of 6,262 rows — these rows as CSV

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