PREVIEW / etf_5min / 2020-01-27

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-01-27.parquet
  size:    1.7 MB
  rows:    74,136

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-27 04:00:00	SPY	ETF	325.61	325.61	325.34	325.43	20462.0
2020-01-27 04:05:00	SPY	ETF	325.45	325.45	325.26	325.34	3992.0
2020-01-27 04:10:00	SPY	ETF	325.4	325.47	325.16	325.19	8466.0
2020-01-27 04:15:00	SPY	ETF	325.14	325.17	324.84	324.84	12057.0
2020-01-27 04:20:00	SPY	ETF	324.99	325.09	324.94	324.98	12363.0
2020-01-27 04:25:00	SPY	ETF	325.04	325.04	324.73	324.83	12031.0
2020-01-27 04:30:00	SPY	ETF	324.78	324.88	324.74	324.77	7677.0
2020-01-27 04:35:00	SPY	ETF	324.76	324.76	324.58	324.58	5498.0
2020-01-27 04:40:00	SPY	ETF	324.65	324.65	324.5	324.5	3765.0
2020-01-27 04:45:00	SPY	ETF	324.47	324.53	324.32	324.32	4273.0
2020-01-27 04:50:00	SPY	ETF	324.48	324.6	324.42	324.6	3430.0
2020-01-27 04:55:00	SPY	ETF	324.6	324.61	324.56	324.56	9750.0
2020-01-27 05:00:00	SPY	ETF	324.31	324.32	324.31	324.32	1631.0
2020-01-27 05:05:00	SPY	ETF	324.34	324.48	324.34	324.48	1260.0
2020-01-27 05:10:00	SPY	ETF	324.4	324.4	324.09	324.3	11770.0
2020-01-27 05:15:00	SPY	ETF	324.33	324.33	323.94	323.94	14409.0
2020-01-27 05:20:00	SPY	ETF	323.95	323.97	323.71	323.97	27410.0
2020-01-27 05:25:00	SPY	ETF	323.98	324.16	323.91	324.16	17957.0
2020-01-27 05:30:00	SPY	ETF	324.06	324.13	323.86	323.86	2224.0
2020-01-27 05:35:00	SPY	ETF	323.9	323.98	323.88	323.9	920.0
2020-01-27 05:40:00	SPY	ETF	323.9	323.9	323.73	323.75	20883.0
2020-01-27 05:45:00	SPY	ETF	323.8	323.8	323.6	323.65	7059.0
2020-01-27 05:50:00	SPY	ETF	323.73	323.73	323.47	323.58	10171.0
2020-01-27 05:55:00	SPY	ETF	323.5	323.5	323.33	323.33	4398.0
2020-01-27 06:00:00	SPY	ETF	323.22	323.4	323.0	323.3	21007.0
2020-01-27 06:05:00	SPY	ETF	323.3	323.31	323.21	323.22	13109.0
2020-01-27 06:10:00	SPY	ETF	323.29	323.3	323.17	323.29	92559.0
2020-01-27 06:15:00	SPY	ETF	323.32	323.45	323.2	323.45	16465.0
2020-01-27 06:20:00	SPY	ETF	323.43	323.74	323.43	323.73	29005.0
2020-01-27 06:25:00	SPY	ETF	323.74	323.97	323.74	323.94	15893.0
2020-01-27 06:30:00	SPY	ETF	323.98	324.21	323.98	324.13	22440.0
2020-01-27 06:35:00	SPY	ETF	324.11	324.11	323.91	324.04	15022.0
2020-01-27 06:40:00	SPY	ETF	324.04	324.07	323.94	324.01	10745.0
2020-01-27 06:45:00	SPY	ETF	324.0	324.0	323.89	323.92	10297.0
2020-01-27 06:50:00	SPY	ETF	323.9	323.92	323.65	323.67	36461.0
2020-01-27 06:55:00	SPY	ETF	323.63	323.95	323.61	323.9	76943.0
2020-01-27 07:00:00	SPY	ETF	323.95	324.17	323.88	324.0	104747.0
2020-01-27 07:05:00	SPY	ETF	324.0	324.29	324.0	324.29	59918.0
2020-01-27 07:10:00	SPY	ETF	324.29	324.42	324.15	324.22	204147.0
2020-01-27 07:15:00	SPY	ETF	324.25	324.45	324.13	324.45	51135.0
2020-01-27 07:20:00	SPY	ETF	324.44	324.62	324.35	324.52	108527.0
2020-01-27 07:25:00	SPY	ETF	324.5	324.69	324.36	324.36	56438.0
2020-01-27 07:30:00	SPY	ETF	324.38	324.48	324.2	324.23	71118.0
2020-01-27 07:35:00	SPY	ETF	324.22	324.26	324.09	324.14	22991.0
2020-01-27 07:40:00	SPY	ETF	324.14	324.49	324.14	324.41	25525.0
2020-01-27 07:45:00	SPY	ETF	324.36	324.42	324.31	324.4	43905.0
2020-01-27 07:50:00	SPY	ETF	324.39	324.43	324.09	324.13	53674.0
2020-01-27 07:55:00	SPY	ETF	324.1	324.1	323.85	323.97	64451.0
2020-01-27 08:00:00	SPY	ETF	324.4	325.8	323.87	323.96	163865.0
2020-01-27 08:05:00	SPY	ETF	323.98	323.98	323.73	323.79	114510.0

> showing 50 of 74,136 rows — these rows as CSV

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