PREVIEW / etf_1min / 2014-08-04

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-08-04.parquet
  size:    2.3 MB
  rows:    115,884

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	192.99	192.99	192.99	5050.0
2014-08-04 04:01:00	SPY	ETF	192.98	193.02	192.98	193.02	1215.0
2014-08-04 04:03:00	SPY	ETF	193.01	193.01	193.01	193.01	258.0
2014-08-04 04:04:00	SPY	ETF	192.99	192.99	192.99	192.99	5000.0
2014-08-04 04:06:00	SPY	ETF	192.93	192.93	192.93	192.93	100.0
2014-08-04 04:07:00	SPY	ETF	192.9	192.9	192.89	192.89	5200.0
2014-08-04 04:09:00	SPY	ETF	192.92	192.92	192.91	192.91	5000.0
2014-08-04 04:18:00	SPY	ETF	192.95	192.95	192.95	192.95	200.0
2014-08-04 04:26:00	SPY	ETF	192.84	192.84	192.84	192.84	200.0
2014-08-04 04:31:00	SPY	ETF	192.77	192.85	192.77	192.85	900.0
2014-08-04 04:36: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.75	192.75	200.0
2014-08-04 04:41:00	SPY	ETF	192.75	192.75	192.75	192.75	100.0
2014-08-04 04:43:00	SPY	ETF	192.73	192.73	192.73	192.73	850.0
2014-08-04 04:59: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.9	192.9	100.0
2014-08-04 05:01:00	SPY	ETF	192.85	192.85	192.85	192.85	103.0
2014-08-04 05:02:00	SPY	ETF	192.88	192.88	192.88	192.88	300.0
2014-08-04 05:04:00	SPY	ETF	192.9	192.9	192.9	192.9	200.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.0	192.95	192.95	500.0
2014-08-04 05:12:00	SPY	ETF	193.04	193.04	193.04	193.04	529.0
2014-08-04 05:18: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	193.0	193.0	2500.0
2014-08-04 05:22:00	SPY	ETF	192.93	192.93	192.93	192.93	100.0
2014-08-04 05:23:00	SPY	ETF	192.95	192.95	192.95	192.95	2500.0
2014-08-04 05:24:00	SPY	ETF	192.95	192.95	192.95	192.95	2550.0
2014-08-04 05:25:00	SPY	ETF	192.95	192.95	192.95	192.95	2456.0
2014-08-04 05:29:00	SPY	ETF	193.05	193.05	193.05	193.05	100.0
2014-08-04 05:33:00	SPY	ETF	192.99	192.99	192.95	192.95	250.0
2014-08-04 05:36: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.04	193.05	583.0
2014-08-04 05:46:00	SPY	ETF	193.0	193.0	193.0	193.0	152.0
2014-08-04 05:53:00	SPY	ETF	192.99	192.99	192.99	192.99	5050.0
2014-08-04 05:58:00	SPY	ETF	193.03	193.03	193.03	193.03	229.0
2014-08-04 06:04: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.09	193.09	380.0
2014-08-04 06:07:00	SPY	ETF	193.05	193.05	193.05	193.05	1300.0
2014-08-04 06:18:00	SPY	ETF	193.09	193.09	193.09	193.09	200.0
2014-08-04 06:24:00	SPY	ETF	193.1	193.1	193.1	193.1	207.0
2014-08-04 06:25:00	SPY	ETF	193.1	193.1	193.1	193.1	300.0
2014-08-04 06:29:00	SPY	ETF	193.14	193.14	193.13	193.13	715.0
2014-08-04 06:32:00	SPY	ETF	193.13	193.13	193.13	193.13	100.0
2014-08-04 06:33:00	SPY	ETF	193.14	193.17	193.13	193.17	835.0
2014-08-04 06:35:00	SPY	ETF	193.1	193.1	193.1	193.1	100.0
2014-08-04 06:37:00	SPY	ETF	193.11	193.12	193.11	193.12	10000.0
2014-08-04 06:38:00	SPY	ETF	193.13	193.15	193.13	193.14	5100.0
2014-08-04 06:39:00	SPY	ETF	193.14	193.14	193.14	193.14	3300.0
2014-08-04 06:40:00	SPY	ETF	193.14	193.14	193.1	193.1	5905.0
2014-08-04 06:42:00	SPY	ETF	193.12	193.12	193.12	193.12	255.0

> showing 50 of 115,884 rows — these rows as CSV

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