PREVIEW / etf_5min / 2019-10-01

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-10-01.parquet
  size:    1.6 MB
  rows:    65,470

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-10-01 04:00:00	SPY	ETF	297.78	297.81	297.72	297.81	3902.0
2019-10-01 04:05:00	SPY	ETF	297.83	297.83	297.58	297.58	400.0
2019-10-01 04:10:00	SPY	ETF	297.58	297.68	297.58	297.65	2450.0
2019-10-01 04:15:00	SPY	ETF	297.66	297.66	297.65	297.65	2500.0
2019-10-01 04:25:00	SPY	ETF	297.9	297.9	297.9	297.9	2051.0
2019-10-01 04:30:00	SPY	ETF	297.88	297.88	297.78	297.81	1300.0
2019-10-01 04:35:00	SPY	ETF	297.8	297.8	297.8	297.8	1000.0
2019-10-01 04:40:00	SPY	ETF	298.0	298.03	298.0	298.03	3469.0
2019-10-01 04:45:00	SPY	ETF	298.07	298.2	298.07	298.2	652.0
2019-10-01 04:50:00	SPY	ETF	298.0	298.0	297.9	297.9	700.0
2019-10-01 04:55:00	SPY	ETF	297.78	297.78	297.78	297.78	300.0
2019-10-01 05:00:00	SPY	ETF	297.68	297.68	297.5	297.5	2379.0
2019-10-01 05:05:00	SPY	ETF	297.55	297.6	297.43	297.55	2500.0
2019-10-01 05:10:00	SPY	ETF	297.68	297.68	297.68	297.68	118.0
2019-10-01 05:15:00	SPY	ETF	297.73	297.8	297.73	297.77	4200.0
2019-10-01 05:20:00	SPY	ETF	297.75	297.75	297.75	297.75	200.0
2019-10-01 05:25:00	SPY	ETF	297.65	297.65	297.55	297.6	2100.0
2019-10-01 05:30:00	SPY	ETF	297.5	297.5	297.43	297.47	2182.0
2019-10-01 05:35:00	SPY	ETF	297.51	297.51	297.5	297.5	724.0
2019-10-01 05:40:00	SPY	ETF	297.43	297.5	297.43	297.5	1083.0
2019-10-01 05:45:00	SPY	ETF	297.5	297.5	297.47	297.47	200.0
2019-10-01 05:50:00	SPY	ETF	297.55	297.63	297.55	297.63	400.0
2019-10-01 05:55:00	SPY	ETF	297.63	297.7	297.63	297.7	600.0
2019-10-01 06:00:00	SPY	ETF	297.6	297.6	297.48	297.53	1205.0
2019-10-01 06:05:00	SPY	ETF	297.65	297.68	297.65	297.68	600.0
2019-10-01 06:10:00	SPY	ETF	297.51	297.55	297.48	297.5	4200.0
2019-10-01 06:15:00	SPY	ETF	297.62	297.82	297.62	297.8	5870.0
2019-10-01 06:20:00	SPY	ETF	297.7	297.7	297.69	297.69	630.0
2019-10-01 06:25:00	SPY	ETF	297.75	297.75	297.75	297.75	1503.0
2019-10-01 06:30:00	SPY	ETF	297.66	297.7	297.6	297.7	3300.0
2019-10-01 06:40:00	SPY	ETF	297.68	297.8	297.67	297.8	4000.0
2019-10-01 06:45:00	SPY	ETF	297.67	297.67	297.67	297.67	700.0
2019-10-01 06:50:00	SPY	ETF	297.62	297.62	297.42	297.48	4007.0
2019-10-01 06:55:00	SPY	ETF	297.5	297.5	297.5	297.5	1202.0
2019-10-01 07:00:00	SPY	ETF	297.5	297.55	297.45	297.46	5917.0
2019-10-01 07:05:00	SPY	ETF	297.48	297.48	297.4	297.41	2851.0
2019-10-01 07:10:00	SPY	ETF	297.42	297.45	297.4	297.43	6135.0
2019-10-01 07:15:00	SPY	ETF	297.4	297.45	297.4	297.4	1931.0
2019-10-01 07:20:00	SPY	ETF	297.43	297.5	297.4	297.5	5408.0
2019-10-01 07:25:00	SPY	ETF	297.53	297.6	297.53	297.55	4200.0
2019-10-01 07:30:00	SPY	ETF	297.55	297.61	297.55	297.61	2000.0
2019-10-01 07:35:00	SPY	ETF	297.6	297.64	297.58	297.59	3301.0
2019-10-01 07:40:00	SPY	ETF	297.56	297.6	297.5	297.51	3957.0
2019-10-01 07:45:00	SPY	ETF	297.46	297.51	297.46	297.49	808.0
2019-10-01 07:50:00	SPY	ETF	297.51	297.55	297.5	297.55	12142.0
2019-10-01 07:55:00	SPY	ETF	297.55	297.55	297.53	297.53	953.0
2019-10-01 08:00:00	SPY	ETF	297.55	298.43	297.4	297.4	30643.0
2019-10-01 08:05:00	SPY	ETF	297.45	297.45	297.4	297.45	3561.0
2019-10-01 08:10:00	SPY	ETF	297.46	297.51	297.45	297.45	17762.0
2019-10-01 08:15:00	SPY	ETF	297.43	297.55	297.4	297.5301	7343.0

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

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