PREVIEW / etf_5min / 2017-12-05

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-12-05.parquet
  size:    1.3 MB
  rows:    57,032

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-05 04:05:00	SPY	ETF	264.3	264.3	264.3	264.3	2500.0
2017-12-05 04:40:00	SPY	ETF	264.32	264.32	264.32	264.32	200.0
2017-12-05 04:45:00	SPY	ETF	264.34	264.34	264.34	264.34	400.0
2017-12-05 04:55:00	SPY	ETF	264.46	264.46	264.46	264.46	100.0
2017-12-05 05:00:00	SPY	ETF	264.46	264.46	264.46	264.46	200.0
2017-12-05 05:20:00	SPY	ETF	264.03	264.03	264.03	264.03	300.0
2017-12-05 05:30:00	SPY	ETF	264.02	264.02	264.02	264.02	200.0
2017-12-05 05:35:00	SPY	ETF	264.02	264.02	264.02	264.02	300.0
2017-12-05 05:45:00	SPY	ETF	264.05	264.05	264.05	264.05	101.0
2017-12-05 05:50:00	SPY	ETF	263.96	263.96	263.96	263.96	600.0
2017-12-05 05:55:00	SPY	ETF	263.83	263.83	263.83	263.83	603.0
2017-12-05 06:05:00	SPY	ETF	263.97	263.97	263.95	263.95	807.0
2017-12-05 06:10:00	SPY	ETF	264.0	264.05	264.0	264.05	1401.0
2017-12-05 06:15:00	SPY	ETF	264.05	264.07	264.05	264.07	1502.0
2017-12-05 06:20:00	SPY	ETF	263.98	264.0	263.98	264.0	202.0
2017-12-05 06:25:00	SPY	ETF	264.04	264.05	264.01	264.01	7600.0
2017-12-05 06:30:00	SPY	ETF	264.01	264.06	264.0	264.06	1701.0
2017-12-05 06:35:00	SPY	ETF	264.11	264.14	264.11	264.13	650.0
2017-12-05 06:40:00	SPY	ETF	264.19	264.2	264.18	264.2	2170.0
2017-12-05 06:45:00	SPY	ETF	264.16	264.23	264.16	264.23	2100.0
2017-12-05 06:50:00	SPY	ETF	264.26	264.26	264.26	264.26	300.0
2017-12-05 06:55:00	SPY	ETF	264.28	264.31	264.26	264.26	4400.0
2017-12-05 07:00:00	SPY	ETF	264.3	264.38	264.24	264.27	24459.0
2017-12-05 07:05:00	SPY	ETF	264.24	264.3	264.24	264.25	3092.0
2017-12-05 07:10:00	SPY	ETF	264.29	264.35	264.29	264.35	800.0
2017-12-05 07:15:00	SPY	ETF	264.35	264.35	264.3	264.3	1100.0
2017-12-05 07:20:00	SPY	ETF	264.37	264.5	264.37	264.41	8375.0
2017-12-05 07:25:00	SPY	ETF	264.33	264.4	264.31	264.38	6300.0
2017-12-05 07:30:00	SPY	ETF	264.38	264.54	264.29	264.54	15060.0
2017-12-05 07:35:00	SPY	ETF	264.5	264.5	264.45	264.47	6075.0
2017-12-05 07:40:00	SPY	ETF	264.45	264.65	264.45	264.57	18771.0
2017-12-05 07:45:00	SPY	ETF	264.61	264.61	264.56	264.59	35145.0
2017-12-05 07:50:00	SPY	ETF	264.6	264.69	264.59	264.66	157912.0
2017-12-05 07:55:00	SPY	ETF	264.63	264.65	264.59	264.62	11902.0
2017-12-05 08:00:00	SPY	ETF	264.14	264.65	264.14	264.62	8652.0
2017-12-05 08:05:00	SPY	ETF	264.64	264.74	264.63	264.71	101376.0
2017-12-05 08:10:00	SPY	ETF	264.71	264.71	264.57	264.59	82981.0
2017-12-05 08:15:00	SPY	ETF	264.57	264.63	264.56	264.61	10937.0
2017-12-05 08:20:00	SPY	ETF	264.63	264.63	264.56	264.56	8128.0
2017-12-05 08:25:00	SPY	ETF	264.62	264.65	264.57	264.65	21259.0
2017-12-05 08:30:00	SPY	ETF	264.63	264.68	264.58	264.62	26873.0
2017-12-05 08:35:00	SPY	ETF	264.6	264.6	264.48	264.55	14715.0
2017-12-05 08:40:00	SPY	ETF	264.51	264.55	264.45	264.54	23486.0
2017-12-05 08:45:00	SPY	ETF	264.55	264.55	264.4	264.46	41887.0
2017-12-05 08:50:00	SPY	ETF	264.43	264.51	264.43	264.51	52479.0
2017-12-05 08:55:00	SPY	ETF	264.49	264.49	264.32	264.33	53090.0
2017-12-05 09:00:00	SPY	ETF	264.35	264.42	264.35	264.4	106618.0
2017-12-05 09:05:00	SPY	ETF	264.36	264.65	264.36	264.57	74504.0
2017-12-05 09:10:00	SPY	ETF	264.54	264.64	264.54	264.6	35851.0
2017-12-05 09:15:00	SPY	ETF	264.61	264.62	264.58	264.58	73967.0

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

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