PREVIEW / etf_5min / 2014-07-15

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-07-15.parquet
  size:    1009 KB
  rows:    42,438

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-15 04:00:00	SPY	ETF	197.54	197.54	197.54	197.54	500.0
2014-07-15 04:15:00	SPY	ETF	197.5	197.5	197.5	197.5	200.0
2014-07-15 04:25:00	SPY	ETF	197.53	197.53	197.53	197.53	200.0
2014-07-15 04:30:00	SPY	ETF	197.52	197.52	197.52	197.52	163.0
2014-07-15 04:35:00	SPY	ETF	197.5	197.53	197.5	197.53	301.0
2014-07-15 04:45:00	SPY	ETF	197.54	197.54	197.54	197.54	125.0
2014-07-15 04:55:00	SPY	ETF	197.51	197.52	197.51	197.52	797.0
2014-07-15 05:05:00	SPY	ETF	197.47	197.47	197.47	197.47	100.0
2014-07-15 05:10:00	SPY	ETF	197.4	197.4	197.4	197.4	191.0
2014-07-15 05:15:00	SPY	ETF	197.34	197.34	197.28	197.28	399.0
2014-07-15 05:50:00	SPY	ETF	197.32	197.32	197.32	197.32	200.0
2014-07-15 05:55:00	SPY	ETF	197.31	197.31	197.31	197.31	167.0
2014-07-15 06:00:00	SPY	ETF	197.33	197.33	197.33	197.33	100.0
2014-07-15 06:05:00	SPY	ETF	197.3	197.3	197.3	197.3	138.0
2014-07-15 06:10:00	SPY	ETF	197.33	197.33	197.31	197.31	3300.0
2014-07-15 06:25:00	SPY	ETF	197.33	197.33	197.33	197.33	111.0
2014-07-15 06:30:00	SPY	ETF	197.29	197.29	197.24	197.24	800.0
2014-07-15 06:35:00	SPY	ETF	197.25	197.26	197.23	197.23	2500.0
2014-07-15 06:40:00	SPY	ETF	197.21	197.26	197.21	197.26	800.0
2014-07-15 06:45:00	SPY	ETF	197.26	197.26	197.26	197.26	1300.0
2014-07-15 06:50:00	SPY	ETF	197.27	197.27	197.27	197.27	149.0
2014-07-15 06:55:00	SPY	ETF	197.34	197.37	197.34	197.37	8200.0
2014-07-15 07:00:00	SPY	ETF	197.36	197.46	197.34	197.46	6660.0
2014-07-15 07:05:00	SPY	ETF	197.42	197.42	197.42	197.42	1400.0
2014-07-15 07:10:00	SPY	ETF	197.55	197.59	197.52	197.58	47400.0
2014-07-15 07:15:00	SPY	ETF	197.58	197.58	197.57	197.57	1432.0
2014-07-15 07:20:00	SPY	ETF	197.57	197.58	197.57	197.57	14550.0
2014-07-15 07:25:00	SPY	ETF	197.57	197.65	197.54	197.64	17365.0
2014-07-15 07:30:00	SPY	ETF	197.62	197.65	197.62	197.65	6000.0
2014-07-15 07:35:00	SPY	ETF	197.65	197.78	197.65	197.73	59862.0
2014-07-15 07:40:00	SPY	ETF	197.74	197.75	197.7	197.72	46977.0
2014-07-15 07:45:00	SPY	ETF	197.72	197.78	197.72	197.78	26070.0
2014-07-15 07:50:00	SPY	ETF	197.75	197.8	197.75	197.8	45848.0
2014-07-15 07:55:00	SPY	ETF	197.79	197.8	197.67	197.67	37061.0
2014-07-15 08:00:00	SPY	ETF	197.67	197.71	197.57	197.7	9016.0
2014-07-15 08:05:00	SPY	ETF	197.69	197.77	197.66	197.77	8697.0
2014-07-15 08:10:00	SPY	ETF	197.75	197.78	197.7	197.72	47357.0
2014-07-15 08:15:00	SPY	ETF	197.72	197.72	197.66	197.66	56768.0
2014-07-15 08:20:00	SPY	ETF	197.66	197.72	197.66	197.69	16517.0
2014-07-15 08:25:00	SPY	ETF	197.69	197.73	197.69	197.71	10650.0
2014-07-15 08:30:00	SPY	ETF	197.73	197.92	197.7	197.8	293720.0
2014-07-15 08:35:00	SPY	ETF	197.79	197.81	197.76	197.81	38475.0
2014-07-15 08:40:00	SPY	ETF	197.8	197.82	197.76	197.78	11313.0
2014-07-15 08:45:00	SPY	ETF	197.81	197.81	197.74	197.75	23991.0
2014-07-15 08:50:00	SPY	ETF	197.75	197.77	197.73	197.75	92072.0
2014-07-15 08:55:00	SPY	ETF	197.76	197.81	197.75	197.78	26433.0
2014-07-15 09:00:00	SPY	ETF	197.78	197.79	197.75	197.77	18025.0
2014-07-15 09:05:00	SPY	ETF	197.77	197.77	197.75	197.75	1046.0
2014-07-15 09:10:00	SPY	ETF	197.76	197.77	197.73	197.74	15916.0
2014-07-15 09:15:00	SPY	ETF	197.74	197.75	197.63	197.68	76016.0

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

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