PREVIEW / stock_5min / 2016-08-24

all stock 5-min files

  file:    by_date/stock_5min/2016/2016-08-24.parquet
  size:    5.3 MB
  rows:    346,155
  symbols: 3,267

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-08-24 04:10:00	AAPL	Stock	27.235	27.235	27.235	27.235	824.0
2016-08-24 06:10:00	AAPL	Stock	27.23	27.23	27.23	27.23	400.0
2016-08-24 06:15:00	AAPL	Stock	27.2425	27.2425	27.2425	27.2425	800.0
2016-08-24 06:55:00	AAPL	Stock	27.2125	27.2125	27.2125	27.2125	400.0
2016-08-24 07:00:00	AAPL	Stock	27.215	27.215	27.215	27.215	1600.0
2016-08-24 07:05:00	AAPL	Stock	27.205	27.245	27.205	27.245	3060.0
2016-08-24 07:20:00	AAPL	Stock	27.205	27.205	27.205	27.205	400.0
2016-08-24 07:40:00	AAPL	Stock	27.2075	27.2075	27.2075	27.2075	1000.0
2016-08-24 07:45:00	AAPL	Stock	27.2125	27.2125	27.2125	27.2125	1600.0
2016-08-24 07:50:00	AAPL	Stock	27.2225	27.2225	27.2225	27.2225	400.0
2016-08-24 08:00:00	AAPL	Stock	27.215	27.2175	27.215	27.2175	1600.0
2016-08-24 08:10:00	AAPL	Stock	27.2375	27.2375	27.2275	27.2275	5924.0
2016-08-24 08:30:00	AAPL	Stock	27.23	27.2325	27.23	27.2325	3028.0
2016-08-24 08:35:00	AAPL	Stock	27.2275	27.2275	27.2275	27.2275	2000.0
2016-08-24 08:40:00	AAPL	Stock	27.2275	27.24	27.2275	27.24	5380.0
2016-08-24 08:45:00	AAPL	Stock	27.24	27.24	27.2375	27.2375	4604.0
2016-08-24 08:50:00	AAPL	Stock	27.24	27.24	27.24	27.24	2400.0
2016-08-24 08:55:00	AAPL	Stock	27.24	27.2425	27.2325	27.2325	5232.0
2016-08-24 09:00:00	AAPL	Stock	27.23	27.2325	27.215	27.215	20600.0
2016-08-24 09:05:00	AAPL	Stock	27.24	27.24	27.215	27.215	4800.0
2016-08-24 09:10:00	AAPL	Stock	27.2175	27.22	27.2125	27.215	19824.0
2016-08-24 09:15:00	AAPL	Stock	27.2125	27.2125	27.2125	27.2125	2400.0
2016-08-24 09:20:00	AAPL	Stock	27.2075	27.21	27.1925	27.1925	55240.0
2016-08-24 09:25:00	AAPL	Stock	27.18	27.205	27.1425	27.1425	113396.0
2016-08-24 09:30:00	AAPL	Stock	27.1425	27.1875	27.0775	27.1325	4509184.0
2016-08-24 09:35:00	AAPL	Stock	27.135	27.1575	27.095	27.0975	1886644.0
2016-08-24 09:40:00	AAPL	Stock	27.0975	27.1025	27.065	27.0875	1884128.0
2016-08-24 09:45:00	AAPL	Stock	27.09	27.09	27.0425	27.0762	1544120.0
2016-08-24 09:50:00	AAPL	Stock	27.0762	27.0775	27.03	27.0415	1957560.0
2016-08-24 09:55:00	AAPL	Stock	27.041	27.075	27.0362	27.066	1135220.0
2016-08-24 10:00:00	AAPL	Stock	27.0675	27.085	27.04	27.06	1508980.0
2016-08-24 10:05:00	AAPL	Stock	27.06	27.095	27.0575	27.0812	1305084.0
2016-08-24 10:10:00	AAPL	Stock	27.0775	27.0975	27.065	27.0925	854712.0
2016-08-24 10:15:00	AAPL	Stock	27.0925	27.0975	27.06	27.0745	860780.0
2016-08-24 10:20:00	AAPL	Stock	27.0725	27.085	27.0638	27.0775	671348.0
2016-08-24 10:25:00	AAPL	Stock	27.0775	27.0925	27.0675	27.0875	626244.0
2016-08-24 10:30:00	AAPL	Stock	27.0875	27.0875	27.0525	27.055	1405420.0
2016-08-24 10:35:00	AAPL	Stock	27.055	27.07	27.04	27.0422	1171664.0
2016-08-24 10:40:00	AAPL	Stock	27.0412	27.0425	27.0125	27.03	1542596.0
2016-08-24 10:45:00	AAPL	Stock	27.0275	27.0375	27.0	27.0275	1466916.0
2016-08-24 10:50:00	AAPL	Stock	27.0275	27.055	27.025	27.04	817580.0
2016-08-24 10:55:00	AAPL	Stock	27.0402	27.0425	27.0225	27.0325	756720.0
2016-08-24 11:00:00	AAPL	Stock	27.035	27.065	27.0325	27.0575	852704.0
2016-08-24 11:05:00	AAPL	Stock	27.0575	27.06	27.04	27.0525	778640.0
2016-08-24 11:10:00	AAPL	Stock	27.05	27.0525	27.02	27.02	544600.0
2016-08-24 11:15:00	AAPL	Stock	27.0225	27.025	27.0075	27.025	1116904.0
2016-08-24 11:20:00	AAPL	Stock	27.0238	27.0275	26.99	26.9975	1482940.0
2016-08-24 11:25:00	AAPL	Stock	26.995	27.02	26.9812	27.0088	1203952.0
2016-08-24 11:30:00	AAPL	Stock	27.0075	27.0125	26.9825	27.0	812980.0
2016-08-24 11:35:00	AAPL	Stock	27.001	27.0275	26.995	27.0225	819420.0

> showing 50 of 346,155 rows — these rows as CSV

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