PREVIEW / etf_30min / 2014-05-16

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-05-16.parquet
  size:    326 KB
  rows:    11,151

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-05-16 04:30:00	SPY	ETF	187.17	187.33	187.17	187.33	5267.0
2014-05-16 05:00:00	SPY	ETF	187.33	187.34	187.2	187.21	1985.0
2014-05-16 05:30:00	SPY	ETF	187.22	187.38	187.06	187.06	12890.0
2014-05-16 06:00:00	SPY	ETF	187.06	187.06	186.82	186.9	17522.0
2014-05-16 06:30:00	SPY	ETF	186.91	186.99	186.8	186.99	19281.0
2014-05-16 07:00:00	SPY	ETF	186.96	187.17	186.9	187.17	241583.0
2014-05-16 07:30:00	SPY	ETF	187.18	187.28	186.96	187.05	166761.0
2014-05-16 08:00:00	SPY	ETF	187.03	187.11	186.91	186.94	245271.0
2014-05-16 08:30:00	SPY	ETF	186.91	187.38	186.9	187.22	868918.0
2014-05-16 09:00:00	SPY	ETF	187.2	187.72	187.18	187.52	1374586.0
2014-05-16 09:30:00	SPY	ETF	187.51	187.53	186.93	187.38	14747761.0
2014-05-16 10:00:00	SPY	ETF	187.39	187.47	186.72	186.78	9612885.0
2014-05-16 10:30:00	SPY	ETF	186.77	187.38	186.76	187.23	6922143.0
2014-05-16 11:00:00	SPY	ETF	187.22	187.52	187.125	187.42	4479286.0
2014-05-16 11:30:00	SPY	ETF	187.43	187.61	187.24	187.45	5013771.0
2014-05-16 12:00:00	SPY	ETF	187.46	187.56	187.35	187.43	3949297.0
2014-05-16 12:30:00	SPY	ETF	187.42	187.479	187.24	187.29	3322692.0
2014-05-16 13:00:00	SPY	ETF	187.28	187.37	187.06	187.27	4040725.0
2014-05-16 13:30:00	SPY	ETF	187.26	187.38	187.16	187.23	3116736.0
2014-05-16 14:00:00	SPY	ETF	187.24	187.26	187.09	187.24	2685097.0
2014-05-16 14:30:00	SPY	ETF	187.24	187.86	187.21	187.86	5589146.0
2014-05-16 15:00:00	SPY	ETF	187.851	188.09	187.81	187.85	9591675.0
2014-05-16 15:30:00	SPY	ETF	187.855	188.13	187.85	188.08	12701171.0
2014-05-16 16:00:00	SPY	ETF	188.09	188.16	188.02	188.05	6389038.0
2014-05-16 16:30:00	SPY	ETF	188.05	188.11	187.3564	188.11	1571488.0
2014-05-16 17:00:00	SPY	ETF	188.09	188.12	188.08	188.12	140410.0
2014-05-16 17:30:00	SPY	ETF	188.13	188.17	188.05	188.05	58616.0
2014-05-16 18:00:00	SPY	ETF	188.05	188.11	188.04	188.11	25344.0
2014-05-16 18:30:00	SPY	ETF	188.11	188.18	188.1	188.18	9366.0
2014-05-16 19:00:00	SPY	ETF	188.15	188.23	188.14	188.23	23022.0
2014-05-16 19:30:00	SPY	ETF	188.15	188.23	188.1	188.14	14067.0
2014-05-16 06:00:00	QQQ	ETF	86.88	86.88	86.88	86.88	1000.0
2014-05-16 06:30:00	QQQ	ETF	86.88	86.93	86.86	86.93	2100.0
2014-05-16 07:00:00	QQQ	ETF	86.96	87.05	86.96	87.05	500.0
2014-05-16 07:30:00	QQQ	ETF	87.08	87.08	86.94	86.98	22000.0
2014-05-16 08:00:00	QQQ	ETF	87.0	87.03	86.92	86.92	25200.0
2014-05-16 08:30:00	QQQ	ETF	86.98	87.22	86.97	87.14	354373.0
2014-05-16 09:00:00	QQQ	ETF	87.14	87.32	87.11	87.27	176090.0
2014-05-16 09:30:00	QQQ	ETF	87.24	87.25	86.81	87.15	5669055.0
2014-05-16 10:00:00	QQQ	ETF	87.16	87.22	86.64	86.68	9425951.0
2014-05-16 10:30:00	QQQ	ETF	86.67	86.95	86.67	86.87	4623251.0
2014-05-16 11:00:00	QQQ	ETF	86.88	87.05	86.83	86.97	1391818.0
2014-05-16 11:30:00	QQQ	ETF	86.97	87.09	86.89	87.03	1713536.0
2014-05-16 12:00:00	QQQ	ETF	87.0398	87.2	87.0001	87.13	1088908.0
2014-05-16 12:30:00	QQQ	ETF	87.1299	87.14	86.97	86.9841	960576.0
2014-05-16 13:00:00	QQQ	ETF	86.98	87.1299	86.84	87.065	2004249.0
2014-05-16 13:30:00	QQQ	ETF	87.059	87.15	87.025	87.07	1394838.0
2014-05-16 14:00:00	QQQ	ETF	87.075	87.15	87.0	87.12	2909957.0
2014-05-16 14:30:00	QQQ	ETF	87.11	87.5	87.11	87.499	3058881.0
2014-05-16 15:00:00	QQQ	ETF	87.5	87.73	87.49	87.5904	3811574.0

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

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