PREVIEW / etf_5min / 2020-01-28

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-01-28.parquet
  size:    1.6 MB
  rows:    67,447

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-01-28 04:00:00	SPY	ETF	324.5	324.5	323.89	324.0	10579.0
2020-01-28 04:05:00	SPY	ETF	324.07	324.14	323.87	324.14	3206.0
2020-01-28 04:10:00	SPY	ETF	324.17	324.2	324.16	324.2	866.0
2020-01-28 04:15:00	SPY	ETF	324.08	324.21	324.08	324.21	2104.0
2020-01-28 04:20:00	SPY	ETF	324.27	324.27	324.18	324.18	3882.0
2020-01-28 04:25:00	SPY	ETF	323.89	324.02	323.85	323.96	6327.0
2020-01-28 04:30:00	SPY	ETF	324.0	324.3	324.0	324.3	4500.0
2020-01-28 04:35:00	SPY	ETF	324.29	324.29	324.2	324.2	974.0
2020-01-28 04:40:00	SPY	ETF	324.18	324.5	324.16	324.5	2623.0
2020-01-28 04:45:00	SPY	ETF	324.29	324.29	324.22	324.22	220.0
2020-01-28 04:50:00	SPY	ETF	324.21	324.27	324.21	324.22	1440.0
2020-01-28 04:55:00	SPY	ETF	324.1	324.2	324.09	324.2	1495.0
2020-01-28 05:00:00	SPY	ETF	324.24	324.25	324.24	324.25	200.0
2020-01-28 05:05:00	SPY	ETF	324.28	324.3	324.27	324.3	2350.0
2020-01-28 05:10:00	SPY	ETF	324.33	324.37	324.12	324.14	1369.0
2020-01-28 05:15:00	SPY	ETF	324.4	324.4	324.4	324.4	420.0
2020-01-28 05:20:00	SPY	ETF	324.35	324.4	324.32	324.32	4392.0
2020-01-28 05:25:00	SPY	ETF	324.1	324.12	323.95	323.96	1712.0
2020-01-28 05:35:00	SPY	ETF	324.11	324.11	324.11	324.11	600.0
2020-01-28 05:45:00	SPY	ETF	324.29	324.29	324.29	324.29	710.0
2020-01-28 05:50:00	SPY	ETF	324.35	324.38	324.25	324.25	1921.0
2020-01-28 05:55:00	SPY	ETF	324.2	324.2	324.2	324.2	544.0
2020-01-28 06:00:00	SPY	ETF	324.11	324.12	323.95	324.05	2851.0
2020-01-28 06:05:00	SPY	ETF	324.1	324.1	324.08	324.08	580.0
2020-01-28 06:10:00	SPY	ETF	324.01	324.02	323.88	323.88	2833.0
2020-01-28 06:15:00	SPY	ETF	323.82	323.82	323.56	323.7	9210.0
2020-01-28 06:20:00	SPY	ETF	323.8	323.85	323.8	323.85	6141.0
2020-01-28 06:25:00	SPY	ETF	323.93	324.03	323.9	324.03	1708.0
2020-01-28 06:30:00	SPY	ETF	324.08	324.11	324.08	324.11	854.0
2020-01-28 06:35:00	SPY	ETF	324.12	324.22	324.11	324.11	7766.0
2020-01-28 06:40:00	SPY	ETF	324.08	324.25	324.08	324.24	3901.0
2020-01-28 06:45:00	SPY	ETF	324.22	324.35	324.2	324.2	4538.0
2020-01-28 06:50:00	SPY	ETF	324.32	324.65	324.32	324.65	9204.0
2020-01-28 06:55:00	SPY	ETF	324.63	324.97	324.57	324.92	15731.0
2020-01-28 07:00:00	SPY	ETF	324.89	324.89	324.76	324.86	38916.0
2020-01-28 07:05:00	SPY	ETF	324.82	324.82	324.65	324.7	12627.0
2020-01-28 07:10:00	SPY	ETF	324.73	325.1	324.73	325.08	32469.0
2020-01-28 07:15:00	SPY	ETF	325.1	325.22	325.01	325.1	10983.0
2020-01-28 07:20:00	SPY	ETF	325.14	325.16	325.01	325.04	19592.0
2020-01-28 07:25:00	SPY	ETF	325.06	325.3	325.04	325.28	20052.0
2020-01-28 07:30:00	SPY	ETF	325.24	325.48	325.16	325.48	23439.0
2020-01-28 07:35:00	SPY	ETF	325.43	325.56	325.37	325.46	61246.0
2020-01-28 07:40:00	SPY	ETF	325.5	325.5	325.35	325.35	23151.0
2020-01-28 07:45:00	SPY	ETF	325.34	325.64	325.33	325.59	27999.0
2020-01-28 07:50:00	SPY	ETF	325.52	325.55	325.42	325.44	13473.0
2020-01-28 07:55:00	SPY	ETF	325.47	325.48	325.18	325.25	99625.0
2020-01-28 08:00:00	SPY	ETF	325.25	325.61	323.5	324.47	337411.0
2020-01-28 08:05:00	SPY	ETF	325.22	325.35	325.21	325.29	63035.0
2020-01-28 08:10:00	SPY	ETF	325.31	325.43	325.16	325.43	27918.0
2020-01-28 08:15:00	SPY	ETF	325.34	325.35	325.21	325.35	15010.0

> showing 50 of 67,447 rows — these rows as CSV

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