PREVIEW / etf_5min / 2015-06-26

all etf 5-min files

  file:    by_date/etf_5min/2015/2015-06-26.parquet
  size:    1.1 MB
  rows:    46,805

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
2015-06-26 04:00:00	SPY	ETF	209.71	209.84	209.71	209.84	300.0
2015-06-26 04:40:00	SPY	ETF	209.89	209.9	209.89	209.9	800.0
2015-06-26 05:15:00	SPY	ETF	209.88	209.91	209.88	209.91	325.0
2015-06-26 05:20:00	SPY	ETF	209.91	209.97	209.88	209.88	3280.0
2015-06-26 05:25:00	SPY	ETF	209.91	209.97	209.91	209.97	900.0
2015-06-26 05:40:00	SPY	ETF	209.85	209.85	209.85	209.85	1000.0
2015-06-26 05:45:00	SPY	ETF	209.8	209.8	209.77	209.77	880.0
2015-06-26 05:50:00	SPY	ETF	209.76	209.79	209.74	209.77	1580.0
2015-06-26 05:55:00	SPY	ETF	209.77	209.85	209.73	209.79	2711.0
2015-06-26 06:00:00	SPY	ETF	209.8	209.8	209.8	209.8	700.0
2015-06-26 06:10:00	SPY	ETF	209.77	209.81	209.77	209.8	1401.0
2015-06-26 06:15:00	SPY	ETF	209.77	209.77	209.77	209.77	100.0
2015-06-26 06:25:00	SPY	ETF	209.87	209.87	209.87	209.87	301.0
2015-06-26 06:30:00	SPY	ETF	209.89	209.89	209.86	209.86	1200.0
2015-06-26 06:35:00	SPY	ETF	209.97	209.99	209.97	209.99	1700.0
2015-06-26 06:50:00	SPY	ETF	210.02	210.17	210.02	210.17	13520.0
2015-06-26 06:55:00	SPY	ETF	210.16	210.24	210.12	210.24	2735.0
2015-06-26 07:00:00	SPY	ETF	210.2	210.2	210.08	210.12	6367.0
2015-06-26 07:05:00	SPY	ETF	210.14	210.22	210.14	210.21	4985.0
2015-06-26 07:10:00	SPY	ETF	210.13	210.29	210.13	210.25	10800.0
2015-06-26 07:15:00	SPY	ETF	210.28	210.3	210.28	210.29	13106.0
2015-06-26 07:20:00	SPY	ETF	210.36	210.37	210.29	210.33	14350.0
2015-06-26 07:25:00	SPY	ETF	210.33	210.34	210.28	210.33	6705.0
2015-06-26 07:30:00	SPY	ETF	210.3	210.43	210.3	210.39	39898.0
2015-06-26 07:35:00	SPY	ETF	210.38	210.41	210.38	210.41	27800.0
2015-06-26 07:40:00	SPY	ETF	210.42	210.42	210.33	210.33	34700.0
2015-06-26 07:45:00	SPY	ETF	210.34	210.34	210.26	210.32	4760.0
2015-06-26 07:50:00	SPY	ETF	210.31	210.32	210.28	210.29	20770.0
2015-06-26 07:55:00	SPY	ETF	210.29	210.36	210.29	210.36	43165.0
2015-06-26 08:00:00	SPY	ETF	210.34	210.36	209.75	209.75	66677.0
2015-06-26 08:05:00	SPY	ETF	210.28	210.28	210.24	210.26	16230.0
2015-06-26 08:10:00	SPY	ETF	210.27	210.3	210.15	210.17	25920.0
2015-06-26 08:15:00	SPY	ETF	210.18	210.18	210.1	210.14	130039.0
2015-06-26 08:20:00	SPY	ETF	210.13	210.14	210.05	210.07	65235.0
2015-06-26 08:25:00	SPY	ETF	210.07	210.13	210.03	210.09	41616.0
2015-06-26 08:30:00	SPY	ETF	210.07	210.12	210.05	210.11	27557.0
2015-06-26 08:35:00	SPY	ETF	210.12	210.19	210.12	210.17	32583.0
2015-06-26 08:40:00	SPY	ETF	210.17	210.17	210.08	210.08	85300.0
2015-06-26 08:45:00	SPY	ETF	210.13	210.18	210.12	210.14	87415.0
2015-06-26 08:50:00	SPY	ETF	210.12	210.15	210.11	210.15	36240.0
2015-06-26 08:55:00	SPY	ETF	210.18	210.33	210.18	210.3	334417.0
2015-06-26 09:00:00	SPY	ETF	210.29	210.3	210.2	210.24	93571.0
2015-06-26 09:05:00	SPY	ETF	210.25	210.31	210.2	210.29	93194.0
2015-06-26 09:10:00	SPY	ETF	210.27	210.36	210.2	210.27	143720.0
2015-06-26 09:15:00	SPY	ETF	210.27	210.36	210.26	210.28	49984.0
2015-06-26 09:20:00	SPY	ETF	210.32	210.33	210.25	210.3	79472.0
2015-06-26 09:25:00	SPY	ETF	210.29	210.3	210.17	210.28	127254.0
2015-06-26 09:30:00	SPY	ETF	210.29	210.31	209.96	210.02	2305660.0
2015-06-26 09:35:00	SPY	ETF	210.01	210.02	209.73	209.82	1742934.0
2015-06-26 09:40:00	SPY	ETF	209.815	210.1	209.64	210.0775	2214434.0

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

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