PREVIEW / etf_5min / 2014-08-01

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-08-01.parquet
  size:    1.1 MB
  rows:    47,523

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-08-01 04:00:00	SPY	ETF	193.03	193.08	193.0	193.0	3205.0
2014-08-01 04:10:00	SPY	ETF	192.94	192.94	192.81	192.81	797.0
2014-08-01 04:15:00	SPY	ETF	192.67	192.67	192.52	192.54	2000.0
2014-08-01 04:20:00	SPY	ETF	192.5	192.56	192.46	192.46	1711.0
2014-08-01 04:25:00	SPY	ETF	192.38	192.4	192.38	192.4	1765.0
2014-08-01 04:30:00	SPY	ETF	192.3	192.3	192.3	192.3	923.0
2014-08-01 04:35:00	SPY	ETF	192.3	192.33	192.3	192.3	600.0
2014-08-01 04:40:00	SPY	ETF	192.3	192.3	192.2	192.23	3390.0
2014-08-01 04:45:00	SPY	ETF	192.33	192.36	192.28	192.36	1450.0
2014-08-01 04:50:00	SPY	ETF	192.22	192.25	192.22	192.25	433.0
2014-08-01 04:55:00	SPY	ETF	192.3	192.31	192.28	192.31	845.0
2014-08-01 05:00:00	SPY	ETF	192.31	192.31	192.17	192.17	2093.0
2014-08-01 05:05:00	SPY	ETF	192.13	192.13	192.12	192.12	333.0
2014-08-01 05:10:00	SPY	ETF	192.11	192.15	192.1	192.15	1323.0
2014-08-01 05:15:00	SPY	ETF	192.24	192.24	192.1	192.12	2160.0
2014-08-01 05:20:00	SPY	ETF	192.04	192.11	192.01	192.11	1691.0
2014-08-01 05:25:00	SPY	ETF	192.03	192.13	192.01	192.01	2352.0
2014-08-01 05:30:00	SPY	ETF	192.0	192.05	191.93	191.93	1782.0
2014-08-01 05:35:00	SPY	ETF	191.94	191.97	191.75	191.75	9816.0
2014-08-01 05:40:00	SPY	ETF	191.8	191.8	191.64	191.72	45355.0
2014-08-01 05:45:00	SPY	ETF	191.7	191.94	191.7	191.94	50839.0
2014-08-01 05:50:00	SPY	ETF	191.73	191.8	191.73	191.8	216.0
2014-08-01 05:55:00	SPY	ETF	191.8	191.8	191.65	191.69	31418.0
2014-08-01 06:00:00	SPY	ETF	191.72	191.88	191.67	191.88	10825.0
2014-08-01 06:05:00	SPY	ETF	192.19	192.19	191.8	191.9	11326.0
2014-08-01 06:10:00	SPY	ETF	191.9	191.9	191.78	191.82	18425.0
2014-08-01 06:15:00	SPY	ETF	191.84	191.88	191.82	191.88	5828.0
2014-08-01 06:20:00	SPY	ETF	191.8	191.86	191.67	191.7	5147.0
2014-08-01 06:25:00	SPY	ETF	191.74	191.77	191.71	191.74	18140.0
2014-08-01 06:30:00	SPY	ETF	191.73	191.75	191.68	191.71	12283.0
2014-08-01 06:35:00	SPY	ETF	191.77	191.8	191.73	191.73	28311.0
2014-08-01 06:40:00	SPY	ETF	191.96	191.98	191.91	191.96	19001.0
2014-08-01 06:45:00	SPY	ETF	191.96	191.96	191.88	191.9	6350.0
2014-08-01 06:50:00	SPY	ETF	191.95	192.0	191.94	191.99	178562.0
2014-08-01 06:55:00	SPY	ETF	192.0	192.05	192.0	192.02	26926.0
2014-08-01 07:00:00	SPY	ETF	192.0	192.0	191.85	191.93	156229.0
2014-08-01 07:05:00	SPY	ETF	191.93	191.94	191.79	191.79	96992.0
2014-08-01 07:10:00	SPY	ETF	191.78	191.97	191.76	191.97	152382.0
2014-08-01 07:15:00	SPY	ETF	191.99	192.07	191.83	191.95	281669.0
2014-08-01 07:20:00	SPY	ETF	191.92	191.92	191.84	191.92	133454.0
2014-08-01 07:25:00	SPY	ETF	191.92	191.96	191.89	191.96	122871.0
2014-08-01 07:30:00	SPY	ETF	191.97	192.05	191.97	192.02	89909.0
2014-08-01 07:35:00	SPY	ETF	192.02	192.15	192.02	192.15	184194.0
2014-08-01 07:40:00	SPY	ETF	192.16	192.19	192.1	192.15	198494.0
2014-08-01 07:45:00	SPY	ETF	192.15	192.26	192.15	192.23	89105.0
2014-08-01 07:50:00	SPY	ETF	192.2	192.25	192.13	192.14	263467.0
2014-08-01 07:55:00	SPY	ETF	192.11	192.18	192.11	192.16	144120.0
2014-08-01 08:00:00	SPY	ETF	192.08	192.25	191.8435	192.02	556081.0
2014-08-01 08:05:00	SPY	ETF	193.67	193.67	191.97	191.97	330122.0
2014-08-01 08:10:00	SPY	ETF	191.97	192.06	191.97	192.05	52241.0

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

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