PREVIEW / etf_30min / 2014-10-28

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-10-28.parquet
  size:    370 KB
  rows:    12,477

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-10-28 04:00:00	SPY	ETF	196.8	197.66	196.78	197.32	57156.0
2014-10-28 04:30:00	SPY	ETF	197.3	197.3	197.1	197.1	4894.0
2014-10-28 05:00:00	SPY	ETF	197.22	197.27	197.15	197.25	45626.0
2014-10-28 05:30:00	SPY	ETF	197.27	197.39	197.26	197.3	69754.0
2014-10-28 06:00:00	SPY	ETF	197.28	197.28	197.18	197.28	38481.0
2014-10-28 06:30:00	SPY	ETF	197.23	197.35	197.19	197.24	14967.0
2014-10-28 07:00:00	SPY	ETF	197.24	197.32	197.18	197.32	63742.0
2014-10-28 07:30:00	SPY	ETF	197.31	197.33	197.11	197.32	158648.0
2014-10-28 08:00:00	SPY	ETF	197.32	197.36	196.505	197.15	337460.0
2014-10-28 08:30:00	SPY	ETF	197.12	197.13	196.82	196.86	675239.0
2014-10-28 09:00:00	SPY	ETF	196.88	196.98	196.71	196.82	1014038.0
2014-10-28 09:30:00	SPY	ETF	196.82	197.25	196.73	197.05	12618356.0
2014-10-28 10:00:00	SPY	ETF	197.04	197.33	196.81	196.97	10573464.0
2014-10-28 10:30:00	SPY	ETF	196.96	197.18	196.9	197.07	5200184.0
2014-10-28 11:00:00	SPY	ETF	197.08	197.43	197.075	197.34	5465432.0
2014-10-28 11:30:00	SPY	ETF	197.34	197.4	196.97	196.98	4872855.0
2014-10-28 12:00:00	SPY	ETF	196.97	197.28	196.97	197.205	3856440.0
2014-10-28 12:30:00	SPY	ETF	197.21	197.26	196.91	197.11	3523826.0
2014-10-28 13:00:00	SPY	ETF	197.105	197.3	197.065	197.26	2259191.0
2014-10-28 13:30:00	SPY	ETF	197.27	197.5	197.16	197.44	3813726.0
2014-10-28 14:00:00	SPY	ETF	197.45	197.64	197.35	197.63	3819726.0
2014-10-28 14:30:00	SPY	ETF	197.625	197.7	197.495	197.61	5592429.0
2014-10-28 15:00:00	SPY	ETF	197.61	198.21	197.6	198.125	8921519.0
2014-10-28 15:30:00	SPY	ETF	198.12	198.42	197.96	198.37	19867648.0
2014-10-28 16:00:00	SPY	ETF	198.37	198.63	198.25	198.48	7495017.0
2014-10-28 16:30:00	SPY	ETF	198.47	198.56	197.0641	198.49	987483.0
2014-10-28 17:00:00	SPY	ETF	198.49	198.52	198.41	198.44	1382187.0
2014-10-28 17:30:00	SPY	ETF	198.42	198.42	198.16	198.17	434868.0
2014-10-28 18:00:00	SPY	ETF	198.17	198.26	198.02	198.08	391761.0
2014-10-28 18:30:00	SPY	ETF	198.09	198.14	198.02	198.04	100389.0
2014-10-28 19:00:00	SPY	ETF	198.04	198.07	198.01	198.02	56799.0
2014-10-28 19:30:00	SPY	ETF	198.04	198.16	198.02	198.12	62881.0
2014-10-28 04:00:00	QQQ	ETF	98.88	99.33	98.88	99.33	19306.0
2014-10-28 04:30:00	QQQ	ETF	99.31	99.31	99.22	99.22	300.0
2014-10-28 05:30:00	QQQ	ETF	99.24	99.34	99.24	99.28	30950.0
2014-10-28 06:00:00	QQQ	ETF	99.26	99.27	99.23	99.24	9200.0
2014-10-28 06:30:00	QQQ	ETF	99.23	99.31	99.23	99.29	19150.0
2014-10-28 07:00:00	QQQ	ETF	99.26	99.31	99.24	99.31	28040.0
2014-10-28 07:30:00	QQQ	ETF	99.29	99.3	99.22	99.29	28583.0
2014-10-28 08:00:00	QQQ	ETF	99.29	99.3	99.21	99.24	117928.0
2014-10-28 08:30:00	QQQ	ETF	99.2	99.2	99.07	99.08	220484.0
2014-10-28 09:00:00	QQQ	ETF	99.08	99.18	99.02	99.1	228298.0
2014-10-28 09:30:00	QQQ	ETF	99.11	99.57	99.08	99.48	4208018.0
2014-10-28 10:00:00	QQQ	ETF	99.48	99.61	99.45	99.52	2265845.0
2014-10-28 10:30:00	QQQ	ETF	99.52	99.64	99.48	99.56	1557586.0
2014-10-28 11:00:00	QQQ	ETF	99.57	99.76	99.57	99.7	1499158.0
2014-10-28 11:30:00	QQQ	ETF	99.71	99.7367	99.49	99.49	1503468.0
2014-10-28 12:00:00	QQQ	ETF	99.49	99.61	99.48	99.53	1230960.0
2014-10-28 12:30:00	QQQ	ETF	99.53	99.5665	99.41	99.51	1539286.0
2014-10-28 13:00:00	QQQ	ETF	99.509	99.649	99.49	99.61	765807.0

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

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