PREVIEW / etf_1hour / 2014-01-17

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-01-17.parquet
  size:    215 KB
  rows:    6,804

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
2014-01-17 04:00:00	SPY	ETF	184.12	184.28	184.12	184.28	13275.0
2014-01-17 05:00:00	SPY	ETF	184.3	184.63	184.3	184.57	8873.0
2014-01-17 06:00:00	SPY	ETF	184.57	184.62	184.53	184.61	55482.0
2014-01-17 07:00:00	SPY	ETF	184.61	184.63	184.36	184.39	517010.0
2014-01-17 08:00:00	SPY	ETF	184.58	184.58	184.01	184.19	3166891.0
2014-01-17 09:00:00	SPY	ETF	184.19	184.3	183.78	184.0	18517087.0
2014-01-17 10:00:00	SPY	ETF	183.99	184.23	183.83	184.21	10284263.0
2014-01-17 11:00:00	SPY	ETF	184.21	184.36	184.17	184.28	6421277.0
2014-01-17 12:00:00	SPY	ETF	184.28	184.45	184.22	184.23	4530911.0
2014-01-17 13:00:00	SPY	ETF	184.23	184.29	183.89	184.08	9932051.0
2014-01-17 14:00:00	SPY	ETF	184.09	184.17	183.87	183.915	7990345.0
2014-01-17 15:00:00	SPY	ETF	183.92	184.02	183.32	183.61	31458243.0
2014-01-17 16:00:00	SPY	ETF	183.6	184.4154	183.54	183.79	7724850.0
2014-01-17 17:00:00	SPY	ETF	183.79	183.8	183.64	183.64	249619.0
2014-01-17 18:00:00	SPY	ETF	183.64	183.65	183.57	183.64	3851544.0
2014-01-17 19:00:00	SPY	ETF	183.61	183.7	183.6	183.6	27965.0
2014-01-17 04:00:00	QQQ	ETF	88.22	88.3	88.22	88.3	17500.0
2014-01-17 05:00:00	QQQ	ETF	88.35	88.49	88.35	88.49	3100.0
2014-01-17 06:00:00	QQQ	ETF	88.46	88.47	88.45	88.45	8700.0
2014-01-17 07:00:00	QQQ	ETF	88.44	88.45	88.32	88.32	160800.0
2014-01-17 08:00:00	QQQ	ETF	88.37	88.37	88.11	88.2	577980.0
2014-01-17 09:00:00	QQQ	ETF	88.2	88.4269	87.93	88.07	8621370.0
2014-01-17 10:00:00	QQQ	ETF	88.07	88.25	88.0001	88.23	3162803.0
2014-01-17 11:00:00	QQQ	ETF	88.23	88.305	88.2	88.2501	1716860.0
2014-01-17 12:00:00	QQQ	ETF	88.26	88.3701	88.22	88.221	1363872.0
2014-01-17 13:00:00	QQQ	ETF	88.23	88.27	88.01	88.1	1682245.0
2014-01-17 14:00:00	QQQ	ETF	88.1099	88.13	87.99	88.02	1629666.0
2014-01-17 15:00:00	QQQ	ETF	88.02	88.07	87.67	87.88	9158974.0
2014-01-17 16:00:00	QQQ	ETF	87.88	88.4269	87.85	87.91	2419934.0
2014-01-17 17:00:00	QQQ	ETF	87.91	87.92	87.86	87.86	18109.0
2014-01-17 18:00:00	QQQ	ETF	87.87	87.88	87.87	87.88	2973.0
2014-01-17 19:00:00	QQQ	ETF	87.87	87.87	87.84	87.85	3495.0
2014-01-17 05:00:00	IWM	ETF	116.35	116.46	116.35	116.46	200.0
2014-01-17 06:00:00	IWM	ETF	116.59	116.59	116.59	116.59	200.0
2014-01-17 07:00:00	IWM	ETF	116.5	116.56	116.44	116.44	116100.0
2014-01-17 08:00:00	IWM	ETF	116.44	116.45	116.2	116.32	413585.0
2014-01-17 09:00:00	IWM	ETF	116.3	116.42	116.02	116.17	3229850.0
2014-01-17 10:00:00	IWM	ETF	116.18	116.34	116.06	116.28	3403518.0
2014-01-17 11:00:00	IWM	ETF	116.29	116.43	116.2201	116.255	1296595.0
2014-01-17 12:00:00	IWM	ETF	116.26	116.39	116.19	116.2	1618172.0
2014-01-17 13:00:00	IWM	ETF	116.21	116.259	115.94	116.04	3072535.0
2014-01-17 14:00:00	IWM	ETF	116.05	116.14	115.98	116.03	2351863.0
2014-01-17 15:00:00	IWM	ETF	116.03	116.105	115.69	115.91	7358904.0
2014-01-17 16:00:00	IWM	ETF	115.92	116.4096	115.87	116.0	3786741.0
2014-01-17 17:00:00	IWM	ETF	116.01	116.01	115.86	115.86	38607.0
2014-01-17 18:00:00	IWM	ETF	115.87	115.99	115.87	115.93	2700.0
2014-01-17 19:00:00	IWM	ETF	115.98	115.98	115.92	115.92	400.0
2014-01-17 05:00:00	DIA	ETF	163.84	163.98	163.84	163.98	300.0
2014-01-17 07:00:00	DIA	ETF	164.0	164.0	164.0	164.0	200.0
2014-01-17 08:00:00	DIA	ETF	163.8	163.8	163.6	163.65	3387.0

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

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