PREVIEW / stock_5min / 2018-07-20

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-07-20.parquet
  size:    5.3 MB
  rows:    344,983
  symbols: 2,781

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-07-20 04:45:00	AAPL	Stock	48.1225	48.125	48.1225	48.125	1200.0
2018-07-20 04:50:00	AAPL	Stock	48.0725	48.0725	48.0725	48.0725	7816.0
2018-07-20 05:30:00	AAPL	Stock	48.075	48.075	48.075	48.075	2488.0
2018-07-20 05:45:00	AAPL	Stock	48.075	48.1225	48.075	48.1225	3096.0
2018-07-20 06:10:00	AAPL	Stock	48.015	48.09	48.015	48.09	2400.0
2018-07-20 06:15:00	AAPL	Stock	47.9875	47.9875	47.95	47.95	8968.0
2018-07-20 06:20:00	AAPL	Stock	47.8875	47.8875	47.875	47.8775	1200.0
2018-07-20 06:25:00	AAPL	Stock	47.875	47.875	47.78	47.8475	25612.0
2018-07-20 06:30:00	AAPL	Stock	47.8475	47.8475	47.8475	47.8475	700.0
2018-07-20 06:40:00	AAPL	Stock	47.95	47.95	47.95	47.95	800.0
2018-07-20 06:50:00	AAPL	Stock	47.975	47.975	47.975	47.975	4016.0
2018-07-20 07:00:00	AAPL	Stock	47.99	47.99	47.975	47.975	2824.0
2018-07-20 07:05:00	AAPL	Stock	47.955	47.955	47.955	47.955	1940.0
2018-07-20 07:10:00	AAPL	Stock	47.9625	47.9625	47.9625	47.9625	400.0
2018-07-20 07:15:00	AAPL	Stock	47.9525	47.9525	47.925	47.925	8000.0
2018-07-20 07:20:00	AAPL	Stock	47.9375	48.025	47.8925	48.025	18848.0
2018-07-20 07:25:00	AAPL	Stock	47.9725	47.9725	47.915	47.96	8580.0
2018-07-20 07:30:00	AAPL	Stock	47.96	48.0	47.9575	47.9975	12116.0
2018-07-20 07:35:00	AAPL	Stock	47.9775	47.9775	47.93	47.935	16192.0
2018-07-20 07:40:00	AAPL	Stock	47.945	47.9625	47.945	47.95	7472.0
2018-07-20 07:50:00	AAPL	Stock	47.9325	47.9325	47.9325	47.9325	1884.0
2018-07-20 07:55:00	AAPL	Stock	47.95	47.95	47.95	47.95	400.0
2018-07-20 08:00:00	AAPL	Stock	47.995	48.025	47.915	47.9975	43780.0
2018-07-20 08:05:00	AAPL	Stock	47.9875	47.9875	47.975	47.9775	14176.0
2018-07-20 08:10:00	AAPL	Stock	47.97	47.975	47.9625	47.975	2000.0
2018-07-20 08:15:00	AAPL	Stock	47.95	47.95	47.9275	47.9275	4892.0
2018-07-20 08:20:00	AAPL	Stock	47.9275	47.9275	47.925	47.925	2416.0
2018-07-20 08:25:00	AAPL	Stock	47.9275	47.9275	47.9025	47.92	4704.0
2018-07-20 08:30:00	AAPL	Stock	47.905	47.905	47.89	47.9025	42040.0
2018-07-20 08:35:00	AAPL	Stock	47.9025	47.94	47.9025	47.94	24052.0
2018-07-20 08:40:00	AAPL	Stock	47.94	47.94	47.8875	47.8875	13672.0
2018-07-20 08:45:00	AAPL	Stock	47.8875	47.9025	47.8875	47.8875	20140.0
2018-07-20 08:50:00	AAPL	Stock	47.8775	47.8975	47.8775	47.8975	46028.0
2018-07-20 08:55:00	AAPL	Stock	47.88	47.945	47.8775	47.9	79192.0
2018-07-20 09:00:00	AAPL	Stock	47.9125	47.9125	47.9	47.905	13368.0
2018-07-20 09:05:00	AAPL	Stock	47.905	47.9125	47.905	47.9125	18420.0
2018-07-20 09:10:00	AAPL	Stock	47.9125	47.935	47.9075	47.935	17884.0
2018-07-20 09:15:00	AAPL	Stock	47.9425	47.99	47.93	47.9625	67036.0
2018-07-20 09:25:00	AAPL	Stock	47.9975	48.075	47.9325	47.94	107908.0
2018-07-20 09:30:00	AAPL	Stock	47.94	48.075	47.9328	47.9375	5961520.0
2018-07-20 09:35:00	AAPL	Stock	47.9375	47.98	47.8925	47.94	1050712.0
2018-07-20 09:40:00	AAPL	Stock	47.9475	48.0325	47.9345	47.99	1217372.0
2018-07-20 09:45:00	AAPL	Stock	47.9925	48.0	47.9275	47.975	829184.0
2018-07-20 09:50:00	AAPL	Stock	47.975	48.0275	47.9725	48.02	1000292.0
2018-07-20 09:55:00	AAPL	Stock	48.025	48.0475	47.9925	48.015	714992.0
2018-07-20 10:00:00	AAPL	Stock	48.015	48.055	47.995	48.0	740728.0
2018-07-20 10:05:00	AAPL	Stock	48.0075	48.035	47.995	48.0275	572592.0
2018-07-20 10:10:00	AAPL	Stock	48.03	48.06	48.0125	48.015	602012.0
2018-07-20 10:15:00	AAPL	Stock	48.0125	48.0375	47.985	48.0225	504792.0
2018-07-20 10:20:00	AAPL	Stock	48.0225	48.071	48.0	48.0275	567004.0

> showing 50 of 344,983 rows — these rows as CSV

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