PREVIEW / etf_5min / 2015-04-20

all etf 5-min files

  file:    by_date/etf_5min/2015/2015-04-20.parquet
  size:    1.1 MB
  rows:    48,165

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-04-20 04:00:00	SPY	ETF	209.17	209.39	209.17	209.39	6331.0
2015-04-20 04:05:00	SPY	ETF	209.3	209.3	209.28	209.3	600.0
2015-04-20 04:10:00	SPY	ETF	209.27	209.27	209.25	209.25	1325.0
2015-04-20 04:15:00	SPY	ETF	209.2	209.2	209.2	209.2	200.0
2015-04-20 04:20:00	SPY	ETF	209.23	209.26	209.21	209.26	1305.0
2015-04-20 04:25:00	SPY	ETF	209.2	209.21	209.2	209.21	400.0
2015-04-20 04:30:00	SPY	ETF	209.25	209.3	209.25	209.3	14905.0
2015-04-20 04:35:00	SPY	ETF	209.26	209.3	209.26	209.3	1100.0
2015-04-20 04:40:00	SPY	ETF	209.21	209.21	209.19	209.2	2590.0
2015-04-20 04:45:00	SPY	ETF	209.2	209.2	209.19	209.19	800.0
2015-04-20 05:00:00	SPY	ETF	209.16	209.18	209.16	209.16	16600.0
2015-04-20 05:05:00	SPY	ETF	209.1	209.1	209.1	209.1	200.0
2015-04-20 05:10:00	SPY	ETF	209.1	209.15	209.1	209.15	900.0
2015-04-20 05:15:00	SPY	ETF	209.14	209.15	209.14	209.15	300.0
2015-04-20 05:20:00	SPY	ETF	209.16	209.17	209.16	209.17	1200.0
2015-04-20 05:25:00	SPY	ETF	209.21	209.3	209.21	209.3	8200.0
2015-04-20 05:30:00	SPY	ETF	209.25	209.25	209.23	209.23	2400.0
2015-04-20 05:35:00	SPY	ETF	209.17	209.17	209.17	209.17	1420.0
2015-04-20 05:40:00	SPY	ETF	209.14	209.17	209.14	209.17	200.0
2015-04-20 05:45:00	SPY	ETF	209.17	209.19	209.17	209.19	5200.0
2015-04-20 05:50:00	SPY	ETF	209.2	209.22	209.2	209.22	500.0
2015-04-20 05:55:00	SPY	ETF	209.24	209.24	209.19	209.19	66299.0
2015-04-20 06:00:00	SPY	ETF	209.17	209.17	209.14	209.14	38324.0
2015-04-20 06:05:00	SPY	ETF	209.15	209.16	209.15	209.16	400.0
2015-04-20 06:10:00	SPY	ETF	209.18	209.19	209.16	209.16	6100.0
2015-04-20 06:15:00	SPY	ETF	209.16	209.22	209.16	209.22	3200.0
2015-04-20 06:20:00	SPY	ETF	209.2	209.22	209.2	209.22	400.0
2015-04-20 06:25:00	SPY	ETF	209.2	209.2	209.18	209.19	10334.0
2015-04-20 06:30:00	SPY	ETF	209.2	209.29	209.2	209.29	3000.0
2015-04-20 06:35:00	SPY	ETF	209.3	209.45	209.3	209.4	74880.0
2015-04-20 06:40:00	SPY	ETF	209.4	209.45	209.4	209.42	9708.0
2015-04-20 06:45:00	SPY	ETF	209.42	209.45	209.34	209.37	45928.0
2015-04-20 06:50:00	SPY	ETF	209.38	209.38	209.29	209.29	3700.0
2015-04-20 06:55:00	SPY	ETF	209.28	209.35	209.27	209.35	17451.0
2015-04-20 07:00:00	SPY	ETF	209.36	209.36	209.28	209.29	40702.0
2015-04-20 07:05:00	SPY	ETF	209.31	209.32	209.29	209.29	14400.0
2015-04-20 07:10:00	SPY	ETF	209.29	209.3	209.17	209.17	14615.0
2015-04-20 07:15:00	SPY	ETF	209.19	209.21	209.17	209.17	28790.0
2015-04-20 07:20:00	SPY	ETF	209.18	209.25	209.16	209.23	27735.0
2015-04-20 07:25:00	SPY	ETF	209.19	209.2	209.17	209.2	4300.0
2015-04-20 07:30:00	SPY	ETF	209.16	209.18	208.99	209.03	63010.0
2015-04-20 07:35:00	SPY	ETF	209.0	209.03	208.9	209.0	40130.0
2015-04-20 07:40:00	SPY	ETF	208.98	209.0	208.94	208.97	129123.0
2015-04-20 07:45:00	SPY	ETF	208.96	209.05	208.96	209.04	15784.0
2015-04-20 07:50:00	SPY	ETF	209.05	209.06	208.99	209.03	7215.0
2015-04-20 07:55:00	SPY	ETF	209.02	209.02	208.71	209.0	21580.0
2015-04-20 08:00:00	SPY	ETF	208.51	209.3	208.51	208.99	235175.0
2015-04-20 08:05:00	SPY	ETF	209.06	209.13	209.04	209.08	48882.0
2015-04-20 08:10:00	SPY	ETF	209.08	209.12	208.99	208.99	39001.0
2015-04-20 08:15:00	SPY	ETF	208.98	209.1	208.96	209.1	70277.0

> showing 50 of 48,165 rows — these rows as CSV

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