PREVIEW / stock_5min / 2019-08-20

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-08-20.parquet
  size:    5.4 MB
  rows:    345,869
  symbols: 2,566

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
2019-08-20 04:00:00	AAPL	Stock	52.65	52.775	52.65	52.775	2784.0
2019-08-20 04:05:00	AAPL	Stock	52.77	52.7725	52.77	52.77	2400.0
2019-08-20 04:10:00	AAPL	Stock	52.745	52.7475	52.735	52.7475	2712.0
2019-08-20 04:15:00	AAPL	Stock	52.745	52.75	52.745	52.75	2000.0
2019-08-20 04:20:00	AAPL	Stock	52.785	52.785	52.785	52.785	400.0
2019-08-20 04:30:00	AAPL	Stock	52.7725	52.7725	52.71	52.71	3600.0
2019-08-20 04:50:00	AAPL	Stock	52.7525	52.7525	52.7525	52.7525	400.0
2019-08-20 05:00:00	AAPL	Stock	52.755	52.755	52.755	52.755	1200.0
2019-08-20 05:10:00	AAPL	Stock	52.7	52.7	52.7	52.7	400.0
2019-08-20 05:15:00	AAPL	Stock	52.6575	52.6575	52.625	52.65	1200.0
2019-08-20 05:20:00	AAPL	Stock	52.65	52.6525	52.5925	52.635	3396.0
2019-08-20 05:35:00	AAPL	Stock	52.6275	52.6275	52.6275	52.6275	768.0
2019-08-20 05:55:00	AAPL	Stock	52.65	52.65	52.65	52.65	616.0
2019-08-20 06:05:00	AAPL	Stock	52.6825	52.75	52.6775	52.6875	4084.0
2019-08-20 06:30:00	AAPL	Stock	52.7275	52.7275	52.725	52.725	1664.0
2019-08-20 06:35:00	AAPL	Stock	52.7125	52.7125	52.7125	52.7125	1324.0
2019-08-20 06:45:00	AAPL	Stock	52.695	52.695	52.695	52.695	2800.0
2019-08-20 06:55:00	AAPL	Stock	52.6675	52.6675	52.65	52.65	4708.0
2019-08-20 07:00:00	AAPL	Stock	52.675	52.6975	52.6075	52.6975	5620.0
2019-08-20 07:05:00	AAPL	Stock	52.645	52.645	52.555	52.5675	13668.0
2019-08-20 07:10:00	AAPL	Stock	52.595	52.595	52.5	52.54	25304.0
2019-08-20 07:15:00	AAPL	Stock	52.58	52.5875	52.5625	52.5625	4856.0
2019-08-20 07:20:00	AAPL	Stock	52.635	52.635	52.5625	52.57	2968.0
2019-08-20 07:25:00	AAPL	Stock	52.575	52.575	52.575	52.575	1472.0
2019-08-20 07:30:00	AAPL	Stock	52.575	52.6125	52.55	52.5875	12924.0
2019-08-20 07:35:00	AAPL	Stock	52.6	52.69	52.6	52.6875	8256.0
2019-08-20 07:40:00	AAPL	Stock	52.695	52.75	52.6875	52.715	16476.0
2019-08-20 07:45:00	AAPL	Stock	52.705	52.75	52.7	52.7	3352.0
2019-08-20 07:50:00	AAPL	Stock	52.7175	52.7325	52.7175	52.7325	2444.0
2019-08-20 07:55:00	AAPL	Stock	52.7075	52.7625	52.7	52.7375	28432.0
2019-08-20 08:00:00	AAPL	Stock	52.6	52.7775	52.5375	52.77	71900.0
2019-08-20 08:05:00	AAPL	Stock	52.775	52.7875	52.7375	52.7375	23100.0
2019-08-20 08:10:00	AAPL	Stock	52.775	52.7875	52.775	52.7875	3384.0
2019-08-20 08:15:00	AAPL	Stock	52.7625	52.8375	52.7625	52.825	11476.0
2019-08-20 08:20:00	AAPL	Stock	52.8345	52.8375	52.7825	52.8	21928.0
2019-08-20 08:25:00	AAPL	Stock	52.805	52.85	52.79	52.85	29948.0
2019-08-20 08:30:00	AAPL	Stock	52.86	52.9125	52.86	52.8775	28784.0
2019-08-20 08:35:00	AAPL	Stock	52.88	52.895	52.875	52.8825	20316.0
2019-08-20 08:40:00	AAPL	Stock	52.875	52.8875	52.7875	52.79	44076.0
2019-08-20 08:45:00	AAPL	Stock	52.7725	52.7725	52.7525	52.77	8024.0
2019-08-20 08:50:00	AAPL	Stock	52.775	52.7975	52.7275	52.7625	38220.0
2019-08-20 08:55:00	AAPL	Stock	52.7625	52.78	52.74	52.775	21740.0
2019-08-20 09:00:00	AAPL	Stock	52.75	52.795	52.6875	52.775	55288.0
2019-08-20 09:05:00	AAPL	Stock	52.795	52.795	52.7125	52.725	14096.0
2019-08-20 09:10:00	AAPL	Stock	52.7175	52.7175	52.6625	52.7	45736.0
2019-08-20 09:15:00	AAPL	Stock	52.6925	52.7225	52.665	52.7225	10636.0
2019-08-20 09:20:00	AAPL	Stock	52.7	52.715	52.675	52.7125	41460.0
2019-08-20 09:25:00	AAPL	Stock	52.7175	52.7275	52.675	52.7025	35440.0
2019-08-20 09:30:00	AAPL	Stock	52.7025	52.945	52.66	52.8325	3941572.0
2019-08-20 09:35:00	AAPL	Stock	52.8375	52.94	52.7175	52.9112	2194984.0

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

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