PREVIEW / etf_5min / 2020-03-31

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-03-31.parquet
  size:    1.8 MB
  rows:    80,739

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-31 04:00:00	SPY	ETF	262.74	263.04	262.5	262.69	16613.0
2020-03-31 04:05:00	SPY	ETF	262.89	263.45	262.72	263.45	14141.0
2020-03-31 04:10:00	SPY	ETF	263.43	263.48	263.13	263.18	9826.0
2020-03-31 04:15:00	SPY	ETF	263.16	263.5	263.04	263.04	12791.0
2020-03-31 04:20:00	SPY	ETF	263.23	263.42	263.12	263.42	2872.0
2020-03-31 04:25:00	SPY	ETF	263.44	263.79	263.44	263.78	2627.0
2020-03-31 04:30:00	SPY	ETF	263.68	263.73	263.57	263.66	12996.0
2020-03-31 04:35:00	SPY	ETF	263.79	263.79	263.21	263.45	9939.0
2020-03-31 04:40:00	SPY	ETF	263.46	263.9	263.46	263.75	4335.0
2020-03-31 04:45:00	SPY	ETF	263.45	263.45	263.0	263.12	9813.0
2020-03-31 04:50:00	SPY	ETF	263.27	263.5	263.27	263.44	868.0
2020-03-31 04:55:00	SPY	ETF	263.37	263.41	263.13	263.3	3786.0
2020-03-31 05:00:00	SPY	ETF	263.46	263.47	263.2	263.2	4666.0
2020-03-31 05:05:00	SPY	ETF	263.22	263.38	263.14	263.38	2910.0
2020-03-31 05:10:00	SPY	ETF	263.3	263.52	263.3	263.4	6159.0
2020-03-31 05:15:00	SPY	ETF	263.32	263.55	263.26	263.55	2850.0
2020-03-31 05:20:00	SPY	ETF	263.62	263.75	263.6	263.75	3532.0
2020-03-31 05:25:00	SPY	ETF	263.7	263.7	263.39	263.39	3237.0
2020-03-31 05:30:00	SPY	ETF	263.61	263.61	263.28	263.37	7350.0
2020-03-31 05:35:00	SPY	ETF	263.4	263.6	263.4	263.6	3886.0
2020-03-31 05:40:00	SPY	ETF	263.5	263.55	263.3	263.31	3733.0
2020-03-31 05:45:00	SPY	ETF	263.02	263.03	262.6	262.68	25676.0
2020-03-31 05:50:00	SPY	ETF	262.81	262.99	262.46	262.81	16997.0
2020-03-31 05:55:00	SPY	ETF	262.86	263.24	262.84	263.01	10923.0
2020-03-31 06:00:00	SPY	ETF	262.93	262.96	262.69	262.79	4292.0
2020-03-31 06:05:00	SPY	ETF	262.82	262.82	262.51	262.76	10174.0
2020-03-31 06:10:00	SPY	ETF	262.69	262.83	262.5	262.71	4556.0
2020-03-31 06:15:00	SPY	ETF	262.55	262.6	262.06	262.06	12886.0
2020-03-31 06:20:00	SPY	ETF	262.06	262.12	261.39	261.75	34414.0
2020-03-31 06:25:00	SPY	ETF	261.63	261.98	261.56	261.57	9342.0
2020-03-31 06:30:00	SPY	ETF	261.66	262.0	261.45	261.97	52372.0
2020-03-31 06:35:00	SPY	ETF	261.83	261.98	261.05	261.65	25104.0
2020-03-31 06:40:00	SPY	ETF	261.6	262.3	261.6	262.18	16410.0
2020-03-31 06:45:00	SPY	ETF	262.28	262.28	261.8	261.92	13200.0
2020-03-31 06:50:00	SPY	ETF	261.88	262.06	261.65	261.65	3892.0
2020-03-31 06:55:00	SPY	ETF	261.6	261.79	261.18	261.18	13509.0
2020-03-31 07:00:00	SPY	ETF	261.26	261.41	260.9	260.91	58138.0
2020-03-31 07:05:00	SPY	ETF	260.9	261.31	260.58	260.63	58862.0
2020-03-31 07:10:00	SPY	ETF	260.56	260.88	260.48	260.57	69186.0
2020-03-31 07:15:00	SPY	ETF	260.601	261.15	260.5	261.04	88401.0
2020-03-31 07:20:00	SPY	ETF	261.05	261.33	260.61	260.75	83010.0
2020-03-31 07:25:00	SPY	ETF	260.85	261.02	260.6	260.7	72440.0
2020-03-31 07:30:00	SPY	ETF	260.96	261.0	260.75	260.9	34318.0
2020-03-31 07:35:00	SPY	ETF	260.96	261.04	260.72	260.72	20506.0
2020-03-31 07:40:00	SPY	ETF	260.67	260.82	260.08	260.13	121682.0
2020-03-31 07:45:00	SPY	ETF	260.12	260.43	259.96	260.29	143736.0
2020-03-31 07:50:00	SPY	ETF	260.36	260.61	260.32	260.32	87976.0
2020-03-31 07:55:00	SPY	ETF	260.33	260.7	260.2	260.43	91722.0
2020-03-31 08:00:00	SPY	ETF	260.8299	263.46	259.15	261.65	485821.0
2020-03-31 08:05:00	SPY	ETF	259.41	259.5	258.85	259.14	366105.0

> showing 50 of 80,739 rows — these rows as CSV

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