PREVIEW / etf_1min / 2014-07-07

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-07-07.parquet
  size:    2.1 MB
  rows:    113,412

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-07 04:00:00	SPY	ETF	197.95	198.08	197.95	198.08	5355.0
2014-07-07 04:02:00	SPY	ETF	197.98	197.98	197.98	197.98	200.0
2014-07-07 04:03:00	SPY	ETF	197.95	197.95	197.95	197.95	217.0
2014-07-07 04:04:00	SPY	ETF	197.85	197.85	197.85	197.85	100.0
2014-07-07 04:05:00	SPY	ETF	197.9	197.9	197.9	197.9	200.0
2014-07-07 04:06:00	SPY	ETF	197.9	197.9	197.9	197.9	200.0
2014-07-07 04:09:00	SPY	ETF	197.9	197.9	197.9	197.9	200.0
2014-07-07 04:25:00	SPY	ETF	197.91	197.91	197.91	197.91	102.0
2014-07-07 04:26:00	SPY	ETF	197.91	197.91	197.91	197.91	100.0
2014-07-07 04:29:00	SPY	ETF	197.95	197.95	197.95	197.95	1500.0
2014-07-07 04:33:00	SPY	ETF	197.88	197.88	197.88	197.88	233.0
2014-07-07 04:34:00	SPY	ETF	197.91	197.91	197.91	197.91	1267.0
2014-07-07 04:37:00	SPY	ETF	197.91	197.91	197.86	197.86	2774.0
2014-07-07 04:38:00	SPY	ETF	197.9	197.9	197.9	197.9	1500.0
2014-07-07 04:39:00	SPY	ETF	197.87	197.87	197.87	197.87	349.0
2014-07-07 04:42:00	SPY	ETF	197.89	197.89	197.89	197.89	600.0
2014-07-07 04:43:00	SPY	ETF	197.89	197.89	197.86	197.86	1000.0
2014-07-07 04:47:00	SPY	ETF	197.88	197.88	197.86	197.86	2000.0
2014-07-07 04:48:00	SPY	ETF	197.84	197.84	197.84	197.84	116.0
2014-07-07 04:49:00	SPY	ETF	197.86	197.86	197.85	197.86	1484.0
2014-07-07 04:52:00	SPY	ETF	197.85	197.9	197.85	197.9	1500.0
2014-07-07 05:05:00	SPY	ETF	197.88	197.88	197.88	197.88	174.0
2014-07-07 05:09:00	SPY	ETF	197.9	197.9	197.9	197.9	100.0
2014-07-07 05:29:00	SPY	ETF	197.95	197.95	197.95	197.95	180.0
2014-07-07 05:35:00	SPY	ETF	197.96	198.02	197.96	198.0	600.0
2014-07-07 05:36:00	SPY	ETF	198.0	198.0	198.0	198.0	200.0
2014-07-07 05:48:00	SPY	ETF	197.97	197.97	197.97	197.97	600.0
2014-07-07 06:00:00	SPY	ETF	197.94	197.94	197.94	197.94	181.0
2014-07-07 06:01:00	SPY	ETF	197.94	197.94	197.94	197.94	349.0
2014-07-07 06:11:00	SPY	ETF	198.0	198.0	197.98	197.99	530.0
2014-07-07 06:14:00	SPY	ETF	198.0	198.04	198.0	198.04	450.0
2014-07-07 06:24:00	SPY	ETF	198.01	198.01	198.0	198.01	400.0
2014-07-07 06:28:00	SPY	ETF	198.02	198.02	198.02	198.02	333.0
2014-07-07 06:35:00	SPY	ETF	198.01	198.01	198.01	198.01	2300.0
2014-07-07 06:37:00	SPY	ETF	198.01	198.01	198.01	198.01	4479.0
2014-07-07 06:45:00	SPY	ETF	197.95	197.95	197.95	197.95	150.0
2014-07-07 06:48:00	SPY	ETF	197.95	197.95	197.94	197.94	450.0
2014-07-07 06:50:00	SPY	ETF	197.92	197.92	197.92	197.92	425.0
2014-07-07 06:53:00	SPY	ETF	197.9	197.9	197.89	197.89	32000.0
2014-07-07 06:54:00	SPY	ETF	197.9	197.9	197.88	197.88	511.0
2014-07-07 06:56:00	SPY	ETF	197.86	197.86	197.86	197.86	5000.0
2014-07-07 06:57:00	SPY	ETF	197.86	197.86	197.86	197.86	2500.0
2014-07-07 06:58:00	SPY	ETF	197.89	197.9	197.89	197.9	239.0
2014-07-07 06:59:00	SPY	ETF	197.87	197.87	197.86	197.86	11025.0
2014-07-07 07:00:00	SPY	ETF	197.87	197.92	197.87	197.91	4132.0
2014-07-07 07:01:00	SPY	ETF	197.88	197.88	197.88	197.88	1410.0
2014-07-07 07:03:00	SPY	ETF	197.87	197.87	197.87	197.87	5400.0
2014-07-07 07:05:00	SPY	ETF	197.9	197.9	197.9	197.9	150.0
2014-07-07 07:07:00	SPY	ETF	197.89	197.9	197.89	197.9	10254.0
2014-07-07 07:08:00	SPY	ETF	197.89	197.89	197.89	197.89	10000.0

> showing 50 of 113,412 rows — these rows as CSV

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