PREVIEW / etf_30min / 2014-07-01

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-07-01.parquet
  size:    346 KB
  rows:    11,725

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-01 04:00:00	SPY	ETF	196.08	196.09	196.05	196.05	29441.0
2014-07-01 04:30:00	SPY	ETF	196.1	196.17	196.1	196.17	334.0
2014-07-01 05:00:00	SPY	ETF	196.14	196.16	196.14	196.16	1247.0
2014-07-01 05:30:00	SPY	ETF	196.05	196.13	196.05	196.13	2375.0
2014-07-01 06:00:00	SPY	ETF	196.13	196.22	196.13	196.22	7151.0
2014-07-01 06:30:00	SPY	ETF	196.25	196.25	196.14	196.15	4350.0
2014-07-01 07:00:00	SPY	ETF	196.16	196.25	196.15	196.24	108769.0
2014-07-01 07:30:00	SPY	ETF	196.22	196.22	196.12	196.15	78832.0
2014-07-01 08:00:00	SPY	ETF	196.15	196.23	196.01	196.18	262547.0
2014-07-01 08:30:00	SPY	ETF	196.18	196.31	196.16	196.26	491248.0
2014-07-01 09:00:00	SPY	ETF	196.24	196.29	195.72	196.19	486182.0
2014-07-01 09:30:00	SPY	ETF	196.19	196.62	196.13	196.56	10833193.0
2014-07-01 10:00:00	SPY	ETF	196.56	196.9	196.38	196.66	10971135.0
2014-07-01 10:30:00	SPY	ETF	196.655	197.02	196.655	196.925	5716671.0
2014-07-01 11:00:00	SPY	ETF	196.93	197.08	196.9	197.06	4458329.0
2014-07-01 11:30:00	SPY	ETF	197.06	197.23	197.015	197.07	5698386.0
2014-07-01 12:00:00	SPY	ETF	197.075	197.16	197.03	197.13	2881086.0
2014-07-01 12:30:00	SPY	ETF	197.13	197.345	197.12	197.3	3896857.0
2014-07-01 13:00:00	SPY	ETF	197.295	197.63	197.282	197.58	4402205.0
2014-07-01 13:30:00	SPY	ETF	197.585	197.6	197.4	197.465	5925017.0
2014-07-01 14:00:00	SPY	ETF	197.465	197.49	197.27	197.28	4610681.0
2014-07-01 14:30:00	SPY	ETF	197.285	197.41	197.2	197.31	4232230.0
2014-07-01 15:00:00	SPY	ETF	197.305	197.4	197.09	197.295	6299289.0
2014-07-01 15:30:00	SPY	ETF	197.295	197.39	197.03	197.06	12336689.0
2014-07-01 16:00:00	SPY	ETF	197.06	197.36	196.22	197.04	3548905.0
2014-07-01 16:30:00	SPY	ETF	197.06	197.08	195.7785	197.07	1425412.0
2014-07-01 17:00:00	SPY	ETF	197.08	197.08	197.04	197.04	35610.0
2014-07-01 17:30:00	SPY	ETF	197.04	197.06	197.02	197.05	19890.0
2014-07-01 18:00:00	SPY	ETF	197.06	197.14	197.04	197.08	50306.0
2014-07-01 18:30:00	SPY	ETF	197.09	197.09	197.07	197.07	5050.0
2014-07-01 19:00:00	SPY	ETF	197.09	197.12	197.09	197.12	34370.0
2014-07-01 19:30:00	SPY	ETF	197.11	197.12	197.07	197.11	47450.0
2014-07-01 05:30:00	QQQ	ETF	94.14	94.14	94.14	94.14	100.0
2014-07-01 06:30:00	QQQ	ETF	94.15	94.16	94.15	94.16	10600.0
2014-07-01 07:00:00	QQQ	ETF	94.15	94.17	94.12	94.16	15148.0
2014-07-01 07:30:00	QQQ	ETF	94.17	94.19	94.15	94.16	30300.0
2014-07-01 08:00:00	QQQ	ETF	94.16	94.16	94.13	94.14	8400.0
2014-07-01 08:30:00	QQQ	ETF	94.16	94.22	94.16	94.2	158497.0
2014-07-01 09:00:00	QQQ	ETF	94.2	94.22	93.91	94.22	95579.0
2014-07-01 09:30:00	QQQ	ETF	94.21	94.54	94.2	94.51	3773398.0
2014-07-01 10:00:00	QQQ	ETF	94.5	94.73	94.46	94.64	3640882.0
2014-07-01 10:30:00	QQQ	ETF	94.64	94.9	94.64	94.8499	1962885.0
2014-07-01 11:00:00	QQQ	ETF	94.845	94.9	94.81	94.88	1683835.0
2014-07-01 11:30:00	QQQ	ETF	94.88	95.0	94.86	94.92	2637571.0
2014-07-01 12:00:00	QQQ	ETF	94.92	94.968	94.89	94.9562	1216622.0
2014-07-01 12:30:00	QQQ	ETF	94.9501	95.07	94.95	95.055	1730918.0
2014-07-01 13:00:00	QQQ	ETF	95.055	95.19	95.05	95.16	2170635.0
2014-07-01 13:30:00	QQQ	ETF	95.16	95.16	95.09	95.1258	1064521.0
2014-07-01 14:00:00	QQQ	ETF	95.12	95.135	95.03	95.03	1945972.0
2014-07-01 14:30:00	QQQ	ETF	95.0329	95.1	94.99	95.07	1360350.0

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

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