PREVIEW / etf_1hour / 2013-04-11

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-04-11.parquet
  size:    199 KB
  rows:    6,237

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-11 04:00:00	SPY	ETF	158.61	158.95	158.61	158.95	386672.0
2013-04-11 05:00:00	SPY	ETF	158.95	159.02	158.86	158.88	165715.0
2013-04-11 06:00:00	SPY	ETF	158.85	158.86	158.73	158.76	10803.0
2013-04-11 07:00:00	SPY	ETF	158.8	158.87	158.71	158.71	400146.0
2013-04-11 08:00:00	SPY	ETF	158.71	158.875	158.62	158.79	1060844.0
2013-04-11 09:00:00	SPY	ETF	158.8	158.98	158.54	158.83	11754841.0
2013-04-11 10:00:00	SPY	ETF	158.82	159.49	158.82	159.4597	19247209.0
2013-04-11 11:00:00	SPY	ETF	159.46	159.71	159.25	159.37	15901153.0
2013-04-11 12:00:00	SPY	ETF	159.38	159.49	159.17	159.4699	9297305.0
2013-04-11 13:00:00	SPY	ETF	159.47	159.63	159.25	159.25	9921861.0
2013-04-11 14:00:00	SPY	ETF	159.251	159.46	159.06	159.4301	11690008.0
2013-04-11 15:00:00	SPY	ETF	159.43	159.525	159.03	159.21	18674930.0
2013-04-11 16:00:00	SPY	ETF	159.21	159.3696	158.7158	159.23	7659064.0
2013-04-11 17:00:00	SPY	ETF	159.22	159.27	159.21	159.23	38195.0
2013-04-11 18:00:00	SPY	ETF	159.23	159.37	159.2	159.31	62688.0
2013-04-11 19:00:00	SPY	ETF	159.31	159.37	159.21	159.21	54956.0
2013-04-11 04:00:00	QQQ	ETF	69.93	70.02	69.93	70.02	1300.0
2013-04-11 05:00:00	QQQ	ETF	70.05	70.05	69.99	69.99	42000.0
2013-04-11 06:00:00	QQQ	ETF	69.97	69.97	69.89	69.9	71800.0
2013-04-11 07:00:00	QQQ	ETF	69.94	69.94	69.83	69.84	176910.0
2013-04-11 08:00:00	QQQ	ETF	69.85	70.11	69.8	69.87	453842.0
2013-04-11 09:00:00	QQQ	ETF	69.87	69.94	69.77	69.82	5829422.0
2013-04-11 10:00:00	QQQ	ETF	69.82	70.05	69.811	70.05	5272088.0
2013-04-11 11:00:00	QQQ	ETF	70.05	70.15	69.905	69.9601	3736317.0
2013-04-11 12:00:00	QQQ	ETF	69.96	70.02	69.9	70.01	1817496.0
2013-04-11 13:00:00	QQQ	ETF	70.01	70.09	69.92	69.93	3457446.0
2013-04-11 14:00:00	QQQ	ETF	69.93	70.05	69.83	70.035	3084299.0
2013-04-11 15:00:00	QQQ	ETF	70.035	70.11	69.87	69.99	5057020.0
2013-04-11 16:00:00	QQQ	ETF	69.99	70.06	69.8599	70.0235	5853369.0
2013-04-11 17:00:00	QQQ	ETF	70.05	70.05	70.0	70.02	19013.0
2013-04-11 18:00:00	QQQ	ETF	70.02	70.08	70.02	70.08	29680.0
2013-04-11 19:00:00	QQQ	ETF	70.08	70.08	70.01	70.02	1763.0
2013-04-11 04:00:00	IWM	ETF	94.0	94.0	94.0	94.0	100.0
2013-04-11 05:00:00	IWM	ETF	94.26	94.26	94.26	94.26	373.0
2013-04-11 06:00:00	IWM	ETF	94.12	94.12	94.12	94.12	100.0
2013-04-11 07:00:00	IWM	ETF	94.12	94.13	94.04	94.06	30750.0
2013-04-11 08:00:00	IWM	ETF	94.0	94.01	93.83	93.88	240417.0
2013-04-11 09:00:00	IWM	ETF	93.87	94.185	93.75	94.09	3586388.0
2013-04-11 10:00:00	IWM	ETF	94.09	94.39	94.07	94.37	4315624.0
2013-04-11 11:00:00	IWM	ETF	94.37	94.575	94.23	94.34	4425882.0
2013-04-11 12:00:00	IWM	ETF	94.35	94.35	94.175	94.3	1897250.0
2013-04-11 13:00:00	IWM	ETF	94.31	94.4	94.02	94.045	2778571.0
2013-04-11 14:00:00	IWM	ETF	94.055	94.17	93.93	94.14	2683178.0
2013-04-11 15:00:00	IWM	ETF	94.13	94.24	93.9	94.04	5922812.0
2013-04-11 16:00:00	IWM	ETF	94.05	94.22	94.0	94.17	1486455.0
2013-04-11 17:00:00	IWM	ETF	94.2	94.24	94.16	94.24	15345.0
2013-04-11 18:00:00	IWM	ETF	94.18	94.24	94.12	94.24	14000.0
2013-04-11 19:00:00	IWM	ETF	94.26	94.28	94.18	94.18	9200.0
2013-04-11 04:00:00	DIA	ETF	148.03	148.03	148.0	148.0	200.0
2013-04-11 05:00:00	DIA	ETF	148.03	148.03	148.03	148.03	100.0

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

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