PREVIEW / etf_5min / 2017-10-24

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-10-24.parquet
  size:    1.3 MB
  rows:    54,871

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-10-24 04:00:00	SPY	ETF	256.25	256.25	256.25	256.25	300.0
2017-10-24 04:20:00	SPY	ETF	256.24	256.24	256.19	256.19	1300.0
2017-10-24 04:30:00	SPY	ETF	256.22	256.26	256.22	256.26	300.0
2017-10-24 04:35:00	SPY	ETF	256.21	256.21	256.15	256.15	2489.0
2017-10-24 04:40:00	SPY	ETF	256.1	256.16	256.1	256.16	1800.0
2017-10-24 04:45:00	SPY	ETF	256.21	256.21	256.21	256.21	500.0
2017-10-24 04:50:00	SPY	ETF	256.21	256.21	256.21	256.21	300.0
2017-10-24 05:00:00	SPY	ETF	256.29	256.29	256.25	256.25	1100.0
2017-10-24 05:05:00	SPY	ETF	256.26	256.34	256.26	256.34	4403.0
2017-10-24 05:10:00	SPY	ETF	256.35	256.35	256.35	256.35	1001.0
2017-10-24 05:15:00	SPY	ETF	256.35	256.35	256.35	256.35	500.0
2017-10-24 05:20:00	SPY	ETF	256.35	256.36	256.32	256.34	700.0
2017-10-24 05:25:00	SPY	ETF	256.36	256.36	256.36	256.36	102.0
2017-10-24 05:30:00	SPY	ETF	256.34	256.34	256.34	256.34	304.0
2017-10-24 05:35:00	SPY	ETF	256.36	256.39	256.34	256.34	4206.0
2017-10-24 05:40:00	SPY	ETF	256.34	256.34	256.34	256.34	1000.0
2017-10-24 05:45:00	SPY	ETF	256.35	256.39	256.35	256.39	301.0
2017-10-24 05:55:00	SPY	ETF	256.38	256.41	256.38	256.41	501.0
2017-10-24 06:00:00	SPY	ETF	256.39	256.39	256.39	256.39	800.0
2017-10-24 06:05:00	SPY	ETF	256.41	256.44	256.41	256.44	13002.0
2017-10-24 06:10:00	SPY	ETF	256.43	256.43	256.43	256.43	1100.0
2017-10-24 06:15:00	SPY	ETF	256.39	256.39	256.39	256.39	502.0
2017-10-24 06:25:00	SPY	ETF	256.44	256.44	256.44	256.44	1405.0
2017-10-24 06:30:00	SPY	ETF	256.46	256.47	256.46	256.47	1440.0
2017-10-24 06:35:00	SPY	ETF	256.46	256.54	256.46	256.53	2304.0
2017-10-24 06:40:00	SPY	ETF	256.51	256.51	256.5	256.5	801.0
2017-10-24 06:50:00	SPY	ETF	256.45	256.45	256.41	256.42	904.0
2017-10-24 06:55:00	SPY	ETF	256.42	256.42	256.42	256.42	1900.0
2017-10-24 07:00:00	SPY	ETF	256.44	256.49	256.41	256.49	20107.0
2017-10-24 07:05:00	SPY	ETF	256.46	256.46	256.42	256.42	1237.0
2017-10-24 07:10:00	SPY	ETF	256.42	256.42	256.37	256.42	4023.0
2017-10-24 07:15:00	SPY	ETF	256.42	256.42	256.39	256.41	20905.0
2017-10-24 07:20:00	SPY	ETF	256.4	256.43	256.4	256.43	7311.0
2017-10-24 07:25:00	SPY	ETF	256.46	256.48	256.46	256.48	49106.0
2017-10-24 07:30:00	SPY	ETF	256.51	256.53	256.5	256.52	69926.0
2017-10-24 07:35:00	SPY	ETF	256.52	256.57	256.52	256.57	2365.0
2017-10-24 07:40:00	SPY	ETF	256.57	256.57	256.52	256.57	10256.0
2017-10-24 07:45:00	SPY	ETF	256.57	256.57	256.5	256.55	18120.0
2017-10-24 07:50:00	SPY	ETF	256.55	256.59	256.54	256.59	16953.0
2017-10-24 07:55:00	SPY	ETF	256.59	256.69	256.57	256.57	23921.0
2017-10-24 08:00:00	SPY	ETF	256.55	256.63	256.47	256.63	67265.0
2017-10-24 08:05:00	SPY	ETF	256.66	256.67	256.62	256.62	152165.0
2017-10-24 08:10:00	SPY	ETF	256.64	256.64	256.59	256.61	10212.0
2017-10-24 08:15:00	SPY	ETF	256.58	256.59	256.54	256.57	25203.0
2017-10-24 08:20:00	SPY	ETF	256.56	256.6	256.55	256.6	26953.0
2017-10-24 08:25:00	SPY	ETF	256.57	256.61	256.57	256.6	27313.0
2017-10-24 08:30:00	SPY	ETF	256.61	256.71	256.6	256.7	54911.0
2017-10-24 08:35:00	SPY	ETF	256.71	256.71	256.63	256.66	49123.0
2017-10-24 08:40:00	SPY	ETF	256.66	256.68	256.61	256.61	24976.0
2017-10-24 08:45:00	SPY	ETF	256.61	256.66	256.6	256.65	18361.0

> showing 50 of 54,871 rows — these rows as CSV

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