PREVIEW / stock_5min / 2017-04-13

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-04-13.parquet
  size:    5.3 MB
  rows:    347,010
  symbols: 3,048

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-13 04:00:00	AAPL	Stock	35.4625	35.4625	35.4625	35.4625	836.0
2017-04-13 04:05:00	AAPL	Stock	35.4	35.4	35.4	35.4	560.0
2017-04-13 04:15:00	AAPL	Stock	35.4	35.4	35.4	35.4	2624.0
2017-04-13 06:10:00	AAPL	Stock	35.385	35.39	35.385	35.39	2000.0
2017-04-13 06:20:00	AAPL	Stock	35.39	35.395	35.39	35.395	2400.0
2017-04-13 07:10:00	AAPL	Stock	35.375	35.375	35.375	35.375	17404.0
2017-04-13 07:20:00	AAPL	Stock	35.3725	35.3725	35.3725	35.3725	400.0
2017-04-13 07:25:00	AAPL	Stock	35.375	35.375	35.375	35.375	8000.0
2017-04-13 07:30:00	AAPL	Stock	35.375	35.375	35.375	35.375	9200.0
2017-04-13 07:35:00	AAPL	Stock	35.375	35.375	35.375	35.375	400.0
2017-04-13 07:45:00	AAPL	Stock	35.3625	35.3625	35.3625	35.3625	436.0
2017-04-13 07:50:00	AAPL	Stock	35.3625	35.3625	35.355	35.355	2964.0
2017-04-13 07:55:00	AAPL	Stock	35.3625	35.3625	35.3625	35.3625	800.0
2017-04-13 08:00:00	AAPL	Stock	35.3725	35.375	35.36	35.36	16240.0
2017-04-13 08:05:00	AAPL	Stock	35.395	35.395	35.395	35.395	1200.0
2017-04-13 08:10:00	AAPL	Stock	35.39	35.395	35.375	35.395	16928.0
2017-04-13 08:20:00	AAPL	Stock	35.4125	35.4125	35.4	35.4	6700.0
2017-04-13 08:25:00	AAPL	Stock	35.4125	35.415	35.4125	35.4125	6604.0
2017-04-13 08:30:00	AAPL	Stock	35.415	35.4175	35.415	35.4175	2400.0
2017-04-13 08:35:00	AAPL	Stock	35.43	35.43	35.43	35.43	800.0
2017-04-13 08:40:00	AAPL	Stock	35.425	35.425	35.425	35.425	400.0
2017-04-13 08:45:00	AAPL	Stock	35.425	35.4275	35.405	35.405	17988.0
2017-04-13 08:50:00	AAPL	Stock	35.42	35.42	35.4	35.4	6700.0
2017-04-13 08:55:00	AAPL	Stock	35.4062	35.4062	35.4	35.4	14000.0
2017-04-13 09:00:00	AAPL	Stock	35.4	35.42	35.395	35.4125	17760.0
2017-04-13 09:05:00	AAPL	Stock	35.4375	35.4375	35.4375	35.4375	1800.0
2017-04-13 09:10:00	AAPL	Stock	35.435	35.435	35.435	35.435	400.0
2017-04-13 09:15:00	AAPL	Stock	35.41	35.4225	35.41	35.4225	64244.0
2017-04-13 09:20:00	AAPL	Stock	35.4225	35.4325	35.4225	35.4325	2400.0
2017-04-13 09:25:00	AAPL	Stock	35.435	35.485	35.435	35.46	66448.0
2017-04-13 09:30:00	AAPL	Stock	35.46	35.4975	35.39	35.4225	3264228.0
2017-04-13 09:35:00	AAPL	Stock	35.42	35.46	35.395	35.4475	1129900.0
2017-04-13 09:40:00	AAPL	Stock	35.4425	35.4425	35.395	35.4275	1200800.0
2017-04-13 09:45:00	AAPL	Stock	35.4312	35.4562	35.415	35.4375	975728.0
2017-04-13 09:50:00	AAPL	Stock	35.44	35.525	35.4275	35.4925	2165744.0
2017-04-13 09:55:00	AAPL	Stock	35.49	35.5325	35.475	35.4965	1093248.0
2017-04-13 10:00:00	AAPL	Stock	35.4975	35.555	35.4968	35.5475	1173352.0
2017-04-13 10:05:00	AAPL	Stock	35.5475	35.555	35.515	35.5275	744000.0
2017-04-13 10:10:00	AAPL	Stock	35.5275	35.55	35.5125	35.5325	632264.0
2017-04-13 10:15:00	AAPL	Stock	35.5325	35.5448	35.5225	35.5275	622424.0
2017-04-13 10:20:00	AAPL	Stock	35.5275	35.545	35.5	35.535	1165612.0
2017-04-13 10:25:00	AAPL	Stock	35.535	35.5475	35.515	35.5225	737528.0
2017-04-13 10:30:00	AAPL	Stock	35.5248	35.544	35.5125	35.5325	711704.0
2017-04-13 10:35:00	AAPL	Stock	35.5325	35.55	35.53	35.545	446228.0
2017-04-13 10:40:00	AAPL	Stock	35.5475	35.55	35.5325	35.5475	337384.0
2017-04-13 10:45:00	AAPL	Stock	35.5475	35.5675	35.5275	35.535	984104.0
2017-04-13 10:50:00	AAPL	Stock	35.535	35.545	35.5148	35.54	728112.0
2017-04-13 10:55:00	AAPL	Stock	35.5412	35.585	35.5412	35.5675	736768.0
2017-04-13 11:00:00	AAPL	Stock	35.5675	35.595	35.5675	35.58	772932.0
2017-04-13 11:05:00	AAPL	Stock	35.5775	35.5875	35.5675	35.5762	445476.0

> showing 50 of 347,010 rows — these rows as CSV

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