PREVIEW / etf_30min / 2014-07-30

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-07-30.parquet
  size:    351 KB
  rows:    12,041

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-30 04:00:00	SPY	ETF	197.06	197.15	197.06	197.13	1004.0
2014-07-30 04:30:00	SPY	ETF	197.02	197.14	197.02	197.14	1181.0
2014-07-30 05:00:00	SPY	ETF	197.08	197.22	197.08	197.22	5850.0
2014-07-30 05:30:00	SPY	ETF	197.2	197.25	197.2	197.25	17970.0
2014-07-30 06:30:00	SPY	ETF	197.14	197.31	197.14	197.31	55177.0
2014-07-30 07:00:00	SPY	ETF	197.28	197.49	197.23	197.46	230228.0
2014-07-30 07:30:00	SPY	ETF	197.46	197.48	197.39	197.47	74663.0
2014-07-30 08:00:00	SPY	ETF	197.38	197.48	197.15	197.28	252237.0
2014-07-30 08:30:00	SPY	ETF	197.26	197.88	197.23	197.67	2058775.0
2014-07-30 09:00:00	SPY	ETF	197.67	197.71	197.45	197.65	866665.0
2014-07-30 09:30:00	SPY	ETF	197.65	197.91	197.18	197.23	9288140.0
2014-07-30 10:00:00	SPY	ETF	197.23	197.29	196.79	197.13	11190758.0
2014-07-30 10:30:00	SPY	ETF	197.135	197.22	196.5	196.68	7254153.0
2014-07-30 11:00:00	SPY	ETF	196.66	196.8889	196.27	196.775	6545317.0
2014-07-30 11:30:00	SPY	ETF	196.77	196.79	196.24	196.3	4415427.0
2014-07-30 12:00:00	SPY	ETF	196.3	196.65	196.16	196.565	5561348.0
2014-07-30 12:30:00	SPY	ETF	196.565	196.79	196.465	196.71	3147050.0
2014-07-30 13:00:00	SPY	ETF	196.71	196.74	196.34	196.4301	3291263.0
2014-07-30 13:30:00	SPY	ETF	196.435	196.7	196.4	196.65	4459077.0
2014-07-30 14:00:00	SPY	ETF	196.63	197.63	196.39	197.36	20582701.0
2014-07-30 14:30:00	SPY	ETF	197.36	197.43	196.71	196.92	6344334.0
2014-07-30 15:00:00	SPY	ETF	196.92	197.04	196.61	196.99	7071134.0
2014-07-30 15:30:00	SPY	ETF	196.98	197.2	196.97	196.99	8050348.0
2014-07-30 16:00:00	SPY	ETF	196.99	197.04	196.9	197.0	2131396.0
2014-07-30 16:30:00	SPY	ETF	197.0	197.02	196.7762	197.0	676860.0
2014-07-30 17:00:00	SPY	ETF	197.0	197.04	196.96	197.03	43045.0
2014-07-30 17:30:00	SPY	ETF	197.02	197.05	197.0	197.04	51451.0
2014-07-30 18:00:00	SPY	ETF	197.04	197.04	196.95	196.95	74490.0
2014-07-30 18:30:00	SPY	ETF	196.97	197.01	196.97	197.0	10249.0
2014-07-30 19:00:00	SPY	ETF	197.0	197.0	196.96	196.98	3445.0
2014-07-30 19:30:00	SPY	ETF	196.96	196.96	196.9	196.9	19909.0
2014-07-30 04:00:00	QQQ	ETF	96.73	96.73	96.73	96.73	100.0
2014-07-30 04:30:00	QQQ	ETF	96.78	96.78	96.78	96.78	100.0
2014-07-30 05:00:00	QQQ	ETF	96.82	96.88	96.82	96.88	3000.0
2014-07-30 05:30:00	QQQ	ETF	96.87	96.87	96.87	96.87	800.0
2014-07-30 06:30:00	QQQ	ETF	96.85	96.92	96.85	96.92	44100.0
2014-07-30 07:00:00	QQQ	ETF	96.91	97.02	96.91	97.02	42940.0
2014-07-30 07:30:00	QQQ	ETF	96.97	97.01	96.96	97.01	42250.0
2014-07-30 08:00:00	QQQ	ETF	96.99	97.0	96.87	96.9	70437.0
2014-07-30 08:30:00	QQQ	ETF	96.91	97.22	96.91	97.15	406450.0
2014-07-30 09:00:00	QQQ	ETF	97.17	97.17	97.07	97.14	331755.0
2014-07-30 09:30:00	QQQ	ETF	97.13	97.32	96.98	97.02	3878813.0
2014-07-30 10:00:00	QQQ	ETF	97.02	97.06	96.81	96.98	2570334.0
2014-07-30 10:30:00	QQQ	ETF	96.99	97.09	96.669	96.8	3019363.0
2014-07-30 11:00:00	QQQ	ETF	96.79	96.955	96.63	96.88	2240437.0
2014-07-30 11:30:00	QQQ	ETF	96.87	96.89	96.67	96.69	1379379.0
2014-07-30 12:00:00	QQQ	ETF	96.7	96.83	96.6	96.79	1584126.0
2014-07-30 12:30:00	QQQ	ETF	96.8	96.88	96.74	96.835	1195783.0
2014-07-30 13:00:00	QQQ	ETF	96.84	96.86	96.7	96.78	838244.0
2014-07-30 13:30:00	QQQ	ETF	96.78	96.94	96.7539	96.88	810481.0

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

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