PREVIEW / etf_1min / 2015-04-22

all etf 1-min files

  file:    by_date/etf_1min/2015/2015-04-22.parquet
  size:    2.4 MB
  rows:    126,511

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
2015-04-22 04:00:00	SPY	ETF	209.82	209.82	209.82	209.82	250.0
2015-04-22 04:01:00	SPY	ETF	209.82	209.82	209.76	209.76	2600.0
2015-04-22 04:07:00	SPY	ETF	209.02	209.02	208.79	208.79	35450.0
2015-04-22 04:08:00	SPY	ETF	208.73	208.73	208.72	208.72	525.0
2015-04-22 04:10:00	SPY	ETF	208.79	208.79	208.78	208.78	1600.0
2015-04-22 04:11:00	SPY	ETF	208.75	208.75	208.75	208.75	205.0
2015-04-22 04:13:00	SPY	ETF	208.98	208.98	208.98	208.98	100.0
2015-04-22 04:14:00	SPY	ETF	208.95	208.95	208.95	208.95	500.0
2015-04-22 04:15:00	SPY	ETF	208.95	208.95	208.95	208.95	600.0
2015-04-22 04:16:00	SPY	ETF	208.95	208.95	208.95	208.95	10015.0
2015-04-22 04:17:00	SPY	ETF	208.96	208.96	208.96	208.96	300.0
2015-04-22 04:20:00	SPY	ETF	208.96	208.96	208.96	208.96	100.0
2015-04-22 04:27:00	SPY	ETF	209.02	209.02	209.02	209.02	100.0
2015-04-22 04:28:00	SPY	ETF	209.02	209.02	209.02	209.02	200.0
2015-04-22 04:29:00	SPY	ETF	209.14	209.14	209.12	209.12	601.0
2015-04-22 04:41:00	SPY	ETF	208.9	208.9	208.89	208.89	200.0
2015-04-22 04:42:00	SPY	ETF	208.88	208.88	208.88	208.88	600.0
2015-04-22 04:44:00	SPY	ETF	208.9	208.96	208.9	208.96	450.0
2015-04-22 04:47:00	SPY	ETF	208.86	208.86	208.86	208.86	100.0
2015-04-22 04:48:00	SPY	ETF	209.05	209.05	209.05	209.05	100.0
2015-04-22 04:49:00	SPY	ETF	209.0	209.0	209.0	209.0	175.0
2015-04-22 04:50:00	SPY	ETF	209.05	209.05	209.05	209.05	1200.0
2015-04-22 04:51:00	SPY	ETF	209.06	209.06	209.06	209.06	210.0
2015-04-22 04:52:00	SPY	ETF	209.05	209.05	209.05	209.05	100.0
2015-04-22 04:55:00	SPY	ETF	208.96	208.96	208.96	208.96	275.0
2015-04-22 04:56:00	SPY	ETF	208.92	208.92	208.88	208.88	320.0
2015-04-22 04:57:00	SPY	ETF	208.85	208.85	208.85	208.85	100.0
2015-04-22 04:58:00	SPY	ETF	208.8	208.8	208.79	208.79	1700.0
2015-04-22 04:59:00	SPY	ETF	208.77	208.86	208.76	208.83	1600.0
2015-04-22 05:00:00	SPY	ETF	208.81	208.81	208.67	208.67	4145.0
2015-04-22 05:01:00	SPY	ETF	208.62	208.69	208.59	208.66	7065.0
2015-04-22 05:02:00	SPY	ETF	208.61	208.64	208.61	208.64	2300.0
2015-04-22 05:03:00	SPY	ETF	208.73	208.86	208.71	208.86	2175.0
2015-04-22 05:04:00	SPY	ETF	208.78	208.78	208.78	208.78	100.0
2015-04-22 05:05:00	SPY	ETF	208.76	208.8	208.76	208.8	2910.0
2015-04-22 05:06:00	SPY	ETF	208.8	208.8	208.8	208.8	100.0
2015-04-22 05:07:00	SPY	ETF	208.83	208.83	208.83	208.83	1000.0
2015-04-22 05:08:00	SPY	ETF	208.77	208.85	208.77	208.85	1310.0
2015-04-22 05:09:00	SPY	ETF	208.87	208.9	208.87	208.89	2900.0
2015-04-22 05:10:00	SPY	ETF	208.89	208.89	208.85	208.85	343.0
2015-04-22 05:11:00	SPY	ETF	208.9	208.91	208.9	208.91	1100.0
2015-04-22 05:14:00	SPY	ETF	208.83	208.83	208.83	208.83	2100.0
2015-04-22 05:23:00	SPY	ETF	208.96	208.96	208.9	208.9	650.0
2015-04-22 05:24:00	SPY	ETF	208.87	208.87	208.87	208.87	200.0
2015-04-22 05:25:00	SPY	ETF	208.8	208.8	208.77	208.77	2000.0
2015-04-22 05:29:00	SPY	ETF	208.86	208.87	208.86	208.86	1500.0
2015-04-22 05:31:00	SPY	ETF	208.9	208.93	208.9	208.93	1004.0
2015-04-22 05:34:00	SPY	ETF	209.0	209.0	209.0	209.0	700.0
2015-04-22 05:35:00	SPY	ETF	209.02	209.09	209.02	209.09	1000.0
2015-04-22 05:37:00	SPY	ETF	209.08	209.11	209.08	209.1	1100.0

> showing 50 of 126,511 rows — these rows as CSV

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