PREVIEW / etf_5min / 2014-07-18

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-07-18.parquet
  size:    981 KB
  rows:    41,340

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-18 04:00:00	SPY	ETF	195.96	196.02	195.96	196.02	295.0
2014-07-18 04:05:00	SPY	ETF	195.99	195.99	195.96	195.96	264.0
2014-07-18 04:30:00	SPY	ETF	196.02	196.02	196.02	196.02	200.0
2014-07-18 04:40:00	SPY	ETF	196.0	196.0	196.0	196.0	300.0
2014-07-18 04:45:00	SPY	ETF	195.98	195.98	195.98	195.98	100.0
2014-07-18 05:00:00	SPY	ETF	195.97	195.97	195.97	195.97	100.0
2014-07-18 05:05:00	SPY	ETF	195.96	195.96	195.96	195.96	400.0
2014-07-18 05:10:00	SPY	ETF	195.95	195.95	195.95	195.95	200.0
2014-07-18 05:15:00	SPY	ETF	195.93	195.94	195.9	195.93	2300.0
2014-07-18 05:20:00	SPY	ETF	195.97	195.98	195.96	195.98	1100.0
2014-07-18 05:30:00	SPY	ETF	195.9	195.97	195.9	195.97	300.0
2014-07-18 05:40:00	SPY	ETF	195.89	195.89	195.89	195.89	400.0
2014-07-18 05:45:00	SPY	ETF	195.9	195.9	195.9	195.9	350.0
2014-07-18 05:50:00	SPY	ETF	195.92	195.92	195.75	195.75	400.0
2014-07-18 05:55:00	SPY	ETF	195.82	195.82	195.67	195.67	800.0
2014-07-18 06:00:00	SPY	ETF	195.83	195.88	195.83	195.88	250.0
2014-07-18 06:05:00	SPY	ETF	195.82	195.94	195.82	195.94	2480.0
2014-07-18 06:10:00	SPY	ETF	195.89	196.0	195.86	196.0	6793.0
2014-07-18 06:20:00	SPY	ETF	195.97	195.99	195.89	195.99	20600.0
2014-07-18 06:25:00	SPY	ETF	195.96	195.96	195.96	195.96	900.0
2014-07-18 06:30:00	SPY	ETF	195.94	195.96	195.94	195.95	6311.0
2014-07-18 06:35:00	SPY	ETF	195.96	195.98	195.96	195.98	600.0
2014-07-18 06:45:00	SPY	ETF	195.99	196.2	195.97	196.2	5042.0
2014-07-18 06:50:00	SPY	ETF	196.1	196.17	196.1	196.16	22315.0
2014-07-18 06:55:00	SPY	ETF	196.16	196.25	196.16	196.2	37250.0
2014-07-18 07:00:00	SPY	ETF	196.18	196.24	196.15	196.17	29054.0
2014-07-18 07:05:00	SPY	ETF	196.14	196.19	196.11	196.19	30495.0
2014-07-18 07:10:00	SPY	ETF	196.19	196.32	196.19	196.28	54704.0
2014-07-18 07:15:00	SPY	ETF	196.25	196.36	196.25	196.35	41720.0
2014-07-18 07:20:00	SPY	ETF	196.35	196.35	196.3	196.31	62100.0
2014-07-18 07:25:00	SPY	ETF	196.3	196.34	196.3	196.3	28100.0
2014-07-18 07:30:00	SPY	ETF	196.28	196.29	196.25	196.25	55200.0
2014-07-18 07:35:00	SPY	ETF	196.25	196.25	196.19	196.19	54442.0
2014-07-18 07:40:00	SPY	ETF	196.18	196.21	196.15	196.18	34611.0
2014-07-18 07:45:00	SPY	ETF	196.16	196.19	196.15	196.16	36533.0
2014-07-18 07:50:00	SPY	ETF	196.18	196.18	196.07	196.09	20674.0
2014-07-18 07:55:00	SPY	ETF	196.08	196.08	196.0	196.06	24025.0
2014-07-18 08:00:00	SPY	ETF	196.11	196.3	196.05	196.06	76745.0
2014-07-18 08:05:00	SPY	ETF	196.04	196.07	196.04	196.06	31240.0
2014-07-18 08:10:00	SPY	ETF	196.07	196.12	196.07	196.09	11994.0
2014-07-18 08:15:00	SPY	ETF	196.11	196.19	196.1	196.14	29081.0
2014-07-18 08:20:00	SPY	ETF	196.14	196.14	196.1	196.1	43572.0
2014-07-18 08:25:00	SPY	ETF	196.1	196.14	196.07	196.13	26971.0
2014-07-18 08:30:00	SPY	ETF	196.13	196.19	196.13	196.15	100661.0
2014-07-18 08:35:00	SPY	ETF	196.15	196.19	196.1	196.12	157404.0
2014-07-18 08:40:00	SPY	ETF	196.15	196.22	196.15	196.21	105780.0
2014-07-18 08:45:00	SPY	ETF	196.2	196.24	196.13	196.14	43342.0
2014-07-18 08:50:00	SPY	ETF	196.16	196.16	196.08	196.11	36746.0
2014-07-18 08:55:00	SPY	ETF	196.12	196.17	196.1	196.1	111696.0
2014-07-18 09:00:00	SPY	ETF	196.11	196.21	196.11	196.17	77857.0

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

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