PREVIEW / stock_5min / 2017-06-20

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-06-20.parquet
  size:    5.3 MB
  rows:    349,923
  symbols: 3,012

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-06-20 04:20:00	AAPL	Stock	36.75	36.75	36.75	36.75	1292.0
2017-06-20 04:50:00	AAPL	Stock	36.75	36.8225	36.75	36.8225	4908.0
2017-06-20 05:00:00	AAPL	Stock	36.82	36.82	36.82	36.82	3760.0
2017-06-20 05:05:00	AAPL	Stock	36.775	36.775	36.775	36.775	796.0
2017-06-20 05:10:00	AAPL	Stock	36.775	36.775	36.775	36.775	3204.0
2017-06-20 06:25:00	AAPL	Stock	36.7725	36.7725	36.7725	36.7725	400.0
2017-06-20 06:30:00	AAPL	Stock	36.7725	36.7725	36.7725	36.7725	600.0
2017-06-20 06:40:00	AAPL	Stock	36.69	36.69	36.69	36.69	400.0
2017-06-20 06:45:00	AAPL	Stock	36.695	36.75	36.695	36.75	3200.0
2017-06-20 06:50:00	AAPL	Stock	36.75	36.75	36.75	36.75	13104.0
2017-06-20 07:00:00	AAPL	Stock	36.7625	36.77	36.75	36.7625	10640.0
2017-06-20 07:05:00	AAPL	Stock	36.7625	36.7625	36.75	36.755	11200.0
2017-06-20 07:10:00	AAPL	Stock	36.75	36.75	36.75	36.75	12732.0
2017-06-20 07:15:00	AAPL	Stock	36.73	36.7325	36.725	36.725	12536.0
2017-06-20 07:20:00	AAPL	Stock	36.725	36.725	36.725	36.725	6000.0
2017-06-20 07:25:00	AAPL	Stock	36.69	36.69	36.6875	36.6875	2676.0
2017-06-20 07:30:00	AAPL	Stock	36.72	36.725	36.7	36.7125	16300.0
2017-06-20 07:35:00	AAPL	Stock	36.7225	36.7225	36.7225	36.7225	716.0
2017-06-20 07:45:00	AAPL	Stock	36.7475	36.7475	36.7475	36.7475	1860.0
2017-06-20 07:50:00	AAPL	Stock	36.7275	36.7275	36.725	36.725	2800.0
2017-06-20 07:55:00	AAPL	Stock	36.7475	36.7725	36.7475	36.7725	12000.0
2017-06-20 08:00:00	AAPL	Stock	36.79	36.79	36.69	36.7075	128088.0
2017-06-20 08:05:00	AAPL	Stock	36.7075	36.725	36.7	36.7	43116.0
2017-06-20 08:10:00	AAPL	Stock	36.7	36.71	36.6525	36.6525	84592.0
2017-06-20 08:15:00	AAPL	Stock	36.6525	36.6725	36.65	36.65	29752.0
2017-06-20 08:20:00	AAPL	Stock	36.64	36.65	36.625	36.6325	53000.0
2017-06-20 08:25:00	AAPL	Stock	36.635	36.6475	36.635	36.64	31268.0
2017-06-20 08:30:00	AAPL	Stock	36.635	36.675	36.635	36.6425	62680.0
2017-06-20 08:35:00	AAPL	Stock	36.6575	36.66	36.6425	36.66	11504.0
2017-06-20 08:40:00	AAPL	Stock	36.655	36.66	36.6025	36.6075	43236.0
2017-06-20 08:45:00	AAPL	Stock	36.6175	36.6175	36.5925	36.6025	54136.0
2017-06-20 08:50:00	AAPL	Stock	36.6125	36.6275	36.6	36.6275	12120.0
2017-06-20 08:55:00	AAPL	Stock	36.6275	36.635	36.625	36.625	11936.0
2017-06-20 09:00:00	AAPL	Stock	36.6475	36.6475	36.625	36.6275	12756.0
2017-06-20 09:05:00	AAPL	Stock	36.645	36.675	36.6425	36.6625	18140.0
2017-06-20 09:10:00	AAPL	Stock	36.655	36.6625	36.65	36.6625	20316.0
2017-06-20 09:15:00	AAPL	Stock	36.66	36.665	36.65	36.665	6524.0
2017-06-20 09:20:00	AAPL	Stock	36.665	36.685	36.665	36.675	18820.0
2017-06-20 09:25:00	AAPL	Stock	36.675	36.7225	36.6625	36.7175	136892.0
2017-06-20 09:30:00	AAPL	Stock	36.7175	36.7175	36.4175	36.4325	4853544.0
2017-06-20 09:35:00	AAPL	Stock	36.4325	36.47	36.3975	36.4585	2228764.0
2017-06-20 09:40:00	AAPL	Stock	36.457	36.525	36.4462	36.4925	1977660.0
2017-06-20 09:45:00	AAPL	Stock	36.4925	36.5125	36.4	36.4075	1862164.0
2017-06-20 09:50:00	AAPL	Stock	36.405	36.4225	36.365	36.415	1887036.0
2017-06-20 09:55:00	AAPL	Stock	36.415	36.4175	36.34	36.355	1769008.0
2017-06-20 10:00:00	AAPL	Stock	36.355	36.389	36.3175	36.3865	1845940.0
2017-06-20 10:05:00	AAPL	Stock	36.385	36.4325	36.3825	36.425	1332028.0
2017-06-20 10:10:00	AAPL	Stock	36.4225	36.4338	36.345	36.359	1084080.0
2017-06-20 10:15:00	AAPL	Stock	36.3575	36.415	36.335	36.4075	1392492.0
2017-06-20 10:20:00	AAPL	Stock	36.4075	36.4088	36.365	36.38	1349696.0

> showing 50 of 349,923 rows — these rows as CSV

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