PREVIEW / etf_5min / 2017-04-24

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-04-24.parquet
  size:    1.3 MB
  rows:    55,480

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-04-24 04:00:00	SPY	ETF	237.06	237.32	237.06	237.32	10018.0
2017-04-24 04:05:00	SPY	ETF	237.15	237.17	237.09	237.17	1285.0
2017-04-24 04:10:00	SPY	ETF	237.13	237.16	237.13	237.16	11150.0
2017-04-24 04:15:00	SPY	ETF	237.16	237.25	237.16	237.25	2429.0
2017-04-24 04:20:00	SPY	ETF	237.2	237.2	237.2	237.2	500.0
2017-04-24 04:25:00	SPY	ETF	237.14	237.2	237.14	237.2	245.0
2017-04-24 04:30:00	SPY	ETF	237.22	237.22	237.22	237.22	3462.0
2017-04-24 04:35:00	SPY	ETF	237.24	237.24	237.19	237.19	402.0
2017-04-24 04:40:00	SPY	ETF	237.2	237.2	237.2	237.2	306.0
2017-04-24 04:45:00	SPY	ETF	237.2	237.21	237.19	237.19	1006.0
2017-04-24 04:50:00	SPY	ETF	237.21	237.21	237.21	237.21	1404.0
2017-04-24 04:55:00	SPY	ETF	237.24	237.36	237.24	237.36	3258.0
2017-04-24 05:00:00	SPY	ETF	237.36	237.36	237.25	237.25	3120.0
2017-04-24 05:05:00	SPY	ETF	237.37	237.38	237.37	237.38	1705.0
2017-04-24 05:10:00	SPY	ETF	237.35	237.4	237.35	237.4	6884.0
2017-04-24 05:15:00	SPY	ETF	237.41	237.41	237.32	237.32	1605.0
2017-04-24 05:20:00	SPY	ETF	237.34	237.34	237.3	237.34	5001.0
2017-04-24 05:25:00	SPY	ETF	237.47	237.47	237.4	237.4	3351.0
2017-04-24 05:30:00	SPY	ETF	237.4	237.4	237.4	237.4	401.0
2017-04-24 05:35:00	SPY	ETF	237.41	237.44	237.4	237.4	3051.0
2017-04-24 05:40:00	SPY	ETF	237.41	237.41	237.37	237.37	1003.0
2017-04-24 05:45:00	SPY	ETF	237.3	237.3	237.3	237.3	432.0
2017-04-24 05:50:00	SPY	ETF	237.39	237.39	237.39	237.39	301.0
2017-04-24 05:55:00	SPY	ETF	237.39	237.41	237.39	237.41	651.0
2017-04-24 06:00:00	SPY	ETF	237.39	237.44	237.39	237.4	2828.0
2017-04-24 06:05:00	SPY	ETF	237.4	237.52	237.4	237.47	7596.0
2017-04-24 06:10:00	SPY	ETF	237.46	237.69	237.46	237.64	18625.0
2017-04-24 06:15:00	SPY	ETF	237.69	237.71	237.63	237.69	2823.0
2017-04-24 06:20:00	SPY	ETF	237.69	237.69	237.69	237.69	101.0
2017-04-24 06:25:00	SPY	ETF	237.65	237.65	237.59	237.59	11802.0
2017-04-24 06:30:00	SPY	ETF	237.56	237.6	237.53	237.58	9240.0
2017-04-24 06:35:00	SPY	ETF	237.54	237.57	237.53	237.55	16148.0
2017-04-24 06:40:00	SPY	ETF	237.55	237.55	237.55	237.55	400.0
2017-04-24 06:45:00	SPY	ETF	237.47	237.49	237.47	237.49	9076.0
2017-04-24 06:50:00	SPY	ETF	237.5	237.52	237.49	237.5	1800.0
2017-04-24 06:55:00	SPY	ETF	237.55	237.55	237.5	237.54	21524.0
2017-04-24 07:00:00	SPY	ETF	237.47	237.5	237.44	237.44	29123.0
2017-04-24 07:05:00	SPY	ETF	237.46	237.48	237.43	237.45	40168.0
2017-04-24 07:10:00	SPY	ETF	237.44	237.44	237.38	237.4	22534.0
2017-04-24 07:15:00	SPY	ETF	237.4	237.4	237.34	237.36	17641.0
2017-04-24 07:20:00	SPY	ETF	237.34	237.36	237.3	237.35	18005.0
2017-04-24 07:25:00	SPY	ETF	237.34	237.42	237.3	237.42	44513.0
2017-04-24 07:30:00	SPY	ETF	237.41	237.41	237.35	237.35	28798.0
2017-04-24 07:35:00	SPY	ETF	237.34	237.34	237.26	237.31	28980.0
2017-04-24 07:40:00	SPY	ETF	237.31	237.39	237.31	237.39	74050.0
2017-04-24 07:45:00	SPY	ETF	237.38	237.44	237.36	237.38	108517.0
2017-04-24 07:50:00	SPY	ETF	237.4	237.47	237.39	237.46	93002.0
2017-04-24 07:55:00	SPY	ETF	237.45	237.46	237.41	237.42	47528.0
2017-04-24 08:00:00	SPY	ETF	237.42	237.49	237.3	237.43	122987.0
2017-04-24 08:05:00	SPY	ETF	237.43	237.5	234.59	237.48	261558.0

> showing 50 of 55,480 rows — these rows as CSV

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