PREVIEW / etf_5min / 2019-06-26

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-06-26.parquet
  size:    1.4 MB
  rows:    62,196

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-06-26 04:05:00	SPY	ETF	291.11	291.11	291.11	291.11	400.0
2019-06-26 04:15:00	SPY	ETF	291.03	291.05	290.99	290.99	505.0
2019-06-26 04:20:00	SPY	ETF	290.97	291.0	290.97	291.0	600.0
2019-06-26 04:25:00	SPY	ETF	290.97	290.97	290.97	290.97	100.0
2019-06-26 04:30:00	SPY	ETF	291.01	291.07	291.0	291.07	970.0
2019-06-26 04:35:00	SPY	ETF	291.11	291.11	291.11	291.11	400.0
2019-06-26 04:40:00	SPY	ETF	291.32	291.32	291.32	291.32	800.0
2019-06-26 04:45:00	SPY	ETF	291.27	291.27	291.22	291.25	1100.0
2019-06-26 04:50:00	SPY	ETF	291.29	291.31	291.27	291.27	2419.0
2019-06-26 04:55:00	SPY	ETF	291.27	291.29	291.27	291.29	400.0
2019-06-26 05:00:00	SPY	ETF	291.33	291.33	291.33	291.33	804.0
2019-06-26 05:05:00	SPY	ETF	291.47	291.74	291.47	291.73	4796.0
2019-06-26 05:10:00	SPY	ETF	291.79	292.24	291.79	292.24	5242.0
2019-06-26 05:15:00	SPY	ETF	292.27	292.27	292.09	292.09	6530.0
2019-06-26 05:20:00	SPY	ETF	292.1	292.29	292.09	292.22	2379.0
2019-06-26 05:25:00	SPY	ETF	292.44	292.47	292.39	292.44	22500.0
2019-06-26 05:30:00	SPY	ETF	292.39	292.39	292.2	292.2	3909.0
2019-06-26 05:35:00	SPY	ETF	292.24	292.32	292.22	292.22	5363.0
2019-06-26 05:40:00	SPY	ETF	292.26	292.31	292.15	292.31	6665.0
2019-06-26 05:45:00	SPY	ETF	292.35	292.4	292.25	292.27	25601.0
2019-06-26 05:50:00	SPY	ETF	292.28	292.35	292.27	292.35	6910.0
2019-06-26 05:55:00	SPY	ETF	292.35	292.35	292.2	292.24	3788.0
2019-06-26 06:00:00	SPY	ETF	292.24	292.25	292.24	292.25	1200.0
2019-06-26 06:05:00	SPY	ETF	292.3	292.32	292.3	292.32	2100.0
2019-06-26 06:10:00	SPY	ETF	292.32	292.32	292.31	292.32	1969.0
2019-06-26 06:15:00	SPY	ETF	292.32	292.43	292.32	292.43	3069.0
2019-06-26 06:20:00	SPY	ETF	292.5	292.5	292.45	292.48	911.0
2019-06-26 06:25:00	SPY	ETF	292.43	292.43	292.39	292.39	1169.0
2019-06-26 06:30:00	SPY	ETF	292.35	292.4	292.32	292.32	2480.0
2019-06-26 06:35:00	SPY	ETF	292.32	292.35	292.24	292.32	5835.0
2019-06-26 06:40:00	SPY	ETF	292.27	292.27	292.04	292.2	7004.0
2019-06-26 06:45:00	SPY	ETF	292.12	292.21	292.05	292.21	52645.0
2019-06-26 06:50:00	SPY	ETF	292.16	292.21	292.13	292.16	10557.0
2019-06-26 06:55:00	SPY	ETF	292.21	292.23	292.08	292.08	8650.0
2019-06-26 07:00:00	SPY	ETF	292.08	292.18	292.02	292.18	15805.0
2019-06-26 07:05:00	SPY	ETF	292.16	292.2	292.05	292.08	22062.0
2019-06-26 07:10:00	SPY	ETF	292.08	292.15	292.08	292.12	36225.0
2019-06-26 07:15:00	SPY	ETF	292.12	292.12	291.99	292.0	30172.0
2019-06-26 07:20:00	SPY	ETF	291.98	292.0	291.97	291.98	34304.0
2019-06-26 07:25:00	SPY	ETF	292.0	292.07	292.0	292.06	29950.0
2019-06-26 07:30:00	SPY	ETF	292.07	292.1	292.02	292.04	18301.0
2019-06-26 07:35:00	SPY	ETF	292.01	292.05	291.97	292.0	8674.0
2019-06-26 07:40:00	SPY	ETF	291.99	292.07	291.99	292.05	14373.0
2019-06-26 07:45:00	SPY	ETF	292.04	292.18	292.0	292.17	49936.0
2019-06-26 07:50:00	SPY	ETF	292.18	292.18	292.11	292.11	14316.0
2019-06-26 07:55:00	SPY	ETF	292.09	292.15	292.07	292.07	7630.0
2019-06-26 08:00:00	SPY	ETF	292.11	292.18	290.96	292.04	68762.0
2019-06-26 08:05:00	SPY	ETF	292.03	292.14	292.02	292.03	48368.0
2019-06-26 08:10:00	SPY	ETF	292.05	292.11	292.03	292.1	31103.0
2019-06-26 08:15:00	SPY	ETF	292.08	292.15	292.07	292.09	58848.0

> showing 50 of 62,196 rows — these rows as CSV

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