PREVIEW / etf_5min / 2018-08-08

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-08-08.parquet
  size:    1.3 MB
  rows:    54,942

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-08-08 04:00:00	SPY	ETF	285.56	285.56	285.56	285.56	100.0
2018-08-08 04:10:00	SPY	ETF	285.55	285.6	285.55	285.6	350.0
2018-08-08 04:15:00	SPY	ETF	285.53	285.53	285.53	285.53	100.0
2018-08-08 04:20:00	SPY	ETF	285.45	285.45	285.45	285.45	300.0
2018-08-08 04:30:00	SPY	ETF	285.61	285.61	285.6	285.6	600.0
2018-08-08 04:35:00	SPY	ETF	285.6	285.6	285.6	285.6	150.0
2018-08-08 05:05:00	SPY	ETF	285.63	285.63	285.6	285.6	200.0
2018-08-08 05:25:00	SPY	ETF	285.63	285.63	285.63	285.63	1000.0
2018-08-08 05:30:00	SPY	ETF	285.55	285.55	285.55	285.55	100.0
2018-08-08 05:55:00	SPY	ETF	285.63	285.63	285.63	285.63	300.0
2018-08-08 06:10:00	SPY	ETF	285.63	285.63	285.63	285.63	150.0
2018-08-08 06:25:00	SPY	ETF	285.7	285.7	285.7	285.7	4000.0
2018-08-08 06:45:00	SPY	ETF	285.72	285.72	285.72	285.72	2000.0
2018-08-08 06:50:00	SPY	ETF	285.75	285.75	285.75	285.75	600.0
2018-08-08 06:55:00	SPY	ETF	285.72	285.75	285.72	285.75	2100.0
2018-08-08 07:00:00	SPY	ETF	285.71	285.75	285.71	285.75	619.0
2018-08-08 07:05:00	SPY	ETF	285.71	285.71	285.7	285.7	500.0
2018-08-08 07:10:00	SPY	ETF	285.75	285.75	285.75	285.75	450.0
2018-08-08 07:15:00	SPY	ETF	285.74	285.74	285.74	285.74	100.0
2018-08-08 07:20:00	SPY	ETF	285.72	285.72	285.72	285.72	1100.0
2018-08-08 07:25:00	SPY	ETF	285.72	285.72	285.7	285.72	634.0
2018-08-08 07:30:00	SPY	ETF	285.74	285.8	285.74	285.8	500.0
2018-08-08 07:35:00	SPY	ETF	285.73	285.73	285.7	285.7	1400.0
2018-08-08 07:40:00	SPY	ETF	285.7	285.72	285.7	285.7	700.0
2018-08-08 07:45:00	SPY	ETF	285.72	285.72	285.72	285.72	100.0
2018-08-08 07:50:00	SPY	ETF	285.7	285.7	285.63	285.63	3400.0
2018-08-08 07:55:00	SPY	ETF	285.69	285.69	285.6	285.6	11137.0
2018-08-08 08:00:00	SPY	ETF	285.73	285.73	285.52	285.52	14287.0
2018-08-08 08:05:00	SPY	ETF	285.52	285.52	285.44	285.5	14422.0
2018-08-08 08:10:00	SPY	ETF	285.47	285.54	285.47	285.54	30417.0
2018-08-08 08:15:00	SPY	ETF	285.5	285.54	285.5	285.53	1429.0
2018-08-08 08:20:00	SPY	ETF	285.53	285.53	285.41	285.41	7575.0
2018-08-08 08:25:00	SPY	ETF	285.42	285.45	285.38	285.38	17685.0
2018-08-08 08:30:00	SPY	ETF	285.38	285.39	285.34	285.38	19767.0
2018-08-08 08:35:00	SPY	ETF	285.38	285.39	285.37	285.37	2020.0
2018-08-08 08:40:00	SPY	ETF	285.36	285.36	285.28	285.3	14565.0
2018-08-08 08:45:00	SPY	ETF	285.28	285.3	285.16	285.2	82332.0
2018-08-08 08:50:00	SPY	ETF	285.19	285.27	285.18	285.23	13372.0
2018-08-08 08:55:00	SPY	ETF	285.22	285.28	285.22	285.28	44507.0
2018-08-08 09:00:00	SPY	ETF	285.26	285.36	285.25	285.33	16435.0
2018-08-08 09:05:00	SPY	ETF	285.31	285.35	285.31	285.33	11213.0
2018-08-08 09:10:00	SPY	ETF	285.33	285.36	285.33	285.36	8855.0
2018-08-08 09:15:00	SPY	ETF	285.34	285.37	285.3	285.37	5012.0
2018-08-08 09:20:00	SPY	ETF	285.36	285.39	285.36	285.37	7661.0
2018-08-08 09:25:00	SPY	ETF	285.39	285.41	285.34	285.38	28277.0
2018-08-08 09:30:00	SPY	ETF	285.39	285.39	285.04	285.22	1210682.0
2018-08-08 09:35:00	SPY	ETF	285.21	285.47	285.09	285.41	823523.0
2018-08-08 09:40:00	SPY	ETF	285.41	285.41	285.14	285.22	542053.0
2018-08-08 09:45:00	SPY	ETF	285.22	285.35	285.09	285.3	562879.0
2018-08-08 09:50:00	SPY	ETF	285.3	285.32	285.16	285.27	287196.0

> showing 50 of 54,942 rows — these rows as CSV

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