PREVIEW / etf_1min / 2014-08-01

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-08-01.parquet
  size:    2.6 MB
  rows:    133,199

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-01 04:00:00	SPY	ETF	193.03	193.03	193.03	193.03	310.0
2014-08-01 04:01:00	SPY	ETF	193.08	193.08	193.08	193.08	2316.0
2014-08-01 04:02:00	SPY	ETF	193.06	193.06	193.06	193.06	249.0
2014-08-01 04:03:00	SPY	ETF	193.0	193.0	193.0	193.0	330.0
2014-08-01 04:11:00	SPY	ETF	192.94	192.94	192.94	192.94	216.0
2014-08-01 04:12:00	SPY	ETF	192.94	192.94	192.94	192.94	100.0
2014-08-01 04:13:00	SPY	ETF	192.91	192.91	192.91	192.91	100.0
2014-08-01 04:14:00	SPY	ETF	192.85	192.85	192.81	192.81	381.0
2014-08-01 04:16:00	SPY	ETF	192.67	192.67	192.67	192.67	100.0
2014-08-01 04:17:00	SPY	ETF	192.62	192.62	192.62	192.62	100.0
2014-08-01 04:18:00	SPY	ETF	192.56	192.56	192.52	192.54	1800.0
2014-08-01 04:20:00	SPY	ETF	192.5	192.5	192.46	192.46	1349.0
2014-08-01 04:24:00	SPY	ETF	192.56	192.56	192.46	192.46	362.0
2014-08-01 04:25:00	SPY	ETF	192.38	192.39	192.38	192.39	1150.0
2014-08-01 04:27:00	SPY	ETF	192.4	192.4	192.4	192.4	115.0
2014-08-01 04:29:00	SPY	ETF	192.4	192.4	192.4	192.4	500.0
2014-08-01 04:30:00	SPY	ETF	192.3	192.3	192.3	192.3	373.0
2014-08-01 04:32:00	SPY	ETF	192.3	192.3	192.3	192.3	550.0
2014-08-01 04:35:00	SPY	ETF	192.3	192.33	192.3	192.33	400.0
2014-08-01 04:36:00	SPY	ETF	192.3	192.3	192.3	192.3	200.0
2014-08-01 04:41:00	SPY	ETF	192.3	192.3	192.28	192.28	1350.0
2014-08-01 04:42:00	SPY	ETF	192.26	192.26	192.26	192.26	590.0
2014-08-01 04:43:00	SPY	ETF	192.25	192.25	192.25	192.25	200.0
2014-08-01 04:44:00	SPY	ETF	192.25	192.25	192.2	192.23	1250.0
2014-08-01 04:47:00	SPY	ETF	192.33	192.35	192.33	192.35	718.0
2014-08-01 04:49:00	SPY	ETF	192.28	192.36	192.28	192.36	732.0
2014-08-01 04:52:00	SPY	ETF	192.22	192.23	192.22	192.23	200.0
2014-08-01 04:54:00	SPY	ETF	192.25	192.25	192.25	192.25	233.0
2014-08-01 04:55:00	SPY	ETF	192.3	192.3	192.3	192.3	245.0
2014-08-01 04:57:00	SPY	ETF	192.28	192.28	192.28	192.28	100.0
2014-08-01 04:59:00	SPY	ETF	192.31	192.31	192.31	192.31	500.0
2014-08-01 05:00:00	SPY	ETF	192.31	192.31	192.28	192.28	1500.0
2014-08-01 05:02:00	SPY	ETF	192.28	192.28	192.17	192.17	593.0
2014-08-01 05:05:00	SPY	ETF	192.13	192.13	192.13	192.13	133.0
2014-08-01 05:06:00	SPY	ETF	192.12	192.12	192.12	192.12	200.0
2014-08-01 05:10:00	SPY	ETF	192.11	192.11	192.1	192.1	1150.0
2014-08-01 05:14:00	SPY	ETF	192.15	192.15	192.15	192.15	173.0
2014-08-01 05:15:00	SPY	ETF	192.24	192.24	192.14	192.14	960.0
2014-08-01 05:18:00	SPY	ETF	192.1	192.22	192.1	192.22	1000.0
2014-08-01 05:19:00	SPY	ETF	192.1	192.12	192.1	192.12	200.0
2014-08-01 05:20:00	SPY	ETF	192.04	192.04	192.01	192.01	438.0
2014-08-01 05:23:00	SPY	ETF	192.03	192.05	192.03	192.05	400.0
2014-08-01 05:24:00	SPY	ETF	192.11	192.11	192.11	192.11	853.0
2014-08-01 05:25:00	SPY	ETF	192.03	192.03	192.03	192.03	500.0
2014-08-01 05:27:00	SPY	ETF	192.1	192.1	192.1	192.1	328.0
2014-08-01 05:28:00	SPY	ETF	192.13	192.13	192.13	192.13	189.0
2014-08-01 05:29:00	SPY	ETF	192.05	192.05	192.01	192.01	1335.0
2014-08-01 05:31:00	SPY	ETF	192.0	192.0	192.0	192.0	500.0
2014-08-01 05:32:00	SPY	ETF	192.05	192.05	192.05	192.05	382.0
2014-08-01 05:34:00	SPY	ETF	192.0	192.0	191.93	191.93	900.0

> showing 50 of 133,199 rows — these rows as CSV

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