PREVIEW / etf_30min / 2014-05-13

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-05-13.parquet
  size:    323 KB
  rows:    11,267

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-13 04:00:00	SPY	ETF	190.01	190.15	190.01	190.15	2611.0
2014-05-13 04:30:00	SPY	ETF	190.07	190.21	190.07	190.21	4242.0
2014-05-13 05:00:00	SPY	ETF	190.18	190.18	190.04	190.04	5753.0
2014-05-13 05:30:00	SPY	ETF	190.03	190.08	190.0	190.0	5819.0
2014-05-13 06:00:00	SPY	ETF	189.95	190.17	189.95	190.12	5495.0
2014-05-13 06:30:00	SPY	ETF	190.16	190.19	190.1	190.12	36879.0
2014-05-13 07:00:00	SPY	ETF	190.11	190.18	190.1	190.14	62871.0
2014-05-13 07:30:00	SPY	ETF	190.13	190.24	190.13	190.17	98875.0
2014-05-13 08:00:00	SPY	ETF	190.13	190.23	189.23	190.12	163519.0
2014-05-13 08:30:00	SPY	ETF	190.12	190.13	189.87	189.97	627563.0
2014-05-13 09:00:00	SPY	ETF	189.97	190.07	189.94	190.0	381567.0
2014-05-13 09:30:00	SPY	ETF	190.03	190.29	189.84	189.9946	11799565.0
2014-05-13 10:00:00	SPY	ETF	190.01	190.32	189.96	190.26	5710496.0
2014-05-13 10:30:00	SPY	ETF	190.26	190.42	190.19	190.21	4900588.0
2014-05-13 11:00:00	SPY	ETF	190.205	190.25	189.91	190.07	4507362.0
2014-05-13 11:30:00	SPY	ETF	190.07	190.11	189.81	189.905	4889328.0
2014-05-13 12:00:00	SPY	ETF	189.9043	190.05	189.82	189.94	3020335.0
2014-05-13 12:30:00	SPY	ETF	189.95	190.115	189.82	190.015	2475524.0
2014-05-13 13:00:00	SPY	ETF	190.01	190.07	189.89	190.03	2448179.0
2014-05-13 13:30:00	SPY	ETF	190.03	190.05	189.81	189.92	2646833.0
2014-05-13 14:00:00	SPY	ETF	189.92	190.035	189.88	189.96	1728215.0
2014-05-13 14:30:00	SPY	ETF	189.96	190.09	189.96	190.025	3002646.0
2014-05-13 15:00:00	SPY	ETF	190.025	190.06	189.77	189.93	5021063.0
2014-05-13 15:30:00	SPY	ETF	189.921	190.02	189.87	189.95	9417027.0
2014-05-13 16:00:00	SPY	ETF	189.95	190.05	189.9384	189.94	2932772.0
2014-05-13 16:30:00	SPY	ETF	189.96	190.03	189.94	190.02	193645.0
2014-05-13 17:00:00	SPY	ETF	190.02	190.05	189.98	190.0	217609.0
2014-05-13 17:30:00	SPY	ETF	190.01	190.03	190.0	190.03	4744.0
2014-05-13 18:00:00	SPY	ETF	190.0	190.0	189.95	189.95	23300.0
2014-05-13 18:30:00	SPY	ETF	189.95	189.97	189.95	189.97	2835.0
2014-05-13 19:00:00	SPY	ETF	189.96	190.03	189.96	190.01	14900.0
2014-05-13 19:30:00	SPY	ETF	190.03	190.03	189.97	189.99	5960.0
2014-05-13 04:00:00	QQQ	ETF	88.4	88.4	88.4	88.4	1200.0
2014-05-13 05:00:00	QQQ	ETF	88.31	88.31	88.31	88.31	700.0
2014-05-13 05:30:00	QQQ	ETF	88.3	88.3	88.29	88.29	1000.0
2014-05-13 06:00:00	QQQ	ETF	88.34	88.34	88.33	88.33	400.0
2014-05-13 07:00:00	QQQ	ETF	88.35	88.43	88.35	88.39	23960.0
2014-05-13 07:30:00	QQQ	ETF	88.42	88.46	88.42	88.44	43560.0
2014-05-13 08:00:00	QQQ	ETF	88.44	88.46	88.36	88.38	79623.0
2014-05-13 08:30:00	QQQ	ETF	88.34	88.38	88.24	88.3	81460.0
2014-05-13 09:00:00	QQQ	ETF	88.3	88.36	88.3	88.31	106475.0
2014-05-13 09:30:00	QQQ	ETF	88.32	88.5201	88.12	88.26	6197485.0
2014-05-13 10:00:00	QQQ	ETF	88.27	88.57	88.24	88.47	2705533.0
2014-05-13 10:30:00	QQQ	ETF	88.47	88.61	88.46	88.48	1846900.0
2014-05-13 11:00:00	QQQ	ETF	88.485	88.51	88.21	88.37	2374649.0
2014-05-13 11:30:00	QQQ	ETF	88.37	88.38	88.12	88.23	1636269.0
2014-05-13 12:00:00	QQQ	ETF	88.23	88.34	88.16	88.24	1493135.0
2014-05-13 12:30:00	QQQ	ETF	88.23	88.35	88.15	88.3	1135369.0
2014-05-13 13:00:00	QQQ	ETF	88.3	88.37	88.24	88.32	878815.0
2014-05-13 13:30:00	QQQ	ETF	88.32	88.35	88.17	88.2501	904403.0

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

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