PREVIEW / etf_5min / 2017-12-07

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-12-07.parquet
  size:    1.3 MB
  rows:    56,027

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
2017-12-07 04:10:00	SPY	ETF	263.53	263.53	263.53	263.53	100.0
2017-12-07 04:15:00	SPY	ETF	263.54	263.63	263.54	263.63	2200.0
2017-12-07 04:30:00	SPY	ETF	263.63	263.63	263.63	263.63	2270.0
2017-12-07 04:40:00	SPY	ETF	263.75	263.75	263.75	263.75	100.0
2017-12-07 04:45:00	SPY	ETF	263.8	263.8	263.8	263.8	100.0
2017-12-07 04:50:00	SPY	ETF	263.73	263.73	263.73	263.73	1000.0
2017-12-07 05:40:00	SPY	ETF	263.76	263.78	263.63	263.63	2100.0
2017-12-07 05:45:00	SPY	ETF	263.62	263.65	263.62	263.65	900.0
2017-12-07 05:55:00	SPY	ETF	263.54	263.54	263.54	263.54	300.0
2017-12-07 06:00:00	SPY	ETF	263.5	263.57	263.48	263.57	1200.0
2017-12-07 06:05:00	SPY	ETF	263.54	263.56	263.53	263.56	6900.0
2017-12-07 06:10:00	SPY	ETF	263.57	263.57	263.52	263.52	2000.0
2017-12-07 06:15:00	SPY	ETF	263.52	263.52	263.46	263.46	1400.0
2017-12-07 06:20:00	SPY	ETF	263.46	263.52	263.46	263.52	1400.0
2017-12-07 06:25:00	SPY	ETF	263.46	263.46	263.45	263.45	500.0
2017-12-07 06:30:00	SPY	ETF	263.4	263.4	263.4	263.4	200.0
2017-12-07 06:35:00	SPY	ETF	263.37	263.38	263.35	263.35	3200.0
2017-12-07 06:45:00	SPY	ETF	263.35	263.35	263.35	263.35	4900.0
2017-12-07 06:50:00	SPY	ETF	263.43	263.43	263.36	263.36	500.0
2017-12-07 06:55:00	SPY	ETF	263.43	263.46	263.41	263.46	3100.0
2017-12-07 07:00:00	SPY	ETF	263.42	263.47	263.38	263.38	61588.0
2017-12-07 07:05:00	SPY	ETF	263.36	263.36	263.2	263.28	16646.0
2017-12-07 07:10:00	SPY	ETF	263.23	263.3	263.23	263.3	1067.0
2017-12-07 07:15:00	SPY	ETF	263.32	263.38	263.32	263.37	8000.0
2017-12-07 07:20:00	SPY	ETF	263.41	263.43	263.41	263.43	11520.0
2017-12-07 07:25:00	SPY	ETF	263.41	263.41	263.36	263.39	47366.0
2017-12-07 07:30:00	SPY	ETF	263.39	263.39	263.36	263.39	5826.0
2017-12-07 07:35:00	SPY	ETF	263.37	263.37	263.35	263.35	826.0
2017-12-07 07:40:00	SPY	ETF	263.36	263.36	263.32	263.35	11504.0
2017-12-07 07:45:00	SPY	ETF	263.33	263.36	263.3	263.36	12221.0
2017-12-07 07:50:00	SPY	ETF	263.33	263.33	263.28	263.28	4000.0
2017-12-07 07:55:00	SPY	ETF	263.26	263.3	263.16	263.16	25625.0
2017-12-07 08:00:00	SPY	ETF	263.38	263.46	263.15	263.32	25273.0
2017-12-07 08:05:00	SPY	ETF	263.3	263.34	263.29	263.34	29816.0
2017-12-07 08:10:00	SPY	ETF	263.31	263.33	263.19	263.19	55301.0
2017-12-07 08:15:00	SPY	ETF	263.21	263.25	263.13	263.2	72273.0
2017-12-07 08:20:00	SPY	ETF	263.2	263.21	263.18	263.21	2505.0
2017-12-07 08:25:00	SPY	ETF	263.19	263.33	263.19	263.33	21015.0
2017-12-07 08:30:00	SPY	ETF	263.3	263.3	263.2	263.2	4247.0
2017-12-07 08:35:00	SPY	ETF	263.21	263.28	263.14	263.16	16606.0
2017-12-07 08:40:00	SPY	ETF	263.16	263.21	263.07	263.21	15874.0
2017-12-07 08:45:00	SPY	ETF	263.24	263.27	263.13	263.13	14073.0
2017-12-07 08:50:00	SPY	ETF	263.13	263.16	263.08	263.13	30600.0
2017-12-07 08:55:00	SPY	ETF	263.11	263.13	263.08	263.08	18453.0
2017-12-07 09:00:00	SPY	ETF	263.08	263.09	262.97	263.07	56548.0
2017-12-07 09:05:00	SPY	ETF	263.05	263.09	262.99	263.08	32655.0
2017-12-07 09:10:00	SPY	ETF	263.1	263.19	263.1	263.1	45535.0
2017-12-07 09:15:00	SPY	ETF	263.08	263.11	263.02	263.02	64353.0
2017-12-07 09:20:00	SPY	ETF	263.0	263.15	263.0	263.15	52497.0
2017-12-07 09:25:00	SPY	ETF	263.13	263.13	263.04	263.1	100272.0

> showing 50 of 56,027 rows — these rows as CSV

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