PREVIEW / stock_5min / 2018-05-29

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-05-29.parquet
  size:    5.6 MB
  rows:    364,806
  symbols: 2,833

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-05-29 04:00:00	AAPL	Stock	47.0775	47.0775	46.985	46.985	15924.0
2018-05-29 04:05:00	AAPL	Stock	46.95	46.95	46.95	46.95	400.0
2018-05-29 04:30:00	AAPL	Stock	46.8125	46.8125	46.75	46.75	9160.0
2018-05-29 04:35:00	AAPL	Stock	46.7125	46.7125	46.6875	46.6875	2300.0
2018-05-29 04:40:00	AAPL	Stock	46.725	46.725	46.725	46.725	2000.0
2018-05-29 04:50:00	AAPL	Stock	46.725	46.725	46.725	46.725	2000.0
2018-05-29 05:00:00	AAPL	Stock	46.695	46.695	46.695	46.695	400.0
2018-05-29 05:05:00	AAPL	Stock	46.7375	46.7375	46.675	46.675	9100.0
2018-05-29 05:15:00	AAPL	Stock	46.7275	46.7275	46.7275	46.7275	744.0
2018-05-29 05:55:00	AAPL	Stock	46.7625	46.7625	46.7625	46.7625	524.0
2018-05-29 06:30:00	AAPL	Stock	46.7875	46.7875	46.7875	46.7875	400.0
2018-05-29 06:35:00	AAPL	Stock	46.875	46.875	46.875	46.875	400.0
2018-05-29 07:00:00	AAPL	Stock	46.8375	46.865	46.75	46.75	114244.0
2018-05-29 07:05:00	AAPL	Stock	46.755	46.775	46.75	46.755	17112.0
2018-05-29 07:10:00	AAPL	Stock	46.7875	46.7875	46.7875	46.7875	1056.0
2018-05-29 07:20:00	AAPL	Stock	46.805	46.9125	46.8	46.8625	16052.0
2018-05-29 07:25:00	AAPL	Stock	46.84	46.84	46.825	46.825	5396.0
2018-05-29 07:30:00	AAPL	Stock	46.825	46.88	46.825	46.88	5200.0
2018-05-29 07:35:00	AAPL	Stock	46.8975	46.9	46.875	46.8875	6820.0
2018-05-29 07:40:00	AAPL	Stock	46.8775	46.8775	46.8625	46.875	7076.0
2018-05-29 07:45:00	AAPL	Stock	46.875	46.875	46.875	46.875	2400.0
2018-05-29 07:50:00	AAPL	Stock	46.88	46.9125	46.88	46.9	13200.0
2018-05-29 07:55:00	AAPL	Stock	46.9	46.9	46.9	46.9	1600.0
2018-05-29 08:00:00	AAPL	Stock	46.755	46.9325	46.755	46.9225	129660.0
2018-05-29 08:05:00	AAPL	Stock	46.89	46.925	46.8675	46.925	40456.0
2018-05-29 08:10:00	AAPL	Stock	46.8825	46.9225	46.8525	46.8875	27632.0
2018-05-29 08:15:00	AAPL	Stock	46.89	46.93	46.88	46.925	57636.0
2018-05-29 08:20:00	AAPL	Stock	46.9075	46.955	46.9025	46.955	12228.0
2018-05-29 08:25:00	AAPL	Stock	46.955	47.0	46.955	47.0	31220.0
2018-05-29 08:30:00	AAPL	Stock	47.0	47.0	46.9875	46.995	8336.0
2018-05-29 08:35:00	AAPL	Stock	46.9875	47.0	46.9875	47.0	4000.0
2018-05-29 08:40:00	AAPL	Stock	47.0	47.0	46.98	46.9875	10596.0
2018-05-29 08:45:00	AAPL	Stock	46.9875	46.995	46.9625	46.9775	27600.0
2018-05-29 08:50:00	AAPL	Stock	46.9825	47.0125	46.9825	47.0125	8948.0
2018-05-29 08:55:00	AAPL	Stock	47.0025	47.0075	46.9675	46.975	39704.0
2018-05-29 09:00:00	AAPL	Stock	46.9625	46.975	46.95	46.95	35660.0
2018-05-29 09:05:00	AAPL	Stock	46.9525	46.9925	46.9525	46.9925	15448.0
2018-05-29 09:10:00	AAPL	Stock	46.9625	46.965	46.9375	46.9375	21592.0
2018-05-29 09:15:00	AAPL	Stock	46.975	46.975	46.9375	46.9375	4612.0
2018-05-29 09:20:00	AAPL	Stock	46.9375	46.975	46.9375	46.975	19612.0
2018-05-29 09:25:00	AAPL	Stock	46.9325	46.9925	46.89	46.8975	19888.0
2018-05-29 09:30:00	AAPL	Stock	46.9	47.0525	46.8	46.805	3554064.0
2018-05-29 09:35:00	AAPL	Stock	46.8125	46.9075	46.7175	46.865	2203824.0
2018-05-29 09:40:00	AAPL	Stock	46.87	46.955	46.8325	46.93	1611644.0
2018-05-29 09:45:00	AAPL	Stock	46.9288	47.0175	46.925	46.991	1176388.0
2018-05-29 09:50:00	AAPL	Stock	46.9925	47.0725	46.9925	47.0375	1137772.0
2018-05-29 09:55:00	AAPL	Stock	47.0375	47.1075	47.0075	47.0875	1320328.0
2018-05-29 10:00:00	AAPL	Stock	47.0875	47.135	47.0788	47.1325	1276308.0
2018-05-29 10:05:00	AAPL	Stock	47.135	47.1875	47.1075	47.155	1269888.0
2018-05-29 10:10:00	AAPL	Stock	47.1525	47.16	47.0725	47.0875	930708.0

> showing 50 of 364,806 rows — these rows as CSV

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