PREVIEW / etf_5min / 2018-04-24

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-04-24.parquet
  size:    1.4 MB
  rows:    59,648

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
2018-04-24 04:00:00	SPY	ETF	267.45	267.57	267.45	267.57	1629.0
2018-04-24 04:05:00	SPY	ETF	267.51	267.51	267.51	267.51	300.0
2018-04-24 04:10:00	SPY	ETF	267.59	267.59	267.59	267.59	123.0
2018-04-24 04:15:00	SPY	ETF	267.6	267.65	267.6	267.6	4300.0
2018-04-24 04:20:00	SPY	ETF	267.64	267.67	267.64	267.67	1675.0
2018-04-24 04:25:00	SPY	ETF	267.75	267.88	267.75	267.88	2412.0
2018-04-24 04:30:00	SPY	ETF	267.78	267.79	267.78	267.79	1150.0
2018-04-24 04:35:00	SPY	ETF	267.78	267.79	267.75	267.76	2060.0
2018-04-24 04:45:00	SPY	ETF	267.76	267.91	267.76	267.89	10450.0
2018-04-24 04:50:00	SPY	ETF	267.97	268.13	267.97	268.04	14002.0
2018-04-24 04:55:00	SPY	ETF	268.04	268.04	268.0	268.0	200.0
2018-04-24 05:00:00	SPY	ETF	268.06	268.06	268.01	268.01	750.0
2018-04-24 05:05:00	SPY	ETF	267.96	267.96	267.81	267.85	1750.0
2018-04-24 05:10:00	SPY	ETF	267.88	267.94	267.88	267.94	20400.0
2018-04-24 05:15:00	SPY	ETF	267.9	267.96	267.85	267.92	3742.0
2018-04-24 05:20:00	SPY	ETF	267.89	267.9	267.89	267.9	2250.0
2018-04-24 05:35:00	SPY	ETF	268.0	268.03	268.0	268.03	4625.0
2018-04-24 05:40:00	SPY	ETF	268.03	268.03	267.97	268.03	3450.0
2018-04-24 05:45:00	SPY	ETF	267.97	267.97	267.94	267.94	1800.0
2018-04-24 06:00:00	SPY	ETF	267.97	268.03	267.97	268.03	300.0
2018-04-24 06:10:00	SPY	ETF	267.98	268.05	267.96	267.98	6700.0
2018-04-24 06:20:00	SPY	ETF	268.02	268.23	268.02	268.2	4850.0
2018-04-24 06:25:00	SPY	ETF	268.2	268.37	268.2	268.34	9400.0
2018-04-24 06:30:00	SPY	ETF	268.32	268.32	268.27	268.32	2980.0
2018-04-24 06:35:00	SPY	ETF	268.35	268.4	268.35	268.35	9160.0
2018-04-24 06:40:00	SPY	ETF	268.32	268.32	268.24	268.3	3900.0
2018-04-24 06:45:00	SPY	ETF	268.25	268.29	268.25	268.29	5950.0
2018-04-24 06:50:00	SPY	ETF	268.21	268.3	268.21	268.28	9648.0
2018-04-24 06:55:00	SPY	ETF	268.29	268.35	268.27	268.3	7582.0
2018-04-24 07:00:00	SPY	ETF	268.29	268.32	268.22	268.25	17102.0
2018-04-24 07:05:00	SPY	ETF	268.25	268.25	268.19	268.2	8589.0
2018-04-24 07:10:00	SPY	ETF	268.18	268.2	268.14	268.18	7110.0
2018-04-24 07:15:00	SPY	ETF	268.16	268.27	268.14	268.27	9950.0
2018-04-24 07:20:00	SPY	ETF	268.22	268.22	268.14	268.16	1825.0
2018-04-24 07:25:00	SPY	ETF	268.16	268.25	268.16	268.18	14500.0
2018-04-24 07:30:00	SPY	ETF	268.16	268.34	268.13	268.23	27321.0
2018-04-24 07:35:00	SPY	ETF	268.23	268.38	268.19	268.34	28330.0
2018-04-24 07:40:00	SPY	ETF	268.37	268.45	268.37	268.37	21330.0
2018-04-24 07:45:00	SPY	ETF	268.31	268.37	268.26	268.32	5294.0
2018-04-24 07:50:00	SPY	ETF	268.29	268.32	268.26	268.26	19272.0
2018-04-24 07:55:00	SPY	ETF	268.29	268.32	268.28	268.3	16402.0
2018-04-24 08:00:00	SPY	ETF	268.29	268.39	267.23	268.3	37529.0
2018-04-24 08:05:00	SPY	ETF	268.28	268.3	268.17	268.29	24435.0
2018-04-24 08:10:00	SPY	ETF	268.29	268.34	268.2	268.26	40318.0
2018-04-24 08:15:00	SPY	ETF	268.26	268.43	268.25	268.4	40963.0
2018-04-24 08:20:00	SPY	ETF	268.4	268.44	268.35	268.39	34766.0
2018-04-24 08:25:00	SPY	ETF	268.35	268.35	268.24	268.27	29802.0
2018-04-24 08:30:00	SPY	ETF	268.27	268.27	268.15	268.19	34965.0
2018-04-24 08:35:00	SPY	ETF	268.18	268.23	268.08	268.14	54709.0
2018-04-24 08:40:00	SPY	ETF	268.12	268.13	268.05	268.09	48696.0

> showing 50 of 59,648 rows — these rows as CSV

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