PREVIEW / etf_5min / 2013-07-16

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-07-16.parquet
  size:    958 KB
  rows:    40,868

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
2013-07-16 04:00:00	SPY	ETF	167.95	167.95	167.95	167.95	100.0
2013-07-16 04:05:00	SPY	ETF	167.98	167.98	167.94	167.94	500.0
2013-07-16 04:10:00	SPY	ETF	167.98	167.98	167.98	167.98	100.0
2013-07-16 04:15:00	SPY	ETF	168.02	168.02	168.02	168.02	100.0
2013-07-16 04:20:00	SPY	ETF	167.98	167.98	167.98	167.98	100.0
2013-07-16 04:25:00	SPY	ETF	168.02	168.04	168.02	168.04	400.0
2013-07-16 04:30:00	SPY	ETF	168.06	168.06	168.06	168.06	100.0
2013-07-16 04:35:00	SPY	ETF	168.06	168.06	168.06	168.06	100.0
2013-07-16 04:40:00	SPY	ETF	168.04	168.04	168.04	168.04	9500.0
2013-07-16 04:45:00	SPY	ETF	168.1	168.1	168.1	168.1	100.0
2013-07-16 05:00:00	SPY	ETF	168.06	168.11	168.06	168.11	1100.0
2013-07-16 05:05:00	SPY	ETF	168.14	168.2	168.14	168.2	300.0
2013-07-16 05:10:00	SPY	ETF	168.19	168.19	168.19	168.19	33500.0
2013-07-16 05:15:00	SPY	ETF	168.25	168.25	168.24	168.24	19200.0
2013-07-16 05:25:00	SPY	ETF	168.22	168.22	168.22	168.22	2500.0
2013-07-16 05:30:00	SPY	ETF	168.2	168.2	168.2	168.2	200.0
2013-07-16 06:15:00	SPY	ETF	168.22	168.22	168.22	168.22	5000.0
2013-07-16 06:20:00	SPY	ETF	168.22	168.22	168.19	168.21	4400.0
2013-07-16 06:30:00	SPY	ETF	168.25	168.26	168.25	168.26	19100.0
2013-07-16 06:35:00	SPY	ETF	168.27	168.27	168.27	168.27	100.0
2013-07-16 06:40:00	SPY	ETF	168.25	168.25	168.25	168.25	100.0
2013-07-16 06:45:00	SPY	ETF	168.27	168.27	168.27	168.27	200.0
2013-07-16 06:50:00	SPY	ETF	168.27	168.27	168.27	168.27	1000.0
2013-07-16 06:55:00	SPY	ETF	168.2	168.21	168.2	168.21	300.0
2013-07-16 07:00:00	SPY	ETF	168.21	168.26	168.21	168.26	7100.0
2013-07-16 07:05:00	SPY	ETF	168.26	168.28	168.26	168.26	4100.0
2013-07-16 07:10:00	SPY	ETF	168.28	168.28	168.28	168.28	100.0
2013-07-16 07:15:00	SPY	ETF	168.25	168.25	168.25	168.25	450.0
2013-07-16 07:20:00	SPY	ETF	168.26	168.26	168.26	168.26	300.0
2013-07-16 07:25:00	SPY	ETF	168.25	168.25	168.2	168.2	5450.0
2013-07-16 07:30:00	SPY	ETF	168.2	168.235	168.18	168.22	105800.0
2013-07-16 07:35:00	SPY	ETF	168.24	168.28	168.24	168.27	76991.0
2013-07-16 07:40:00	SPY	ETF	168.25	168.25	168.23	168.23	27900.0
2013-07-16 07:45:00	SPY	ETF	168.26	168.28	168.25	168.25	9450.0
2013-07-16 07:50:00	SPY	ETF	168.22	168.22	168.15	168.17	113673.0
2013-07-16 07:55:00	SPY	ETF	168.16	168.17	168.08	168.08	84450.0
2013-07-16 08:00:00	SPY	ETF	168.21	168.21	168.03	168.06	26705.0
2013-07-16 08:05:00	SPY	ETF	168.06	168.14	168.06	168.12	23185.0
2013-07-16 08:10:00	SPY	ETF	168.11	168.12	168.06	168.1	10400.0
2013-07-16 08:15:00	SPY	ETF	168.1	168.11	168.1	168.11	28500.0
2013-07-16 08:20:00	SPY	ETF	168.11	168.16	168.11	168.13	15420.0
2013-07-16 08:25:00	SPY	ETF	168.13	168.2	166.75	168.15	24131.0
2013-07-16 08:30:00	SPY	ETF	168.15	168.17	167.85	168.07	65689.0
2013-07-16 08:35:00	SPY	ETF	168.05	168.08	167.98	168.08	67707.0
2013-07-16 08:40:00	SPY	ETF	168.08	168.13	168.08	168.1	81490.0
2013-07-16 08:45:00	SPY	ETF	168.08	168.21	168.08	168.19	43311.0
2013-07-16 08:50:00	SPY	ETF	168.16	168.19	168.16	168.19	128611.0
2013-07-16 08:55:00	SPY	ETF	168.19	168.23	168.18	168.21	58863.0
2013-07-16 09:00:00	SPY	ETF	168.21	168.21	168.16	168.2	10897.0
2013-07-16 09:05:00	SPY	ETF	168.19	168.19	168.15	168.16	14628.0

> showing 50 of 40,868 rows — these rows as CSV

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