PREVIEW / stock_5min / 2017-07-19

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-07-19.parquet
  size:    5.3 MB
  rows:    347,660
  symbols: 2,996

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-07-19 04:20:00	AAPL	Stock	37.5875	37.5875	37.575	37.575	4400.0
2017-07-19 04:40:00	AAPL	Stock	37.6125	37.6125	37.6125	37.6125	400.0
2017-07-19 05:20:00	AAPL	Stock	37.565	37.565	37.525	37.525	1884.0
2017-07-19 05:25:00	AAPL	Stock	37.525	37.525	37.525	37.525	2668.0
2017-07-19 05:45:00	AAPL	Stock	37.5925	37.5925	37.5925	37.5925	400.0
2017-07-19 06:40:00	AAPL	Stock	37.585	37.5875	37.585	37.5875	3008.0
2017-07-19 06:50:00	AAPL	Stock	37.5875	37.5875	37.5875	37.5875	800.0
2017-07-19 07:05:00	AAPL	Stock	37.5875	37.6125	37.5875	37.6125	2400.0
2017-07-19 07:10:00	AAPL	Stock	37.6125	37.6125	37.6125	37.6125	5420.0
2017-07-19 07:15:00	AAPL	Stock	37.6075	37.6075	37.5925	37.5925	800.0
2017-07-19 07:25:00	AAPL	Stock	37.6175	37.6175	37.6125	37.6125	4800.0
2017-07-19 07:35:00	AAPL	Stock	37.6125	37.6125	37.6125	37.6125	7924.0
2017-07-19 07:40:00	AAPL	Stock	37.6	37.6	37.6	37.6	3736.0
2017-07-19 07:45:00	AAPL	Stock	37.5875	37.5875	37.5675	37.5675	6248.0
2017-07-19 07:50:00	AAPL	Stock	37.5625	37.5625	37.5625	37.5625	800.0
2017-07-19 07:55:00	AAPL	Stock	37.575	37.575	37.565	37.565	29808.0
2017-07-19 08:00:00	AAPL	Stock	37.6125	37.6125	37.4375	37.565	20752.0
2017-07-19 08:05:00	AAPL	Stock	37.5775	37.5875	37.5775	37.5875	29192.0
2017-07-19 08:15:00	AAPL	Stock	37.585	37.5925	37.575	37.575	14984.0
2017-07-19 08:20:00	AAPL	Stock	37.605	37.6125	37.605	37.6125	2480.0
2017-07-19 08:25:00	AAPL	Stock	37.6125	37.615	37.5875	37.615	10300.0
2017-07-19 08:30:00	AAPL	Stock	37.61	37.61	37.61	37.61	3600.0
2017-07-19 08:35:00	AAPL	Stock	37.59	37.6	37.59	37.6	3216.0
2017-07-19 08:40:00	AAPL	Stock	37.6025	37.6025	37.5875	37.5875	1416.0
2017-07-19 08:45:00	AAPL	Stock	37.5825	37.5925	37.57	37.57	4536.0
2017-07-19 08:50:00	AAPL	Stock	37.575	37.5875	37.575	37.5775	8024.0
2017-07-19 08:55:00	AAPL	Stock	37.575	37.595	37.575	37.5875	19892.0
2017-07-19 09:00:00	AAPL	Stock	37.6	37.6	37.5875	37.5925	15860.0
2017-07-19 09:05:00	AAPL	Stock	37.59	37.5925	37.5875	37.5925	6000.0
2017-07-19 09:10:00	AAPL	Stock	37.6	37.6175	37.595	37.61	24488.0
2017-07-19 09:15:00	AAPL	Stock	37.6125	37.62	37.6	37.6	21524.0
2017-07-19 09:25:00	AAPL	Stock	37.6125	37.65	37.595	37.62	85220.0
2017-07-19 09:30:00	AAPL	Stock	37.61	37.6425	37.4875	37.5075	2906368.0
2017-07-19 09:35:00	AAPL	Stock	37.5075	37.7375	37.5025	37.735	2353712.0
2017-07-19 09:40:00	AAPL	Stock	37.7362	37.7375	37.6725	37.7	1233236.0
2017-07-19 09:45:00	AAPL	Stock	37.7	37.7125	37.609	37.625	1358864.0
2017-07-19 09:50:00	AAPL	Stock	37.6262	37.65	37.575	37.625	1397632.0
2017-07-19 09:55:00	AAPL	Stock	37.625	37.675	37.62	37.6625	1222048.0
2017-07-19 10:00:00	AAPL	Stock	37.66	37.7025	37.6325	37.6785	1331792.0
2017-07-19 10:05:00	AAPL	Stock	37.68	37.6862	37.6525	37.655	970996.0
2017-07-19 10:10:00	AAPL	Stock	37.655	37.665	37.6	37.61	1141352.0
2017-07-19 10:15:00	AAPL	Stock	37.6078	37.6225	37.5625	37.605	1133952.0
2017-07-19 10:20:00	AAPL	Stock	37.6025	37.6138	37.5638	37.605	1084152.0
2017-07-19 10:25:00	AAPL	Stock	37.6025	37.65	37.602	37.6275	915676.0
2017-07-19 10:30:00	AAPL	Stock	37.63	37.6575	37.6275	37.6475	838036.0
2017-07-19 10:35:00	AAPL	Stock	37.645	37.65	37.5875	37.6025	665732.0
2017-07-19 10:40:00	AAPL	Stock	37.6	37.6125	37.5725	37.5862	699536.0
2017-07-19 10:45:00	AAPL	Stock	37.585	37.655	37.583	37.6412	816416.0
2017-07-19 10:50:00	AAPL	Stock	37.64	37.647	37.62	37.6225	354728.0
2017-07-19 10:55:00	AAPL	Stock	37.6225	37.6225	37.5925	37.6025	586964.0

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

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