PREVIEW / etf_30min / 2014-12-29

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-12-29.parquet
  size:    369 KB
  rows:    12,631

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-12-29 04:00:00	SPY	ETF	208.4	208.4	208.19	208.19	13570.0
2014-12-29 04:30:00	SPY	ETF	208.19	208.19	208.05	208.05	10605.0
2014-12-29 05:00:00	SPY	ETF	208.1	208.17	207.99	208.02	6834.0
2014-12-29 05:30:00	SPY	ETF	207.92	208.14	207.64	207.94	113175.0
2014-12-29 06:00:00	SPY	ETF	208.01	208.22	208.01	208.04	23136.0
2014-12-29 06:30:00	SPY	ETF	208.09	208.18	207.91	208.16	202325.0
2014-12-29 07:00:00	SPY	ETF	208.18	208.21	208.07	208.08	19807.0
2014-12-29 07:30:00	SPY	ETF	208.1	208.1	207.8	207.87	121439.0
2014-12-29 08:00:00	SPY	ETF	207.87	208.0	207.82	207.82	177512.0
2014-12-29 08:30:00	SPY	ETF	207.84	208.23	207.81	208.17	342182.0
2014-12-29 09:00:00	SPY	ETF	208.18	208.25	208.0247	208.22	510723.0
2014-12-29 09:30:00	SPY	ETF	208.22	208.8	208.14	208.75	14745252.0
2014-12-29 10:00:00	SPY	ETF	208.75	208.88	208.66	208.73	5861722.0
2014-12-29 10:30:00	SPY	ETF	208.73	208.96	208.72	208.89	4419906.0
2014-12-29 11:00:00	SPY	ETF	208.89	208.94	208.78	208.875	3030565.0
2014-12-29 11:30:00	SPY	ETF	208.8735	208.97	208.82	208.85	2434020.0
2014-12-29 12:00:00	SPY	ETF	208.85	208.95	208.68	208.71	4497262.0
2014-12-29 12:30:00	SPY	ETF	208.71	208.81	208.61	208.615	4451712.0
2014-12-29 13:00:00	SPY	ETF	208.61	208.86	208.575	208.79	3594196.0
2014-12-29 13:30:00	SPY	ETF	208.79	208.83	208.6	208.7099	2078968.0
2014-12-29 14:00:00	SPY	ETF	208.705	208.84	208.6461	208.81	4957187.0
2014-12-29 14:30:00	SPY	ETF	208.811	208.84	208.73	208.8299	6363774.0
2014-12-29 15:00:00	SPY	ETF	208.83	208.89	208.78	208.8165	2839889.0
2014-12-29 15:30:00	SPY	ETF	208.81	208.92	208.61	208.73	8837235.0
2014-12-29 16:00:00	SPY	ETF	208.75	208.82	208.6395	208.77	5914571.0
2014-12-29 16:30:00	SPY	ETF	208.79	208.92	208.72	208.92	818858.0
2014-12-29 17:00:00	SPY	ETF	208.92	208.92	208.72	208.83	2584232.0
2014-12-29 17:30:00	SPY	ETF	208.85	208.86	208.83	208.86	17552.0
2014-12-29 18:00:00	SPY	ETF	208.89	208.92	208.83	208.84	51590.0
2014-12-29 18:30:00	SPY	ETF	208.84	208.88	208.8	208.88	13538.0
2014-12-29 19:00:00	SPY	ETF	208.88	208.9	208.85	208.89	10175.0
2014-12-29 19:30:00	SPY	ETF	208.91	208.93	208.89	208.93	36646.0
2014-12-29 05:00:00	QQQ	ETF	105.02	105.02	105.02	105.02	100.0
2014-12-29 05:30:00	QQQ	ETF	104.79	104.8	104.79	104.8	6000.0
2014-12-29 06:00:00	QQQ	ETF	104.83	104.86	104.81	104.82	3900.0
2014-12-29 06:30:00	QQQ	ETF	104.86	104.86	104.84	104.84	600.0
2014-12-29 07:00:00	QQQ	ETF	104.94	104.94	104.89	104.91	2800.0
2014-12-29 07:30:00	QQQ	ETF	104.88	104.91	104.73	104.77	19000.0
2014-12-29 08:00:00	QQQ	ETF	104.79	104.98	104.72	104.74	42402.0
2014-12-29 08:30:00	QQQ	ETF	104.74	104.92	104.74	104.91	35231.0
2014-12-29 09:00:00	QQQ	ETF	104.9	104.94	104.85	104.93	154496.0
2014-12-29 09:30:00	QQQ	ETF	104.94	105.17	104.875	105.07	4313700.0
2014-12-29 10:00:00	QQQ	ETF	105.07	105.1	104.93	104.95	1561674.0
2014-12-29 10:30:00	QQQ	ETF	104.95	105.16	104.945	105.1372	1672827.0
2014-12-29 11:00:00	QQQ	ETF	105.13	105.24	105.0961	105.23	1002934.0
2014-12-29 11:30:00	QQQ	ETF	105.23	105.25	105.165	105.176	896365.0
2014-12-29 12:00:00	QQQ	ETF	105.17	105.201	105.11	105.11	549406.0
2014-12-29 12:30:00	QQQ	ETF	105.11	105.2	105.08	105.09	493158.0
2014-12-29 13:00:00	QQQ	ETF	105.09	105.18	105.075	105.1362	458046.0
2014-12-29 13:30:00	QQQ	ETF	105.14	105.14	104.99	105.0132	445193.0

> showing 50 of 12,631 rows — these rows as CSV

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