PREVIEW / etf_1hour / 2013-10-25

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-10-25.parquet
  size:    206 KB
  rows:    6,526

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-25 04:00:00	SPY	ETF	174.84	175.32	174.75	175.11	154714.0
2013-10-25 05:00:00	SPY	ETF	175.08	175.26	175.02	175.26	722477.0
2013-10-25 06:00:00	SPY	ETF	175.25	175.25	175.13	175.25	294017.0
2013-10-25 07:00:00	SPY	ETF	175.26	175.43	175.24	175.35	1125890.0
2013-10-25 08:00:00	SPY	ETF	175.41	175.42	175.17	175.4	820515.0
2013-10-25 09:00:00	SPY	ETF	175.4	175.68	175.32	175.63	10579564.0
2013-10-25 10:00:00	SPY	ETF	175.63	175.84	175.24	175.439	16290542.0
2013-10-25 11:00:00	SPY	ETF	175.43	175.65	175.28	175.38	11952269.0
2013-10-25 12:00:00	SPY	ETF	175.38	175.52	175.17	175.5	7085432.0
2013-10-25 13:00:00	SPY	ETF	175.5	175.6	175.39	175.51	5900961.0
2013-10-25 14:00:00	SPY	ETF	175.5	175.7	175.47	175.66	5926251.0
2013-10-25 15:00:00	SPY	ETF	175.65	175.96	175.49	175.93	18541128.0
2013-10-25 16:00:00	SPY	ETF	175.95	176.05	175.31	175.88	10788185.0
2013-10-25 17:00:00	SPY	ETF	175.89	175.9	175.7	175.75	131189.0
2013-10-25 18:00:00	SPY	ETF	175.74	175.89	175.74	175.81	37631.0
2013-10-25 19:00:00	SPY	ETF	175.83	175.83	175.81	175.83	16411.0
2013-10-25 04:00:00	QQQ	ETF	82.7	82.82	82.7	82.82	49857.0
2013-10-25 05:00:00	QQQ	ETF	82.83	82.91	82.81	82.91	8300.0
2013-10-25 06:00:00	QQQ	ETF	82.92	82.93	82.85	82.92	38100.0
2013-10-25 07:00:00	QQQ	ETF	82.93	83.03	82.93	82.95	73655.0
2013-10-25 08:00:00	QQQ	ETF	82.94	83.03	82.87	83.01	293050.0
2013-10-25 09:00:00	QQQ	ETF	83.02	83.24	82.8796	83.2	6734825.0
2013-10-25 10:00:00	QQQ	ETF	83.21	83.28	82.84	82.8901	5458224.0
2013-10-25 11:00:00	QQQ	ETF	82.899	82.922	82.5899	82.63	4317412.0
2013-10-25 12:00:00	QQQ	ETF	82.63	82.74	82.5	82.73	2531449.0
2013-10-25 13:00:00	QQQ	ETF	82.73	82.86	82.67	82.7955	1870616.0
2013-10-25 14:00:00	QQQ	ETF	82.79	82.91	82.77	82.845	3925509.0
2013-10-25 15:00:00	QQQ	ETF	82.85	82.87	82.7001	82.86	5218688.0
2013-10-25 16:00:00	QQQ	ETF	82.86	83.0044	82.3502	82.87	3728553.0
2013-10-25 17:00:00	QQQ	ETF	82.86	82.88	82.8	82.8	3100.0
2013-10-25 18:00:00	QQQ	ETF	82.8	82.82	82.77	82.77	7060.0
2013-10-25 19:00:00	QQQ	ETF	82.8	82.8	82.8	82.8	100.0
2013-10-25 04:00:00	IWM	ETF	110.86	110.86	110.86	110.86	999.0
2013-10-25 07:00:00	IWM	ETF	111.13	111.15	111.07	111.07	35400.0
2013-10-25 08:00:00	IWM	ETF	111.09	111.12	110.92	111.09	58367.0
2013-10-25 09:00:00	IWM	ETF	111.09	111.38	111.06	111.33	2747825.0
2013-10-25 10:00:00	IWM	ETF	111.35	111.45	110.91	111.05	3351936.0
2013-10-25 11:00:00	IWM	ETF	111.05	111.09	110.67	110.71	2978784.0
2013-10-25 12:00:00	IWM	ETF	110.71	110.898	110.57	110.8399	2332702.0
2013-10-25 13:00:00	IWM	ETF	110.835	110.88	110.729	110.8	1536660.0
2013-10-25 14:00:00	IWM	ETF	110.8	110.99	110.75	110.89	1724819.0
2013-10-25 15:00:00	IWM	ETF	110.9	111.08	110.77	111.06	4373700.0
2013-10-25 16:00:00	IWM	ETF	111.06	111.3347	110.8	110.98	1051776.0
2013-10-25 17:00:00	IWM	ETF	110.97	110.97	110.9	110.9	6332.0
2013-10-25 18:00:00	IWM	ETF	110.9	111.0	110.9	110.93	998.0
2013-10-25 07:00:00	DIA	ETF	154.86	154.86	154.86	154.86	500.0
2013-10-25 08:00:00	DIA	ETF	154.88	154.88	154.7	154.84	17655.0
2013-10-25 09:00:00	DIA	ETF	154.84	155.14	154.8	155.06	783168.0
2013-10-25 10:00:00	DIA	ETF	155.1	155.27	154.79	154.96	773388.0
2013-10-25 11:00:00	DIA	ETF	154.97	155.18	154.87	154.95	493358.0

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

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