PREVIEW / etf_30min / 2014-07-24

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-07-24.parquet
  size:    341 KB
  rows:    11,956

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-24 04:00:00	SPY	ETF	198.47	198.77	198.47	198.77	3489.0
2014-07-24 04:30:00	SPY	ETF	198.77	198.89	198.77	198.89	2341.0
2014-07-24 05:00:00	SPY	ETF	198.88	198.88	198.84	198.87	4137.0
2014-07-24 05:30:00	SPY	ETF	198.85	198.89	198.79	198.79	9702.0
2014-07-24 06:00:00	SPY	ETF	198.83	198.83	198.83	198.83	534.0
2014-07-24 06:30:00	SPY	ETF	198.83	198.94	198.82	198.93	27344.0
2014-07-24 07:00:00	SPY	ETF	198.9	199.09	198.9	199.07	105580.0
2014-07-24 07:30:00	SPY	ETF	199.06	199.09	198.95	198.99	81915.0
2014-07-24 08:00:00	SPY	ETF	198.96	199.04	198.37	198.94	226815.0
2014-07-24 08:30:00	SPY	ETF	198.95	199.02	198.88	198.96	243855.0
2014-07-24 09:00:00	SPY	ETF	198.94	198.97	198.81	198.83	685369.0
2014-07-24 09:30:00	SPY	ETF	198.83	198.955	198.6	198.65	7885324.0
2014-07-24 10:00:00	SPY	ETF	198.65	198.78	198.45	198.73	5666641.0
2014-07-24 10:30:00	SPY	ETF	198.74	198.81	198.615	198.76	2754729.0
2014-07-24 11:00:00	SPY	ETF	198.76	199.0	198.72	198.9798	3402984.0
2014-07-24 11:30:00	SPY	ETF	198.97	199.06	198.92	198.93	2804292.0
2014-07-24 12:00:00	SPY	ETF	198.935	199.0	198.88	198.88	1750584.0
2014-07-24 12:30:00	SPY	ETF	198.884	198.9	198.82	198.83	1186910.0
2014-07-24 13:00:00	SPY	ETF	198.83	198.84	198.6	198.81	4932722.0
2014-07-24 13:30:00	SPY	ETF	198.8077	198.91	198.69	198.91	1997755.0
2014-07-24 14:00:00	SPY	ETF	198.905	198.94	198.84	198.87	1593633.0
2014-07-24 14:30:00	SPY	ETF	198.87	198.89	198.54	198.57	4446976.0
2014-07-24 15:00:00	SPY	ETF	198.56	198.67	198.47	198.59	3716886.0
2014-07-24 15:30:00	SPY	ETF	198.59	198.84	198.59	198.65	7498306.0
2014-07-24 16:00:00	SPY	ETF	198.65	198.74	198.47	198.51	3891723.0
2014-07-24 16:30:00	SPY	ETF	198.51	198.7308	198.32	198.43	656372.0
2014-07-24 17:00:00	SPY	ETF	198.42	198.44	198.17	198.32	133839.0
2014-07-24 17:30:00	SPY	ETF	198.28	198.4	198.28	198.35	90306.0
2014-07-24 18:00:00	SPY	ETF	198.34	198.38	198.24	198.35	48773.0
2014-07-24 18:30:00	SPY	ETF	198.36	198.37	198.34	198.36	17000.0
2014-07-24 19:00:00	SPY	ETF	198.33	198.33	198.28	198.3	11614.0
2014-07-24 19:30:00	SPY	ETF	198.3	198.38	198.28	198.36	41332.0
2014-07-24 04:30:00	QQQ	ETF	97.4	97.4	97.4	97.4	200.0
2014-07-24 05:30:00	QQQ	ETF	97.43	97.43	97.42	97.42	16200.0
2014-07-24 07:00:00	QQQ	ETF	97.46	97.52	97.45	97.52	69220.0
2014-07-24 07:30:00	QQQ	ETF	97.52	97.53	97.47	97.47	15410.0
2014-07-24 08:00:00	QQQ	ETF	97.47	97.5	97.44	97.46	30493.0
2014-07-24 08:30:00	QQQ	ETF	97.46	97.49	97.4	97.42	146096.0
2014-07-24 09:00:00	QQQ	ETF	97.42	97.42	97.37	97.4	362286.0
2014-07-24 09:30:00	QQQ	ETF	97.4	97.51	97.12	97.17	4425303.0
2014-07-24 10:00:00	QQQ	ETF	97.17	97.19	96.98	97.12	2832259.0
2014-07-24 10:30:00	QQQ	ETF	97.12	97.19	96.99	97.17	1626060.0
2014-07-24 11:00:00	QQQ	ETF	97.18	97.34	97.13	97.29	1574770.0
2014-07-24 11:30:00	QQQ	ETF	97.29	97.4	97.29	97.35	1004071.0
2014-07-24 12:00:00	QQQ	ETF	97.355	97.41	97.25	97.25	964510.0
2014-07-24 12:30:00	QQQ	ETF	97.26	97.29	97.17	97.17	950877.0
2014-07-24 13:00:00	QQQ	ETF	97.17	97.17	97.025	97.1399	1249461.0
2014-07-24 13:30:00	QQQ	ETF	97.14	97.26	97.1	97.26	743239.0
2014-07-24 14:00:00	QQQ	ETF	97.27	97.33	97.22	97.25	979598.0
2014-07-24 14:30:00	QQQ	ETF	97.26	97.275	97.08	97.1	1341499.0

> showing 50 of 11,956 rows — these rows as CSV

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