PREVIEW / etf_30min / 2015-05-13

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-05-13.parquet
  size:    372 KB
  rows:    12,526

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
2015-05-13 04:00:00	SPY	ETF	210.7	211.08	210.7	211.01	25352.0
2015-05-13 04:30:00	SPY	ETF	211.01	211.01	210.89	210.89	2900.0
2015-05-13 05:00:00	SPY	ETF	211.02	211.04	210.81	210.88	73640.0
2015-05-13 05:30:00	SPY	ETF	210.85	211.0	210.81	210.81	35620.0
2015-05-13 06:00:00	SPY	ETF	210.9	210.9	210.74	210.74	15266.0
2015-05-13 06:30:00	SPY	ETF	210.79	210.79	210.65	210.65	16160.0
2015-05-13 07:00:00	SPY	ETF	210.65	210.69	210.5	210.55	140561.0
2015-05-13 07:30:00	SPY	ETF	210.55	210.78	210.55	210.77	273502.0
2015-05-13 08:00:00	SPY	ETF	210.65	210.97	210.59	210.66	219116.0
2015-05-13 08:30:00	SPY	ETF	210.65	210.76	210.26	210.44	1085270.0
2015-05-13 09:00:00	SPY	ETF	210.41	210.6	210.15	210.47	880154.0
2015-05-13 09:30:00	SPY	ETF	210.47	211.22	210.29	210.81	11257005.0
2015-05-13 10:00:00	SPY	ETF	210.8	210.98	210.62	210.73	5488492.0
2015-05-13 10:30:00	SPY	ETF	210.73	210.79	210.04	210.055	10633305.0
2015-05-13 11:00:00	SPY	ETF	210.06	210.28	209.85	210.06	5785710.0
2015-05-13 11:30:00	SPY	ETF	210.08	210.44	209.88	210.2399	4387757.0
2015-05-13 12:00:00	SPY	ETF	210.24	210.42	209.92	210.04	3786653.0
2015-05-13 12:30:00	SPY	ETF	210.03	210.2895	209.92	210.19	2058537.0
2015-05-13 13:00:00	SPY	ETF	210.19	210.59	210.18	210.445	3771039.0
2015-05-13 13:30:00	SPY	ETF	210.45	210.54	210.24	210.365	2392593.0
2015-05-13 14:00:00	SPY	ETF	210.37	210.4	209.87	209.99	3755840.0
2015-05-13 14:30:00	SPY	ETF	209.99	210.22	209.88	209.97	3514531.0
2015-05-13 15:00:00	SPY	ETF	209.96	210.22	209.81	209.91	4754518.0
2015-05-13 15:30:00	SPY	ETF	209.9	210.1	209.74	210.04	13889493.0
2015-05-13 16:00:00	SPY	ETF	210.03	210.9717	209.905	210.09	6917132.0
2015-05-13 16:30:00	SPY	ETF	210.1	210.24	210.0645	210.21	2974276.0
2015-05-13 17:00:00	SPY	ETF	210.19	210.22	210.09	210.11	61795.0
2015-05-13 17:30:00	SPY	ETF	210.15	210.27	210.11	210.15	28236.0
2015-05-13 18:00:00	SPY	ETF	210.17	210.35	210.16	210.25	71685.0
2015-05-13 18:30:00	SPY	ETF	210.255	210.26	210.18	210.18	12080.0
2015-05-13 19:00:00	SPY	ETF	210.23	210.24	210.2	210.21	6918.0
2015-05-13 19:30:00	SPY	ETF	210.21	210.23	210.199	210.22	5951.0
2015-05-13 03:30:00	QQQ	ETF	108.35	108.35	108.35	108.35	100.0
2015-05-13 04:00:00	QQQ	ETF	108.48	108.48	108.47	108.47	6350.0
2015-05-13 06:00:00	QQQ	ETF	108.37	108.37	108.35	108.35	7700.0
2015-05-13 06:30:00	QQQ	ETF	108.31	108.34	108.3	108.34	10300.0
2015-05-13 07:00:00	QQQ	ETF	108.32	108.34	108.24	108.26	28800.0
2015-05-13 07:30:00	QQQ	ETF	108.26	108.37	108.24	108.36	14416.0
2015-05-13 08:00:00	QQQ	ETF	108.36	108.48	108.25	108.32	74485.0
2015-05-13 08:30:00	QQQ	ETF	108.25	108.46	108.13	108.3	165274.0
2015-05-13 09:00:00	QQQ	ETF	108.28	108.33	108.11	108.26	164182.0
2015-05-13 09:30:00	QQQ	ETF	108.25	108.81	108.11	108.52	4848140.0
2015-05-13 10:00:00	QQQ	ETF	108.51	108.67	108.421	108.54	1381241.0
2015-05-13 10:30:00	QQQ	ETF	108.54	108.57	108.13	108.18	1582441.0
2015-05-13 11:00:00	QQQ	ETF	108.19	108.26	107.98	108.0562	1467121.0
2015-05-13 11:30:00	QQQ	ETF	108.06	108.28	107.96	108.17	990647.0
2015-05-13 12:00:00	QQQ	ETF	108.16	108.2373	107.961	108.01	548586.0
2015-05-13 12:30:00	QQQ	ETF	107.995	108.18	107.94	108.09	566689.0
2015-05-13 13:00:00	QQQ	ETF	108.1	108.31	108.08	108.2344	678955.0
2015-05-13 13:30:00	QQQ	ETF	108.24	108.32	108.17	108.261	578171.0

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

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