PREVIEW / stock_5min / 2016-11-17

all stock 5-min files

  file:    by_date/stock_5min/2016/2016-11-17.parquet
  size:    5.5 MB
  rows:    363,247
  symbols: 3,189

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
2016-11-17 04:05:00	AAPL	Stock	27.4975	27.4975	27.4975	27.4975	2012.0
2016-11-17 04:20:00	AAPL	Stock	27.4975	27.4975	27.4975	27.4975	600.0
2016-11-17 04:30:00	AAPL	Stock	27.4975	27.4975	27.4975	27.4975	1420.0
2016-11-17 05:20:00	AAPL	Stock	27.46	27.46	27.46	27.46	3988.0
2016-11-17 06:15:00	AAPL	Stock	27.45	27.45	27.45	27.45	3988.0
2016-11-17 06:45:00	AAPL	Stock	27.44	27.44	27.44	27.44	1080.0
2016-11-17 07:15:00	AAPL	Stock	27.465	27.465	27.465	27.465	1200.0
2016-11-17 07:20:00	AAPL	Stock	27.465	27.465	27.46	27.465	2640.0
2016-11-17 07:35:00	AAPL	Stock	27.5	27.5325	27.5	27.5325	1616.0
2016-11-17 07:40:00	AAPL	Stock	27.53	27.53	27.53	27.53	4000.0
2016-11-17 07:45:00	AAPL	Stock	27.5125	27.5125	27.48	27.48	8000.0
2016-11-17 08:00:00	AAPL	Stock	27.475	27.5425	27.4425	27.475	36416.0
2016-11-17 08:05:00	AAPL	Stock	27.465	27.4875	27.465	27.485	13600.0
2016-11-17 08:10:00	AAPL	Stock	27.475	27.4875	27.475	27.48	20840.0
2016-11-17 08:15:00	AAPL	Stock	27.4875	27.52	27.4875	27.5025	18568.0
2016-11-17 08:20:00	AAPL	Stock	27.5125	27.5125	27.5125	27.5125	3120.0
2016-11-17 08:25:00	AAPL	Stock	27.5	27.5	27.5	27.5	21500.0
2016-11-17 08:30:00	AAPL	Stock	27.48	27.5	27.45	27.45	9844.0
2016-11-17 08:35:00	AAPL	Stock	27.475	27.4975	27.465	27.465	21744.0
2016-11-17 08:40:00	AAPL	Stock	27.48	27.4875	27.46	27.485	8608.0
2016-11-17 08:45:00	AAPL	Stock	27.46	27.46	27.4575	27.46	14820.0
2016-11-17 08:50:00	AAPL	Stock	27.48	27.4875	27.4775	27.4775	26492.0
2016-11-17 08:55:00	AAPL	Stock	27.4775	27.495	27.45	27.45	31676.0
2016-11-17 09:00:00	AAPL	Stock	27.47	27.47	27.45	27.455	29656.0
2016-11-17 09:05:00	AAPL	Stock	27.465	27.465	27.4375	27.445	41904.0
2016-11-17 09:10:00	AAPL	Stock	27.4675	27.4675	27.4375	27.4375	207292.0
2016-11-17 09:15:00	AAPL	Stock	27.45	27.4575	27.45	27.45	13872.0
2016-11-17 09:20:00	AAPL	Stock	27.45	27.465	27.445	27.4525	2824.0
2016-11-17 09:25:00	AAPL	Stock	27.4675	27.4675	27.43	27.44	21680.0
2016-11-17 09:30:00	AAPL	Stock	27.455	27.5875	27.3775	27.51	5320968.0
2016-11-17 09:35:00	AAPL	Stock	27.51	27.55	27.3312	27.3425	3376632.0
2016-11-17 09:40:00	AAPL	Stock	27.3425	27.4425	27.335	27.4325	2697588.0
2016-11-17 09:45:00	AAPL	Stock	27.4325	27.505	27.41	27.4925	2162268.0
2016-11-17 09:50:00	AAPL	Stock	27.49	27.495	27.3525	27.3575	1652924.0
2016-11-17 09:55:00	AAPL	Stock	27.3575	27.4225	27.3575	27.4175	1680076.0
2016-11-17 10:00:00	AAPL	Stock	27.4175	27.4275	27.3625	27.39	1618280.0
2016-11-17 10:05:00	AAPL	Stock	27.39	27.42	27.375	27.3948	1203548.0
2016-11-17 10:10:00	AAPL	Stock	27.3925	27.4025	27.2925	27.295	2253448.0
2016-11-17 10:15:00	AAPL	Stock	27.2975	27.345	27.275	27.345	1809324.0
2016-11-17 10:20:00	AAPL	Stock	27.3425	27.375	27.31	27.31	1476408.0
2016-11-17 10:25:00	AAPL	Stock	27.311	27.3325	27.2875	27.2988	1147104.0
2016-11-17 10:30:00	AAPL	Stock	27.2975	27.329	27.2825	27.2875	1426252.0
2016-11-17 10:35:00	AAPL	Stock	27.286	27.3675	27.2075	27.35	4183996.0
2016-11-17 10:40:00	AAPL	Stock	27.3475	27.357	27.305	27.315	1104544.0
2016-11-17 10:45:00	AAPL	Stock	27.32	27.325	27.3	27.315	736304.0
2016-11-17 10:50:00	AAPL	Stock	27.315	27.32	27.2525	27.2525	1508024.0
2016-11-17 10:55:00	AAPL	Stock	27.2528	27.2725	27.23	27.2328	1393452.0
2016-11-17 11:00:00	AAPL	Stock	27.2325	27.26	27.2125	27.255	1312576.0
2016-11-17 11:05:00	AAPL	Stock	27.255	27.3	27.2475	27.2512	1453404.0
2016-11-17 11:10:00	AAPL	Stock	27.25	27.2822	27.24	27.255	1393624.0

> showing 50 of 363,247 rows — these rows as CSV

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