PREVIEW / etf_5min / 2014-10-27

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-10-27.parquet
  size:    1.0 MB
  rows:    46,031

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-27 05:00:00	SPY	ETF	196.9	196.98	196.34	196.34	12816.0
2014-10-27 05:05:00	SPY	ETF	196.46	196.46	196.46	196.46	100.0
2014-10-27 05:10:00	SPY	ETF	196.6	196.66	196.59	196.59	2250.0
2014-10-27 05:15:00	SPY	ETF	196.48	196.51	196.46	196.46	2750.0
2014-10-27 05:20:00	SPY	ETF	196.48	196.48	196.3	196.34	12150.0
2014-10-27 05:25:00	SPY	ETF	196.34	196.34	196.34	196.34	400.0
2014-10-27 05:30:00	SPY	ETF	196.48	196.48	196.39	196.39	3200.0
2014-10-27 05:35:00	SPY	ETF	196.34	196.36	196.34	196.36	1500.0
2014-10-27 05:45:00	SPY	ETF	196.2	196.21	196.0	196.21	3430.0
2014-10-27 05:50:00	SPY	ETF	196.16	196.27	196.14	196.26	950.0
2014-10-27 05:55:00	SPY	ETF	196.26	196.29	196.26	196.28	1700.0
2014-10-27 06:00:00	SPY	ETF	196.19	196.19	196.03	196.11	102909.0
2014-10-27 06:05:00	SPY	ETF	196.09	196.16	196.04	196.04	15500.0
2014-10-27 06:10:00	SPY	ETF	196.08	196.08	196.03	196.08	63910.0
2014-10-27 06:15:00	SPY	ETF	196.11	196.11	195.93	196.06	85324.0
2014-10-27 06:20:00	SPY	ETF	196.11	196.11	196.03	196.03	15550.0
2014-10-27 06:25:00	SPY	ETF	196.03	196.28	196.01	196.28	16550.0
2014-10-27 06:30:00	SPY	ETF	196.21	196.22	196.19	196.19	1300.0
2014-10-27 06:35:00	SPY	ETF	196.19	196.23	196.06	196.08	13595.0
2014-10-27 06:40:00	SPY	ETF	196.11	196.14	196.06	196.14	7675.0
2014-10-27 06:45:00	SPY	ETF	196.26	196.26	196.18	196.18	4504.0
2014-10-27 06:50:00	SPY	ETF	196.21	196.21	196.04	196.05	3544.0
2014-10-27 06:55:00	SPY	ETF	196.03	196.11	196.01	196.04	20800.0
2014-10-27 07:00:00	SPY	ETF	196.09	196.11	196.03	196.11	25156.0
2014-10-27 07:05:00	SPY	ETF	196.19	196.34	196.12	196.3	51221.0
2014-10-27 07:10:00	SPY	ETF	196.34	196.34	196.24	196.29	4254.0
2014-10-27 07:15:00	SPY	ETF	196.26	196.3	196.24	196.24	12416.0
2014-10-27 07:20:00	SPY	ETF	196.32	196.32	196.18	196.24	60614.0
2014-10-27 07:25:00	SPY	ETF	196.21	196.29	196.21	196.29	9950.0
2014-10-27 07:30:00	SPY	ETF	196.21	196.21	196.12	196.14	28189.0
2014-10-27 07:35:00	SPY	ETF	196.14	196.19	196.09	196.19	18300.0
2014-10-27 07:40:00	SPY	ETF	196.16	196.3	196.15	196.28	56212.0
2014-10-27 07:45:00	SPY	ETF	196.29	196.31	196.26	196.27	70963.0
2014-10-27 07:50:00	SPY	ETF	196.23	196.23	196.15	196.17	24017.0
2014-10-27 07:55:00	SPY	ETF	196.16	196.22	196.15	196.18	37003.0
2014-10-27 08:00:00	SPY	ETF	196.18	197.02	196.06	196.11	179732.0
2014-10-27 08:05:00	SPY	ETF	196.13	196.18	196.11	196.14	61932.0
2014-10-27 08:10:00	SPY	ETF	196.14	196.28	196.14	196.24	37736.0
2014-10-27 08:15:00	SPY	ETF	196.24	196.26	196.11	196.15	38117.0
2014-10-27 08:20:00	SPY	ETF	196.18	196.2	196.15	196.16	9012.0
2014-10-27 08:25:00	SPY	ETF	196.16	196.16	196.07	196.13	63928.0
2014-10-27 08:30:00	SPY	ETF	196.12	196.15	195.9	195.92	162173.0
2014-10-27 08:35:00	SPY	ETF	195.92	195.93	195.78	195.88	104514.0
2014-10-27 08:40:00	SPY	ETF	195.87	195.87	195.74	195.85	172950.0
2014-10-27 08:45:00	SPY	ETF	195.84	195.84	195.62	195.72	361140.0
2014-10-27 08:50:00	SPY	ETF	195.71	195.79	195.67	195.68	99689.0
2014-10-27 08:55:00	SPY	ETF	195.69	195.81	195.66	195.74	148244.0
2014-10-27 09:00:00	SPY	ETF	195.75	195.75	195.6	195.64	144380.0
2014-10-27 09:05:00	SPY	ETF	195.63	195.63	195.38	195.54	226088.0
2014-10-27 09:10:00	SPY	ETF	195.56	195.59	195.5	195.53	122292.0

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

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