PREVIEW / etf_5min / 2014-07-30

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-07-30.parquet
  size:    1017 KB
  rows:    43,247

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-30 04:05:00	SPY	ETF	197.06	197.06	197.06	197.06	125.0
2014-07-30 04:10:00	SPY	ETF	197.13	197.13	197.13	197.13	130.0
2014-07-30 04:15:00	SPY	ETF	197.1	197.1	197.1	197.1	125.0
2014-07-30 04:20:00	SPY	ETF	197.15	197.15	197.15	197.15	199.0
2014-07-30 04:25:00	SPY	ETF	197.13	197.13	197.13	197.13	425.0
2014-07-30 04:40:00	SPY	ETF	197.02	197.14	197.02	197.14	1181.0
2014-07-30 05:00:00	SPY	ETF	197.08	197.08	197.08	197.08	100.0
2014-07-30 05:05:00	SPY	ETF	197.18	197.2	197.18	197.2	5250.0
2014-07-30 05:20:00	SPY	ETF	197.2	197.22	197.2	197.22	500.0
2014-07-30 05:30:00	SPY	ETF	197.2	197.2	197.2	197.2	10070.0
2014-07-30 05:35:00	SPY	ETF	197.22	197.22	197.22	197.22	2000.0
2014-07-30 05:40:00	SPY	ETF	197.25	197.25	197.25	197.25	5900.0
2014-07-30 06:30:00	SPY	ETF	197.14	197.17	197.14	197.17	200.0
2014-07-30 06:40:00	SPY	ETF	197.17	197.2	197.17	197.19	5300.0
2014-07-30 06:45:00	SPY	ETF	197.22	197.27	197.22	197.27	1300.0
2014-07-30 06:50:00	SPY	ETF	197.24	197.28	197.23	197.25	26577.0
2014-07-30 06:55:00	SPY	ETF	197.3	197.31	197.26	197.31	21800.0
2014-07-30 07:00:00	SPY	ETF	197.28	197.32	197.28	197.31	20744.0
2014-07-30 07:05:00	SPY	ETF	197.26	197.33	197.26	197.31	7800.0
2014-07-30 07:10:00	SPY	ETF	197.31	197.33	197.3	197.32	19100.0
2014-07-30 07:15:00	SPY	ETF	197.28	197.28	197.23	197.27	37073.0
2014-07-30 07:20:00	SPY	ETF	197.29	197.4	197.29	197.4	90402.0
2014-07-30 07:25:00	SPY	ETF	197.4	197.49	197.37	197.46	55109.0
2014-07-30 07:30:00	SPY	ETF	197.46	197.47	197.44	197.46	6850.0
2014-07-30 07:35:00	SPY	ETF	197.45	197.45	197.43	197.43	7300.0
2014-07-30 07:40:00	SPY	ETF	197.42	197.43	197.4	197.4	16503.0
2014-07-30 07:45:00	SPY	ETF	197.42	197.43	197.39	197.39	14700.0
2014-07-30 07:50:00	SPY	ETF	197.39	197.43	197.39	197.43	5100.0
2014-07-30 07:55:00	SPY	ETF	197.43	197.48	197.43	197.47	24210.0
2014-07-30 08:00:00	SPY	ETF	197.38	197.48	197.3	197.45	43595.0
2014-07-30 08:05:00	SPY	ETF	197.45	197.48	197.4	197.4	30465.0
2014-07-30 08:10:00	SPY	ETF	197.42	197.42	197.34	197.36	49528.0
2014-07-30 08:15:00	SPY	ETF	197.33	197.42	197.31	197.35	66840.0
2014-07-30 08:20:00	SPY	ETF	197.34	197.34	197.15	197.15	38013.0
2014-07-30 08:25:00	SPY	ETF	197.15	197.28	197.15	197.28	23796.0
2014-07-30 08:30:00	SPY	ETF	197.26	197.88	197.23	197.69	1300125.0
2014-07-30 08:35:00	SPY	ETF	197.7	197.77	197.63	197.66	228399.0
2014-07-30 08:40:00	SPY	ETF	197.66	197.78	197.66	197.7	96571.0
2014-07-30 08:45:00	SPY	ETF	197.7	197.78	197.68	197.73	110802.0
2014-07-30 08:50:00	SPY	ETF	197.72	197.72	197.54	197.63	246467.0
2014-07-30 08:55:00	SPY	ETF	197.63	197.67	197.57	197.67	76411.0
2014-07-30 09:00:00	SPY	ETF	197.67	197.71	197.66	197.67	55934.0
2014-07-30 09:05:00	SPY	ETF	197.68	197.69	197.56	197.57	212199.0
2014-07-30 09:10:00	SPY	ETF	197.55	197.6	197.45	197.6	90151.0
2014-07-30 09:15:00	SPY	ETF	197.59	197.6	197.52	197.56	48191.0
2014-07-30 09:20:00	SPY	ETF	197.55	197.66	197.55	197.64	104790.0
2014-07-30 09:25:00	SPY	ETF	197.63	197.67	197.6	197.65	355400.0
2014-07-30 09:30:00	SPY	ETF	197.65	197.91	197.64	197.74	2931264.0
2014-07-30 09:35:00	SPY	ETF	197.74	197.85	197.58	197.62	1154524.0
2014-07-30 09:40:00	SPY	ETF	197.61	197.76	197.61	197.67	1214838.0

> showing 50 of 43,247 rows — these rows as CSV

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