PREVIEW / etf_5min / 2017-02-23

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-02-23.parquet
  size:    1.3 MB
  rows:    56,436

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-02-23 04:00:00	SPY	ETF	236.27	236.27	236.27	236.27	388.0
2017-02-23 04:20:00	SPY	ETF	236.46	236.46	236.46	236.46	100.0
2017-02-23 04:40:00	SPY	ETF	236.5	236.54	236.5	236.54	925.0
2017-02-23 04:50:00	SPY	ETF	236.54	236.58	236.54	236.58	2400.0
2017-02-23 05:15:00	SPY	ETF	236.49	236.49	236.49	236.49	400.0
2017-02-23 05:20:00	SPY	ETF	236.44	236.47	236.44	236.47	1300.0
2017-02-23 05:30:00	SPY	ETF	236.52	236.52	236.52	236.52	300.0
2017-02-23 05:40:00	SPY	ETF	236.52	236.52	236.52	236.52	100.0
2017-02-23 05:55:00	SPY	ETF	236.47	236.47	236.47	236.47	300.0
2017-02-23 06:05:00	SPY	ETF	236.38	236.38	236.38	236.38	400.0
2017-02-23 06:15:00	SPY	ETF	236.42	236.42	236.42	236.42	1000.0
2017-02-23 06:20:00	SPY	ETF	236.42	236.42	236.39	236.39	1100.0
2017-02-23 06:25:00	SPY	ETF	236.39	236.39	236.39	236.39	100.0
2017-02-23 06:30:00	SPY	ETF	236.37	236.41	236.37	236.41	25500.0
2017-02-23 06:45:00	SPY	ETF	236.45	236.45	236.45	236.45	100.0
2017-02-23 07:00:00	SPY	ETF	236.46	236.58	236.44	236.56	10500.0
2017-02-23 07:05:00	SPY	ETF	236.41	236.41	236.36	236.36	1600.0
2017-02-23 07:10:00	SPY	ETF	236.39	236.42	236.39	236.42	3300.0
2017-02-23 07:15:00	SPY	ETF	236.42	236.42	236.41	236.42	3600.0
2017-02-23 07:20:00	SPY	ETF	236.44	236.49	236.44	236.48	29350.0
2017-02-23 07:25:00	SPY	ETF	236.45	236.48	236.44	236.48	3400.0
2017-02-23 07:30:00	SPY	ETF	236.46	236.52	236.46	236.5	3674.0
2017-02-23 07:35:00	SPY	ETF	236.46	236.46	236.45	236.45	2100.0
2017-02-23 07:40:00	SPY	ETF	236.51	236.64	236.51	236.61	22050.0
2017-02-23 07:45:00	SPY	ETF	236.56	236.7	236.56	236.7	13613.0
2017-02-23 07:50:00	SPY	ETF	236.62	236.62	236.54	236.62	15523.0
2017-02-23 07:55:00	SPY	ETF	236.62	236.64	236.62	236.64	3000.0
2017-02-23 08:00:00	SPY	ETF	236.44	236.66	236.42	236.62	51320.0
2017-02-23 08:05:00	SPY	ETF	236.65	236.65	236.57	236.62	70644.0
2017-02-23 08:10:00	SPY	ETF	236.62	236.67	236.58	236.58	16850.0
2017-02-23 08:15:00	SPY	ETF	236.59	236.65	236.57	236.65	14207.0
2017-02-23 08:20:00	SPY	ETF	236.66	236.66	236.58	236.6	6727.0
2017-02-23 08:25:00	SPY	ETF	236.61	236.68	236.61	236.63	16200.0
2017-02-23 08:30:00	SPY	ETF	236.63	236.65	236.6	236.62	12595.0
2017-02-23 08:35:00	SPY	ETF	236.61	236.67	236.59	236.66	17835.0
2017-02-23 08:40:00	SPY	ETF	236.66	236.67	236.63	236.64	13755.0
2017-02-23 08:45:00	SPY	ETF	236.64	236.75	236.64	236.69	86986.0
2017-02-23 08:50:00	SPY	ETF	236.69	236.73	236.67	236.72	17988.0
2017-02-23 08:55:00	SPY	ETF	236.71	236.72	236.66	236.72	11875.0
2017-02-23 09:00:00	SPY	ETF	236.73	236.82	236.73	236.82	46269.0
2017-02-23 09:05:00	SPY	ETF	236.8	236.89	236.78	236.78	26530.0
2017-02-23 09:10:00	SPY	ETF	236.78	236.8	236.7	236.79	38407.0
2017-02-23 09:15:00	SPY	ETF	236.8	236.89	236.78	236.89	21502.0
2017-02-23 09:20:00	SPY	ETF	236.87	236.92	236.87	236.91	50260.0
2017-02-23 09:25:00	SPY	ETF	236.91	236.99	236.86	236.87	172590.0
2017-02-23 09:30:00	SPY	ETF	236.88	236.9	236.73	236.84	1975766.0
2017-02-23 09:35:00	SPY	ETF	236.84	236.86	236.65	236.75	1783336.0
2017-02-23 09:40:00	SPY	ETF	236.76	236.77	236.58	236.61	1200493.0
2017-02-23 09:45:00	SPY	ETF	236.615	236.65	236.52	236.6184	1116713.0
2017-02-23 09:50:00	SPY	ETF	236.62	236.69	236.58	236.65	547100.0

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

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