PREVIEW / etf_1hour / 2014-05-02

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-05-02.parquet
  size:    210 KB
  rows:    6,660

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-05-02 04:00:00	SPY	ETF	188.58	188.58	188.5	188.5	250.0
2014-05-02 05:00:00	SPY	ETF	188.29	188.52	188.29	188.52	1844.0
2014-05-02 06:00:00	SPY	ETF	188.5	188.6	188.38	188.42	49731.0
2014-05-02 07:00:00	SPY	ETF	188.4	188.54	188.4	188.49	258798.0
2014-05-02 08:00:00	SPY	ETF	188.48	189.3	188.13	188.2	4831340.0
2014-05-02 09:00:00	SPY	ETF	188.19	188.93	188.09	188.69	15585434.0
2014-05-02 10:00:00	SPY	ETF	188.69	189.14	187.98	188.2	21251309.0
2014-05-02 11:00:00	SPY	ETF	188.2	188.6	188.05	188.5	10885716.0
2014-05-02 12:00:00	SPY	ETF	188.5	188.54	188.3	188.4404	5166680.0
2014-05-02 13:00:00	SPY	ETF	188.441	188.53	188.0	188.02	6379203.0
2014-05-02 14:00:00	SPY	ETF	188.0	188.21	187.78	188.06	10688802.0
2014-05-02 15:00:00	SPY	ETF	188.06	188.33	187.89	188.07	13371064.0
2014-05-02 16:00:00	SPY	ETF	188.08	188.13	187.93	187.96	8513455.0
2014-05-02 17:00:00	SPY	ETF	187.97	187.98	187.81	187.94	618942.0
2014-05-02 18:00:00	SPY	ETF	187.95	188.09	187.91	188.03	94760.0
2014-05-02 19:00:00	SPY	ETF	188.01	188.02	187.98	188.01	19156.0
2014-05-02 07:00:00	QQQ	ETF	87.73	87.74	87.72	87.74	7500.0
2014-05-02 08:00:00	QQQ	ETF	87.74	88.14	87.71	87.78	881312.0
2014-05-02 09:00:00	QQQ	ETF	87.75	88.11	87.49	87.66	7272221.0
2014-05-02 10:00:00	QQQ	ETF	87.665	87.97	87.28	87.42	8585207.0
2014-05-02 11:00:00	QQQ	ETF	87.42	87.84	87.39	87.78	3930659.0
2014-05-02 12:00:00	QQQ	ETF	87.79	87.84	87.641	87.74	1419274.0
2014-05-02 13:00:00	QQQ	ETF	87.731	87.79	87.47	87.47	1922468.0
2014-05-02 14:00:00	QQQ	ETF	87.47	87.65	87.41	87.56	3164724.0
2014-05-02 15:00:00	QQQ	ETF	87.56	87.73	87.47	87.49	7004258.0
2014-05-02 16:00:00	QQQ	ETF	87.49	87.8	87.4565	87.51	1468319.0
2014-05-02 17:00:00	QQQ	ETF	87.51	87.51	87.46	87.5	24656.0
2014-05-02 18:00:00	QQQ	ETF	87.49	87.51	87.48	87.51	3100.0
2014-05-02 19:00:00	QQQ	ETF	87.49	87.51	87.49	87.51	11000.0
2014-05-02 06:00:00	IWM	ETF	112.03	112.11	112.03	112.05	4500.0
2014-05-02 07:00:00	IWM	ETF	111.98	111.98	111.96	111.97	15500.0
2014-05-02 08:00:00	IWM	ETF	112.01	112.55	111.84	111.97	1469798.0
2014-05-02 09:00:00	IWM	ETF	111.97	112.43	111.68	112.25	6288482.0
2014-05-02 10:00:00	IWM	ETF	112.24	113.12	111.96	112.32	10739686.0
2014-05-02 11:00:00	IWM	ETF	112.33	112.66	112.1813	112.52	4764657.0
2014-05-02 12:00:00	IWM	ETF	112.52	112.69	112.34	112.57	1326858.0
2014-05-02 13:00:00	IWM	ETF	112.57	112.6	111.93	112.06	2496723.0
2014-05-02 14:00:00	IWM	ETF	112.05	112.32	111.95	112.1	3327972.0
2014-05-02 15:00:00	IWM	ETF	112.11	112.23	111.8	112.05	6739333.0
2014-05-02 16:00:00	IWM	ETF	112.05	112.1169	111.79	111.99	1588503.0
2014-05-02 17:00:00	IWM	ETF	111.99	111.99	111.96	111.96	9000.0
2014-05-02 18:00:00	IWM	ETF	111.95	111.98	111.89	111.89	1189.0
2014-05-02 04:00:00	DIA	ETF	165.1	165.1	165.1	165.1	113.0
2014-05-02 07:00:00	DIA	ETF	165.25	165.25	165.25	165.25	150.0
2014-05-02 08:00:00	DIA	ETF	165.45	165.77	165.02	165.14	9762.0
2014-05-02 09:00:00	DIA	ETF	165.12	165.68	165.04	165.54	763727.0
2014-05-02 10:00:00	DIA	ETF	165.53	165.85	164.84	164.98	2480282.0
2014-05-02 11:00:00	DIA	ETF	164.98	165.29	164.88	165.19	706770.0
2014-05-02 12:00:00	DIA	ETF	165.19	165.21	165.04	165.1	284982.0
2014-05-02 13:00:00	DIA	ETF	165.11	165.17	164.72	164.74	312884.0

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

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