PREVIEW / etf_5min / 2014-10-22

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-10-22.parquet
  size:    1.1 MB
  rows:    47,939

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-10-22 04:00:00	SPY	ETF	194.25	194.25	194.04	194.1	8599.0
2014-10-22 04:05:00	SPY	ETF	194.0	194.0	194.0	194.0	10025.0
2014-10-22 04:10:00	SPY	ETF	193.9	193.9	193.85	193.85	2624.0
2014-10-22 04:15:00	SPY	ETF	193.83	194.04	193.83	193.99	2863.0
2014-10-22 04:20:00	SPY	ETF	193.95	193.95	193.87	193.92	1170.0
2014-10-22 04:25:00	SPY	ETF	193.9	193.9	193.82	193.84	6350.0
2014-10-22 04:30:00	SPY	ETF	193.74	193.82	193.73	193.77	8568.0
2014-10-22 04:35:00	SPY	ETF	193.79	193.9	193.77	193.79	9266.0
2014-10-22 04:40:00	SPY	ETF	193.7	193.79	193.7	193.79	6160.0
2014-10-22 04:45:00	SPY	ETF	193.79	193.94	193.7	193.7	7591.0
2014-10-22 04:50:00	SPY	ETF	193.79	193.9	193.73	193.9	9114.0
2014-10-22 04:55:00	SPY	ETF	193.85	193.88	193.85	193.88	553.0
2014-10-22 05:00:00	SPY	ETF	193.87	193.9	193.87	193.9	2795.0
2014-10-22 05:20:00	SPY	ETF	193.95	193.95	193.95	193.95	6579.0
2014-10-22 05:25:00	SPY	ETF	194.04	194.05	193.87	193.87	3449.0
2014-10-22 05:30:00	SPY	ETF	193.85	193.88	193.84	193.88	600.0
2014-10-22 05:35:00	SPY	ETF	193.95	194.05	193.95	194.05	1250.0
2014-10-22 05:40:00	SPY	ETF	193.95	193.98	193.92	193.95	87800.0
2014-10-22 05:45:00	SPY	ETF	194.01	194.02	193.99	193.99	10682.0
2014-10-22 05:50:00	SPY	ETF	193.97	193.97	193.9	193.9	22800.0
2014-10-22 05:55:00	SPY	ETF	193.9	193.91	193.84	193.84	64756.0
2014-10-22 06:00:00	SPY	ETF	193.91	193.91	193.82	193.82	30491.0
2014-10-22 06:05:00	SPY	ETF	193.85	193.9	193.85	193.86	10534.0
2014-10-22 06:10:00	SPY	ETF	193.9	193.94	193.87	193.94	47500.0
2014-10-22 06:15:00	SPY	ETF	193.94	193.95	193.88	193.88	5713.0
2014-10-22 06:20:00	SPY	ETF	193.86	193.86	193.8	193.81	4035.0
2014-10-22 06:25:00	SPY	ETF	193.87	193.95	193.87	193.95	7066.0
2014-10-22 06:30:00	SPY	ETF	193.99	193.99	193.92	193.94	11437.0
2014-10-22 06:35:00	SPY	ETF	193.92	193.96	193.9	193.9	1000.0
2014-10-22 06:40:00	SPY	ETF	193.98	194.09	193.98	194.09	2610.0
2014-10-22 06:45:00	SPY	ETF	194.04	194.12	194.04	194.12	2041.0
2014-10-22 06:50:00	SPY	ETF	194.06	194.09	194.06	194.09	24351.0
2014-10-22 06:55:00	SPY	ETF	194.07	194.14	194.07	194.08	10582.0
2014-10-22 07:00:00	SPY	ETF	194.09	194.17	194.09	194.12	34335.0
2014-10-22 07:05:00	SPY	ETF	194.13	194.25	194.12	194.24	14275.0
2014-10-22 07:10:00	SPY	ETF	194.2	194.24	194.06	194.11	17207.0
2014-10-22 07:15:00	SPY	ETF	194.11	194.16	194.11	194.15	9740.0
2014-10-22 07:20:00	SPY	ETF	194.13	194.13	193.94	193.94	33884.0
2014-10-22 07:25:00	SPY	ETF	193.93	194.06	193.93	194.06	57823.0
2014-10-22 07:30:00	SPY	ETF	194.04	194.04	193.95	193.98	22976.0
2014-10-22 07:35:00	SPY	ETF	193.98	194.06	193.97	194.05	104341.0
2014-10-22 07:40:00	SPY	ETF	194.06	194.11	194.06	194.11	4566.0
2014-10-22 07:45:00	SPY	ETF	194.09	194.2	194.09	194.12	138179.0
2014-10-22 07:50:00	SPY	ETF	194.17	194.22	194.16	194.22	26975.0
2014-10-22 07:55:00	SPY	ETF	194.23	194.29	194.2	194.25	204078.0
2014-10-22 08:00:00	SPY	ETF	194.25	194.27	193.96	194.05	174951.0
2014-10-22 08:05:00	SPY	ETF	194.04	194.1	193.93	194.07	157726.0
2014-10-22 08:10:00	SPY	ETF	194.05	194.12	194.02	194.12	199444.0
2014-10-22 08:15:00	SPY	ETF	194.12	194.22	194.1	194.17	122663.0
2014-10-22 08:20:00	SPY	ETF	194.16	194.19	194.12	194.16	18922.0

> showing 50 of 47,939 rows — these rows as CSV

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