PREVIEW / etf_5min / 2013-10-28

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-10-28.parquet
  size:    967 KB
  rows:    42,109

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
2013-10-28 04:00:00	SPY	ETF	175.89	176.35	175.89	176.35	11332.0
2013-10-28 04:05:00	SPY	ETF	176.26	176.31	175.79	176.31	28900.0
2013-10-28 04:10:00	SPY	ETF	176.31	176.34	176.28	176.28	1600.0
2013-10-28 04:15:00	SPY	ETF	176.3	176.3	176.3	176.3	100.0
2013-10-28 04:20:00	SPY	ETF	176.3	176.3	176.3	176.3	500.0
2013-10-28 04:25:00	SPY	ETF	176.32	176.32	176.32	176.32	500.0
2013-10-28 04:30:00	SPY	ETF	176.28	176.28	176.24	176.24	1600.0
2013-10-28 04:35:00	SPY	ETF	176.22	176.24	176.22	176.24	200.0
2013-10-28 04:40:00	SPY	ETF	176.22	176.22	176.22	176.22	300.0
2013-10-28 04:45:00	SPY	ETF	176.24	176.28	176.24	176.28	700.0
2013-10-28 04:50:00	SPY	ETF	176.26	176.26	176.24	176.24	400.0
2013-10-28 05:10:00	SPY	ETF	176.26	176.29	176.26	176.29	400.0
2013-10-28 05:15:00	SPY	ETF	176.3	176.3	176.3	176.3	100.0
2013-10-28 05:30:00	SPY	ETF	176.28	176.28	176.28	176.28	200.0
2013-10-28 05:35:00	SPY	ETF	176.27	176.27	176.27	176.27	1234.0
2013-10-28 05:45:00	SPY	ETF	176.3	176.3	176.3	176.3	200.0
2013-10-28 05:50:00	SPY	ETF	176.3	176.3	176.28	176.29	2485.0
2013-10-28 05:55:00	SPY	ETF	176.26	176.28	176.24	176.28	800.0
2013-10-28 06:00:00	SPY	ETF	176.28	176.32	176.28	176.3	2618.0
2013-10-28 06:05:00	SPY	ETF	176.32	176.32	176.32	176.32	2000.0
2013-10-28 06:10:00	SPY	ETF	176.28	176.28	176.28	176.28	200.0
2013-10-28 06:15:00	SPY	ETF	176.28	176.28	176.28	176.28	200.0
2013-10-28 06:20:00	SPY	ETF	176.27	176.27	176.27	176.27	100.0
2013-10-28 06:25:00	SPY	ETF	176.26	176.26	176.21	176.22	2700.0
2013-10-28 06:30:00	SPY	ETF	176.24	176.24	176.22	176.22	600.0
2013-10-28 06:35:00	SPY	ETF	176.22	176.22	176.13	176.14	2900.0
2013-10-28 06:40:00	SPY	ETF	176.16	176.16	176.13	176.13	48300.0
2013-10-28 06:45:00	SPY	ETF	176.13	176.13	176.09	176.11	5600.0
2013-10-28 06:50:00	SPY	ETF	176.11	176.14	176.11	176.11	36700.0
2013-10-28 06:55:00	SPY	ETF	176.11	176.12	176.09	176.09	26000.0
2013-10-28 07:00:00	SPY	ETF	176.08	176.14	176.08	176.1	16100.0
2013-10-28 07:05:00	SPY	ETF	176.11	176.12	176.08	176.08	5660.0
2013-10-28 07:10:00	SPY	ETF	176.09	176.14	176.08	176.09	6600.0
2013-10-28 07:15:00	SPY	ETF	176.09	176.09	176.06	176.06	54839.0
2013-10-28 07:20:00	SPY	ETF	176.08	176.12	176.08	176.09	3650.0
2013-10-28 07:30:00	SPY	ETF	176.1	176.1	176.01	176.02	12155.0
2013-10-28 07:35:00	SPY	ETF	176.02	176.02	175.97	176.0	75744.0
2013-10-28 07:40:00	SPY	ETF	176.0	176.02	175.98	175.99	9112.0
2013-10-28 07:45:00	SPY	ETF	176.02	176.04	175.98	176.02	2442.0
2013-10-28 07:50:00	SPY	ETF	176.04	176.06	176.01	176.05	18650.0
2013-10-28 07:55:00	SPY	ETF	176.05	176.07	176.04	176.05	7855.0
2013-10-28 08:00:00	SPY	ETF	175.93	176.06	175.93	176.02	36506.0
2013-10-28 08:05:00	SPY	ETF	175.99	176.02	175.88	175.9	86247.0
2013-10-28 08:10:00	SPY	ETF	175.9	175.9	175.74	175.74	221364.0
2013-10-28 08:15:00	SPY	ETF	175.74	175.8	175.72	175.75	38475.0
2013-10-28 08:20:00	SPY	ETF	175.75	175.76	175.67	175.74	146947.0
2013-10-28 08:25:00	SPY	ETF	175.74	175.75	175.71	175.75	12075.0
2013-10-28 08:30:00	SPY	ETF	175.74	175.81	175.73	175.81	36965.0
2013-10-28 08:35:00	SPY	ETF	175.78	175.78	175.72	175.76	11121.0
2013-10-28 08:40:00	SPY	ETF	175.76	175.8	175.72	175.79	41450.0

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

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