PREVIEW / etf_30min / 2014-07-21

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-07-21.parquet
  size:    342 KB
  rows:    11,857

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-21 04:00:00	SPY	ETF	197.51	197.51	197.13	197.13	32865.0
2014-07-21 04:30:00	SPY	ETF	197.13	197.32	197.13	197.21	12683.0
2014-07-21 05:00:00	SPY	ETF	197.25	197.32	197.25	197.25	1515.0
2014-07-21 05:30:00	SPY	ETF	197.4	197.49	197.4	197.41	10706.0
2014-07-21 06:00:00	SPY	ETF	197.32	197.32	197.23	197.31	1637.0
2014-07-21 06:30:00	SPY	ETF	197.34	197.4	197.13	197.13	99579.0
2014-07-21 07:00:00	SPY	ETF	197.19	197.31	197.14	197.27	120308.0
2014-07-21 07:30:00	SPY	ETF	197.27	197.28	197.18	197.22	63926.0
2014-07-21 08:00:00	SPY	ETF	197.22	197.61	197.17	197.25	287432.0
2014-07-21 08:30:00	SPY	ETF	197.23	197.3	197.17	197.23	120205.0
2014-07-21 09:00:00	SPY	ETF	197.22	197.22	196.88	197.09	867769.0
2014-07-21 09:30:00	SPY	ETF	197.09	197.29	196.84	197.1974	9288683.0
2014-07-21 10:00:00	SPY	ETF	197.2	197.221	196.79	196.99	5517538.0
2014-07-21 10:30:00	SPY	ETF	196.99	197.0	196.43	196.56	8001828.0
2014-07-21 11:00:00	SPY	ETF	196.55	196.96	196.46	196.91	4394429.0
2014-07-21 11:30:00	SPY	ETF	196.915	197.03	196.67	197.0	5024587.0
2014-07-21 12:00:00	SPY	ETF	197.01	197.04	196.83	196.85	4810633.0
2014-07-21 12:30:00	SPY	ETF	196.84	196.99	196.84	196.915	2007785.0
2014-07-21 13:00:00	SPY	ETF	196.91	197.3077	196.88	197.29	2847929.0
2014-07-21 13:30:00	SPY	ETF	197.29	197.45	197.2	197.38	2484110.0
2014-07-21 14:00:00	SPY	ETF	197.37	197.46	197.249	197.29	2326083.0
2014-07-21 14:30:00	SPY	ETF	197.29	197.475	197.2	197.4	2503936.0
2014-07-21 15:00:00	SPY	ETF	197.4	197.5	197.3	197.485	3360656.0
2014-07-21 15:30:00	SPY	ETF	197.48	197.49	197.23	197.3	7488922.0
2014-07-21 16:00:00	SPY	ETF	197.32	197.34	197.0226	197.18	4689990.0
2014-07-21 16:30:00	SPY	ETF	197.18	197.2	197.0226	197.09	121459.0
2014-07-21 17:00:00	SPY	ETF	197.08	197.12	197.05	197.12	71438.0
2014-07-21 17:30:00	SPY	ETF	197.11	197.12	197.05	197.08	55307.0
2014-07-21 18:00:00	SPY	ETF	197.08	197.13	197.06	197.08	39398.0
2014-07-21 18:30:00	SPY	ETF	197.12	197.12	197.07	197.09	28200.0
2014-07-21 19:00:00	SPY	ETF	197.09	197.12	197.09	197.1	25900.0
2014-07-21 19:30:00	SPY	ETF	197.09	197.11	197.08	197.08	26112.0
2014-07-21 04:00:00	QQQ	ETF	95.87	95.87	95.76	95.82	14400.0
2014-07-21 04:30:00	QQQ	ETF	95.9	96.0	95.9	95.91	2200.0
2014-07-21 06:00:00	QQQ	ETF	95.96	95.98	95.96	95.98	200.0
2014-07-21 06:30:00	QQQ	ETF	96.0	96.0	95.9	95.9	6040.0
2014-07-21 07:00:00	QQQ	ETF	95.92	95.98	95.9	95.98	9300.0
2014-07-21 07:30:00	QQQ	ETF	95.98	95.98	95.94	95.95	30033.0
2014-07-21 08:00:00	QQQ	ETF	95.95	96.0	95.92	95.95	23400.0
2014-07-21 08:30:00	QQQ	ETF	95.95	95.99	95.91	95.93	48756.0
2014-07-21 09:00:00	QQQ	ETF	95.94	95.96	95.81	95.92	228726.0
2014-07-21 09:30:00	QQQ	ETF	95.91	96.04	95.745	95.92	3723302.0
2014-07-21 10:00:00	QQQ	ETF	95.92	95.939	95.64	95.84	2762261.0
2014-07-21 10:30:00	QQQ	ETF	95.84	95.84	95.56	95.6	1657712.0
2014-07-21 11:00:00	QQQ	ETF	95.6	95.88	95.55	95.83	1724752.0
2014-07-21 11:30:00	QQQ	ETF	95.84	95.86	95.68	95.855	1358937.0
2014-07-21 12:00:00	QQQ	ETF	95.86	95.86	95.74	95.75	1001697.0
2014-07-21 12:30:00	QQQ	ETF	95.75	95.88	95.75	95.85	633770.0
2014-07-21 13:00:00	QQQ	ETF	95.85	96.07	95.825	96.07	926633.0
2014-07-21 13:30:00	QQQ	ETF	96.06	96.16	96.0	96.11	1091217.0

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

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