PREVIEW / etf_30min / 2014-07-02

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-07-02.parquet
  size:    339 KB
  rows:    12,032

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-02 04:00:00	SPY	ETF	197.15	197.2	197.14	197.2	2700.0
2014-07-02 04:30:00	SPY	ETF	197.2	197.2	197.14	197.14	1315.0
2014-07-02 05:00:00	SPY	ETF	197.19	197.22	197.16	197.16	938.0
2014-07-02 05:30:00	SPY	ETF	197.18	197.18	197.1	197.17	2468.0
2014-07-02 06:00:00	SPY	ETF	197.17	197.17	197.14	197.14	300.0
2014-07-02 06:30:00	SPY	ETF	197.15	197.15	197.09	197.1	7861.0
2014-07-02 07:00:00	SPY	ETF	197.15	197.25	197.15	197.23	62350.0
2014-07-02 07:30:00	SPY	ETF	197.22	197.28	197.22	197.27	61772.0
2014-07-02 08:00:00	SPY	ETF	197.27	197.5	197.175	197.22	684445.0
2014-07-02 08:30:00	SPY	ETF	197.19	197.33	197.17	197.22	212485.0
2014-07-02 09:00:00	SPY	ETF	197.21	197.21	196.94	197.05	437126.0
2014-07-02 09:30:00	SPY	ETF	197.05	197.33	196.96	197.16	8834190.0
2014-07-02 10:00:00	SPY	ETF	197.15	197.28	197.03	197.2	4276902.0
2014-07-02 10:30:00	SPY	ETF	197.21	197.35	197.15	197.28	3618390.0
2014-07-02 11:00:00	SPY	ETF	197.275	197.48	197.1	197.22	4309589.0
2014-07-02 11:30:00	SPY	ETF	197.23	197.31	197.2	197.2	2209813.0
2014-07-02 12:00:00	SPY	ETF	197.2	197.33	197.19	197.26	1608458.0
2014-07-02 12:30:00	SPY	ETF	197.26	197.26	197.05	197.2101	2298328.0
2014-07-02 13:00:00	SPY	ETF	197.22	197.24	197.045	197.22	2349751.0
2014-07-02 13:30:00	SPY	ETF	197.2199	197.235	197.05	197.16	1538638.0
2014-07-02 14:00:00	SPY	ETF	197.16	197.18	197.09	197.13	1364524.0
2014-07-02 14:30:00	SPY	ETF	197.13	197.24	197.02	197.11	2727779.0
2014-07-02 15:00:00	SPY	ETF	197.12	197.18	197.06	197.11	2490502.0
2014-07-02 15:30:00	SPY	ETF	197.115	197.25	197.08	197.24	7533028.0
2014-07-02 16:00:00	SPY	ETF	197.24	197.3	197.1503	197.28	3482667.0
2014-07-02 16:30:00	SPY	ETF	197.27	197.32	197.0978	197.3	918893.0
2014-07-02 17:00:00	SPY	ETF	197.28	197.39	197.28	197.35	118114.0
2014-07-02 17:30:00	SPY	ETF	197.36	197.36	197.31	197.31	26058.0
2014-07-02 18:00:00	SPY	ETF	197.31	197.31	197.25	197.26	61479.0
2014-07-02 18:30:00	SPY	ETF	197.26	197.26	197.24	197.24	5397.0
2014-07-02 19:00:00	SPY	ETF	197.24	197.24	197.21	197.23	33853.0
2014-07-02 19:30:00	SPY	ETF	197.21	197.22	197.21	197.22	36181.0
2014-07-02 05:30:00	QQQ	ETF	95.03	95.03	95.03	95.03	200.0
2014-07-02 07:30:00	QQQ	ETF	95.04	95.05	95.03	95.03	30650.0
2014-07-02 08:00:00	QQQ	ETF	95.03	95.11	95.02	95.03	163232.0
2014-07-02 08:30:00	QQQ	ETF	95.03	95.08	95.0	95.02	83943.0
2014-07-02 09:00:00	QQQ	ETF	95.01	95.03	94.94	94.98	199216.0
2014-07-02 09:30:00	QQQ	ETF	94.98	95.16	94.96	95.13	2929397.0
2014-07-02 10:00:00	QQQ	ETF	95.13	95.19	95.0	95.16	2166698.0
2014-07-02 10:30:00	QQQ	ETF	95.16	95.2	95.1	95.1373	1285021.0
2014-07-02 11:00:00	QQQ	ETF	95.13	95.18	94.95	95.03	1452310.0
2014-07-02 11:30:00	QQQ	ETF	95.04	95.17	95.0321	95.11	887291.0
2014-07-02 12:00:00	QQQ	ETF	95.11	95.24	95.1	95.21	732885.0
2014-07-02 12:30:00	QQQ	ETF	95.21	95.22	95.099	95.16	956834.0
2014-07-02 13:00:00	QQQ	ETF	95.1601	95.18	95.09	95.16	730881.0
2014-07-02 13:30:00	QQQ	ETF	95.1567	95.17	95.04	95.11	590784.0
2014-07-02 14:00:00	QQQ	ETF	95.11	95.1195	95.02	95.03	548285.0
2014-07-02 14:30:00	QQQ	ETF	95.03	95.085	94.91	94.98	1096472.0
2014-07-02 15:00:00	QQQ	ETF	94.99	95.08	94.99	95.05	846496.0
2014-07-02 15:30:00	QQQ	ETF	95.05	95.11	94.99	95.1	2032663.0

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

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