PREVIEW / etf_5min / 2014-07-01

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-07-01.parquet
  size:    1.0 MB
  rows:    44,184

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-07-01 04:00:00	SPY	ETF	196.08	196.08	196.08	196.08	25000.0
2014-07-01 04:05:00	SPY	ETF	196.08	196.09	196.08	196.09	4341.0
2014-07-01 04:10:00	SPY	ETF	196.05	196.05	196.05	196.05	100.0
2014-07-01 04:30:00	SPY	ETF	196.1	196.1	196.1	196.1	100.0
2014-07-01 04:35:00	SPY	ETF	196.17	196.17	196.17	196.17	234.0
2014-07-01 05:00:00	SPY	ETF	196.14	196.16	196.14	196.16	1247.0
2014-07-01 05:35:00	SPY	ETF	196.05	196.06	196.05	196.06	1200.0
2014-07-01 05:40:00	SPY	ETF	196.1	196.13	196.1	196.13	600.0
2014-07-01 05:45:00	SPY	ETF	196.07	196.13	196.07	196.13	275.0
2014-07-01 05:50:00	SPY	ETF	196.13	196.13	196.13	196.13	300.0
2014-07-01 06:00:00	SPY	ETF	196.13	196.14	196.13	196.14	750.0
2014-07-01 06:15:00	SPY	ETF	196.16	196.18	196.16	196.16	4600.0
2014-07-01 06:20:00	SPY	ETF	196.17	196.2	196.17	196.19	1600.0
2014-07-01 06:25:00	SPY	ETF	196.22	196.22	196.22	196.22	201.0
2014-07-01 06:30:00	SPY	ETF	196.25	196.25	196.22	196.22	650.0
2014-07-01 06:35:00	SPY	ETF	196.19	196.21	196.18	196.2	1300.0
2014-07-01 06:40:00	SPY	ETF	196.2	196.2	196.17	196.17	900.0
2014-07-01 06:50:00	SPY	ETF	196.18	196.18	196.14	196.14	1400.0
2014-07-01 06:55:00	SPY	ETF	196.15	196.15	196.15	196.15	100.0
2014-07-01 07:00:00	SPY	ETF	196.16	196.16	196.15	196.15	3000.0
2014-07-01 07:05:00	SPY	ETF	196.18	196.25	196.18	196.18	37400.0
2014-07-01 07:10:00	SPY	ETF	196.19	196.25	196.19	196.21	32573.0
2014-07-01 07:15:00	SPY	ETF	196.21	196.23	196.18	196.21	6976.0
2014-07-01 07:20:00	SPY	ETF	196.21	196.23	196.21	196.23	1020.0
2014-07-01 07:25:00	SPY	ETF	196.22	196.24	196.16	196.24	27800.0
2014-07-01 07:30:00	SPY	ETF	196.22	196.22	196.18	196.18	21011.0
2014-07-01 07:35:00	SPY	ETF	196.18	196.2	196.16	196.16	751.0
2014-07-01 07:40:00	SPY	ETF	196.17	196.21	196.16	196.16	24763.0
2014-07-01 07:45:00	SPY	ETF	196.16	196.16	196.12	196.12	14028.0
2014-07-01 07:50:00	SPY	ETF	196.14	196.16	196.12	196.16	17210.0
2014-07-01 07:55:00	SPY	ETF	196.14	196.15	196.14	196.15	1069.0
2014-07-01 08:00:00	SPY	ETF	196.15	196.23	196.01	196.01	201217.0
2014-07-01 08:05:00	SPY	ETF	196.14	196.15	196.13	196.15	4051.0
2014-07-01 08:10:00	SPY	ETF	196.15	196.18	196.15	196.17	6025.0
2014-07-01 08:15:00	SPY	ETF	196.18	196.18	196.15	196.15	18340.0
2014-07-01 08:20:00	SPY	ETF	196.16	196.18	196.13	196.13	19533.0
2014-07-01 08:25:00	SPY	ETF	196.13	196.18	196.13	196.18	13381.0
2014-07-01 08:30:00	SPY	ETF	196.18	196.21	196.16	196.2	49492.0
2014-07-01 08:35:00	SPY	ETF	196.2	196.26	196.2	196.24	62412.0
2014-07-01 08:40:00	SPY	ETF	196.24	196.26	196.22	196.26	124418.0
2014-07-01 08:45:00	SPY	ETF	196.25	196.31	196.24	196.3	148363.0
2014-07-01 08:50:00	SPY	ETF	196.3	196.3	196.26	196.27	66383.0
2014-07-01 08:55:00	SPY	ETF	196.27	196.29	196.24	196.26	40180.0
2014-07-01 09:00:00	SPY	ETF	196.24	196.26	196.23	196.25	49571.0
2014-07-01 09:05:00	SPY	ETF	196.25	196.29	195.72	196.27	56328.0
2014-07-01 09:10:00	SPY	ETF	195.72	196.28	195.72	196.26	41964.0
2014-07-01 09:15:00	SPY	ETF	196.24	196.25	196.21	196.22	58312.0
2014-07-01 09:20:00	SPY	ETF	196.21	196.21	196.16	196.18	63551.0
2014-07-01 09:25:00	SPY	ETF	196.18	196.22	196.16	196.19	216456.0
2014-07-01 09:30:00	SPY	ETF	196.19	196.435	196.13	196.38	3267792.0

> showing 50 of 44,184 rows — these rows as CSV

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