PREVIEW / etf_5min / 2018-08-29

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-08-29.parquet
  size:    1.4 MB
  rows:    57,443

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-08-29 04:05:00	SPY	ETF	290.15	290.22	290.15	290.22	1369.0
2018-08-29 04:10:00	SPY	ETF	290.21	290.21	290.21	290.21	400.0
2018-08-29 04:15:00	SPY	ETF	290.22	290.22	290.22	290.22	300.0
2018-08-29 04:20:00	SPY	ETF	290.25	290.25	290.25	290.25	1202.0
2018-08-29 04:25:00	SPY	ETF	290.22	290.22	290.2	290.2	500.0
2018-08-29 04:35:00	SPY	ETF	290.22	290.22	290.22	290.22	400.0
2018-08-29 04:50:00	SPY	ETF	290.17	290.17	290.17	290.17	300.0
2018-08-29 05:00:00	SPY	ETF	290.1	290.15	290.1	290.15	1100.0
2018-08-29 05:05:00	SPY	ETF	290.15	290.15	290.15	290.15	1100.0
2018-08-29 05:15:00	SPY	ETF	290.15	290.17	290.15	290.17	1100.0
2018-08-29 05:20:00	SPY	ETF	290.22	290.26	290.22	290.22	3200.0
2018-08-29 05:25:00	SPY	ETF	290.2	290.2	290.2	290.2	800.0
2018-08-29 05:30:00	SPY	ETF	290.1	290.1	290.1	290.1	100.0
2018-08-29 05:35:00	SPY	ETF	290.07	290.07	290.02	290.02	3707.0
2018-08-29 05:40:00	SPY	ETF	289.94	289.97	289.94	289.94	2600.0
2018-08-29 05:45:00	SPY	ETF	289.97	290.02	289.97	290.02	2400.0
2018-08-29 05:50:00	SPY	ETF	290.02	290.02	290.02	290.02	1100.0
2018-08-29 06:00:00	SPY	ETF	290.02	290.02	289.96	289.96	5700.0
2018-08-29 06:05:00	SPY	ETF	290.02	290.02	289.96	289.96	1100.0
2018-08-29 06:15:00	SPY	ETF	290.03	290.03	290.01	290.01	1300.0
2018-08-29 06:20:00	SPY	ETF	290.01	290.01	289.92	289.92	3652.0
2018-08-29 06:30:00	SPY	ETF	289.96	289.96	289.96	289.96	600.0
2018-08-29 06:35:00	SPY	ETF	290.0	290.0	289.97	289.97	700.0
2018-08-29 06:45:00	SPY	ETF	289.93	289.93	289.93	289.93	1000.0
2018-08-29 06:50:00	SPY	ETF	289.93	289.93	289.89	289.89	1600.0
2018-08-29 06:55:00	SPY	ETF	289.9	289.9	289.9	289.9	400.0
2018-08-29 07:00:00	SPY	ETF	289.94	289.98	289.94	289.98	6303.0
2018-08-29 07:05:00	SPY	ETF	289.98	289.98	289.91	289.91	9650.0
2018-08-29 07:10:00	SPY	ETF	289.95	290.05	289.95	290.05	4691.0
2018-08-29 07:15:00	SPY	ETF	290.09	290.12	290.07	290.07	1140.0
2018-08-29 07:20:00	SPY	ETF	290.07	290.07	290.07	290.07	2430.0
2018-08-29 07:25:00	SPY	ETF	290.05	290.05	290.05	290.05	350.0
2018-08-29 07:30:00	SPY	ETF	290.12	290.12	290.09	290.09	1680.0
2018-08-29 07:35:00	SPY	ETF	290.1	290.1	290.1	290.1	1100.0
2018-08-29 07:40:00	SPY	ETF	290.12	290.12	290.08	290.12	2084.0
2018-08-29 07:45:00	SPY	ETF	290.14	290.14	290.14	290.14	344.0
2018-08-29 07:50:00	SPY	ETF	290.12	290.15	290.12	290.15	1780.0
2018-08-29 07:55:00	SPY	ETF	290.15	290.18	290.15	290.17	600.0
2018-08-29 08:00:00	SPY	ETF	290.0699	290.44	289.95	290.08	10869.0
2018-08-29 08:05:00	SPY	ETF	290.06	290.11	290.06	290.11	3084.0
2018-08-29 08:10:00	SPY	ETF	290.12	290.16	290.11	290.11	10055.0
2018-08-29 08:15:00	SPY	ETF	290.1	290.1	290.04	290.04	4602.0
2018-08-29 08:20:00	SPY	ETF	290.1	290.1	289.96	289.96	3351.0
2018-08-29 08:25:00	SPY	ETF	289.93	289.93	289.81	289.84	19542.0
2018-08-29 08:30:00	SPY	ETF	289.91	289.92	289.8	289.89	41289.0
2018-08-29 08:35:00	SPY	ETF	289.87	289.87	289.72	289.8001	27743.0
2018-08-29 08:40:00	SPY	ETF	289.81	289.87	289.81	289.85	20248.0
2018-08-29 08:45:00	SPY	ETF	289.87	289.92	289.87	289.9	22604.0
2018-08-29 08:50:00	SPY	ETF	289.91	289.92	289.83	289.88	17410.0
2018-08-29 08:55:00	SPY	ETF	289.87	289.9	289.81	289.9	32778.0

> showing 50 of 57,443 rows — these rows as CSV

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