PREVIEW / etf_30min / 2013-12-16

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-12-16.parquet
  size:    328 KB
  rows:    11,168

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
2013-12-16 04:00:00	SPY	ETF	178.01	178.29	178.01	178.25	23634.0
2013-12-16 04:30:00	SPY	ETF	178.31	178.36	178.24	178.3	10113.0
2013-12-16 05:00:00	SPY	ETF	178.27	178.86	178.23	178.75	85581.0
2013-12-16 05:30:00	SPY	ETF	178.78	178.81	178.67	178.81	13518.0
2013-12-16 06:00:00	SPY	ETF	178.8	178.81	178.75	178.75	24460.0
2013-12-16 06:30:00	SPY	ETF	178.77	179.04	178.75	178.83	113480.0
2013-12-16 07:00:00	SPY	ETF	178.82	178.99	178.8	178.93	286041.0
2013-12-16 07:30:00	SPY	ETF	178.96	179.16	178.93	179.05	152603.0
2013-12-16 08:00:00	SPY	ETF	179.07	179.08	177.04	178.96	289093.0
2013-12-16 08:30:00	SPY	ETF	178.95	179.13	178.86	179.01	531335.0
2013-12-16 09:00:00	SPY	ETF	179.01	179.04	178.9	178.95	998045.0
2013-12-16 09:30:00	SPY	ETF	178.95	179.77	178.9	179.71	15381423.0
2013-12-16 10:00:00	SPY	ETF	179.7	179.81	179.44	179.52	7243885.0
2013-12-16 10:30:00	SPY	ETF	179.52	179.58	179.25	179.35	6021746.0
2013-12-16 11:00:00	SPY	ETF	179.35	179.45	179.155	179.41	4778334.0
2013-12-16 11:30:00	SPY	ETF	179.41	179.44	179.25	179.4	3768325.0
2013-12-16 12:00:00	SPY	ETF	179.4	179.41	179.13	179.219	4293802.0
2013-12-16 12:30:00	SPY	ETF	179.22	179.35	179.18	179.21	1968107.0
2013-12-16 13:00:00	SPY	ETF	179.21	179.27	178.97	179.205	3863803.0
2013-12-16 13:30:00	SPY	ETF	179.21	179.42	179.07	179.37	3751615.0
2013-12-16 14:00:00	SPY	ETF	179.37	179.55	179.37	179.47	3849508.0
2013-12-16 14:30:00	SPY	ETF	179.47	179.49	179.31	179.45	4432180.0
2013-12-16 15:00:00	SPY	ETF	179.44	179.48	179.24	179.305	5625926.0
2013-12-16 15:30:00	SPY	ETF	179.305	179.4	179.2	179.2	10794053.0
2013-12-16 16:00:00	SPY	ETF	179.21	179.26	178.0955	179.17	4546517.0
2013-12-16 16:30:00	SPY	ETF	179.2	179.22	179.08	179.12	3906819.0
2013-12-16 17:00:00	SPY	ETF	179.1	179.12	178.0956	179.08	2057162.0
2013-12-16 17:30:00	SPY	ETF	179.08	179.11	179.05	179.05	28514.0
2013-12-16 18:00:00	SPY	ETF	179.1	179.12	179.08	179.11	57853.0
2013-12-16 18:30:00	SPY	ETF	179.09	179.11	179.07	179.09	29559.0
2013-12-16 19:00:00	SPY	ETF	179.08	179.1	179.04	179.04	18290.0
2013-12-16 19:30:00	SPY	ETF	179.06	179.06	179.01	179.01	42144.0
2013-12-16 04:00:00	QQQ	ETF	84.9	85.02	84.9	85.02	2200.0
2013-12-16 04:30:00	QQQ	ETF	85.06	85.06	85.0	85.05	12100.0
2013-12-16 05:00:00	QQQ	ETF	85.06	85.26	85.06	85.26	9340.0
2013-12-16 05:30:00	QQQ	ETF	85.24	85.28	85.24	85.28	3800.0
2013-12-16 06:00:00	QQQ	ETF	85.26	85.26	85.26	85.26	600.0
2013-12-16 06:30:00	QQQ	ETF	85.24	85.32	85.24	85.26	9160.0
2013-12-16 07:00:00	QQQ	ETF	85.28	85.32	85.28	85.32	2800.0
2013-12-16 07:30:00	QQQ	ETF	85.32	85.37	85.29	85.37	64926.0
2013-12-16 08:00:00	QQQ	ETF	85.3	85.34	85.24	85.29	52614.0
2013-12-16 08:30:00	QQQ	ETF	85.26	85.34	85.26	85.32	243127.0
2013-12-16 09:00:00	QQQ	ETF	85.33	85.35	85.24	85.24	211733.0
2013-12-16 09:30:00	QQQ	ETF	85.27	85.79	85.24	85.7608	4207916.0
2013-12-16 10:00:00	QQQ	ETF	85.77	85.81	85.5501	85.64	1769787.0
2013-12-16 10:30:00	QQQ	ETF	85.66	85.68	85.49	85.52	1177165.0
2013-12-16 11:00:00	QQQ	ETF	85.52	85.56	85.39	85.55	987320.0
2013-12-16 11:30:00	QQQ	ETF	85.55	85.57	85.45	85.48	657273.0
2013-12-16 12:00:00	QQQ	ETF	85.489	85.49	85.34	85.42	933715.0
2013-12-16 12:30:00	QQQ	ETF	85.42	85.495	85.39	85.39	350145.0

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

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