PREVIEW / etf_5min / 2019-10-09

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-10-09.parquet
  size:    1.4 MB
  rows:    60,801

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
2019-10-09 04:00:00	SPY	ETF	289.5	289.52	289.43	289.51	7500.0
2019-10-09 04:05:00	SPY	ETF	289.43	289.47	289.42	289.47	1310.0
2019-10-09 04:15:00	SPY	ETF	289.65	289.89	289.55	289.89	2353.0
2019-10-09 04:20:00	SPY	ETF	289.88	289.88	289.82	289.83	1050.0
2019-10-09 04:25:00	SPY	ETF	289.8	289.92	289.8	289.92	1770.0
2019-10-09 04:30:00	SPY	ETF	289.98	289.98	289.82	289.82	1125.0
2019-10-09 04:35:00	SPY	ETF	289.8	289.81	289.8	289.8	2600.0
2019-10-09 04:40:00	SPY	ETF	290.0	290.1	289.97	290.1	1890.0
2019-10-09 04:45:00	SPY	ETF	290.0	290.12	290.0	290.12	640.0
2019-10-09 04:50:00	SPY	ETF	290.12	290.12	290.0	290.07	1642.0
2019-10-09 04:55:00	SPY	ETF	290.0	290.15	290.0	290.03	1524.0
2019-10-09 05:00:00	SPY	ETF	290.0	290.0	290.0	290.0	300.0
2019-10-09 05:05:00	SPY	ETF	290.11	290.11	290.05	290.05	1000.0
2019-10-09 05:10:00	SPY	ETF	290.03	291.51	290.03	291.06	72204.0
2019-10-09 05:15:00	SPY	ETF	291.0	291.36	290.85	290.9	12621.0
2019-10-09 05:20:00	SPY	ETF	290.94	291.03	290.92	291.03	1550.0
2019-10-09 05:25:00	SPY	ETF	291.04	291.3	290.97	290.97	6950.0
2019-10-09 05:30:00	SPY	ETF	290.89	290.94	290.8	290.87	5715.0
2019-10-09 05:35:00	SPY	ETF	290.85	291.05	290.83	291.02	7885.0
2019-10-09 05:40:00	SPY	ETF	290.92	290.95	290.9	290.93	3415.0
2019-10-09 05:45:00	SPY	ETF	290.95	292.72	290.78	291.24	55176.0
2019-10-09 05:50:00	SPY	ETF	291.12	291.12	290.82	290.98	4850.0
2019-10-09 05:55:00	SPY	ETF	291.21	291.38	291.21	291.38	4382.0
2019-10-09 06:00:00	SPY	ETF	291.15	291.15	290.81	290.88	2555.0
2019-10-09 06:05:00	SPY	ETF	290.9	290.9	290.84	290.86	2375.0
2019-10-09 06:10:00	SPY	ETF	290.92	290.92	290.75	290.77	6430.0
2019-10-09 06:15:00	SPY	ETF	290.68	290.88	290.68	290.86	5400.0
2019-10-09 06:20:00	SPY	ETF	290.8	291.05	290.8	291.0	6150.0
2019-10-09 06:25:00	SPY	ETF	290.98	291.41	290.96	291.21	23800.0
2019-10-09 06:30:00	SPY	ETF	291.19	291.26	291.04	291.25	13000.0
2019-10-09 06:35:00	SPY	ETF	291.27	291.34	291.19	291.25	16340.0
2019-10-09 06:40:00	SPY	ETF	291.11	291.16	291.07	291.16	10010.0
2019-10-09 06:45:00	SPY	ETF	291.2	291.32	291.16	291.16	2960.0
2019-10-09 06:50:00	SPY	ETF	291.02	291.08	291.01	291.08	1220.0
2019-10-09 06:55:00	SPY	ETF	291.03	291.24	291.01	291.06	18334.0
2019-10-09 07:00:00	SPY	ETF	291.01	291.08	290.89	290.9	33716.0
2019-10-09 07:05:00	SPY	ETF	290.89	290.96	290.89	290.95	36522.0
2019-10-09 07:10:00	SPY	ETF	290.95	290.98	290.82	290.92	20615.0
2019-10-09 07:15:00	SPY	ETF	290.97	291.12	290.97	291.08	24177.0
2019-10-09 07:20:00	SPY	ETF	291.14	291.3	291.14	291.3	51306.0
2019-10-09 07:25:00	SPY	ETF	291.32	291.34	291.22	291.3	16701.0
2019-10-09 07:30:00	SPY	ETF	291.26	291.26	291.11	291.11	2600.0
2019-10-09 07:35:00	SPY	ETF	291.16	291.22	291.14	291.14	15578.0
2019-10-09 07:40:00	SPY	ETF	291.17	291.17	291.0	291.03	76287.0
2019-10-09 07:45:00	SPY	ETF	291.04	291.17	291.04	291.13	55933.0
2019-10-09 07:50:00	SPY	ETF	291.13	291.24	291.01	291.24	33705.0
2019-10-09 07:55:00	SPY	ETF	291.26	291.37	291.24	291.36	88899.0
2019-10-09 08:00:00	SPY	ETF	291.37	291.42	289.1	291.35	92197.0
2019-10-09 08:05:00	SPY	ETF	291.34	291.37	291.16	291.18	63218.0
2019-10-09 08:10:00	SPY	ETF	291.17	291.27	291.14	291.17	53200.0

> showing 50 of 60,801 rows — these rows as CSV

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