PREVIEW / etf_5min / 2018-10-19

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-10-19.parquet
  size:    1.4 MB
  rows:    59,378

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-10-19 04:00:00	SPY	ETF	276.96	276.96	276.86	276.9	1209.0
2018-10-19 04:05:00	SPY	ETF	276.84	276.89	276.8	276.85	2300.0
2018-10-19 04:10:00	SPY	ETF	276.95	276.95	276.95	276.95	1200.0
2018-10-19 04:15:00	SPY	ETF	276.85	276.85	276.64	276.64	2183.0
2018-10-19 04:20:00	SPY	ETF	276.58	276.65	276.58	276.65	1000.0
2018-10-19 04:25:00	SPY	ETF	276.62	276.72	276.58	276.58	4725.0
2018-10-19 04:30:00	SPY	ETF	276.55	276.55	276.55	276.55	2235.0
2018-10-19 04:35:00	SPY	ETF	276.7	276.75	276.69	276.75	9905.0
2018-10-19 04:40:00	SPY	ETF	276.75	276.76	276.75	276.76	1910.0
2018-10-19 04:45:00	SPY	ETF	276.8	276.8	276.79	276.79	2000.0
2018-10-19 04:50:00	SPY	ETF	276.83	276.91	276.71	276.91	5502.0
2018-10-19 04:55:00	SPY	ETF	276.94	277.04	276.9	276.9	16130.0
2018-10-19 05:00:00	SPY	ETF	276.96	276.96	276.92	276.95	3300.0
2018-10-19 05:05:00	SPY	ETF	277.0	277.05	277.0	277.0	3100.0
2018-10-19 05:10:00	SPY	ETF	276.95	276.95	276.9	276.9	5000.0
2018-10-19 05:15:00	SPY	ETF	276.85	276.95	276.85	276.95	1554.0
2018-10-19 05:20:00	SPY	ETF	276.93	276.93	276.85	276.85	4000.0
2018-10-19 05:25:00	SPY	ETF	276.85	276.95	276.83	276.95	5100.0
2018-10-19 05:30:00	SPY	ETF	276.96	277.17	276.96	277.17	9121.0
2018-10-19 05:35:00	SPY	ETF	277.1	277.12	277.04	277.04	5600.0
2018-10-19 05:40:00	SPY	ETF	277.15	277.2	277.05	277.05	13600.0
2018-10-19 05:45:00	SPY	ETF	277.07	277.07	276.8	276.8	12860.0
2018-10-19 05:50:00	SPY	ETF	276.77	276.77	276.7	276.72	8500.0
2018-10-19 05:55:00	SPY	ETF	276.77	276.77	276.72	276.74	3000.0
2018-10-19 06:00:00	SPY	ETF	276.76	276.79	276.64	276.79	4650.0
2018-10-19 06:05:00	SPY	ETF	276.77	276.8	276.74	276.74	1500.0
2018-10-19 06:10:00	SPY	ETF	276.68	276.8	276.67	276.8	1966.0
2018-10-19 06:15:00	SPY	ETF	276.85	276.95	276.85	276.95	3200.0
2018-10-19 06:20:00	SPY	ETF	276.99	277.11	276.96	277.11	8400.0
2018-10-19 06:25:00	SPY	ETF	277.15	277.2	277.08	277.2	5250.0
2018-10-19 06:30:00	SPY	ETF	277.19	277.29	277.19	277.24	15210.0
2018-10-19 06:35:00	SPY	ETF	277.26	277.27	277.06	277.06	6900.0
2018-10-19 06:40:00	SPY	ETF	277.05	277.1	277.05	277.1	3120.0
2018-10-19 06:45:00	SPY	ETF	277.15	277.25	277.15	277.2	4500.0
2018-10-19 06:50:00	SPY	ETF	277.15	277.15	277.0	277.0	6225.0
2018-10-19 06:55:00	SPY	ETF	276.94	277.02	276.87	276.92	3600.0
2018-10-19 07:00:00	SPY	ETF	276.89	277.15	276.89	277.15	18886.0
2018-10-19 07:05:00	SPY	ETF	277.19	277.33	277.17	277.32	31959.0
2018-10-19 07:10:00	SPY	ETF	277.34	277.46	277.3	277.46	61018.0
2018-10-19 07:15:00	SPY	ETF	277.43	277.5	277.4	277.48	175300.0
2018-10-19 07:20:00	SPY	ETF	277.53	277.62	277.49	277.53	88338.0
2018-10-19 07:25:00	SPY	ETF	277.56	277.71	277.55	277.66	109169.0
2018-10-19 07:30:00	SPY	ETF	277.65	277.65	277.53	277.53	57080.0
2018-10-19 07:35:00	SPY	ETF	277.52	277.6	277.45	277.45	30675.0
2018-10-19 07:40:00	SPY	ETF	277.5	277.64	277.5	277.62	42007.0
2018-10-19 07:45:00	SPY	ETF	277.63	277.72	277.62	277.63	43420.0
2018-10-19 07:50:00	SPY	ETF	277.61	277.7	277.6	277.62	42190.0
2018-10-19 07:55:00	SPY	ETF	277.6	277.64	277.5	277.55	30347.0
2018-10-19 08:00:00	SPY	ETF	277.55	277.8	276.92	277.63	60766.0
2018-10-19 08:05:00	SPY	ETF	277.6	277.65	277.57	277.57	22383.0

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

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