PREVIEW / etf_1hour / 2013-10-16

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-10-16.parquet
  size:    211 KB
  rows:    6,642

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-10-16 04:00:00	SPY	ETF	170.4	170.49	170.3	170.43	30124.0
2013-10-16 05:00:00	SPY	ETF	170.41	170.51	170.34	170.42	35565.0
2013-10-16 06:00:00	SPY	ETF	170.37	170.39	170.2	170.33	52184.0
2013-10-16 07:00:00	SPY	ETF	170.31	170.49	170.27	170.3	316725.0
2013-10-16 08:00:00	SPY	ETF	170.3	170.87	169.72	170.8	1219148.0
2013-10-16 09:00:00	SPY	ETF	170.81	171.84	170.635	171.665	22067055.0
2013-10-16 10:00:00	SPY	ETF	171.66	171.98	171.31	171.95	29147436.0
2013-10-16 11:00:00	SPY	ETF	171.95	172.16	171.73	171.935	19509325.0
2013-10-16 12:00:00	SPY	ETF	171.93	172.15	171.65	171.768	17686862.0
2013-10-16 13:00:00	SPY	ETF	171.76	172.04	171.63	171.8	10547589.0
2013-10-16 14:00:00	SPY	ETF	171.79	171.84	171.47	171.61	10961542.0
2013-10-16 15:00:00	SPY	ETF	171.61	172.14	171.46	172.07	22712569.0
2013-10-16 16:00:00	SPY	ETF	172.09	172.1085	169.7638	171.7	18049639.0
2013-10-16 17:00:00	SPY	ETF	171.69	172.05	171.68	171.7	4134036.0
2013-10-16 18:00:00	SPY	ETF	171.68	171.73	171.6	171.63	445552.0
2013-10-16 19:00:00	SPY	ETF	171.65	171.97	171.65	171.9	183821.0
2013-10-16 04:00:00	QQQ	ETF	79.71	79.72	79.65	79.7	38400.0
2013-10-16 05:00:00	QQQ	ETF	79.71	79.74	79.62	79.64	42600.0
2013-10-16 06:00:00	QQQ	ETF	79.63	79.65	79.59	79.64	11200.0
2013-10-16 07:00:00	QQQ	ETF	79.63	79.79	79.63	79.74	39223.0
2013-10-16 08:00:00	QQQ	ETF	79.73	79.96	79.48	79.92	92996.0
2013-10-16 09:00:00	QQQ	ETF	79.93	80.259	79.79	80.2	6775502.0
2013-10-16 10:00:00	QQQ	ETF	80.2	80.35	80.08	80.33	7458190.0
2013-10-16 11:00:00	QQQ	ETF	80.33	80.42	80.25	80.3201	4872000.0
2013-10-16 12:00:00	QQQ	ETF	80.32	80.41	80.25	80.3199	6443137.0
2013-10-16 13:00:00	QQQ	ETF	80.32	80.35	80.23	80.255	3794220.0
2013-10-16 14:00:00	QQQ	ETF	80.25	80.305	80.16	80.23	2270121.0
2013-10-16 15:00:00	QQQ	ETF	80.23	80.41	80.16	80.39	6569575.0
2013-10-16 16:00:00	QQQ	ETF	80.38	80.39	79.916	80.1	2774462.0
2013-10-16 17:00:00	QQQ	ETF	80.12	80.15	80.08	80.14	36455.0
2013-10-16 18:00:00	QQQ	ETF	80.11	80.11	80.06	80.07	53349.0
2013-10-16 19:00:00	QQQ	ETF	80.13	80.22	80.13	80.21	21103.0
2013-10-16 05:00:00	IWM	ETF	107.75	107.75	107.74	107.74	1000.0
2013-10-16 07:00:00	IWM	ETF	107.72	107.72	107.48	107.53	6100.0
2013-10-16 08:00:00	IWM	ETF	107.56	107.97	107.16	107.96	351864.0
2013-10-16 09:00:00	IWM	ETF	107.95	108.59	107.64	108.42	5403916.0
2013-10-16 10:00:00	IWM	ETF	108.43	108.54	108.17	108.41	5792851.0
2013-10-16 11:00:00	IWM	ETF	108.4	108.56	108.2141	108.36	3398903.0
2013-10-16 12:00:00	IWM	ETF	108.355	108.4873	108.19	108.28	3244660.0
2013-10-16 13:00:00	IWM	ETF	108.29	108.6	108.25	108.43	2050252.0
2013-10-16 14:00:00	IWM	ETF	108.43	108.52	108.29	108.39	2466068.0
2013-10-16 15:00:00	IWM	ETF	108.385	108.57	108.29	108.49	7382752.0
2013-10-16 16:00:00	IWM	ETF	108.5	108.54	108.25	108.38	2342351.0
2013-10-16 17:00:00	IWM	ETF	108.38	108.41	108.34	108.34	19125.0
2013-10-16 18:00:00	IWM	ETF	108.4	108.4	108.2	108.2	58625.0
2013-10-16 19:00:00	IWM	ETF	108.19	108.43	108.19	108.41	8732.0
2013-10-16 08:00:00	DIA	ETF	152.04	152.45	152.04	152.44	9004.0
2013-10-16 09:00:00	DIA	ETF	152.46	153.42	152.24	153.25	1554422.0
2013-10-16 10:00:00	DIA	ETF	153.27	153.45	152.91	153.43	1808214.0
2013-10-16 11:00:00	DIA	ETF	153.42	153.559	153.2001	153.41	1214362.0

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

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