PREVIEW / etf_5min / 2020-03-02

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-03-02.parquet
  size:    2.0 MB
  rows:    87,282

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
2020-03-02 04:00:00	SPY	ETF	300.2	300.2	299.1	300.0	26476.0
2020-03-02 04:05:00	SPY	ETF	300.04	300.48	299.99	300.0	18716.0
2020-03-02 04:10:00	SPY	ETF	300.11	300.38	299.44	299.69	16707.0
2020-03-02 04:15:00	SPY	ETF	299.4	299.45	298.62	299.36	24393.0
2020-03-02 04:20:00	SPY	ETF	299.5	300.57	299.5	300.48	17736.0
2020-03-02 04:25:00	SPY	ETF	300.37	300.37	299.65	299.77	10856.0
2020-03-02 04:30:00	SPY	ETF	300.04	300.12	298.95	298.95	17620.0
2020-03-02 04:35:00	SPY	ETF	298.75	298.86	298.03	298.03	9821.0
2020-03-02 04:40:00	SPY	ETF	298.25	298.25	296.5	296.5	34921.0
2020-03-02 04:45:00	SPY	ETF	296.45	297.62	296.22	297.38	22591.0
2020-03-02 04:50:00	SPY	ETF	297.38	297.46	296.6	296.6	12452.0
2020-03-02 04:55:00	SPY	ETF	296.66	297.33	296.46	297.24	26037.0
2020-03-02 05:00:00	SPY	ETF	297.51	297.51	296.86	296.86	7740.0
2020-03-02 05:05:00	SPY	ETF	296.84	297.16	296.7	296.83	20272.0
2020-03-02 05:10:00	SPY	ETF	296.69	296.69	296.14	296.26	14534.0
2020-03-02 05:15:00	SPY	ETF	296.28	297.28	296.28	296.89	8119.0
2020-03-02 05:20:00	SPY	ETF	296.76	296.76	296.21	296.21	9578.0
2020-03-02 05:25:00	SPY	ETF	296.49	297.16	296.49	297.16	6925.0
2020-03-02 05:30:00	SPY	ETF	297.2	297.9	297.01	297.5	16282.0
2020-03-02 05:35:00	SPY	ETF	297.54	297.54	297.2	297.21	4334.0
2020-03-02 05:40:00	SPY	ETF	297.48	297.48	296.7	297.0	4316.0
2020-03-02 05:45:00	SPY	ETF	297.08	297.2	296.4	296.49	4872.0
2020-03-02 05:50:00	SPY	ETF	296.51	296.8	296.38	296.63	37310.0
2020-03-02 05:55:00	SPY	ETF	296.74	296.75	295.95	296.12	24871.0
2020-03-02 06:00:00	SPY	ETF	296.0	296.08	295.08	295.1	59680.0
2020-03-02 06:05:00	SPY	ETF	295.14	295.77	295.1	295.37	26094.0
2020-03-02 06:10:00	SPY	ETF	295.26	295.42	294.28	294.28	35542.0
2020-03-02 06:15:00	SPY	ETF	294.24	295.24	294.2	295.24	74861.0
2020-03-02 06:20:00	SPY	ETF	295.33	295.33	294.55	294.8	16941.0
2020-03-02 06:25:00	SPY	ETF	294.7	294.82	294.07	294.07	98459.0
2020-03-02 06:30:00	SPY	ETF	294.15	294.34	293.52	293.6	129748.0
2020-03-02 06:35:00	SPY	ETF	293.63	294.22	293.44	293.91	28150.0
2020-03-02 06:40:00	SPY	ETF	293.88	294.02	292.86	293.1	75081.0
2020-03-02 06:45:00	SPY	ETF	293.1	293.74	292.96	293.47	106774.0
2020-03-02 06:50:00	SPY	ETF	293.57	293.57	292.41	292.51	55827.0
2020-03-02 06:55:00	SPY	ETF	292.52	292.82	290.65	291.1	258638.0
2020-03-02 07:00:00	SPY	ETF	291.14	292.47	290.9	292.03	196606.0
2020-03-02 07:05:00	SPY	ETF	292.14	293.15	291.8	293.03	115592.0
2020-03-02 07:10:00	SPY	ETF	293.03	293.08	292.01	292.29	150804.0
2020-03-02 07:15:00	SPY	ETF	292.48	292.71	292.12	292.12	100466.0
2020-03-02 07:20:00	SPY	ETF	292.14	292.76	291.94	292.52	119432.0
2020-03-02 07:25:00	SPY	ETF	292.5	293.45	292.35	293.45	75469.0
2020-03-02 07:30:00	SPY	ETF	293.39	293.56	292.61	292.77	113873.0
2020-03-02 07:35:00	SPY	ETF	292.89	293.37	292.5	292.5	123789.0
2020-03-02 07:40:00	SPY	ETF	292.51	293.44	292.48	292.94	95998.0
2020-03-02 07:45:00	SPY	ETF	292.99	293.52	292.85	293.16	59544.0
2020-03-02 07:50:00	SPY	ETF	293.06	293.27	292.87	293.0	79080.0
2020-03-02 07:55:00	SPY	ETF	293.03	294.86	293.03	294.29	177440.0
2020-03-02 08:00:00	SPY	ETF	294.42	302.07	290.99	293.92	333642.0
2020-03-02 08:05:00	SPY	ETF	294.05	297.13	293.78	293.93	271581.0

> showing 50 of 87,282 rows — these rows as CSV

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