PREVIEW / etf_5min / 2014-08-04

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-08-04.parquet
  size:    1.0 MB
  rows:    43,514

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-08-04 04:00:00	SPY	ETF	192.99	193.02	192.98	192.99	11523.0
2014-08-04 04:05:00	SPY	ETF	192.93	192.93	192.89	192.91	10300.0
2014-08-04 04:15:00	SPY	ETF	192.95	192.95	192.95	192.95	200.0
2014-08-04 04:25:00	SPY	ETF	192.84	192.84	192.84	192.84	200.0
2014-08-04 04:30:00	SPY	ETF	192.77	192.85	192.77	192.85	900.0
2014-08-04 04:35:00	SPY	ETF	192.85	192.85	192.85	192.85	348.0
2014-08-04 04:40:00	SPY	ETF	192.75	192.75	192.73	192.73	1150.0
2014-08-04 04:55:00	SPY	ETF	192.84	192.84	192.84	192.84	100.0
2014-08-04 05:00:00	SPY	ETF	192.9	192.9	192.85	192.9	703.0
2014-08-04 05:05:00	SPY	ETF	192.9	192.92	192.9	192.91	303.0
2014-08-04 05:10:00	SPY	ETF	193.0	193.04	192.95	193.04	1029.0
2014-08-04 05:15:00	SPY	ETF	192.98	193.0	192.98	193.0	246.0
2014-08-04 05:20:00	SPY	ETF	193.0	193.0	192.93	192.95	7650.0
2014-08-04 05:25:00	SPY	ETF	192.95	193.05	192.95	193.05	2556.0
2014-08-04 05:30:00	SPY	ETF	192.99	192.99	192.95	192.95	250.0
2014-08-04 05:35:00	SPY	ETF	192.93	192.93	192.93	192.93	100.0
2014-08-04 05:45:00	SPY	ETF	193.04	193.05	193.0	193.0	735.0
2014-08-04 05:50:00	SPY	ETF	192.99	192.99	192.99	192.99	5050.0
2014-08-04 05:55:00	SPY	ETF	193.03	193.03	193.03	193.03	229.0
2014-08-04 06:00:00	SPY	ETF	193.03	193.05	193.03	193.05	10671.0
2014-08-04 06:05:00	SPY	ETF	193.09	193.09	193.05	193.05	1680.0
2014-08-04 06:15:00	SPY	ETF	193.09	193.09	193.09	193.09	200.0
2014-08-04 06:20:00	SPY	ETF	193.1	193.1	193.1	193.1	207.0
2014-08-04 06:25:00	SPY	ETF	193.1	193.14	193.1	193.13	1015.0
2014-08-04 06:30:00	SPY	ETF	193.13	193.17	193.13	193.17	935.0
2014-08-04 06:35:00	SPY	ETF	193.1	193.15	193.1	193.14	18500.0
2014-08-04 06:40:00	SPY	ETF	193.14	193.14	193.1	193.12	6160.0
2014-08-04 06:45:00	SPY	ETF	193.12	193.14	193.12	193.14	37500.0
2014-08-04 06:50:00	SPY	ETF	193.06	193.07	193.04	193.07	12294.0
2014-08-04 06:55:00	SPY	ETF	193.01	193.07	193.01	193.07	5294.0
2014-08-04 07:00:00	SPY	ETF	193.05	193.08	193.03	193.04	4347.0
2014-08-04 07:05:00	SPY	ETF	193.09	193.18	193.09	193.18	27303.0
2014-08-04 07:10:00	SPY	ETF	193.14	193.16	193.08	193.08	20276.0
2014-08-04 07:15:00	SPY	ETF	193.06	193.18	193.06	193.16	10106.0
2014-08-04 07:20:00	SPY	ETF	193.19	193.21	193.16	193.16	39600.0
2014-08-04 07:25:00	SPY	ETF	193.16	193.18	193.14	193.17	11850.0
2014-08-04 07:30:00	SPY	ETF	193.17	193.2	193.14	193.16	25810.0
2014-08-04 07:35:00	SPY	ETF	193.16	193.16	193.06	193.09	18700.0
2014-08-04 07:40:00	SPY	ETF	193.11	193.11	193.01	193.01	79589.0
2014-08-04 07:45:00	SPY	ETF	193.07	193.12	193.07	193.12	4377.0
2014-08-04 07:50:00	SPY	ETF	193.11	193.16	193.11	193.14	15403.0
2014-08-04 07:55:00	SPY	ETF	193.11	193.11	193.1	193.1	14550.0
2014-08-04 08:00:00	SPY	ETF	193.08	193.15	192.815	193.035	137074.0
2014-08-04 08:05:00	SPY	ETF	193.11	193.14	193.08	193.11	63560.0
2014-08-04 08:10:00	SPY	ETF	193.1	193.1	192.27	193.0	53332.0
2014-08-04 08:15:00	SPY	ETF	192.98	193.02	192.96	192.99	19507.0
2014-08-04 08:20:00	SPY	ETF	193.0	193.01	192.91	192.94	57309.0
2014-08-04 08:25:00	SPY	ETF	192.91	192.99	192.91	192.96	103841.0
2014-08-04 08:30:00	SPY	ETF	192.98	193.02	192.96	193.0	80950.0
2014-08-04 08:35:00	SPY	ETF	193.0	193.0	192.94	192.94	8351.0

> showing 50 of 43,514 rows — these rows as CSV

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