PREVIEW / etf_1min / 2015-10-29

all etf 1-min files

  file:    by_date/etf_1min/2015/2015-10-29.parquet
  size:    2.4 MB
  rows:    126,613

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-10-29 04:00:00	SPY	ETF	208.49	208.49	208.49	208.49	5000.0
2015-10-29 04:01:00	SPY	ETF	208.5	208.5	208.5	208.5	300.0
2015-10-29 04:05:00	SPY	ETF	208.47	208.47	208.47	208.47	217.0
2015-10-29 04:08:00	SPY	ETF	208.39	208.39	208.38	208.38	300.0
2015-10-29 04:09:00	SPY	ETF	208.43	208.43	208.38	208.38	700.0
2015-10-29 04:10:00	SPY	ETF	208.36	208.36	208.36	208.36	725.0
2015-10-29 04:14:00	SPY	ETF	208.35	208.35	208.33	208.35	650.0
2015-10-29 04:15:00	SPY	ETF	208.3	208.3	208.3	208.3	400.0
2015-10-29 04:18:00	SPY	ETF	208.3	208.33	208.3	208.33	615.0
2015-10-29 04:20:00	SPY	ETF	208.25	208.25	208.25	208.25	500.0
2015-10-29 04:21:00	SPY	ETF	208.25	208.25	208.25	208.25	155.0
2015-10-29 04:23:00	SPY	ETF	208.27	208.27	208.27	208.27	5500.0
2015-10-29 04:24:00	SPY	ETF	208.36	208.36	208.32	208.32	6325.0
2015-10-29 04:26:00	SPY	ETF	208.32	208.38	208.32	208.38	501.0
2015-10-29 04:28:00	SPY	ETF	208.27	208.27	208.27	208.27	100.0
2015-10-29 04:31:00	SPY	ETF	208.31	208.31	208.3	208.3	8600.0
2015-10-29 04:33:00	SPY	ETF	208.32	208.32	208.32	208.32	4022.0
2015-10-29 04:34:00	SPY	ETF	208.31	208.34	208.31	208.34	4847.0
2015-10-29 04:36:00	SPY	ETF	208.38	208.38	208.38	208.38	202.0
2015-10-29 04:37:00	SPY	ETF	208.33	208.33	208.33	208.33	24030.0
2015-10-29 04:38:00	SPY	ETF	208.33	208.33	208.33	208.33	2970.0
2015-10-29 04:39:00	SPY	ETF	208.3	208.3	208.3	208.3	500.0
2015-10-29 04:41:00	SPY	ETF	208.31	208.31	208.31	208.31	14583.0
2015-10-29 04:42:00	SPY	ETF	208.37	208.37	208.37	208.37	275.0
2015-10-29 04:44:00	SPY	ETF	208.39	208.39	208.39	208.39	150.0
2015-10-29 04:45:00	SPY	ETF	208.35	208.35	208.35	208.35	300.0
2015-10-29 04:49:00	SPY	ETF	208.26	208.26	208.25	208.25	300.0
2015-10-29 04:50:00	SPY	ETF	208.26	208.26	208.26	208.26	100.0
2015-10-29 04:52:00	SPY	ETF	208.25	208.25	208.25	208.25	175.0
2015-10-29 05:00:00	SPY	ETF	208.22	208.22	208.12	208.12	6115.0
2015-10-29 05:01:00	SPY	ETF	208.16	208.16	208.16	208.16	100.0
2015-10-29 05:02:00	SPY	ETF	208.12	208.12	208.12	208.12	1525.0
2015-10-29 05:03:00	SPY	ETF	208.1	208.1	208.1	208.1	525.0
2015-10-29 05:04:00	SPY	ETF	208.12	208.14	208.12	208.14	420.0
2015-10-29 05:05:00	SPY	ETF	208.13	208.13	208.07	208.07	300.0
2015-10-29 05:06:00	SPY	ETF	208.07	208.12	208.02	208.1	10260.0
2015-10-29 05:07:00	SPY	ETF	208.14	208.14	208.14	208.14	700.0
2015-10-29 05:08:00	SPY	ETF	208.11	208.14	208.11	208.14	200.0
2015-10-29 05:13:00	SPY	ETF	208.05	208.05	208.05	208.05	500.0
2015-10-29 05:14:00	SPY	ETF	208.02	208.12	208.02	208.12	80025.0
2015-10-29 05:19:00	SPY	ETF	208.21	208.21	208.21	208.21	700.0
2015-10-29 05:20:00	SPY	ETF	208.21	208.24	208.21	208.23	500.0
2015-10-29 05:25:00	SPY	ETF	208.14	208.14	208.12	208.12	200.0
2015-10-29 05:27:00	SPY	ETF	208.11	208.12	208.09	208.12	27700.0
2015-10-29 05:28:00	SPY	ETF	208.11	208.11	208.11	208.11	67000.0
2015-10-29 05:29:00	SPY	ETF	208.11	208.11	208.06	208.06	28900.0
2015-10-29 05:30:00	SPY	ETF	207.99	208.0	207.99	207.99	4048.0
2015-10-29 05:31:00	SPY	ETF	208.07	208.07	208.07	208.07	600.0
2015-10-29 05:34:00	SPY	ETF	208.11	208.11	208.11	208.11	1700.0
2015-10-29 05:36:00	SPY	ETF	208.14	208.18	208.14	208.18	425.0

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

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