PREVIEW / etf_30min / 2014-07-22

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-07-22.parquet
  size:    338 KB
  rows:    11,875

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-22 04:00:00	SPY	ETF	197.36	197.36	197.3	197.3	775.0
2014-07-22 04:30:00	SPY	ETF	197.32	197.54	197.32	197.54	1058.0
2014-07-22 05:00:00	SPY	ETF	197.49	197.63	197.49	197.63	1618.0
2014-07-22 05:30:00	SPY	ETF	197.69	197.78	197.69	197.75	37725.0
2014-07-22 06:00:00	SPY	ETF	197.73	197.76	197.7	197.7	13778.0
2014-07-22 06:30:00	SPY	ETF	197.65	197.86	197.59	197.71	97317.0
2014-07-22 07:00:00	SPY	ETF	197.7	197.79	197.62	197.76	39900.0
2014-07-22 07:30:00	SPY	ETF	197.77	197.97	197.74	197.76	307027.0
2014-07-22 08:00:00	SPY	ETF	197.77	198.01	197.67	197.83	338623.0
2014-07-22 08:30:00	SPY	ETF	197.83	198.09	197.8	197.92	588580.0
2014-07-22 09:00:00	SPY	ETF	197.92	198.16	197.85	198.02	815311.0
2014-07-22 09:30:00	SPY	ETF	198.01	198.23	197.87	198.1	8657373.0
2014-07-22 10:00:00	SPY	ETF	198.1	198.43	198.1	198.29	6830981.0
2014-07-22 10:30:00	SPY	ETF	198.3	198.39	198.15	198.35	5118856.0
2014-07-22 11:00:00	SPY	ETF	198.35	198.56	198.32	198.35	6348945.0
2014-07-22 11:30:00	SPY	ETF	198.342	198.42	198.3	198.37	2439881.0
2014-07-22 12:00:00	SPY	ETF	198.36	198.48	198.36	198.465	3238440.0
2014-07-22 12:30:00	SPY	ETF	198.465	198.55	198.35	198.36	1961860.0
2014-07-22 13:00:00	SPY	ETF	198.355	198.48	198.34	198.403	1921663.0
2014-07-22 13:30:00	SPY	ETF	198.41	198.43	198.28	198.3799	2517352.0
2014-07-22 14:00:00	SPY	ETF	198.3796	198.47	198.34	198.4	2655273.0
2014-07-22 14:30:00	SPY	ETF	198.4	198.405	198.0	198.19	6156709.0
2014-07-22 15:00:00	SPY	ETF	198.19	198.31	198.12	198.3	3712729.0
2014-07-22 15:30:00	SPY	ETF	198.29	198.42	198.18	198.19	7980414.0
2014-07-22 16:00:00	SPY	ETF	198.2	198.3	197.92	198.04	4285875.0
2014-07-22 16:30:00	SPY	ETF	198.03	198.1	197.77	197.77	741355.0
2014-07-22 17:00:00	SPY	ETF	197.77	197.97	197.77	197.92	71208.0
2014-07-22 17:30:00	SPY	ETF	197.9	197.92	197.78	197.86	35515.0
2014-07-22 18:00:00	SPY	ETF	197.82	198.02	197.82	197.94	68795.0
2014-07-22 18:30:00	SPY	ETF	197.95	198.03	197.92	197.92	43100.0
2014-07-22 19:00:00	SPY	ETF	197.91	197.92	197.88	197.92	22700.0
2014-07-22 19:30:00	SPY	ETF	197.92	197.92	197.91	197.91	23853.0
2014-07-22 04:00:00	QQQ	ETF	96.13	96.14	96.13	96.14	4100.0
2014-07-22 04:30:00	QQQ	ETF	96.07	96.2	96.07	96.2	6200.0
2014-07-22 05:00:00	QQQ	ETF	96.2	96.25	96.2	96.25	10200.0
2014-07-22 05:30:00	QQQ	ETF	96.29	96.3	96.29	96.3	26950.0
2014-07-22 06:00:00	QQQ	ETF	96.3	96.3	96.3	96.3	2000.0
2014-07-22 06:30:00	QQQ	ETF	96.29	96.29	96.26	96.27	1420.0
2014-07-22 07:00:00	QQQ	ETF	96.26	96.32	96.25	96.3	27279.0
2014-07-22 07:30:00	QQQ	ETF	96.34	96.46	96.31	96.35	130580.0
2014-07-22 08:00:00	QQQ	ETF	96.36	96.39	96.28	96.32	49005.0
2014-07-22 08:30:00	QQQ	ETF	96.34	96.48	96.34	96.39	133096.0
2014-07-22 09:00:00	QQQ	ETF	96.39	96.52	96.38	96.45	283948.0
2014-07-22 09:30:00	QQQ	ETF	96.45	96.6	96.345	96.48	3090747.0
2014-07-22 10:00:00	QQQ	ETF	96.49	96.76	96.49	96.6799	2333583.0
2014-07-22 10:30:00	QQQ	ETF	96.68	96.72	96.569	96.67	976029.0
2014-07-22 11:00:00	QQQ	ETF	96.68	96.75	96.585	96.6	1029866.0
2014-07-22 11:30:00	QQQ	ETF	96.59	96.68	96.58	96.615	624121.0
2014-07-22 12:00:00	QQQ	ETF	96.62	96.7	96.6	96.69	477902.0
2014-07-22 12:30:00	QQQ	ETF	96.7	96.73	96.6127	96.621	856153.0

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

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