PREVIEW / etf_1min / 2014-07-31

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-07-31.parquet
  size:    2.6 MB
  rows:    131,410

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-31 04:00:00	SPY	ETF	196.61	196.61	195.98	195.98	1545.0
2014-07-31 04:01:00	SPY	ETF	195.98	195.98	195.92	195.92	1057.0
2014-07-31 04:03:00	SPY	ETF	195.9	195.9	195.9	195.9	200.0
2014-07-31 04:05:00	SPY	ETF	195.9	195.9	195.9	195.9	100.0
2014-07-31 04:13:00	SPY	ETF	196.08	196.08	196.08	196.08	100.0
2014-07-31 04:14:00	SPY	ETF	196.11	196.14	196.11	196.14	1100.0
2014-07-31 04:15:00	SPY	ETF	196.17	196.17	196.1	196.1	5050.0
2014-07-31 04:17:00	SPY	ETF	196.12	196.12	196.12	196.12	500.0
2014-07-31 04:24:00	SPY	ETF	196.0	196.0	196.0	196.0	500.0
2014-07-31 04:31:00	SPY	ETF	196.11	196.11	196.11	196.11	300.0
2014-07-31 04:34:00	SPY	ETF	196.05	196.05	196.0	196.0	700.0
2014-07-31 04:35:00	SPY	ETF	196.0	196.0	196.0	196.0	500.0
2014-07-31 04:36:00	SPY	ETF	195.89	195.89	195.89	195.89	400.0
2014-07-31 04:37:00	SPY	ETF	195.92	195.92	195.92	195.92	298.0
2014-07-31 04:41:00	SPY	ETF	195.94	195.94	195.94	195.94	100.0
2014-07-31 04:42:00	SPY	ETF	195.81	195.81	195.81	195.81	150.0
2014-07-31 04:43:00	SPY	ETF	195.81	195.81	195.81	195.81	200.0
2014-07-31 04:45:00	SPY	ETF	195.77	195.77	195.77	195.77	100.0
2014-07-31 04:46:00	SPY	ETF	195.75	195.75	195.75	195.75	2500.0
2014-07-31 04:47:00	SPY	ETF	195.7	195.7	195.7	195.7	150.0
2014-07-31 04:49:00	SPY	ETF	195.7	195.7	195.7	195.7	100.0
2014-07-31 04:52:00	SPY	ETF	195.55	195.55	195.55	195.55	1100.0
2014-07-31 04:53:00	SPY	ETF	195.64	195.64	195.5	195.56	2984.0
2014-07-31 04:54:00	SPY	ETF	195.55	195.55	195.5	195.5	10950.0
2014-07-31 04:56:00	SPY	ETF	195.54	195.54	195.35	195.35	19318.0
2014-07-31 04:57:00	SPY	ETF	195.5	195.5	195.5	195.5	1000.0
2014-07-31 04:58:00	SPY	ETF	195.48	195.48	195.48	195.48	300.0
2014-07-31 04:59:00	SPY	ETF	195.51	195.51	195.5	195.5	1200.0
2014-07-31 05:01:00	SPY	ETF	195.5	195.5	195.5	195.5	500.0
2014-07-31 05:02:00	SPY	ETF	195.55	195.59	195.55	195.59	7600.0
2014-07-31 05:03:00	SPY	ETF	195.58	195.59	195.52	195.52	5400.0
2014-07-31 05:04:00	SPY	ETF	195.55	195.55	195.55	195.55	100.0
2014-07-31 05:07:00	SPY	ETF	195.5	195.5	195.5	195.5	1150.0
2014-07-31 05:10:00	SPY	ETF	195.58	195.58	195.58	195.58	1000.0
2014-07-31 05:12:00	SPY	ETF	195.57	195.64	195.57	195.64	500.0
2014-07-31 05:13:00	SPY	ETF	195.65	195.69	195.65	195.66	5923.0
2014-07-31 05:15:00	SPY	ETF	195.61	195.61	195.61	195.61	1050.0
2014-07-31 05:21:00	SPY	ETF	195.68	195.68	195.68	195.68	170.0
2014-07-31 05:29:00	SPY	ETF	195.8	195.8	195.8	195.8	625.0
2014-07-31 05:30:00	SPY	ETF	195.78	195.78	195.78	195.78	5070.0
2014-07-31 05:32:00	SPY	ETF	195.8	195.8	195.78	195.78	2600.0
2014-07-31 05:37:00	SPY	ETF	195.68	195.68	195.68	195.68	1300.0
2014-07-31 05:40:00	SPY	ETF	195.75	195.75	195.75	195.75	401.0
2014-07-31 05:45:00	SPY	ETF	195.68	195.68	195.68	195.68	100.0
2014-07-31 05:49:00	SPY	ETF	195.79	195.79	195.79	195.79	150.0
2014-07-31 05:56:00	SPY	ETF	195.73	195.73	195.69	195.69	3900.0
2014-07-31 05:57:00	SPY	ETF	195.7	195.71	195.68	195.68	5614.0
2014-07-31 05:58:00	SPY	ETF	195.68	195.68	195.68	195.68	150.0
2014-07-31 05:59:00	SPY	ETF	195.7	195.71	195.7	195.71	600.0
2014-07-31 06:00:00	SPY	ETF	195.68	195.68	195.68	195.68	1800.0

> showing 50 of 131,410 rows — these rows as CSV

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