PREVIEW / etf_1hour / 2013-04-25

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-04-25.parquet
  size:    201 KB
  rows:    6,313

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-04-25 04:00:00	SPY	ETF	157.94	158.02	157.89	157.98	1100.0
2013-04-25 05:00:00	SPY	ETF	158.1	158.3	158.1	158.17	80150.0
2013-04-25 06:00:00	SPY	ETF	158.2	158.33	158.2	158.32	26739.0
2013-04-25 07:00:00	SPY	ETF	158.3	158.54	158.27	158.44	523195.0
2013-04-25 08:00:00	SPY	ETF	158.44	158.72	158.08	158.53	1590577.0
2013-04-25 09:00:00	SPY	ETF	158.51	158.55	158.1	158.39	16131224.0
2013-04-25 10:00:00	SPY	ETF	158.39	159.03	158.34	158.9599	25115280.0
2013-04-25 11:00:00	SPY	ETF	158.95	159.04	158.77	158.8	14054753.0
2013-04-25 12:00:00	SPY	ETF	158.81	159.0	158.77	158.99	7870971.0
2013-04-25 13:00:00	SPY	ETF	158.99	159.24	158.9	159.181	10797661.0
2013-04-25 14:00:00	SPY	ETF	159.185	159.27	158.64	158.74	12797067.0
2013-04-25 15:00:00	SPY	ETF	158.74	158.745	158.27	158.55	27938469.0
2013-04-25 16:00:00	SPY	ETF	158.54	158.8117	158.3821	158.55	9367019.0
2013-04-25 17:00:00	SPY	ETF	158.54	158.64	158.52	158.6	1296815.0
2013-04-25 18:00:00	SPY	ETF	158.59	158.65	158.56	158.58	89514.0
2013-04-25 19:00:00	SPY	ETF	158.58	158.58	158.42	158.47	122646.0
2013-04-25 04:00:00	QQQ	ETF	69.38	69.42	69.38	69.42	300.0
2013-04-25 05:00:00	QQQ	ETF	69.47	69.57	69.47	69.53	8400.0
2013-04-25 06:00:00	QQQ	ETF	69.58	69.58	69.53	69.58	30470.0
2013-04-25 07:00:00	QQQ	ETF	69.58	69.65	69.56	69.6	61640.0
2013-04-25 08:00:00	QQQ	ETF	69.6	69.8	69.58	69.72	233468.0
2013-04-25 09:00:00	QQQ	ETF	69.71	69.89	69.59	69.78	4204696.0
2013-04-25 10:00:00	QQQ	ETF	69.79	70.05	69.74	69.96	5196740.0
2013-04-25 11:00:00	QQQ	ETF	69.96	70.025	69.83	69.87	2243128.0
2013-04-25 12:00:00	QQQ	ETF	69.869	69.96	69.835	69.93	1838996.0
2013-04-25 13:00:00	QQQ	ETF	69.93	70.01	69.9	69.9281	1224169.0
2013-04-25 14:00:00	QQQ	ETF	69.9245	70.0	69.7527	69.82	3292339.0
2013-04-25 15:00:00	QQQ	ETF	69.82	69.88	69.62	69.78	5116392.0
2013-04-25 16:00:00	QQQ	ETF	69.79	69.9	69.4075	69.83	1861780.0
2013-04-25 17:00:00	QQQ	ETF	69.82	69.82	69.69	69.73	593162.0
2013-04-25 18:00:00	QQQ	ETF	69.73	69.75	69.7	69.7	19280.0
2013-04-25 19:00:00	QQQ	ETF	69.7	69.71	69.68	69.68	16600.0
2013-04-25 04:00:00	IWM	ETF	92.86	92.86	92.86	92.86	400.0
2013-04-25 05:00:00	IWM	ETF	92.98	93.01	92.98	93.01	3992.0
2013-04-25 06:00:00	IWM	ETF	93.02	93.07	93.02	93.07	600.0
2013-04-25 07:00:00	IWM	ETF	93.05	93.19	93.05	93.17	57800.0
2013-04-25 08:00:00	IWM	ETF	93.06	93.27	93.02	93.14	102688.0
2013-04-25 09:00:00	IWM	ETF	93.11	93.65	92.89	93.56	5565936.0
2013-04-25 10:00:00	IWM	ETF	93.57	93.83	93.55	93.75	6002455.0
2013-04-25 11:00:00	IWM	ETF	93.75	93.86	93.555	93.62	2691112.0
2013-04-25 12:00:00	IWM	ETF	93.62	93.79	93.54	93.78	1954298.0
2013-04-25 13:00:00	IWM	ETF	93.785	93.9	93.72	93.85	2760336.0
2013-04-25 14:00:00	IWM	ETF	93.85	93.87	93.55	93.64	3106948.0
2013-04-25 15:00:00	IWM	ETF	93.62	93.63	93.25	93.37	8179798.0
2013-04-25 16:00:00	IWM	ETF	93.38	93.48	93.33	93.42	4824527.0
2013-04-25 17:00:00	IWM	ETF	93.43	93.48	93.23	93.28	31837.0
2013-04-25 18:00:00	IWM	ETF	93.28	93.4	93.28	93.4	1800.0
2013-04-25 19:00:00	IWM	ETF	93.4	93.4	93.4	93.4	500.0
2013-04-25 04:00:00	DIA	ETF	146.62	146.62	146.62	146.62	2900.0
2013-04-25 07:00:00	DIA	ETF	147.1	147.12	146.87	146.9	3403.0

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

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