PREVIEW / etf_5min / 2018-05-14

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-05-14.parquet
  size:    1.3 MB
  rows:    57,090

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
2018-05-14 04:00:00	SPY	ETF	273.28	273.54	273.28	273.47	3558.0
2018-05-14 04:05:00	SPY	ETF	273.49	273.49	273.47	273.49	2035.0
2018-05-14 04:10:00	SPY	ETF	273.49	273.49	273.44	273.44	1834.0
2018-05-14 04:15:00	SPY	ETF	273.44	273.51	273.44	273.51	1330.0
2018-05-14 04:20:00	SPY	ETF	273.49	273.5	273.47	273.47	2025.0
2018-05-14 04:25:00	SPY	ETF	273.53	273.56	273.51	273.56	1740.0
2018-05-14 04:30:00	SPY	ETF	273.51	273.53	273.51	273.53	760.0
2018-05-14 04:40:00	SPY	ETF	273.51	273.51	273.46	273.46	813.0
2018-05-14 04:45:00	SPY	ETF	273.42	273.42	273.42	273.42	345.0
2018-05-14 04:50:00	SPY	ETF	273.46	273.46	273.43	273.43	1770.0
2018-05-14 04:55:00	SPY	ETF	273.46	273.46	273.4	273.42	1300.0
2018-05-14 05:00:00	SPY	ETF	273.48	273.48	273.45	273.45	405.0
2018-05-14 05:05:00	SPY	ETF	273.48	273.48	273.48	273.48	300.0
2018-05-14 05:10:00	SPY	ETF	273.47	273.47	273.47	273.47	805.0
2018-05-14 05:15:00	SPY	ETF	273.5	273.54	273.5	273.52	1210.0
2018-05-14 05:20:00	SPY	ETF	273.52	273.52	273.52	273.52	615.0
2018-05-14 05:25:00	SPY	ETF	273.55	273.55	273.55	273.55	315.0
2018-05-14 05:30:00	SPY	ETF	273.55	273.59	273.55	273.57	3835.0
2018-05-14 05:35:00	SPY	ETF	273.6	273.6	273.59	273.59	5740.0
2018-05-14 05:50:00	SPY	ETF	273.53	273.54	273.53	273.54	410.0
2018-05-14 05:55:00	SPY	ETF	273.51	273.51	273.51	273.51	1055.0
2018-05-14 06:00:00	SPY	ETF	273.47	273.49	273.47	273.48	625.0
2018-05-14 06:05:00	SPY	ETF	273.45	273.45	273.45	273.45	1721.0
2018-05-14 06:10:00	SPY	ETF	273.45	273.46	273.45	273.46	300.0
2018-05-14 06:15:00	SPY	ETF	273.41	273.41	273.39	273.39	1450.0
2018-05-14 06:20:00	SPY	ETF	273.43	273.43	273.43	273.43	915.0
2018-05-14 06:25:00	SPY	ETF	273.43	273.43	273.37	273.37	1670.0
2018-05-14 06:30:00	SPY	ETF	273.37	273.38	273.32	273.32	555.0
2018-05-14 06:35:00	SPY	ETF	273.35	273.36	273.35	273.36	300.0
2018-05-14 06:40:00	SPY	ETF	273.36	273.39	273.36	273.39	1290.0
2018-05-14 06:45:00	SPY	ETF	273.32	273.34	273.3	273.32	935.0
2018-05-14 06:50:00	SPY	ETF	273.34	273.36	273.34	273.36	1615.0
2018-05-14 06:55:00	SPY	ETF	273.36	273.43	273.36	273.43	8630.0
2018-05-14 07:00:00	SPY	ETF	273.42	273.42	273.39	273.41	6995.0
2018-05-14 07:05:00	SPY	ETF	273.41	273.43	273.41	273.43	3355.0
2018-05-14 07:10:00	SPY	ETF	273.44	273.47	273.38	273.41	31195.0
2018-05-14 07:15:00	SPY	ETF	273.39	273.44	273.39	273.39	6820.0
2018-05-14 07:20:00	SPY	ETF	273.39	273.39	273.33	273.36	5985.0
2018-05-14 07:25:00	SPY	ETF	273.36	273.39	273.35	273.39	2366.0
2018-05-14 07:30:00	SPY	ETF	273.36	273.39	273.3	273.37	7865.0
2018-05-14 07:35:00	SPY	ETF	273.39	273.41	273.33	273.33	6909.0
2018-05-14 07:40:00	SPY	ETF	273.34	273.38	273.32	273.32	26107.0
2018-05-14 07:45:00	SPY	ETF	273.3	273.32	273.26	273.26	5505.0
2018-05-14 07:50:00	SPY	ETF	273.29	273.3	273.27	273.27	13010.0
2018-05-14 07:55:00	SPY	ETF	273.3	273.3	273.26	273.26	20391.0
2018-05-14 08:00:00	SPY	ETF	273.43	274.07	273.27	273.27	40221.0
2018-05-14 08:05:00	SPY	ETF	273.27	273.3	273.26	273.3	6903.0
2018-05-14 08:10:00	SPY	ETF	273.3181	273.35	273.3181	273.33	1789.0
2018-05-14 08:15:00	SPY	ETF	273.3	273.31	273.25	273.26	8187.0
2018-05-14 08:20:00	SPY	ETF	273.26	273.3	273.22	273.3	5298.0

> showing 50 of 57,090 rows — these rows as CSV

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