PREVIEW / etf_5min / 2017-08-23

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-08-23.parquet
  size:    1.2 MB
  rows:    50,446

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
2017-08-23 04:00:00	SPY	ETF	245.21	245.21	244.8	245.11	1450.0
2017-08-23 04:05:00	SPY	ETF	245.08	245.08	245.06	245.07	1260.0
2017-08-23 04:10:00	SPY	ETF	245.09	245.09	245.02	245.04	1860.0
2017-08-23 04:15:00	SPY	ETF	245.09	245.09	245.02	245.07	2503.0
2017-08-23 04:20:00	SPY	ETF	245.04	245.07	245.04	245.07	2000.0
2017-08-23 04:25:00	SPY	ETF	245.1	245.1	245.07	245.07	900.0
2017-08-23 04:30:00	SPY	ETF	245.02	245.02	245.02	245.02	300.0
2017-08-23 04:35:00	SPY	ETF	244.99	244.99	244.99	244.99	650.0
2017-08-23 04:40:00	SPY	ETF	245.02	245.02	245.02	245.02	300.0
2017-08-23 04:50:00	SPY	ETF	244.99	244.99	244.99	244.99	1000.0
2017-08-23 05:00:00	SPY	ETF	245.03	245.03	245.02	245.02	300.0
2017-08-23 05:05:00	SPY	ETF	244.99	244.99	244.99	244.99	600.0
2017-08-23 05:15:00	SPY	ETF	244.99	244.99	244.97	244.99	6600.0
2017-08-23 05:20:00	SPY	ETF	245.0	245.01	244.99	244.99	1100.0
2017-08-23 05:25:00	SPY	ETF	245.0	245.0	244.97	244.97	1300.0
2017-08-23 05:30:00	SPY	ETF	244.99	245.04	244.99	244.99	3200.0
2017-08-23 05:35:00	SPY	ETF	244.99	245.0	244.99	244.99	1100.0
2017-08-23 05:40:00	SPY	ETF	245.05	245.05	245.05	245.05	500.0
2017-08-23 05:45:00	SPY	ETF	244.99	245.02	244.99	245.02	1500.0
2017-08-23 05:50:00	SPY	ETF	244.99	245.0	244.97	244.97	1000.0
2017-08-23 05:55:00	SPY	ETF	244.98	244.98	244.98	244.98	2900.0
2017-08-23 06:00:00	SPY	ETF	244.95	244.95	244.94	244.94	22142.0
2017-08-23 06:05:00	SPY	ETF	244.85	244.85	244.84	244.84	260.0
2017-08-23 06:10:00	SPY	ETF	244.84	244.86	244.84	244.86	1480.0
2017-08-23 06:15:00	SPY	ETF	244.88	244.88	244.88	244.88	800.0
2017-08-23 06:20:00	SPY	ETF	244.85	244.86	244.85	244.86	200.0
2017-08-23 06:25:00	SPY	ETF	244.86	244.9	244.86	244.88	3000.0
2017-08-23 06:30:00	SPY	ETF	244.9	244.9	244.84	244.84	7150.0
2017-08-23 06:35:00	SPY	ETF	244.85	244.85	244.82	244.82	1900.0
2017-08-23 06:40:00	SPY	ETF	244.85	244.85	244.84	244.85	600.0
2017-08-23 06:45:00	SPY	ETF	244.84	244.85	244.82	244.85	4490.0
2017-08-23 06:50:00	SPY	ETF	244.88	244.95	244.88	244.95	780.0
2017-08-23 06:55:00	SPY	ETF	244.93	244.98	244.92	244.98	4540.0
2017-08-23 07:00:00	SPY	ETF	245.0	245.0	244.98	244.98	5000.0
2017-08-23 07:05:00	SPY	ETF	245.03	245.05	245.02	245.02	2414.0
2017-08-23 07:10:00	SPY	ETF	245.05	245.05	245.03	245.03	14200.0
2017-08-23 07:15:00	SPY	ETF	245.02	245.03	244.97	244.99	18758.0
2017-08-23 07:20:00	SPY	ETF	245.03	245.03	245.0	245.0	8900.0
2017-08-23 07:25:00	SPY	ETF	244.99	245.0	244.99	244.99	4050.0
2017-08-23 07:30:00	SPY	ETF	245.0	245.0	244.92	244.92	29390.0
2017-08-23 07:35:00	SPY	ETF	244.93	244.93	244.79	244.82	79650.0
2017-08-23 07:40:00	SPY	ETF	244.82	244.82	244.72	244.72	33810.0
2017-08-23 07:45:00	SPY	ETF	244.73	244.75	244.58	244.62	91790.0
2017-08-23 07:50:00	SPY	ETF	244.64	244.68	244.63	244.68	20504.0
2017-08-23 07:55:00	SPY	ETF	244.69	244.75	244.69	244.71	11220.0
2017-08-23 08:00:00	SPY	ETF	244.7	245.3745	244.67	244.72	39795.0
2017-08-23 08:05:00	SPY	ETF	244.73	244.73	244.68	244.72	27900.0
2017-08-23 08:10:00	SPY	ETF	244.72	244.72	244.68	244.68	8968.0
2017-08-23 08:15:00	SPY	ETF	244.68	244.78	244.68	244.75	25146.0
2017-08-23 08:20:00	SPY	ETF	244.75	244.78	244.66	244.72	67223.0

> showing 50 of 50,446 rows — these rows as CSV

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