PREVIEW / etf_5min / 2019-06-24

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-06-24.parquet
  size:    1.4 MB
  rows:    61,372

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-24 04:00:00	SPY	ETF	294.3	294.38	294.3	294.32	22701.0
2019-06-24 04:05:00	SPY	ETF	294.32	294.38	294.22	294.38	2455.0
2019-06-24 04:10:00	SPY	ETF	294.26	294.31	294.26	294.31	3130.0
2019-06-24 04:15:00	SPY	ETF	294.25	294.35	294.24	294.33	5520.0
2019-06-24 04:20:00	SPY	ETF	294.25	294.35	294.25	294.32	1545.0
2019-06-24 04:25:00	SPY	ETF	294.27	294.38	294.27	294.38	2776.0
2019-06-24 04:30:00	SPY	ETF	294.38	294.38	294.35	294.35	2100.0
2019-06-24 04:35:00	SPY	ETF	294.31	294.31	294.31	294.31	297.0
2019-06-24 04:40:00	SPY	ETF	294.3	294.3	294.27	294.3	600.0
2019-06-24 04:55:00	SPY	ETF	294.35	294.35	294.35	294.35	510.0
2019-06-24 05:00:00	SPY	ETF	294.29	294.3	294.29	294.3	695.0
2019-06-24 05:10:00	SPY	ETF	294.33	294.33	294.33	294.33	850.0
2019-06-24 05:15:00	SPY	ETF	294.3	294.3	294.27	294.29	1600.0
2019-06-24 05:20:00	SPY	ETF	294.32	294.38	294.32	294.38	5600.0
2019-06-24 05:25:00	SPY	ETF	294.32	294.36	294.32	294.36	500.0
2019-06-24 05:30:00	SPY	ETF	294.24	294.24	294.24	294.24	100.0
2019-06-24 05:45:00	SPY	ETF	294.27	294.3	294.27	294.3	1100.0
2019-06-24 05:50:00	SPY	ETF	294.25	294.25	294.24	294.24	2500.0
2019-06-24 05:55:00	SPY	ETF	294.28	294.28	294.26	294.28	1000.0
2019-06-24 06:00:00	SPY	ETF	294.33	294.53	294.33	294.5	12705.0
2019-06-24 06:05:00	SPY	ETF	294.46	294.46	294.43	294.44	2500.0
2019-06-24 06:10:00	SPY	ETF	294.44	294.48	294.42	294.48	1545.0
2019-06-24 06:15:00	SPY	ETF	294.48	294.49	294.48	294.49	600.0
2019-06-24 06:20:00	SPY	ETF	294.46	294.46	294.46	294.46	500.0
2019-06-24 06:25:00	SPY	ETF	294.39	294.42	294.39	294.42	1100.0
2019-06-24 06:30:00	SPY	ETF	294.44	294.44	294.44	294.44	300.0
2019-06-24 06:35:00	SPY	ETF	294.42	294.42	294.36	294.41	2769.0
2019-06-24 06:40:00	SPY	ETF	294.38	294.38	294.38	294.38	400.0
2019-06-24 06:45:00	SPY	ETF	294.36	294.36	294.24	294.29	3448.0
2019-06-24 06:50:00	SPY	ETF	294.29	294.39	294.29	294.3	10100.0
2019-06-24 06:55:00	SPY	ETF	294.31	294.31	294.24	294.24	3500.0
2019-06-24 07:00:00	SPY	ETF	294.24	294.29	294.13	294.16	22675.0
2019-06-24 07:05:00	SPY	ETF	294.11	294.14	294.07	294.07	8800.0
2019-06-24 07:10:00	SPY	ETF	294.11	294.17	294.07	294.14	1175.0
2019-06-24 07:15:00	SPY	ETF	294.12	294.18	294.11	294.17	28496.0
2019-06-24 07:20:00	SPY	ETF	294.15	294.21	294.15	294.21	4488.0
2019-06-24 07:25:00	SPY	ETF	294.19	294.21	294.15	294.19	28199.0
2019-06-24 07:30:00	SPY	ETF	294.2	294.21	294.16	294.21	1535.0
2019-06-24 07:35:00	SPY	ETF	294.18	294.25	294.17	294.25	15121.0
2019-06-24 07:40:00	SPY	ETF	294.16	294.25	294.16	294.2	3000.0
2019-06-24 07:45:00	SPY	ETF	294.2	294.27	294.2	294.27	4750.0
2019-06-24 07:50:00	SPY	ETF	294.27	294.29	294.24	294.24	3120.0
2019-06-24 07:55:00	SPY	ETF	294.24	294.29	294.23	294.27	4320.0
2019-06-24 08:00:00	SPY	ETF	294.07	294.67	294.07	294.32	16401.0
2019-06-24 08:05:00	SPY	ETF	294.3	294.32	294.27	294.3001	5434.0
2019-06-24 08:10:00	SPY	ETF	294.3	294.33	294.27	294.31	10520.0
2019-06-24 08:15:00	SPY	ETF	294.31	294.31	294.27	294.29	14619.0
2019-06-24 08:20:00	SPY	ETF	294.29	294.29	294.13	294.16	10332.0
2019-06-24 08:25:00	SPY	ETF	294.17	294.18	294.12	294.18	9685.0
2019-06-24 08:30:00	SPY	ETF	294.16	294.3	294.15	294.26	22807.0

> showing 50 of 61,372 rows — these rows as CSV

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