PREVIEW / etf_5min / 2014-02-27

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-02-27.parquet
  size:    1006 KB
  rows:    42,430

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-02-27 04:00:00	SPY	ETF	185.1	185.1	185.05	185.06	501.0
2014-02-27 04:05:00	SPY	ETF	185.02	185.02	185.01	185.01	205.0
2014-02-27 04:10:00	SPY	ETF	185.01	185.01	184.99	185.0	441.0
2014-02-27 04:15:00	SPY	ETF	184.91	184.91	184.75	184.76	2743.0
2014-02-27 04:20:00	SPY	ETF	184.64	184.65	184.5	184.65	1745.0
2014-02-27 04:25:00	SPY	ETF	184.66	184.68	184.63	184.68	435.0
2014-02-27 04:30:00	SPY	ETF	184.62	184.7	184.62	184.68	472.0
2014-02-27 04:35:00	SPY	ETF	184.61	184.61	184.51	184.55	11057.0
2014-02-27 04:40:00	SPY	ETF	184.55	184.55	184.55	184.55	151.0
2014-02-27 04:45:00	SPY	ETF	184.5	184.51	184.46	184.51	3810.0
2014-02-27 04:50:00	SPY	ETF	184.41	184.42	184.37	184.42	680.0
2014-02-27 04:55:00	SPY	ETF	184.39	184.39	184.21	184.21	21134.0
2014-02-27 05:00:00	SPY	ETF	184.17	184.28	184.1	184.28	11678.0
2014-02-27 05:05:00	SPY	ETF	184.25	184.26	184.23	184.26	700.0
2014-02-27 05:10:00	SPY	ETF	184.33	184.38	184.33	184.38	400.0
2014-02-27 05:15:00	SPY	ETF	184.38	184.38	184.3	184.3	1275.0
2014-02-27 05:20:00	SPY	ETF	184.23	184.24	184.21	184.21	5219.0
2014-02-27 05:25:00	SPY	ETF	184.2	184.24	184.17	184.24	300.0
2014-02-27 05:30:00	SPY	ETF	184.19	184.19	184.13	184.15	5328.0
2014-02-27 05:35:00	SPY	ETF	184.15	184.15	184.12	184.12	2000.0
2014-02-27 05:40:00	SPY	ETF	184.08	184.08	184.06	184.06	2900.0
2014-02-27 05:45:00	SPY	ETF	184.06	184.06	183.86	183.86	11381.0
2014-02-27 05:50:00	SPY	ETF	183.84	183.9	183.84	183.9	2700.0
2014-02-27 05:55:00	SPY	ETF	183.9	183.93	183.9	183.93	2944.0
2014-02-27 06:00:00	SPY	ETF	183.93	184.0	183.93	183.94	3242.0
2014-02-27 06:05:00	SPY	ETF	183.92	183.92	183.87	183.87	3148.0
2014-02-27 06:10:00	SPY	ETF	183.99	183.99	183.99	183.99	140.0
2014-02-27 06:15:00	SPY	ETF	184.07	184.11	184.04	184.04	2513.0
2014-02-27 06:20:00	SPY	ETF	184.04	184.04	184.04	184.04	4318.0
2014-02-27 06:25:00	SPY	ETF	184.06	184.06	183.87	183.94	11998.0
2014-02-27 06:30:00	SPY	ETF	184.0	184.0	183.96	183.98	6500.0
2014-02-27 06:35:00	SPY	ETF	183.92	184.02	183.91	184.02	1000.0
2014-02-27 06:40:00	SPY	ETF	183.99	184.12	183.99	184.12	14100.0
2014-02-27 06:45:00	SPY	ETF	184.11	184.2	184.1	184.1	6430.0
2014-02-27 06:50:00	SPY	ETF	184.09	184.15	184.06	184.15	13800.0
2014-02-27 06:55:00	SPY	ETF	184.15	184.15	184.15	184.15	200.0
2014-02-27 07:00:00	SPY	ETF	184.12	184.18	184.11	184.18	9418.0
2014-02-27 07:05:00	SPY	ETF	184.21	184.21	184.15	184.21	26825.0
2014-02-27 07:10:00	SPY	ETF	184.2	184.2	184.12	184.13	30863.0
2014-02-27 07:15:00	SPY	ETF	184.14	184.2	184.13	184.2	18016.0
2014-02-27 07:20:00	SPY	ETF	184.2	184.28	184.2	184.28	10500.0
2014-02-27 07:25:00	SPY	ETF	184.29	184.35	184.26	184.26	33652.0
2014-02-27 07:30:00	SPY	ETF	184.26	184.27	184.19	184.24	14310.0
2014-02-27 07:35:00	SPY	ETF	184.24	184.24	184.18	184.2	5000.0
2014-02-27 07:40:00	SPY	ETF	184.16	184.2	184.06	184.07	105054.0
2014-02-27 07:45:00	SPY	ETF	184.07	184.19	184.07	184.19	67427.0
2014-02-27 07:50:00	SPY	ETF	184.2	184.3	184.17	184.27	16431.0
2014-02-27 07:55:00	SPY	ETF	184.29	184.4	184.29	184.39	42200.0
2014-02-27 08:00:00	SPY	ETF	184.29	184.39	183.99	184.3	104038.0
2014-02-27 08:05:00	SPY	ETF	184.3	184.3	184.24	184.25	34344.0

> showing 50 of 42,430 rows — these rows as CSV

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