PREVIEW / etf_1hour / 2013-07-16

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-07-16.parquet
  size:    203 KB
  rows:    6,386

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-07-16 04:00:00	SPY	ETF	167.95	168.1	167.94	168.1	11100.0
2013-07-16 05:00:00	SPY	ETF	168.06	168.25	168.06	168.2	56800.0
2013-07-16 06:00:00	SPY	ETF	168.22	168.27	168.19	168.21	30200.0
2013-07-16 07:00:00	SPY	ETF	168.21	168.28	168.08	168.08	435764.0
2013-07-16 08:00:00	SPY	ETF	168.21	168.23	166.75	168.21	574012.0
2013-07-16 09:00:00	SPY	ETF	168.21	168.36	167.87	167.9	10267417.0
2013-07-16 10:00:00	SPY	ETF	167.92	168.18	167.72	167.73	12038955.0
2013-07-16 11:00:00	SPY	ETF	167.73	167.76	167.2	167.38	16042422.0
2013-07-16 12:00:00	SPY	ETF	167.38	167.555	167.32	167.352	5900885.0
2013-07-16 13:00:00	SPY	ETF	167.355	167.42	167.07	167.4199	9794353.0
2013-07-16 14:00:00	SPY	ETF	167.41	167.665	167.4	167.44	8616886.0
2013-07-16 15:00:00	SPY	ETF	167.44	167.57	167.19	167.52	14722858.0
2013-07-16 16:00:00	SPY	ETF	167.52	168.1556	167.4	167.63	6083172.0
2013-07-16 17:00:00	SPY	ETF	167.61	167.63	167.52	167.57	160080.0
2013-07-16 18:00:00	SPY	ETF	167.58	167.67	167.57	167.61	95623.0
2013-07-16 19:00:00	SPY	ETF	167.62	167.62	167.56	167.61	17475.0
2013-07-16 04:00:00	QQQ	ETF	75.43	75.46	75.42	75.46	5950.0
2013-07-16 05:00:00	QQQ	ETF	75.48	75.5	75.48	75.5	1800.0
2013-07-16 06:00:00	QQQ	ETF	75.47	75.47	75.47	75.47	2600.0
2013-07-16 07:00:00	QQQ	ETF	75.47	75.5	75.46	75.46	14938.0
2013-07-16 08:00:00	QQQ	ETF	75.47	75.52	75.43	75.51	31106.0
2013-07-16 09:00:00	QQQ	ETF	75.5	75.57	75.43	75.44	2442156.0
2013-07-16 10:00:00	QQQ	ETF	75.45	75.59	75.39	75.39	2866839.0
2013-07-16 11:00:00	QQQ	ETF	75.39	75.41	75.2	75.245	3017631.0
2013-07-16 12:00:00	QQQ	ETF	75.2471	75.38	75.23	75.3	1638868.0
2013-07-16 13:00:00	QQQ	ETF	75.3	75.38	75.18	75.38	2728169.0
2013-07-16 14:00:00	QQQ	ETF	75.38	75.47	75.3	75.3	1922454.0
2013-07-16 15:00:00	QQQ	ETF	75.3	75.42	75.19	75.385	4167325.0
2013-07-16 16:00:00	QQQ	ETF	75.38	75.47	75.319	75.4	6538557.0
2013-07-16 17:00:00	QQQ	ETF	75.41	75.45	75.4	75.42	3220015.0
2013-07-16 18:00:00	QQQ	ETF	75.41	75.43	75.41	75.43	6325.0
2013-07-16 19:00:00	QQQ	ETF	75.41	75.41	75.41	75.41	7220.0
2013-07-16 04:00:00	IWM	ETF	103.57	103.57	103.57	103.57	532.0
2013-07-16 05:00:00	IWM	ETF	103.64	103.64	103.55	103.55	1000.0
2013-07-16 06:00:00	IWM	ETF	103.6	103.62	103.56	103.56	600.0
2013-07-16 07:00:00	IWM	ETF	103.6	103.64	103.51	103.51	20800.0
2013-07-16 08:00:00	IWM	ETF	103.5	103.61	103.44	103.58	66164.0
2013-07-16 09:00:00	IWM	ETF	103.58	103.67	103.32	103.45	3159497.0
2013-07-16 10:00:00	IWM	ETF	103.45	103.67	103.24	103.24	3350488.0
2013-07-16 11:00:00	IWM	ETF	103.25	103.3	102.91	103.05	5002266.0
2013-07-16 12:00:00	IWM	ETF	103.04	103.27	103.02	103.18	2341498.0
2013-07-16 13:00:00	IWM	ETF	103.18	103.19	102.82	103.08	3466171.0
2013-07-16 14:00:00	IWM	ETF	103.09	103.26	103.05	103.09	2466418.0
2013-07-16 15:00:00	IWM	ETF	103.09	103.17	102.89	103.03	5516560.0
2013-07-16 16:00:00	IWM	ETF	103.03	103.27	102.9989	103.23	599933.0
2013-07-16 17:00:00	IWM	ETF	103.22	103.22	103.15	103.15	1605.0
2013-07-16 18:00:00	IWM	ETF	103.13	103.15	103.13	103.15	500.0
2013-07-16 19:00:00	IWM	ETF	103.11	103.15	103.11	103.15	1388.0
2013-07-16 05:00:00	DIA	ETF	154.66	154.67	154.66	154.67	1000.0
2013-07-16 07:00:00	DIA	ETF	154.79	154.79	154.79	154.79	500.0

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

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