PREVIEW / etf_5min / 2017-01-24

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-01-24.parquet
  size:    1.3 MB
  rows:    57,139

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
2017-01-24 04:00:00	SPY	ETF	226.14	226.14	226.14	226.14	300.0
2017-01-24 04:05:00	SPY	ETF	226.11	226.11	226.11	226.11	100.0
2017-01-24 04:10:00	SPY	ETF	226.13	226.19	226.13	226.19	4911.0
2017-01-24 04:15:00	SPY	ETF	226.23	226.24	226.22	226.22	3100.0
2017-01-24 04:20:00	SPY	ETF	226.18	226.21	226.18	226.21	800.0
2017-01-24 04:25:00	SPY	ETF	226.21	226.21	226.21	226.21	300.0
2017-01-24 04:30:00	SPY	ETF	226.16	226.16	226.16	226.16	1300.0
2017-01-24 04:35:00	SPY	ETF	226.23	226.36	226.21	226.36	9000.0
2017-01-24 04:40:00	SPY	ETF	226.26	226.26	226.21	226.21	2201.0
2017-01-24 04:50:00	SPY	ETF	226.24	226.29	226.24	226.29	900.0
2017-01-24 05:00:00	SPY	ETF	226.36	226.36	226.36	226.36	1900.0
2017-01-24 05:05:00	SPY	ETF	226.45	226.49	226.45	226.49	1500.0
2017-01-24 05:10:00	SPY	ETF	226.42	226.42	226.42	226.42	200.0
2017-01-24 05:15:00	SPY	ETF	226.41	226.41	226.41	226.41	700.0
2017-01-24 05:25:00	SPY	ETF	226.36	226.36	226.36	226.36	1000.0
2017-01-24 05:45:00	SPY	ETF	226.44	226.44	226.44	226.44	300.0
2017-01-24 06:00:00	SPY	ETF	226.34	226.34	226.34	226.34	300.0
2017-01-24 06:15:00	SPY	ETF	226.25	226.25	226.25	226.25	2002.0
2017-01-24 06:20:00	SPY	ETF	226.3	226.3	226.3	226.3	919.0
2017-01-24 06:25:00	SPY	ETF	226.31	226.31	226.3	226.3	1800.0
2017-01-24 06:35:00	SPY	ETF	226.31	226.31	226.31	226.31	300.0
2017-01-24 06:45:00	SPY	ETF	226.21	226.21	226.21	226.21	202.0
2017-01-24 06:50:00	SPY	ETF	226.2	226.25	226.2	226.25	602.0
2017-01-24 06:55:00	SPY	ETF	226.25	226.25	226.25	226.25	1400.0
2017-01-24 07:05:00	SPY	ETF	226.26	226.26	226.26	226.26	100.0
2017-01-24 07:10:00	SPY	ETF	226.26	226.26	226.26	226.26	1927.0
2017-01-24 07:15:00	SPY	ETF	226.23	226.23	226.22	226.23	7500.0
2017-01-24 07:25:00	SPY	ETF	226.21	226.22	226.21	226.21	2400.0
2017-01-24 07:30:00	SPY	ETF	226.24	226.24	226.23	226.23	540.0
2017-01-24 07:35:00	SPY	ETF	226.24	226.24	226.24	226.24	160.0
2017-01-24 07:40:00	SPY	ETF	226.21	226.21	226.21	226.21	646.0
2017-01-24 07:45:00	SPY	ETF	226.2	226.2	226.2	226.2	1400.0
2017-01-24 07:50:00	SPY	ETF	226.21	226.21	226.21	226.21	100.0
2017-01-24 07:55:00	SPY	ETF	226.24	226.25	226.24	226.25	1502.0
2017-01-24 08:00:00	SPY	ETF	226.21	226.26	226.21	226.24	13022.0
2017-01-24 08:05:00	SPY	ETF	226.28	226.28	226.24	226.24	779.0
2017-01-24 08:10:00	SPY	ETF	226.23	226.29	226.23	226.26	2401.0
2017-01-24 08:15:00	SPY	ETF	226.24	226.28	226.23	226.28	5501.0
2017-01-24 08:20:00	SPY	ETF	226.26	226.26	226.2	226.21	7412.0
2017-01-24 08:25:00	SPY	ETF	226.24	226.24	226.21	226.22	55103.0
2017-01-24 08:30:00	SPY	ETF	226.21	226.27	226.21	226.27	10043.0
2017-01-24 08:35:00	SPY	ETF	226.26	226.29	226.26	226.29	11859.0
2017-01-24 08:40:00	SPY	ETF	226.27	226.29	226.26	226.28	6753.0
2017-01-24 08:45:00	SPY	ETF	226.27	226.3	226.27	226.3	9450.0
2017-01-24 08:50:00	SPY	ETF	226.31	226.38	226.31	226.35	30327.0
2017-01-24 08:55:00	SPY	ETF	226.35	226.46	226.35	226.45	27689.0
2017-01-24 09:00:00	SPY	ETF	226.41	226.46	226.41	226.45	32817.0
2017-01-24 09:05:00	SPY	ETF	226.45	226.46	226.41	226.41	19674.0
2017-01-24 09:10:00	SPY	ETF	226.42	226.46	226.42	226.44	18203.0
2017-01-24 09:15:00	SPY	ETF	226.43	226.44	226.42	226.43	34169.0

> showing 50 of 57,139 rows — these rows as CSV

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