PREVIEW / stock_5min / 2018-08-22

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-08-22.parquet
  size:    5.4 MB
  rows:    345,457
  symbols: 2,793

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
2018-08-22 04:00:00	AAPL	Stock	53.5	53.5	53.5	53.5	428.0
2018-08-22 04:05:00	AAPL	Stock	53.525	53.525	53.525	53.525	800.0
2018-08-22 04:20:00	AAPL	Stock	53.6	53.6	53.6	53.6	600.0
2018-08-22 04:30:00	AAPL	Stock	53.55	53.55	53.55	53.55	800.0
2018-08-22 04:40:00	AAPL	Stock	53.59	53.59	53.59	53.59	600.0
2018-08-22 04:50:00	AAPL	Stock	53.6	53.6	53.6	53.6	3100.0
2018-08-22 06:05:00	AAPL	Stock	53.6125	53.62	53.5975	53.5975	7228.0
2018-08-22 06:10:00	AAPL	Stock	53.62	53.6225	53.62	53.6225	17848.0
2018-08-22 06:15:00	AAPL	Stock	53.6625	53.67	53.6575	53.67	4000.0
2018-08-22 06:20:00	AAPL	Stock	53.6675	53.6825	53.6675	53.6825	12700.0
2018-08-22 06:50:00	AAPL	Stock	53.6575	53.7	53.6575	53.7	1200.0
2018-08-22 07:00:00	AAPL	Stock	53.7	53.7375	53.625	53.7375	59828.0
2018-08-22 07:05:00	AAPL	Stock	53.72	53.72	53.6875	53.695	4844.0
2018-08-22 07:10:00	AAPL	Stock	53.6825	53.6925	53.675	53.685	21952.0
2018-08-22 07:15:00	AAPL	Stock	53.665	53.665	53.65	53.655	11740.0
2018-08-22 07:20:00	AAPL	Stock	53.655	53.655	53.655	53.655	400.0
2018-08-22 07:25:00	AAPL	Stock	53.67	53.67	53.67	53.67	1200.0
2018-08-22 07:30:00	AAPL	Stock	53.67	53.67	53.6625	53.67	5704.0
2018-08-22 07:35:00	AAPL	Stock	53.6675	53.6675	53.6675	53.6675	3860.0
2018-08-22 07:40:00	AAPL	Stock	53.65	53.6675	53.645	53.6675	3260.0
2018-08-22 07:45:00	AAPL	Stock	53.63	53.63	53.625	53.625	3200.0
2018-08-22 07:50:00	AAPL	Stock	53.625	53.625	53.605	53.6225	2680.0
2018-08-22 07:55:00	AAPL	Stock	53.6575	53.67	53.6575	53.6625	18676.0
2018-08-22 08:00:00	AAPL	Stock	53.6375	53.7	53.605	53.65	52932.0
2018-08-22 08:05:00	AAPL	Stock	53.6475	53.6625	53.6475	53.6625	4456.0
2018-08-22 08:10:00	AAPL	Stock	53.65	53.65	53.6475	53.65	11872.0
2018-08-22 08:15:00	AAPL	Stock	53.625	53.625	53.58	53.6	27348.0
2018-08-22 08:20:00	AAPL	Stock	53.575	53.5875	53.575	53.585	15352.0
2018-08-22 08:25:00	AAPL	Stock	53.575	53.61	53.5625	53.565	9304.0
2018-08-22 08:30:00	AAPL	Stock	53.6	53.6275	53.5825	53.585	66576.0
2018-08-22 08:35:00	AAPL	Stock	53.595	53.6475	53.595	53.625	16264.0
2018-08-22 08:40:00	AAPL	Stock	53.6075	53.625	53.575	53.625	24824.0
2018-08-22 08:45:00	AAPL	Stock	53.625	53.6625	53.625	53.6625	9600.0
2018-08-22 08:50:00	AAPL	Stock	53.6675	53.6725	53.6625	53.6725	5984.0
2018-08-22 08:55:00	AAPL	Stock	53.67	53.6775	53.6525	53.675	17472.0
2018-08-22 09:00:00	AAPL	Stock	53.6675	53.6825	53.65	53.65	14400.0
2018-08-22 09:05:00	AAPL	Stock	53.65	53.7	53.65	53.6825	48876.0
2018-08-22 09:10:00	AAPL	Stock	53.6875	53.7125	53.6875	53.7125	15360.0
2018-08-22 09:15:00	AAPL	Stock	53.7225	53.7225	53.6925	53.7075	23104.0
2018-08-22 09:20:00	AAPL	Stock	53.6925	53.7175	53.6875	53.6875	23516.0
2018-08-22 09:25:00	AAPL	Stock	53.7175	53.7175	53.53	53.53	76844.0
2018-08-22 09:30:00	AAPL	Stock	53.525	53.8525	53.5125	53.8	3216820.0
2018-08-22 09:35:00	AAPL	Stock	53.7972	53.9298	53.745	53.8312	1535276.0
2018-08-22 09:40:00	AAPL	Stock	53.83	53.8425	53.6575	53.6625	1179524.0
2018-08-22 09:45:00	AAPL	Stock	53.6625	53.75	53.6325	53.6825	1422936.0
2018-08-22 09:50:00	AAPL	Stock	53.6775	53.7125	53.59	53.63	1102888.0
2018-08-22 09:55:00	AAPL	Stock	53.6275	53.67	53.55	53.5662	1064552.0
2018-08-22 10:00:00	AAPL	Stock	53.565	53.5825	53.46	53.575	1917848.0
2018-08-22 10:05:00	AAPL	Stock	53.575	53.6475	53.525	53.5342	1332804.0
2018-08-22 10:10:00	AAPL	Stock	53.535	53.6975	53.52	53.6825	1455016.0

> showing 50 of 345,457 rows — these rows as CSV

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