PREVIEW / etf_5min / 2014-07-31

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-07-31.parquet
  size:    1.1 MB
  rows:    47,886

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-31 04:00:00	SPY	ETF	196.61	196.61	195.9	195.9	2802.0
2014-07-31 04:05:00	SPY	ETF	195.9	195.9	195.9	195.9	100.0
2014-07-31 04:10:00	SPY	ETF	196.08	196.14	196.08	196.14	1200.0
2014-07-31 04:15:00	SPY	ETF	196.17	196.17	196.1	196.12	5550.0
2014-07-31 04:20:00	SPY	ETF	196.0	196.0	196.0	196.0	500.0
2014-07-31 04:30:00	SPY	ETF	196.11	196.11	196.0	196.0	1000.0
2014-07-31 04:35:00	SPY	ETF	196.0	196.0	195.89	195.92	1198.0
2014-07-31 04:40:00	SPY	ETF	195.94	195.94	195.81	195.81	450.0
2014-07-31 04:45:00	SPY	ETF	195.77	195.77	195.7	195.7	2850.0
2014-07-31 04:50:00	SPY	ETF	195.55	195.64	195.5	195.5	15034.0
2014-07-31 04:55:00	SPY	ETF	195.54	195.54	195.35	195.5	21818.0
2014-07-31 05:00:00	SPY	ETF	195.5	195.59	195.5	195.55	13600.0
2014-07-31 05:05:00	SPY	ETF	195.5	195.5	195.5	195.5	1150.0
2014-07-31 05:10:00	SPY	ETF	195.58	195.69	195.57	195.66	7423.0
2014-07-31 05:15:00	SPY	ETF	195.61	195.61	195.61	195.61	1050.0
2014-07-31 05:20:00	SPY	ETF	195.68	195.68	195.68	195.68	170.0
2014-07-31 05:25:00	SPY	ETF	195.8	195.8	195.8	195.8	625.0
2014-07-31 05:30:00	SPY	ETF	195.78	195.8	195.78	195.78	7670.0
2014-07-31 05:35:00	SPY	ETF	195.68	195.68	195.68	195.68	1300.0
2014-07-31 05:40:00	SPY	ETF	195.75	195.75	195.75	195.75	401.0
2014-07-31 05:45:00	SPY	ETF	195.68	195.79	195.68	195.79	250.0
2014-07-31 05:55:00	SPY	ETF	195.73	195.73	195.68	195.71	10264.0
2014-07-31 06:00:00	SPY	ETF	195.68	195.7	195.67	195.7	5200.0
2014-07-31 06:05:00	SPY	ETF	195.66	195.66	195.66	195.66	1900.0
2014-07-31 06:10:00	SPY	ETF	195.71	195.72	195.67	195.67	3950.0
2014-07-31 06:15:00	SPY	ETF	195.7	195.7	195.7	195.7	200.0
2014-07-31 06:20:00	SPY	ETF	195.7	195.7	195.62	195.62	35163.0
2014-07-31 06:25:00	SPY	ETF	195.69	195.77	195.69	195.77	22368.0
2014-07-31 06:30:00	SPY	ETF	195.86	195.95	195.85	195.85	50675.0
2014-07-31 06:35:00	SPY	ETF	195.85	195.86	195.79	195.86	7179.0
2014-07-31 06:40:00	SPY	ETF	195.93	195.95	195.88	195.95	37125.0
2014-07-31 06:45:00	SPY	ETF	195.9	195.98	195.9	195.98	59610.0
2014-07-31 06:50:00	SPY	ETF	195.9	195.98	195.9	195.98	3500.0
2014-07-31 06:55:00	SPY	ETF	195.91	195.92	195.91	195.92	1400.0
2014-07-31 07:00:00	SPY	ETF	195.96	196.0	195.91	195.95	17378.0
2014-07-31 07:05:00	SPY	ETF	195.95	196.0	195.95	195.99	33320.0
2014-07-31 07:10:00	SPY	ETF	195.96	195.98	195.84	195.86	26622.0
2014-07-31 07:15:00	SPY	ETF	195.86	195.95	195.85	195.95	56951.0
2014-07-31 07:20:00	SPY	ETF	195.9	195.92	195.85	195.86	25559.0
2014-07-31 07:25:00	SPY	ETF	195.86	195.86	195.83	195.84	28010.0
2014-07-31 07:30:00	SPY	ETF	195.91	195.96	195.89	195.91	63368.0
2014-07-31 07:35:00	SPY	ETF	195.93	195.96	195.84	195.84	35577.0
2014-07-31 07:40:00	SPY	ETF	195.86	195.91	195.84	195.89	61929.0
2014-07-31 07:45:00	SPY	ETF	195.87	195.87	195.61	195.7	33988.0
2014-07-31 07:50:00	SPY	ETF	195.78	195.95	195.71	195.95	92395.0
2014-07-31 07:55:00	SPY	ETF	195.93	196.04	195.93	195.94	105700.0
2014-07-31 08:00:00	SPY	ETF	195.76	196.02	195.7	195.98	178262.0
2014-07-31 08:05:00	SPY	ETF	196.966	196.966	195.84	196.11	386425.0
2014-07-31 08:10:00	SPY	ETF	196.11	196.11	196.04	196.09	55576.0
2014-07-31 08:15:00	SPY	ETF	196.09	196.14	196.02	196.02	117009.0

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

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