PREVIEW / etf_5min / 2017-03-30

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-03-30.parquet
  size:    1.2 MB
  rows:    52,718

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-03-30 04:00:00	SPY	ETF	235.67	235.67	235.67	235.67	188.0
2017-03-30 04:05:00	SPY	ETF	235.57	235.57	235.57	235.57	400.0
2017-03-30 04:10:00	SPY	ETF	235.6	235.62	235.6	235.62	2000.0
2017-03-30 04:15:00	SPY	ETF	235.6	235.62	235.6	235.62	900.0
2017-03-30 04:20:00	SPY	ETF	235.6	235.6	235.6	235.6	700.0
2017-03-30 04:25:00	SPY	ETF	235.55	235.58	235.55	235.58	600.0
2017-03-30 04:30:00	SPY	ETF	235.59	235.59	235.59	235.59	300.0
2017-03-30 04:35:00	SPY	ETF	235.57	235.57	235.57	235.57	3300.0
2017-03-30 04:40:00	SPY	ETF	235.39	235.39	235.39	235.39	300.0
2017-03-30 04:45:00	SPY	ETF	235.34	235.34	235.34	235.34	500.0
2017-03-30 04:50:00	SPY	ETF	235.32	235.32	235.25	235.27	6040.0
2017-03-30 04:55:00	SPY	ETF	235.27	235.27	235.27	235.27	2200.0
2017-03-30 05:00:00	SPY	ETF	235.27	235.3	235.27	235.3	1701.0
2017-03-30 05:05:00	SPY	ETF	235.3	235.3	235.3	235.3	4100.0
2017-03-30 05:10:00	SPY	ETF	235.33	235.33	235.33	235.33	1499.0
2017-03-30 05:15:00	SPY	ETF	235.33	235.33	235.33	235.33	1100.0
2017-03-30 05:20:00	SPY	ETF	235.3	235.3	235.3	235.3	652.0
2017-03-30 05:25:00	SPY	ETF	235.29	235.31	235.29	235.31	700.0
2017-03-30 05:35:00	SPY	ETF	235.34	235.34	235.34	235.34	2403.0
2017-03-30 05:40:00	SPY	ETF	235.36	235.36	235.34	235.34	1901.0
2017-03-30 05:45:00	SPY	ETF	235.36	235.36	235.36	235.36	300.0
2017-03-30 05:55:00	SPY	ETF	235.31	235.34	235.31	235.34	1450.0
2017-03-30 06:05:00	SPY	ETF	235.29	235.29	235.29	235.29	1000.0
2017-03-30 06:10:00	SPY	ETF	235.27	235.27	235.27	235.27	431.0
2017-03-30 06:45:00	SPY	ETF	235.23	235.23	235.21	235.21	10000.0
2017-03-30 06:50:00	SPY	ETF	235.22	235.22	235.22	235.22	200.0
2017-03-30 06:55:00	SPY	ETF	235.26	235.26	235.26	235.26	100.0
2017-03-30 07:00:00	SPY	ETF	235.24	235.24	235.2	235.2	21760.0
2017-03-30 07:05:00	SPY	ETF	235.2	235.23	235.2	235.22	13201.0
2017-03-30 07:10:00	SPY	ETF	235.2	235.2	235.2	235.2	1003.0
2017-03-30 07:15:00	SPY	ETF	235.23	235.3	235.23	235.29	30552.0
2017-03-30 07:20:00	SPY	ETF	235.29	235.29	235.26	235.26	2948.0
2017-03-30 07:25:00	SPY	ETF	235.25	235.27	235.25	235.27	3099.0
2017-03-30 07:30:00	SPY	ETF	235.26	235.28	235.26	235.28	600.0
2017-03-30 07:35:00	SPY	ETF	235.29	235.29	235.22	235.23	7872.0
2017-03-30 07:40:00	SPY	ETF	235.28	235.29	235.28	235.29	1901.0
2017-03-30 07:45:00	SPY	ETF	235.35	235.35	235.31	235.31	2900.0
2017-03-30 07:50:00	SPY	ETF	235.33	235.35	235.26	235.26	46905.0
2017-03-30 07:55:00	SPY	ETF	235.26	235.31	235.26	235.31	1850.0
2017-03-30 08:00:00	SPY	ETF	235.31	235.32	235.21	235.3	15038.0
2017-03-30 08:05:00	SPY	ETF	235.29	235.3	235.29	235.3	300.0
2017-03-30 08:10:00	SPY	ETF	235.31	235.35	235.28	235.31	30354.0
2017-03-30 08:15:00	SPY	ETF	235.3	235.32	235.3	235.32	5751.0
2017-03-30 08:20:00	SPY	ETF	235.33	235.38	235.33	235.36	19884.0
2017-03-30 08:25:00	SPY	ETF	235.35	235.4	235.34	235.4	36942.0
2017-03-30 08:30:00	SPY	ETF	235.43	235.52	235.43	235.52	162443.0
2017-03-30 08:35:00	SPY	ETF	235.51	235.55	235.45	235.48	59952.0
2017-03-30 08:40:00	SPY	ETF	235.48	235.54	235.47	235.52	28730.0
2017-03-30 08:45:00	SPY	ETF	235.5	235.5	235.44	235.44	3360.0
2017-03-30 08:50:00	SPY	ETF	235.45	235.46	235.42	235.42	6542.0

> showing 50 of 52,718 rows — these rows as CSV

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