PREVIEW / stock_5min / 2018-07-18

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-07-18.parquet
  size:    5.5 MB
  rows:    351,320
  symbols: 2,824

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-18 04:00:00	AAPL	Stock	48.0125	48.0125	48.0125	48.0125	7200.0
2018-07-18 04:05:00	AAPL	Stock	47.9975	47.9975	47.9975	47.9975	968.0
2018-07-18 04:10:00	AAPL	Stock	48.0	48.0	47.9875	48.0	17636.0
2018-07-18 04:15:00	AAPL	Stock	48.0	48.0	48.0	48.0	1200.0
2018-07-18 04:35:00	AAPL	Stock	48.0	48.0	48.0	48.0	800.0
2018-07-18 04:40:00	AAPL	Stock	47.9875	47.9875	47.9875	47.9875	1600.0
2018-07-18 04:45:00	AAPL	Stock	48.02	48.0375	48.02	48.0375	8192.0
2018-07-18 05:00:00	AAPL	Stock	48.0475	48.0475	48.04	48.04	824.0
2018-07-18 05:10:00	AAPL	Stock	48.0525	48.0525	48.0525	48.0525	532.0
2018-07-18 05:40:00	AAPL	Stock	48.05	48.05	48.05	48.05	800.0
2018-07-18 05:55:00	AAPL	Stock	48.05	48.1	48.05	48.1	2000.0
2018-07-18 06:00:00	AAPL	Stock	48.0975	48.0975	48.0975	48.0975	1040.0
2018-07-18 06:05:00	AAPL	Stock	48.0625	48.09	48.0625	48.09	2476.0
2018-07-18 06:35:00	AAPL	Stock	48.05	48.05	48.05	48.05	3548.0
2018-07-18 06:55:00	AAPL	Stock	48.0725	48.075	48.0725	48.075	1600.0
2018-07-18 07:00:00	AAPL	Stock	48.045	48.05	48.0275	48.0375	6060.0
2018-07-18 07:05:00	AAPL	Stock	48.0375	48.05	48.0375	48.05	3152.0
2018-07-18 07:10:00	AAPL	Stock	48.05	48.0525	48.0375	48.0375	3600.0
2018-07-18 07:15:00	AAPL	Stock	48.0375	48.0475	48.035	48.0475	3016.0
2018-07-18 07:20:00	AAPL	Stock	48.05	48.05	48.05	48.05	2000.0
2018-07-18 07:25:00	AAPL	Stock	48.03	48.03	48.0025	48.0025	15124.0
2018-07-18 07:30:00	AAPL	Stock	48.0025	48.0375	48.0	48.0375	27548.0
2018-07-18 07:35:00	AAPL	Stock	48.05	48.0625	48.0375	48.0375	7688.0
2018-07-18 07:40:00	AAPL	Stock	48.04	48.0475	48.0375	48.0475	8980.0
2018-07-18 07:45:00	AAPL	Stock	48.04	48.05	48.0325	48.05	2600.0
2018-07-18 07:50:00	AAPL	Stock	48.0375	48.0375	48.025	48.025	2452.0
2018-07-18 08:00:00	AAPL	Stock	48.05	48.06	47.9525	47.955	49804.0
2018-07-18 08:05:00	AAPL	Stock	47.9625	47.985	47.95	47.9825	13464.0
2018-07-18 08:10:00	AAPL	Stock	47.9625	48.025	47.9575	48.0	22196.0
2018-07-18 08:15:00	AAPL	Stock	47.9875	48.0	47.96	48.0	23700.0
2018-07-18 08:20:00	AAPL	Stock	47.9875	48.0	47.9875	48.0	4752.0
2018-07-18 08:25:00	AAPL	Stock	47.995	48.0	47.975	48.0	16400.0
2018-07-18 08:30:00	AAPL	Stock	48.0	48.0225	47.9975	48.02	16456.0
2018-07-18 08:35:00	AAPL	Stock	48.02	48.0375	48.02	48.0325	11688.0
2018-07-18 08:40:00	AAPL	Stock	48.02	48.025	48.02	48.0225	2800.0
2018-07-18 08:45:00	AAPL	Stock	48.0225	48.025	47.9975	48.025	15688.0
2018-07-18 08:50:00	AAPL	Stock	48.0375	48.0375	48.035	48.035	4464.0
2018-07-18 08:55:00	AAPL	Stock	48.0375	48.0375	48.02	48.0375	7228.0
2018-07-18 09:00:00	AAPL	Stock	48.0375	48.0375	48.0175	48.0375	12832.0
2018-07-18 09:05:00	AAPL	Stock	48.0275	48.0325	48.005	48.0075	22532.0
2018-07-18 09:10:00	AAPL	Stock	48.025	48.05	48.0175	48.0475	28812.0
2018-07-18 09:15:00	AAPL	Stock	48.0275	48.035	48.01	48.01	9600.0
2018-07-18 09:20:00	AAPL	Stock	48.01	48.05	48.01	48.025	41740.0
2018-07-18 09:25:00	AAPL	Stock	48.0475	48.05	47.9375	47.9375	81324.0
2018-07-18 09:30:00	AAPL	Stock	47.945	47.95	47.6425	47.7525	3607896.0
2018-07-18 09:35:00	AAPL	Stock	47.7575	47.7875	47.5505	47.6425	2184780.0
2018-07-18 09:40:00	AAPL	Stock	47.6425	47.675	47.5525	47.5962	1647732.0
2018-07-18 09:45:00	AAPL	Stock	47.595	47.735	47.5775	47.7125	1316184.0
2018-07-18 09:50:00	AAPL	Stock	47.71	47.71	47.615	47.64	822776.0
2018-07-18 09:55:00	AAPL	Stock	47.6425	47.65	47.5575	47.595	1033436.0

> showing 50 of 351,320 rows — these rows as CSV

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