PREVIEW / etf_5min / 2014-10-07

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-10-07.parquet
  size:    1.1 MB
  rows:    46,183

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-07 04:00:00	SPY	ETF	195.81	195.81	195.52	195.53	416.0
2014-10-07 04:10:00	SPY	ETF	195.53	195.53	195.53	195.53	700.0
2014-10-07 04:15:00	SPY	ETF	195.3	195.42	195.23	195.42	1560.0
2014-10-07 04:25:00	SPY	ETF	195.45	195.45	195.45	195.45	150.0
2014-10-07 04:35:00	SPY	ETF	195.52	195.52	195.52	195.52	100.0
2014-10-07 04:40:00	SPY	ETF	195.51	195.51	195.51	195.51	100.0
2014-10-07 04:45:00	SPY	ETF	195.23	195.23	195.0	195.0	1665.0
2014-10-07 04:50:00	SPY	ETF	195.17	195.17	195.12	195.14	1000.0
2014-10-07 04:55:00	SPY	ETF	195.24	195.27	195.16	195.16	2300.0
2014-10-07 05:00:00	SPY	ETF	195.2	195.2	195.2	195.2	100.0
2014-10-07 05:05:00	SPY	ETF	195.17	195.2	195.15	195.2	2400.0
2014-10-07 05:10:00	SPY	ETF	195.2	195.2	195.15	195.15	4500.0
2014-10-07 05:15:00	SPY	ETF	195.18	195.18	195.18	195.18	100.0
2014-10-07 05:30:00	SPY	ETF	195.15	195.16	195.11	195.16	6930.0
2014-10-07 05:35:00	SPY	ETF	195.09	195.09	195.06	195.07	7050.0
2014-10-07 05:40:00	SPY	ETF	195.09	195.09	195.09	195.09	5000.0
2014-10-07 05:45:00	SPY	ETF	195.13	195.17	195.13	195.17	400.0
2014-10-07 05:50:00	SPY	ETF	195.26	195.26	195.21	195.21	13037.0
2014-10-07 05:55:00	SPY	ETF	195.21	195.41	195.21	195.4	5150.0
2014-10-07 06:00:00	SPY	ETF	195.38	195.42	195.38	195.42	15450.0
2014-10-07 06:10:00	SPY	ETF	195.4	195.43	195.37	195.37	2283.0
2014-10-07 06:15:00	SPY	ETF	195.38	195.49	195.38	195.48	4300.0
2014-10-07 06:20:00	SPY	ETF	195.48	195.48	195.46	195.47	1100.0
2014-10-07 06:25:00	SPY	ETF	195.48	195.48	195.45	195.45	1000.0
2014-10-07 06:30:00	SPY	ETF	195.45	195.45	195.41	195.41	1870.0
2014-10-07 06:35:00	SPY	ETF	195.43	195.46	195.42	195.42	10100.0
2014-10-07 06:40:00	SPY	ETF	195.4	195.4	195.37	195.37	2300.0
2014-10-07 06:45:00	SPY	ETF	195.3	195.33	195.3	195.33	1975.0
2014-10-07 06:50:00	SPY	ETF	195.36	195.39	195.35	195.35	8307.0
2014-10-07 06:55:00	SPY	ETF	195.35	195.39	195.35	195.39	600.0
2014-10-07 07:00:00	SPY	ETF	195.41	195.44	195.4	195.4	35025.0
2014-10-07 07:05:00	SPY	ETF	195.4	195.43	195.38	195.41	10201.0
2014-10-07 07:10:00	SPY	ETF	195.42	195.46	195.4	195.46	15650.0
2014-10-07 07:15:00	SPY	ETF	195.49	195.49	195.45	195.45	3455.0
2014-10-07 07:20:00	SPY	ETF	195.46	195.48	195.43	195.46	151600.0
2014-10-07 07:25:00	SPY	ETF	195.45	195.45	195.34	195.41	83051.0
2014-10-07 07:30:00	SPY	ETF	195.38	195.39	195.3	195.35	28835.0
2014-10-07 07:35:00	SPY	ETF	195.35	195.49	195.35	195.49	162684.0
2014-10-07 07:40:00	SPY	ETF	195.49	195.52	195.43	195.5	25442.0
2014-10-07 07:45:00	SPY	ETF	195.51	195.51	195.43	195.48	22600.0
2014-10-07 07:50:00	SPY	ETF	195.45	195.6	195.45	195.58	40401.0
2014-10-07 07:55:00	SPY	ETF	195.58	195.73	195.58	195.72	38619.0
2014-10-07 08:00:00	SPY	ETF	195.9026	195.9026	195.35	195.75	292183.0
2014-10-07 08:05:00	SPY	ETF	195.75	195.78	195.7	195.71	121750.0
2014-10-07 08:10:00	SPY	ETF	195.76	195.9	195.76	195.89	43499.0
2014-10-07 08:15:00	SPY	ETF	195.9	195.92	195.85	195.91	59575.0
2014-10-07 08:20:00	SPY	ETF	195.91	195.91	195.77	195.82	90844.0
2014-10-07 08:25:00	SPY	ETF	195.83	195.86	195.77	195.85	68107.0
2014-10-07 08:30:00	SPY	ETF	195.87	195.89	195.76	195.76	59905.0
2014-10-07 08:35:00	SPY	ETF	195.78	195.78	195.66	195.66	59981.0

> showing 50 of 46,183 rows — these rows as CSV

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