PREVIEW / etf_1hour / 2014-05-14

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-05-14.parquet
  size:    213 KB
  rows:    6,755

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-14 04:00:00	SPY	ETF	189.9	189.93	189.83	189.91	5078.0
2014-05-14 05:00:00	SPY	ETF	189.91	190.01	189.81	189.81	13361.0
2014-05-14 06:00:00	SPY	ETF	189.8	189.83	189.7	189.75	35992.0
2014-05-14 07:00:00	SPY	ETF	189.77	189.84	189.62	189.68	321349.0
2014-05-14 08:00:00	SPY	ETF	189.71	189.77	189.62	189.66	349401.0
2014-05-14 09:00:00	SPY	ETF	189.64	189.88	189.4	189.69	9947995.0
2014-05-14 10:00:00	SPY	ETF	189.7	189.84	189.34	189.5	10217179.0
2014-05-14 11:00:00	SPY	ETF	189.505	189.72	189.4	189.515	7443522.0
2014-05-14 12:00:00	SPY	ETF	189.515	189.68	189.49	189.6	4602419.0
2014-05-14 13:00:00	SPY	ETF	189.591	189.74	189.56	189.64	3234674.0
2014-05-14 14:00:00	SPY	ETF	189.64	189.65	189.17	189.235	7848737.0
2014-05-14 15:00:00	SPY	ETF	189.24	189.26	188.79	189.05	21709450.0
2014-05-14 16:00:00	SPY	ETF	189.06	189.15	189.0	189.11	5211189.0
2014-05-14 17:00:00	SPY	ETF	189.1	189.2	189.1	189.16	73251.0
2014-05-14 18:00:00	SPY	ETF	189.19	189.2	189.1	189.15	33458.0
2014-05-14 19:00:00	SPY	ETF	189.13	189.18	189.03	189.05	89262.0
2014-05-14 04:00:00	QQQ	ETF	88.23	88.23	88.2	88.2	2500.0
2014-05-14 05:00:00	QQQ	ETF	88.13	88.13	88.13	88.13	2500.0
2014-05-14 06:00:00	QQQ	ETF	88.1	88.15	88.08	88.15	1070.0
2014-05-14 07:00:00	QQQ	ETF	88.11	88.12	88.05	88.08	31360.0
2014-05-14 08:00:00	QQQ	ETF	88.07	88.29	87.945	87.95	314905.0
2014-05-14 09:00:00	QQQ	ETF	87.94	88.27	87.9201	88.24	4542473.0
2014-05-14 10:00:00	QQQ	ETF	88.25	88.35	87.98	88.141	4120879.0
2014-05-14 11:00:00	QQQ	ETF	88.15	88.21	87.9901	88.0749	1796748.0
2014-05-14 12:00:00	QQQ	ETF	88.07	88.23	88.07	88.18	1361397.0
2014-05-14 13:00:00	QQQ	ETF	88.18	88.32	88.18	88.21	1679608.0
2014-05-14 14:00:00	QQQ	ETF	88.22	88.24	87.921	87.9599	2843236.0
2014-05-14 15:00:00	QQQ	ETF	87.955	87.97	87.62	87.81	6845092.0
2014-05-14 16:00:00	QQQ	ETF	87.82	88.2285	87.79	87.98	2653113.0
2014-05-14 17:00:00	QQQ	ETF	87.99	88.07	87.99	88.04	50936.0
2014-05-14 18:00:00	QQQ	ETF	88.04	88.04	87.99	88.0	61594.0
2014-05-14 19:00:00	QQQ	ETF	88.02	88.03	87.97	87.99	11300.0
2014-05-14 07:00:00	IWM	ETF	111.21	111.21	111.0	111.03	59050.0
2014-05-14 08:00:00	IWM	ETF	111.06	111.11	110.92	110.93	166862.0
2014-05-14 09:00:00	IWM	ETF	110.92	111.41	110.29	110.93	8531880.0
2014-05-14 10:00:00	IWM	ETF	110.93	111.1	110.12	110.25	8140924.0
2014-05-14 11:00:00	IWM	ETF	110.25	110.68	110.16	110.2	4404317.0
2014-05-14 12:00:00	IWM	ETF	110.21	110.63	110.2	110.41	2642490.0
2014-05-14 13:00:00	IWM	ETF	110.43	110.65	110.25	110.365	2472859.0
2014-05-14 14:00:00	IWM	ETF	110.37	110.38	109.69	109.76	5716610.0
2014-05-14 15:00:00	IWM	ETF	109.76	110.01	109.42	109.64	10072324.0
2014-05-14 16:00:00	IWM	ETF	109.64	109.864	109.49	109.68	4923624.0
2014-05-14 17:00:00	IWM	ETF	109.69	109.83	109.62	109.62	224858.0
2014-05-14 18:00:00	IWM	ETF	109.78	109.78	109.75	109.75	650.0
2014-05-14 19:00:00	IWM	ETF	109.78	109.8	109.74	109.8	3886.0
2014-05-14 07:00:00	DIA	ETF	167.09	167.09	166.94	166.94	3707.0
2014-05-14 08:00:00	DIA	ETF	166.96	167.0	166.93	167.0	2604.0
2014-05-14 09:00:00	DIA	ETF	166.96	167.37	166.55	166.7	578474.0
2014-05-14 10:00:00	DIA	ETF	166.71	166.86	166.49	166.61	532951.0
2014-05-14 11:00:00	DIA	ETF	166.62	166.69	166.52	166.544	225605.0

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

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