PREVIEW / etf_30min / 2014-03-13

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-03-13.parquet
  size:    354 KB
  rows:    11,789

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-03-13 04:00:00	SPY	ETF	187.56	187.58	187.34	187.37	14500.0
2014-03-13 04:30:00	SPY	ETF	187.37	187.6	187.37	187.6	3900.0
2014-03-13 05:00:00	SPY	ETF	187.59	187.78	187.59	187.78	22507.0
2014-03-13 05:30:00	SPY	ETF	187.82	187.82	187.66	187.74	11396.0
2014-03-13 06:00:00	SPY	ETF	187.75	187.84	187.7	187.75	16763.0
2014-03-13 06:30:00	SPY	ETF	187.77	187.84	187.56	187.58	58291.0
2014-03-13 07:00:00	SPY	ETF	187.61	187.7	187.54	187.7	143715.0
2014-03-13 07:30:00	SPY	ETF	187.7	187.7	187.54	187.63	215493.0
2014-03-13 08:00:00	SPY	ETF	187.58	187.66	187.55	187.65	324033.0
2014-03-13 08:30:00	SPY	ETF	187.65	187.82	187.6	187.68	845863.0
2014-03-13 09:00:00	SPY	ETF	187.67	187.9	187.65	187.85	819411.0
2014-03-13 09:30:00	SPY	ETF	187.84	187.99	187.5	187.6	9419795.0
2014-03-13 10:00:00	SPY	ETF	187.5999	187.72	187.35	187.521	6588367.0
2014-03-13 10:30:00	SPY	ETF	187.53	187.61	186.9	186.922	7602827.0
2014-03-13 11:00:00	SPY	ETF	186.925	187.15	186.63	186.7	7599290.0
2014-03-13 11:30:00	SPY	ETF	186.7	186.91	186.49	186.54	6611082.0
2014-03-13 12:00:00	SPY	ETF	186.55	186.63	186.042	186.1	9248139.0
2014-03-13 12:30:00	SPY	ETF	186.095	186.11	185.6401	185.715	12485343.0
2014-03-13 13:00:00	SPY	ETF	185.715	185.84	185.06	185.83	16944557.0
2014-03-13 13:30:00	SPY	ETF	185.83	185.84	185.38	185.59	7896041.0
2014-03-13 14:00:00	SPY	ETF	185.59	185.66	185.12	185.3	7179667.0
2014-03-13 14:30:00	SPY	ETF	185.31	185.58	184.99	185.15	10922060.0
2014-03-13 15:00:00	SPY	ETF	185.15	186.189	184.66	184.98	14036093.0
2014-03-13 15:30:00	SPY	ETF	184.99	185.37	184.83	185.19	21584931.0
2014-03-13 16:00:00	SPY	ETF	185.19	187.3209	185.13	185.21	9049059.0
2014-03-13 16:30:00	SPY	ETF	185.22	187.29	185.19	185.28	1314682.0
2014-03-13 17:00:00	SPY	ETF	185.28	185.3	185.26	185.28	96348.0
2014-03-13 17:30:00	SPY	ETF	185.27	185.29	185.2	185.21	79699.0
2014-03-13 18:00:00	SPY	ETF	185.23	185.28	185.14	185.18	732400.0
2014-03-13 18:30:00	SPY	ETF	185.19	185.33	185.14	185.31	38323.0
2014-03-13 19:00:00	SPY	ETF	185.31	185.33	185.3	185.31	71000.0
2014-03-13 19:30:00	SPY	ETF	185.31	185.36	185.17	185.3	48862.0
2014-03-13 04:00:00	QQQ	ETF	90.75	90.75	90.63	90.63	5100.0
2014-03-13 04:30:00	QQQ	ETF	90.73	90.74	90.7	90.74	9700.0
2014-03-13 05:00:00	QQQ	ETF	90.81	90.87	90.81	90.87	26500.0
2014-03-13 05:30:00	QQQ	ETF	90.92	90.94	90.84	90.87	22130.0
2014-03-13 06:00:00	QQQ	ETF	90.86	90.88	90.85	90.85	2500.0
2014-03-13 06:30:00	QQQ	ETF	90.92	90.92	90.78	90.79	10000.0
2014-03-13 07:00:00	QQQ	ETF	90.77	90.82	90.77	90.82	7000.0
2014-03-13 07:30:00	QQQ	ETF	90.81	90.81	90.78	90.79	1700.0
2014-03-13 08:00:00	QQQ	ETF	90.8	90.84	90.76	90.83	50510.0
2014-03-13 08:30:00	QQQ	ETF	90.82	90.91	90.82	90.84	156802.0
2014-03-13 09:00:00	QQQ	ETF	90.85	90.96	90.84	90.91	146282.0
2014-03-13 09:30:00	QQQ	ETF	90.9	90.93	90.6501	90.83	3127633.0
2014-03-13 10:00:00	QQQ	ETF	90.839	90.91	90.61	90.69	1896018.0
2014-03-13 10:30:00	QQQ	ETF	90.69	90.7	90.29	90.33	1760842.0
2014-03-13 11:00:00	QQQ	ETF	90.34	90.42	90.17	90.181	1476503.0
2014-03-13 11:30:00	QQQ	ETF	90.18	90.31	90.04	90.11	2312739.0
2014-03-13 12:00:00	QQQ	ETF	90.11	90.16	89.76	89.79	2476040.0
2014-03-13 12:30:00	QQQ	ETF	89.79	89.8	89.49	89.55	2311949.0

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

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