PREVIEW / stock_5min / 2017-03-20

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-03-20.parquet
  size:    5.3 MB
  rows:    350,618
  symbols: 3,071

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-03-20 04:00:00	AAPL	Stock	35.035	35.035	35.0	35.0	5016.0
2017-03-20 04:10:00	AAPL	Stock	35.0175	35.0175	35.015	35.015	800.0
2017-03-20 04:20:00	AAPL	Stock	35.015	35.02	35.015	35.02	2000.0
2017-03-20 05:40:00	AAPL	Stock	35.0025	35.0025	35.0025	35.0025	1672.0
2017-03-20 05:50:00	AAPL	Stock	35.015	35.015	35.015	35.015	400.0
2017-03-20 06:00:00	AAPL	Stock	35.07	35.0725	35.07	35.0725	1380.0
2017-03-20 06:05:00	AAPL	Stock	35.07	35.0725	35.07	35.0725	1200.0
2017-03-20 06:30:00	AAPL	Stock	35.045	35.045	35.0325	35.0325	9324.0
2017-03-20 06:35:00	AAPL	Stock	35.0325	35.0325	35.0325	35.0325	1608.0
2017-03-20 06:40:00	AAPL	Stock	35.0325	35.045	35.0325	35.045	1360.0
2017-03-20 06:45:00	AAPL	Stock	35.045	35.045	35.045	35.045	1200.0
2017-03-20 06:50:00	AAPL	Stock	35.045	35.045	35.045	35.045	408.0
2017-03-20 06:55:00	AAPL	Stock	35.045	35.045	35.045	35.045	1648.0
2017-03-20 07:05:00	AAPL	Stock	35.045	35.045	35.045	35.045	400.0
2017-03-20 07:10:00	AAPL	Stock	35.055	35.055	35.055	35.055	2400.0
2017-03-20 07:15:00	AAPL	Stock	35.0575	35.0575	35.0575	35.0575	1200.0
2017-03-20 07:20:00	AAPL	Stock	35.055	35.055	35.055	35.055	800.0
2017-03-20 07:30:00	AAPL	Stock	35.05	35.05	35.05	35.05	1680.0
2017-03-20 07:35:00	AAPL	Stock	35.0625	35.0625	35.0625	35.0625	1200.0
2017-03-20 07:40:00	AAPL	Stock	35.0525	35.0625	35.0525	35.0625	8800.0
2017-03-20 07:45:00	AAPL	Stock	35.0625	35.0625	35.0625	35.0625	2096.0
2017-03-20 08:00:00	AAPL	Stock	35.0625	35.0725	35.0325	35.07	108164.0
2017-03-20 08:05:00	AAPL	Stock	35.0675	35.1225	35.0675	35.1225	34404.0
2017-03-20 08:10:00	AAPL	Stock	35.1175	35.12	35.0625	35.0725	16256.0
2017-03-20 08:15:00	AAPL	Stock	35.0725	35.08	35.0625	35.0625	19128.0
2017-03-20 08:20:00	AAPL	Stock	35.065	35.0775	35.05	35.0775	23252.0
2017-03-20 08:25:00	AAPL	Stock	35.0775	35.0975	35.075	35.0775	4392.0
2017-03-20 08:30:00	AAPL	Stock	35.075	35.0875	35.075	35.075	17348.0
2017-03-20 08:35:00	AAPL	Stock	35.065	35.085	35.065	35.0675	5200.0
2017-03-20 08:40:00	AAPL	Stock	35.085	35.085	35.075	35.075	26400.0
2017-03-20 08:45:00	AAPL	Stock	35.075	35.075	35.0525	35.065	30488.0
2017-03-20 08:50:00	AAPL	Stock	35.065	35.09	35.065	35.09	17844.0
2017-03-20 08:55:00	AAPL	Stock	35.0875	35.0875	35.075	35.075	81820.0
2017-03-20 09:00:00	AAPL	Stock	35.0825	35.085	35.075	35.075	18028.0
2017-03-20 09:05:00	AAPL	Stock	35.0875	35.09	35.0775	35.09	21508.0
2017-03-20 09:10:00	AAPL	Stock	35.0875	35.0925	35.0775	35.0825	6148.0
2017-03-20 09:15:00	AAPL	Stock	35.0875	35.09	35.08	35.08	19120.0
2017-03-20 09:20:00	AAPL	Stock	35.0875	35.095	35.08	35.08	50172.0
2017-03-20 09:25:00	AAPL	Stock	35.0825	35.125	35.0775	35.11	76640.0
2017-03-20 09:30:00	AAPL	Stock	35.1	35.125	35.0625	35.071	3744404.0
2017-03-20 09:35:00	AAPL	Stock	35.07	35.12	35.0575	35.1125	1763748.0
2017-03-20 09:40:00	AAPL	Stock	35.1112	35.1625	35.1025	35.1568	2265120.0
2017-03-20 09:45:00	AAPL	Stock	35.1575	35.1775	35.13	35.14	1594048.0
2017-03-20 09:50:00	AAPL	Stock	35.14	35.1475	35.135	35.1425	731452.0
2017-03-20 09:55:00	AAPL	Stock	35.1425	35.19	35.1425	35.184	1406732.0
2017-03-20 10:00:00	AAPL	Stock	35.1825	35.195	35.175	35.1912	981704.0
2017-03-20 10:05:00	AAPL	Stock	35.1925	35.195	35.1825	35.1875	699156.0
2017-03-20 10:10:00	AAPL	Stock	35.19	35.2112	35.1725	35.2112	1171232.0
2017-03-20 10:15:00	AAPL	Stock	35.2125	35.245	35.21	35.2438	1097672.0
2017-03-20 10:20:00	AAPL	Stock	35.245	35.3325	35.24	35.3025	3274060.0

> showing 50 of 350,618 rows — these rows as CSV

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