PREVIEW / etf_5min / 2019-08-02

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-08-02.parquet
  size:    1.5 MB
  rows:    65,851

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-08-02 04:00:00	SPY	ETF	293.26	293.48	293.26	293.48	2135.0
2019-08-02 04:05:00	SPY	ETF	293.61	293.63	293.48	293.63	1032.0
2019-08-02 04:10:00	SPY	ETF	293.56	293.63	293.52	293.52	1295.0
2019-08-02 04:15:00	SPY	ETF	293.3	293.33	293.3	293.33	364.0
2019-08-02 04:20:00	SPY	ETF	293.3	293.3	293.3	293.3	164.0
2019-08-02 04:25:00	SPY	ETF	293.31	293.31	293.31	293.31	100.0
2019-08-02 04:35:00	SPY	ETF	293.5	293.5	293.42	293.42	1700.0
2019-08-02 04:40:00	SPY	ETF	293.42	293.42	293.42	293.42	200.0
2019-08-02 04:50:00	SPY	ETF	293.54	293.54	293.1	293.29	2208.0
2019-08-02 04:55:00	SPY	ETF	293.24	293.39	293.24	293.34	444.0
2019-08-02 05:00:00	SPY	ETF	293.39	293.39	293.39	293.39	205.0
2019-08-02 05:05:00	SPY	ETF	293.35	293.37	293.35	293.37	1676.0
2019-08-02 05:10:00	SPY	ETF	293.22	293.22	293.14	293.14	1354.0
2019-08-02 05:15:00	SPY	ETF	293.05	293.17	292.99	293.17	2363.0
2019-08-02 05:20:00	SPY	ETF	293.29	293.29	293.29	293.29	100.0
2019-08-02 05:25:00	SPY	ETF	293.44	293.5	293.44	293.5	1350.0
2019-08-02 05:30:00	SPY	ETF	293.5	293.6	293.49	293.6	934.0
2019-08-02 05:35:00	SPY	ETF	293.6	293.6	293.6	293.6	435.0
2019-08-02 05:40:00	SPY	ETF	293.52	293.57	293.52	293.57	2400.0
2019-08-02 05:45:00	SPY	ETF	293.6	293.6	293.57	293.57	500.0
2019-08-02 05:55:00	SPY	ETF	293.39	293.49	293.39	293.49	4310.0
2019-08-02 06:00:00	SPY	ETF	293.52	293.6	293.52	293.6	3210.0
2019-08-02 06:05:00	SPY	ETF	293.91	293.91	293.91	293.91	817.0
2019-08-02 06:10:00	SPY	ETF	293.82	293.87	293.79	293.87	2055.0
2019-08-02 06:15:00	SPY	ETF	293.82	294.02	293.82	294.02	1443.0
2019-08-02 06:20:00	SPY	ETF	294.07	294.07	293.99	294.02	1717.0
2019-08-02 06:25:00	SPY	ETF	294.06	294.09	293.96	293.96	27250.0
2019-08-02 06:30:00	SPY	ETF	293.96	294.08	293.83	294.08	651.0
2019-08-02 06:35:00	SPY	ETF	294.08	294.19	293.96	293.96	6452.0
2019-08-02 06:40:00	SPY	ETF	293.98	294.01	293.8	293.8	9369.0
2019-08-02 06:45:00	SPY	ETF	293.8	293.87	293.74	293.74	2946.0
2019-08-02 06:50:00	SPY	ETF	293.82	294.07	293.82	294.07	1450.0
2019-08-02 06:55:00	SPY	ETF	294.12	294.19	293.96	293.96	6771.0
2019-08-02 07:00:00	SPY	ETF	294.0	294.0	293.72	293.74	8296.0
2019-08-02 07:05:00	SPY	ETF	293.7	293.74	293.6	293.72	25878.0
2019-08-02 07:10:00	SPY	ETF	293.69	293.76	293.69	293.76	14543.0
2019-08-02 07:15:00	SPY	ETF	293.74	293.82	293.74	293.79	4330.0
2019-08-02 07:20:00	SPY	ETF	293.74	293.75	293.66	293.72	3464.0
2019-08-02 07:25:00	SPY	ETF	293.62	293.69	293.62	293.69	514.0
2019-08-02 07:30:00	SPY	ETF	293.69	293.69	293.54	293.66	49117.0
2019-08-02 07:35:00	SPY	ETF	293.69	293.73	293.66	293.7	14641.0
2019-08-02 07:40:00	SPY	ETF	293.72	293.79	293.67	293.73	82945.0
2019-08-02 07:45:00	SPY	ETF	293.76	293.85	293.75	293.78	40690.0
2019-08-02 07:50:00	SPY	ETF	293.77	293.78	293.58	293.66	72736.0
2019-08-02 07:55:00	SPY	ETF	293.63	293.68	293.57	293.68	65400.0
2019-08-02 08:00:00	SPY	ETF	294.525	294.84	293.2	293.6	360581.0
2019-08-02 08:05:00	SPY	ETF	293.6599	293.69	293.57	293.58	41903.0
2019-08-02 08:10:00	SPY	ETF	293.57	293.69	293.57	293.69	10642.0
2019-08-02 08:15:00	SPY	ETF	293.75	293.88	293.67	293.84	84827.0
2019-08-02 08:20:00	SPY	ETF	293.85	293.85	293.75	293.84	72507.0

> showing 50 of 65,851 rows — these rows as CSV

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