PREVIEW / etf_1hour / 2014-05-27

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-05-27.parquet
  size:    221 KB
  rows:    7,094

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-27 04:00:00	SPY	ETF	190.54	191.18	190.54	191.18	7146.0
2014-05-27 05:00:00	SPY	ETF	191.23	191.23	190.47	191.07	16176.0
2014-05-27 06:00:00	SPY	ETF	191.09	191.19	191.07	191.07	24466.0
2014-05-27 07:00:00	SPY	ETF	191.06	191.1	190.91	190.95	133088.0
2014-05-27 08:00:00	SPY	ETF	190.95	191.11	190.88	191.05	407610.0
2014-05-27 09:00:00	SPY	ETF	191.07	191.29	190.95	191.13	10811938.0
2014-05-27 10:00:00	SPY	ETF	191.13	191.49	191.09	191.425	12313596.0
2014-05-27 11:00:00	SPY	ETF	191.43	191.49	191.21	191.27	7748651.0
2014-05-27 12:00:00	SPY	ETF	191.28	191.37	191.09	191.23	3884241.0
2014-05-27 13:00:00	SPY	ETF	191.23	191.32	191.08	191.2999	4902858.0
2014-05-27 14:00:00	SPY	ETF	191.29	191.37	191.22	191.32	3889203.0
2014-05-27 15:00:00	SPY	ETF	191.33	191.58	191.32	191.54	13595243.0
2014-05-27 16:00:00	SPY	ETF	191.53	191.64	191.1	191.55	6588536.0
2014-05-27 17:00:00	SPY	ETF	191.55	191.59	191.52	191.59	99197.0
2014-05-27 18:00:00	SPY	ETF	191.56	191.56	191.47	191.48	23681.0
2014-05-27 19:00:00	SPY	ETF	191.52	191.54	191.5	191.53	31113.0
2014-05-27 04:00:00	QQQ	ETF	90.15	90.25	90.15	90.25	26000.0
2014-05-27 05:00:00	QQQ	ETF	90.28	90.28	90.28	90.28	210.0
2014-05-27 06:00:00	QQQ	ETF	90.3	90.35	90.25	90.28	13643.0
2014-05-27 07:00:00	QQQ	ETF	90.32	90.35	90.25	90.28	78482.0
2014-05-27 08:00:00	QQQ	ETF	90.38	90.38	90.2	90.29	218679.0
2014-05-27 09:00:00	QQQ	ETF	90.29	90.49	90.2	90.32	4299126.0
2014-05-27 10:00:00	QQQ	ETF	90.33	90.63	90.31	90.59	3943820.0
2014-05-27 11:00:00	QQQ	ETF	90.59	90.68	90.51	90.54	3641017.0
2014-05-27 12:00:00	QQQ	ETF	90.54	90.65	90.47	90.595	1796581.0
2014-05-27 13:00:00	QQQ	ETF	90.59	90.67	90.49	90.66	1556094.0
2014-05-27 14:00:00	QQQ	ETF	90.66	90.73	90.62	90.685	2089483.0
2014-05-27 15:00:00	QQQ	ETF	90.69	91.01	90.68	91.01	7056875.0
2014-05-27 16:00:00	QQQ	ETF	91.01	91.02	90.5394	91.01	3784375.0
2014-05-27 17:00:00	QQQ	ETF	91.0	91.02	90.96	91.0	37105.0
2014-05-27 18:00:00	QQQ	ETF	90.98	91.0	90.94	90.96	12468.0
2014-05-27 19:00:00	QQQ	ETF	90.96	90.97	90.96	90.97	1600.0
2014-05-27 04:00:00	IWM	ETF	112.4	112.77	112.4	112.77	200.0
2014-05-27 06:00:00	IWM	ETF	112.7	112.7	112.7	112.7	100.0
2014-05-27 07:00:00	IWM	ETF	112.7	112.73	112.6	112.68	140395.0
2014-05-27 08:00:00	IWM	ETF	112.66	112.8	112.54	112.75	122313.0
2014-05-27 09:00:00	IWM	ETF	112.8	113.14	112.65	112.96	6431303.0
2014-05-27 10:00:00	IWM	ETF	112.96	113.83	112.87	113.77	8961784.0
2014-05-27 11:00:00	IWM	ETF	113.77	113.84	113.27	113.37	4548656.0
2014-05-27 12:00:00	IWM	ETF	113.365	113.45	113.12	113.26	2640014.0
2014-05-27 13:00:00	IWM	ETF	113.26	113.35	112.9601	113.32	2087133.0
2014-05-27 14:00:00	IWM	ETF	113.31	113.47	113.1601	113.38	2151278.0
2014-05-27 15:00:00	IWM	ETF	113.37	113.61	113.33	113.61	6526822.0
2014-05-27 16:00:00	IWM	ETF	113.61	113.66	113.0555	113.65	2718392.0
2014-05-27 17:00:00	IWM	ETF	113.64	113.66	113.64	113.66	4000.0
2014-05-27 18:00:00	IWM	ETF	113.57	113.57	113.54	113.54	1708.0
2014-05-27 19:00:00	IWM	ETF	113.51	113.51	113.5	113.5	300.0
2014-05-27 06:00:00	DIA	ETF	166.55	166.55	166.55	166.55	200.0
2014-05-27 08:00:00	DIA	ETF	166.27	166.55	166.12	166.53	7410.0
2014-05-27 09:00:00	DIA	ETF	166.51	166.59	166.13	166.36	728713.0

> showing 50 of 7,094 rows — these rows as CSV

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