PREVIEW / etf_1hour / 2014-07-18

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-07-18.parquet
  size:    226 KB
  rows:    7,375

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-07-18 04:00:00	SPY	ETF	195.96	196.02	195.96	195.98	1159.0
2014-07-18 05:00:00	SPY	ETF	195.97	195.98	195.67	195.67	6350.0
2014-07-18 06:00:00	SPY	ETF	195.83	196.25	195.82	196.2	102541.0
2014-07-18 07:00:00	SPY	ETF	196.18	196.36	196.0	196.06	471658.0
2014-07-18 08:00:00	SPY	ETF	196.11	196.3	196.04	196.1	775232.0
2014-07-18 09:00:00	SPY	ETF	196.11	196.62	196.11	196.4699	26486268.0
2014-07-18 10:00:00	SPY	ETF	196.47	196.98	196.28	196.925	14992696.0
2014-07-18 11:00:00	SPY	ETF	196.93	197.32	196.86	197.16	16880231.0
2014-07-18 12:00:00	SPY	ETF	197.16	197.45	197.15	197.37	10051292.0
2014-07-18 13:00:00	SPY	ETF	197.37	197.39	197.04	197.36	7517581.0
2014-07-18 14:00:00	SPY	ETF	197.36	197.73	197.2383	197.6	13607522.0
2014-07-18 15:00:00	SPY	ETF	197.6	197.91	197.55	197.72	21705213.0
2014-07-18 16:00:00	SPY	ETF	197.72	197.77	195.7158	197.65	9757159.0
2014-07-18 17:00:00	SPY	ETF	197.65	197.75	197.56	197.73	115994.0
2014-07-18 18:00:00	SPY	ETF	197.7	197.78	197.7	197.72	41376.0
2014-07-18 19:00:00	SPY	ETF	197.74	197.75	197.71	197.74	10305.0
2014-07-18 04:00:00	QQQ	ETF	94.76	94.76	94.76	94.76	300.0
2014-07-18 06:00:00	QQQ	ETF	94.8	94.9	94.72	94.9	1300.0
2014-07-18 07:00:00	QQQ	ETF	94.9	95.0	94.9	94.9	86150.0
2014-07-18 08:00:00	QQQ	ETF	94.93	95.07	94.93	95.02	127125.0
2014-07-18 09:00:00	QQQ	ETF	95.02	95.3999	95.0	95.205	6728251.0
2014-07-18 10:00:00	QQQ	ETF	95.21	95.5	95.04	95.48	5189042.0
2014-07-18 11:00:00	QQQ	ETF	95.48	95.72	95.48	95.63	4910949.0
2014-07-18 12:00:00	QQQ	ETF	95.64	95.8101	95.62	95.7601	2510803.0
2014-07-18 13:00:00	QQQ	ETF	95.77	95.87	95.62	95.84	2101782.0
2014-07-18 14:00:00	QQQ	ETF	95.84	96.1	95.78	95.9911	3821434.0
2014-07-18 15:00:00	QQQ	ETF	95.99	96.17	95.97	96.11	6552547.0
2014-07-18 16:00:00	QQQ	ETF	96.11	96.1213	95.4185	96.07	1968179.0
2014-07-18 17:00:00	QQQ	ETF	96.07	96.07	96.05	96.06	18642.0
2014-07-18 18:00:00	QQQ	ETF	96.06	96.09	96.06	96.09	1750.0
2014-07-18 19:00:00	QQQ	ETF	96.15	96.18	96.1	96.13	6447.0
2014-07-18 04:00:00	IWM	ETF	112.35	112.47	112.35	112.41	1700.0
2014-07-18 05:00:00	IWM	ETF	112.32	112.32	112.32	112.32	100.0
2014-07-18 06:00:00	IWM	ETF	112.55	112.69	112.55	112.68	26100.0
2014-07-18 07:00:00	IWM	ETF	112.68	112.85	112.47	112.49	88273.0
2014-07-18 08:00:00	IWM	ETF	112.54	112.75	112.44	112.46	271715.0
2014-07-18 09:00:00	IWM	ETF	112.52	113.2	112.46	113.13	7941831.0
2014-07-18 10:00:00	IWM	ETF	113.14	113.83	113.01	113.81	8457841.0
2014-07-18 11:00:00	IWM	ETF	113.82	114.02	113.64	113.92	4371414.0
2014-07-18 12:00:00	IWM	ETF	113.92	114.45	113.89	114.18	4506499.0
2014-07-18 13:00:00	IWM	ETF	114.19	114.2	113.805	113.9899	2469840.0
2014-07-18 14:00:00	IWM	ETF	113.99	114.29	113.89	114.13	3746803.0
2014-07-18 15:00:00	IWM	ETF	114.14	114.44	114.03	114.24	6280955.0
2014-07-18 16:00:00	IWM	ETF	114.23	114.29	114.1	114.12	1279368.0
2014-07-18 17:00:00	IWM	ETF	114.12	114.3	114.01	114.3	26573.0
2014-07-18 19:00:00	IWM	ETF	114.3	114.3	114.3	114.3	600.0
2014-07-18 06:00:00	DIA	ETF	169.71	169.71	169.71	169.71	100.0
2014-07-18 07:00:00	DIA	ETF	169.8	169.81	169.8	169.81	200.0
2014-07-18 08:00:00	DIA	ETF	169.76	169.8	169.68	169.8	3700.0
2014-07-18 09:00:00	DIA	ETF	169.77	170.06	169.58	169.84	1476692.0

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

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