PREVIEW / etf_5min / 2013-07-18

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-07-18.parquet
  size:    969 KB
  rows:    41,596

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
2013-07-18 04:05:00	SPY	ETF	167.98	167.98	167.98	167.98	100.0
2013-07-18 04:15:00	SPY	ETF	168.0	168.06	168.0	168.04	800.0
2013-07-18 04:20:00	SPY	ETF	168.03	168.08	168.03	168.08	300.0
2013-07-18 04:35:00	SPY	ETF	168.08	168.08	168.08	168.08	100.0
2013-07-18 04:55:00	SPY	ETF	168.1	168.1	168.1	168.1	200.0
2013-07-18 05:15:00	SPY	ETF	168.05	168.05	168.05	168.05	200.0
2013-07-18 05:20:00	SPY	ETF	168.05	168.05	168.05	168.05	500.0
2013-07-18 05:30:00	SPY	ETF	168.1	168.1	168.1	168.1	200.0
2013-07-18 05:50:00	SPY	ETF	168.15	168.15	168.15	168.15	300.0
2013-07-18 06:05:00	SPY	ETF	168.1	168.1	168.09	168.09	500.0
2013-07-18 06:15:00	SPY	ETF	168.13	168.15	168.13	168.15	300.0
2013-07-18 06:20:00	SPY	ETF	168.16	168.16	168.16	168.16	4200.0
2013-07-18 06:25:00	SPY	ETF	168.16	168.16	168.16	168.16	5000.0
2013-07-18 06:35:00	SPY	ETF	168.14	168.14	168.14	168.14	200.0
2013-07-18 06:40:00	SPY	ETF	168.12	168.12	168.09	168.09	6130.0
2013-07-18 06:50:00	SPY	ETF	168.11	168.11	168.11	168.11	100.0
2013-07-18 06:55:00	SPY	ETF	168.14	168.14	168.14	168.14	5100.0
2013-07-18 07:00:00	SPY	ETF	168.15	168.15	168.11	168.14	14250.0
2013-07-18 07:05:00	SPY	ETF	168.15	168.16	168.15	168.16	700.0
2013-07-18 07:10:00	SPY	ETF	168.13	168.15	168.09	168.15	4365.0
2013-07-18 07:15:00	SPY	ETF	168.15	168.15	168.14	168.14	12100.0
2013-07-18 07:20:00	SPY	ETF	168.16	168.17	168.16	168.17	10200.0
2013-07-18 07:25:00	SPY	ETF	168.2	168.22	168.2	168.2	1648.0
2013-07-18 07:30:00	SPY	ETF	168.17	168.17	168.145	168.15	6395.0
2013-07-18 07:35:00	SPY	ETF	168.17	168.17	168.16	168.16	230.0
2013-07-18 07:40:00	SPY	ETF	168.16	168.21	168.16	168.19	53292.0
2013-07-18 07:50:00	SPY	ETF	168.15	168.15	168.14	168.14	2400.0
2013-07-18 07:55:00	SPY	ETF	168.14	168.14	168.12	168.13	2615.0
2013-07-18 08:00:00	SPY	ETF	168.14	168.18	168.11	168.11	19300.0
2013-07-18 08:05:00	SPY	ETF	168.11	168.12	168.08	168.12	12700.0
2013-07-18 08:10:00	SPY	ETF	168.12	168.12	168.12	168.12	5900.0
2013-07-18 08:15:00	SPY	ETF	168.14	168.17	168.13	168.17	18508.0
2013-07-18 08:20:00	SPY	ETF	168.15	168.18	168.15	168.17	10975.0
2013-07-18 08:25:00	SPY	ETF	168.18	168.62	168.14	168.2	23820.0
2013-07-18 08:30:00	SPY	ETF	168.52	170.46	168.15	168.25	118378.0
2013-07-18 08:35:00	SPY	ETF	168.25	168.39	168.25	168.33	177031.0
2013-07-18 08:40:00	SPY	ETF	168.35	168.39	168.32	168.33	91670.0
2013-07-18 08:45:00	SPY	ETF	168.36	168.39	168.35	168.36	12490.0
2013-07-18 08:50:00	SPY	ETF	168.36	168.37	168.33	168.34	21126.0
2013-07-18 08:55:00	SPY	ETF	168.35	168.35	168.31	168.35	53530.0
2013-07-18 09:00:00	SPY	ETF	168.35	168.43	168.35	168.39	170460.0
2013-07-18 09:05:00	SPY	ETF	168.4	168.41	168.33	168.35	34976.0
2013-07-18 09:10:00	SPY	ETF	168.34	168.36	168.28	168.3	47422.0
2013-07-18 09:15:00	SPY	ETF	168.31	168.31	168.28	168.29	20225.0
2013-07-18 09:20:00	SPY	ETF	168.29	168.31	168.29	168.31	23585.0
2013-07-18 09:25:00	SPY	ETF	168.31	168.31	168.27	168.3	108482.0
2013-07-18 09:30:00	SPY	ETF	168.31	168.36	168.2	168.3	2380320.0
2013-07-18 09:35:00	SPY	ETF	168.3	168.47	168.23	168.44	1494045.0
2013-07-18 09:40:00	SPY	ETF	168.45	168.6	168.38	168.53	1839161.0
2013-07-18 09:45:00	SPY	ETF	168.53	168.66	168.51	168.55	1587428.0

> showing 50 of 41,596 rows — these rows as CSV

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