PREVIEW / etf_1min / 2014-03-12

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-03-12.parquet
  size:    2.1 MB
  rows:    112,102

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-03-12 04:01:00	SPY	ETF	186.95	186.95	186.95	186.95	239.0
2014-03-12 04:02:00	SPY	ETF	186.91	186.92	186.89	186.92	1100.0
2014-03-12 04:04:00	SPY	ETF	186.97	186.97	186.97	186.97	200.0
2014-03-12 04:05:00	SPY	ETF	186.99	187.04	186.99	187.04	1250.0
2014-03-12 04:06:00	SPY	ETF	187.02	187.04	187.02	187.04	400.0
2014-03-12 04:07:00	SPY	ETF	187.09	187.09	187.09	187.09	1000.0
2014-03-12 04:08:00	SPY	ETF	187.09	187.09	187.09	187.09	100.0
2014-03-12 04:10:00	SPY	ETF	187.12	187.12	187.12	187.12	400.0
2014-03-12 04:13:00	SPY	ETF	187.09	187.09	187.09	187.09	100.0
2014-03-12 04:22:00	SPY	ETF	187.03	187.03	187.03	187.03	100.0
2014-03-12 04:23:00	SPY	ETF	186.99	186.99	186.99	186.99	200.0
2014-03-12 04:27:00	SPY	ETF	187.02	187.02	187.02	187.02	100.0
2014-03-12 04:29:00	SPY	ETF	187.04	187.04	187.04	187.04	300.0
2014-03-12 04:31:00	SPY	ETF	187.05	187.05	187.05	187.05	300.0
2014-03-12 04:32:00	SPY	ETF	187.04	187.04	187.04	187.04	200.0
2014-03-12 04:34:00	SPY	ETF	187.0	187.0	186.97	186.97	1150.0
2014-03-12 04:36:00	SPY	ETF	186.99	186.99	186.99	186.99	300.0
2014-03-12 04:39:00	SPY	ETF	187.03	187.03	187.03	187.03	400.0
2014-03-12 04:45:00	SPY	ETF	187.03	187.04	187.03	187.04	1200.0
2014-03-12 04:48:00	SPY	ETF	187.0	187.0	187.0	187.0	500.0
2014-03-12 04:52:00	SPY	ETF	187.06	187.06	187.06	187.06	400.0
2014-03-12 04:53:00	SPY	ETF	187.08	187.08	187.08	187.08	500.0
2014-03-12 04:56:00	SPY	ETF	187.02	187.02	187.02	187.02	400.0
2014-03-12 04:57:00	SPY	ETF	187.0	187.0	187.0	187.0	400.0
2014-03-12 04:58:00	SPY	ETF	186.98	186.98	186.98	186.98	200.0
2014-03-12 05:00:00	SPY	ETF	186.97	186.97	186.97	186.97	253.0
2014-03-12 05:01:00	SPY	ETF	186.94	186.94	186.91	186.91	544.0
2014-03-12 05:02:00	SPY	ETF	186.9	186.9	186.87	186.9	1692.0
2014-03-12 05:03:00	SPY	ETF	186.9	186.9	186.89	186.89	718.0
2014-03-12 05:04:00	SPY	ETF	186.9	186.9	186.9	186.9	100.0
2014-03-12 05:07:00	SPY	ETF	186.89	186.89	186.89	186.89	392.0
2014-03-12 05:09:00	SPY	ETF	186.88	186.88	186.88	186.88	515.0
2014-03-12 05:11:00	SPY	ETF	186.84	186.84	186.84	186.84	129.0
2014-03-12 05:13:00	SPY	ETF	186.82	186.82	186.82	186.82	100.0
2014-03-12 05:14:00	SPY	ETF	186.83	186.83	186.75	186.75	2364.0
2014-03-12 05:15:00	SPY	ETF	186.74	186.74	186.7	186.71	1175.0
2014-03-12 05:16:00	SPY	ETF	186.72	186.74	186.72	186.74	300.0
2014-03-12 05:17:00	SPY	ETF	186.75	186.75	186.72	186.72	1100.0
2014-03-12 05:22:00	SPY	ETF	186.7	186.7	186.67	186.67	1100.0
2014-03-12 05:25:00	SPY	ETF	186.73	186.73	186.73	186.73	400.0
2014-03-12 05:26:00	SPY	ETF	186.74	186.75	186.74	186.75	356.0
2014-03-12 05:28:00	SPY	ETF	186.74	186.74	186.74	186.74	300.0
2014-03-12 05:29:00	SPY	ETF	186.72	186.72	186.72	186.72	185.0
2014-03-12 05:30:00	SPY	ETF	186.75	186.75	186.75	186.75	1700.0
2014-03-12 05:32:00	SPY	ETF	186.78	186.78	186.78	186.78	169.0
2014-03-12 05:35:00	SPY	ETF	186.77	186.77	186.77	186.77	300.0
2014-03-12 05:37:00	SPY	ETF	186.78	186.78	186.78	186.78	436.0
2014-03-12 05:39:00	SPY	ETF	186.82	186.82	186.82	186.82	1007.0
2014-03-12 05:44:00	SPY	ETF	186.86	186.86	186.86	186.86	842.0
2014-03-12 05:45:00	SPY	ETF	186.78	186.78	186.78	186.78	1000.0

> showing 50 of 112,102 rows — these rows as CSV

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