PREVIEW / etf_30min / 2014-07-10

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-07-10.parquet
  size:    360 KB
  rows:    12,382

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-10 04:00:00	SPY	ETF	196.97	196.97	196.5	196.53	5818.0
2014-07-10 04:30:00	SPY	ETF	196.58	196.58	196.05	196.13	13400.0
2014-07-10 05:00:00	SPY	ETF	196.03	196.15	195.83	195.93	31766.0
2014-07-10 05:30:00	SPY	ETF	195.93	196.34	195.53	195.7	126159.0
2014-07-10 06:00:00	SPY	ETF	195.68	195.73	195.49	195.66	181557.0
2014-07-10 06:30:00	SPY	ETF	195.69	195.7	195.33	195.38	159173.0
2014-07-10 07:00:00	SPY	ETF	195.42	195.57	195.25	195.53	399564.0
2014-07-10 07:30:00	SPY	ETF	195.53	195.6	195.39	195.45	646585.0
2014-07-10 08:00:00	SPY	ETF	195.47	195.57	195.44	195.56	756502.0
2014-07-10 08:30:00	SPY	ETF	195.58	195.61	195.12	195.12	982831.0
2014-07-10 09:00:00	SPY	ETF	195.13	195.42	195.04	195.23	1558609.0
2014-07-10 09:30:00	SPY	ETF	195.22	195.6	195.06	195.41	19853562.0
2014-07-10 10:00:00	SPY	ETF	195.4	195.9	195.37	195.87	12327849.0
2014-07-10 10:30:00	SPY	ETF	195.86	196.15	195.67	196.14	7848632.0
2014-07-10 11:00:00	SPY	ETF	196.14	196.27	196.015	196.065	6039954.0
2014-07-10 11:30:00	SPY	ETF	196.07	196.2	195.95	196.15	3242879.0
2014-07-10 12:00:00	SPY	ETF	196.14	196.47	196.04	196.42	4906358.0
2014-07-10 12:30:00	SPY	ETF	196.43	196.48	196.21	196.32	3140612.0
2014-07-10 13:00:00	SPY	ETF	196.315	196.72	196.26	196.67	4520846.0
2014-07-10 13:30:00	SPY	ETF	196.67	196.86	196.53	196.55	4481237.0
2014-07-10 14:00:00	SPY	ETF	196.56	196.68	196.49	196.65	2674254.0
2014-07-10 14:30:00	SPY	ETF	196.645	196.68	196.2	196.2	4500394.0
2014-07-10 15:00:00	SPY	ETF	196.2	196.41	196.03	196.38	6136420.0
2014-07-10 15:30:00	SPY	ETF	196.37	196.53	196.27	196.335	7846380.0
2014-07-10 16:00:00	SPY	ETF	196.31	197.1238	195.4655	196.26	5162811.0
2014-07-10 16:30:00	SPY	ETF	196.27	196.3101	196.16	196.16	427025.0
2014-07-10 17:00:00	SPY	ETF	196.15	196.26	196.14	196.25	51205.0
2014-07-10 17:30:00	SPY	ETF	196.24	196.24	196.15	196.15	91447.0
2014-07-10 18:00:00	SPY	ETF	196.18	196.18	196.13	196.18	101054.0
2014-07-10 18:30:00	SPY	ETF	196.18	196.22	196.13	196.22	16678.0
2014-07-10 19:00:00	SPY	ETF	196.19	196.2	196.14	196.14	9361.0
2014-07-10 19:30:00	SPY	ETF	196.16	196.22	196.15	196.17	6230.0
2014-07-10 04:00:00	QQQ	ETF	94.99	94.99	94.65	94.65	6700.0
2014-07-10 05:00:00	QQQ	ETF	94.48	94.48	94.3	94.3	13800.0
2014-07-10 05:30:00	QQQ	ETF	94.3	94.4	94.19	94.31	16890.0
2014-07-10 06:00:00	QQQ	ETF	94.26	94.27	94.16	94.27	2700.0
2014-07-10 06:30:00	QQQ	ETF	94.26	94.26	94.06	94.06	37650.0
2014-07-10 07:00:00	QQQ	ETF	94.09	94.16	94.0	94.14	53132.0
2014-07-10 07:30:00	QQQ	ETF	94.15	94.19	94.08	94.09	49282.0
2014-07-10 08:00:00	QQQ	ETF	94.12	94.14	94.04	94.12	147283.0
2014-07-10 08:30:00	QQQ	ETF	94.13	94.15	93.79	93.81	231046.0
2014-07-10 09:00:00	QQQ	ETF	93.81	93.91	93.68	93.78	753709.0
2014-07-10 09:30:00	QQQ	ETF	93.78	94.03	93.63	93.83	6244102.0
2014-07-10 10:00:00	QQQ	ETF	93.83	94.32	93.83	94.3	3720283.0
2014-07-10 10:30:00	QQQ	ETF	94.3	94.51	94.21	94.495	2391296.0
2014-07-10 11:00:00	QQQ	ETF	94.5	94.62	94.46	94.51	2313064.0
2014-07-10 11:30:00	QQQ	ETF	94.51	94.63	94.44	94.56	1973090.0
2014-07-10 12:00:00	QQQ	ETF	94.56	94.85	94.5	94.84	1980906.0
2014-07-10 12:30:00	QQQ	ETF	94.84	94.87	94.69	94.76	2038828.0
2014-07-10 13:00:00	QQQ	ETF	94.75	95.01	94.73	94.9659	2211162.0

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

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