PREVIEW / etf_1min / 2015-08-27

all etf 1-min files

  file:    by_date/etf_1min/2015/2015-08-27.parquet
  size:    3.2 MB
  rows:    166,462

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-08-27 04:00:00	SPY	ETF	196.32	196.32	196.32	196.32	2105.0
2015-08-27 04:01:00	SPY	ETF	196.33	196.33	196.25	196.3	581.0
2015-08-27 04:02:00	SPY	ETF	196.38	196.38	196.22	196.29	24840.0
2015-08-27 04:03:00	SPY	ETF	196.22	196.22	196.22	196.22	500.0
2015-08-27 04:04:00	SPY	ETF	196.19	196.19	196.07	196.1	3500.0
2015-08-27 04:05:00	SPY	ETF	196.21	196.21	196.17	196.18	10200.0
2015-08-27 04:06:00	SPY	ETF	196.28	196.28	196.28	196.28	150.0
2015-08-27 04:07:00	SPY	ETF	196.32	196.32	196.23	196.23	600.0
2015-08-27 04:08:00	SPY	ETF	196.36	196.36	196.36	196.36	200.0
2015-08-27 04:09:00	SPY	ETF	196.33	196.33	196.22	196.22	1100.0
2015-08-27 04:12:00	SPY	ETF	196.18	196.18	196.18	196.18	300.0
2015-08-27 04:13:00	SPY	ETF	196.08	196.19	196.08	196.19	200.0
2015-08-27 04:14:00	SPY	ETF	196.21	196.21	196.21	196.21	905.0
2015-08-27 04:15:00	SPY	ETF	196.33	196.33	196.33	196.33	2000.0
2015-08-27 04:16:00	SPY	ETF	196.3	196.3	196.28	196.28	500.0
2015-08-27 04:17:00	SPY	ETF	196.26	196.26	196.26	196.26	510.0
2015-08-27 04:19:00	SPY	ETF	196.33	196.43	196.33	196.43	2400.0
2015-08-27 04:20:00	SPY	ETF	196.48	196.49	196.44	196.44	1505.0
2015-08-27 04:21:00	SPY	ETF	196.43	196.46	196.43	196.46	3805.0
2015-08-27 04:22:00	SPY	ETF	196.46	196.5	196.43	196.5	1750.0
2015-08-27 04:23:00	SPY	ETF	196.5	196.5	196.47	196.47	700.0
2015-08-27 04:24:00	SPY	ETF	196.44	196.5	196.44	196.44	2600.0
2015-08-27 04:25:00	SPY	ETF	196.47	196.47	196.41	196.41	2400.0
2015-08-27 04:26:00	SPY	ETF	196.52	196.52	196.52	196.52	3423.0
2015-08-27 04:28:00	SPY	ETF	196.51	196.51	196.51	196.51	300.0
2015-08-27 04:29:00	SPY	ETF	196.58	196.58	196.58	196.58	300.0
2015-08-27 04:30:00	SPY	ETF	196.6	196.6	196.6	196.6	100.0
2015-08-27 04:31:00	SPY	ETF	196.65	196.65	196.65	196.65	100.0
2015-08-27 04:33:00	SPY	ETF	196.44	196.44	196.42	196.42	200.0
2015-08-27 04:34:00	SPY	ETF	196.49	196.49	196.49	196.49	800.0
2015-08-27 04:37:00	SPY	ETF	196.42	196.44	196.39	196.39	8012.0
2015-08-27 04:38:00	SPY	ETF	196.39	196.39	196.36	196.39	7112.0
2015-08-27 04:39:00	SPY	ETF	196.39	196.44	196.37	196.44	7566.0
2015-08-27 04:40:00	SPY	ETF	196.44	196.46	196.42	196.43	19600.0
2015-08-27 04:41:00	SPY	ETF	196.44	196.52	196.44	196.48	4530.0
2015-08-27 04:42:00	SPY	ETF	196.48	196.51	196.47	196.51	14850.0
2015-08-27 04:43:00	SPY	ETF	196.5	196.5	196.5	196.5	225.0
2015-08-27 04:44:00	SPY	ETF	196.52	196.52	196.48	196.48	3100.0
2015-08-27 04:45:00	SPY	ETF	196.49	196.52	196.47	196.47	63238.0
2015-08-27 04:46:00	SPY	ETF	196.46	196.46	196.46	196.46	400.0
2015-08-27 04:47:00	SPY	ETF	196.52	196.52	196.4	196.4	1823.0
2015-08-27 04:48:00	SPY	ETF	196.34	196.42	196.34	196.41	1900.0
2015-08-27 04:49:00	SPY	ETF	196.44	196.44	196.44	196.44	1900.0
2015-08-27 04:50:00	SPY	ETF	196.42	196.44	196.42	196.44	2300.0
2015-08-27 04:51:00	SPY	ETF	196.47	196.89	196.47	196.77	30036.0
2015-08-27 04:52:00	SPY	ETF	196.77	196.83	196.77	196.82	7868.0
2015-08-27 04:53:00	SPY	ETF	196.81	197.07	196.81	196.97	9656.0
2015-08-27 04:54:00	SPY	ETF	196.92	196.99	196.88	196.98	6738.0
2015-08-27 04:55:00	SPY	ETF	196.95	196.95	196.95	196.95	200.0
2015-08-27 04:56:00	SPY	ETF	196.97	196.99	196.97	196.99	700.0

> showing 50 of 166,462 rows — these rows as CSV

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