PREVIEW / stock_5min / 2018-08-07

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-08-07.parquet
  size:    5.5 MB
  rows:    351,856
  symbols: 2,779

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
2018-08-07 04:00:00	AAPL	Stock	52.3125	52.3125	52.28	52.28	1600.0
2018-08-07 04:10:00	AAPL	Stock	52.3725	52.39	52.3725	52.3825	15292.0
2018-08-07 04:15:00	AAPL	Stock	52.3825	52.3825	52.3825	52.3825	420.0
2018-08-07 04:30:00	AAPL	Stock	52.385	52.385	52.385	52.385	400.0
2018-08-07 04:40:00	AAPL	Stock	52.44	52.44	52.4375	52.4375	8176.0
2018-08-07 04:55:00	AAPL	Stock	52.4375	52.4375	52.4375	52.4375	5600.0
2018-08-07 05:00:00	AAPL	Stock	52.4375	52.4675	52.4375	52.45	12148.0
2018-08-07 05:05:00	AAPL	Stock	52.45	52.45	52.45	52.45	800.0
2018-08-07 05:10:00	AAPL	Stock	52.45	52.45	52.45	52.45	496.0
2018-08-07 05:20:00	AAPL	Stock	52.425	52.425	52.425	52.425	800.0
2018-08-07 05:25:00	AAPL	Stock	52.425	52.425	52.425	52.425	400.0
2018-08-07 05:40:00	AAPL	Stock	52.445	52.45	52.445	52.45	4540.0
2018-08-07 05:50:00	AAPL	Stock	52.415	52.4225	52.4125	52.4225	3260.0
2018-08-07 05:55:00	AAPL	Stock	52.4225	52.4225	52.4225	52.4225	1200.0
2018-08-07 06:05:00	AAPL	Stock	52.42	52.4225	52.375	52.3825	8572.0
2018-08-07 06:15:00	AAPL	Stock	52.365	52.365	52.36	52.36	1352.0
2018-08-07 06:20:00	AAPL	Stock	52.36	52.36	52.36	52.36	1448.0
2018-08-07 06:25:00	AAPL	Stock	52.365	52.365	52.36	52.36	1244.0
2018-08-07 06:30:00	AAPL	Stock	52.41	52.41	52.41	52.41	400.0
2018-08-07 06:35:00	AAPL	Stock	52.4125	52.4125	52.4125	52.4125	3964.0
2018-08-07 06:40:00	AAPL	Stock	52.4125	52.4125	52.375	52.375	3352.0
2018-08-07 06:55:00	AAPL	Stock	52.4075	52.4125	52.4075	52.4125	3788.0
2018-08-07 07:00:00	AAPL	Stock	52.4125	52.4125	52.36	52.375	23080.0
2018-08-07 07:05:00	AAPL	Stock	52.3725	52.38	52.36	52.375	23488.0
2018-08-07 07:10:00	AAPL	Stock	52.395	52.395	52.375	52.375	8304.0
2018-08-07 07:15:00	AAPL	Stock	52.3825	52.4075	52.3825	52.4075	9640.0
2018-08-07 07:20:00	AAPL	Stock	52.4	52.415	52.395	52.415	5780.0
2018-08-07 07:25:00	AAPL	Stock	52.405	52.405	52.3875	52.3875	3600.0
2018-08-07 07:30:00	AAPL	Stock	52.3875	52.405	52.3825	52.405	2716.0
2018-08-07 07:35:00	AAPL	Stock	52.39	52.4075	52.3875	52.3875	4908.0
2018-08-07 07:40:00	AAPL	Stock	52.3975	52.4	52.3625	52.3625	30568.0
2018-08-07 07:45:00	AAPL	Stock	52.39	52.39	52.39	52.39	400.0
2018-08-07 07:50:00	AAPL	Stock	52.39	52.39	52.375	52.3875	12436.0
2018-08-07 07:55:00	AAPL	Stock	52.385	52.3875	52.3625	52.3625	10112.0
2018-08-07 08:00:00	AAPL	Stock	52.395	52.42	52.36	52.36	84304.0
2018-08-07 08:05:00	AAPL	Stock	52.3725	52.3725	52.3575	52.3575	14436.0
2018-08-07 08:10:00	AAPL	Stock	52.3725	52.3925	52.3725	52.3825	8000.0
2018-08-07 08:15:00	AAPL	Stock	52.3825	52.3825	52.35	52.35	22600.0
2018-08-07 08:20:00	AAPL	Stock	52.345	52.36	52.3375	52.34	18136.0
2018-08-07 08:25:00	AAPL	Stock	52.3375	52.3575	52.3375	52.355	15540.0
2018-08-07 08:30:00	AAPL	Stock	52.3475	52.355	52.315	52.325	49868.0
2018-08-07 08:35:00	AAPL	Stock	52.3375	52.3375	52.3375	52.3375	6000.0
2018-08-07 08:40:00	AAPL	Stock	52.355	52.355	52.3175	52.345	17780.0
2018-08-07 08:45:00	AAPL	Stock	52.345	52.3575	52.3425	52.355	7708.0
2018-08-07 08:50:00	AAPL	Stock	52.35	52.375	52.35	52.37	40632.0
2018-08-07 08:55:00	AAPL	Stock	52.3625	52.37	52.3575	52.37	23720.0
2018-08-07 09:00:00	AAPL	Stock	52.3725	52.3725	52.3125	52.3125	106348.0
2018-08-07 09:05:00	AAPL	Stock	52.3125	52.325	52.275	52.3125	95456.0
2018-08-07 09:10:00	AAPL	Stock	52.3225	52.325	52.31	52.325	41316.0
2018-08-07 09:15:00	AAPL	Stock	52.325	52.325	52.2775	52.2825	118260.0

> showing 50 of 351,856 rows — these rows as CSV

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