PREVIEW / stock_5min / 2017-08-10

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-08-10.parquet
  size:    5.5 MB
  rows:    357,811
  symbols: 2,986

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
2017-08-10 04:20:00	AAPL	Stock	40.065	40.065	40.065	40.065	400.0
2017-08-10 04:35:00	AAPL	Stock	40.0375	40.0375	40.0375	40.0375	3600.0
2017-08-10 04:40:00	AAPL	Stock	40.0375	40.0375	40.0375	40.0375	740.0
2017-08-10 04:55:00	AAPL	Stock	39.9975	39.9975	39.9975	39.9975	4000.0
2017-08-10 05:15:00	AAPL	Stock	40.0	40.0	40.0	40.0	3372.0
2017-08-10 05:25:00	AAPL	Stock	39.9825	39.9825	39.9825	39.9825	480.0
2017-08-10 05:45:00	AAPL	Stock	39.9825	39.9825	39.9825	39.9825	7036.0
2017-08-10 05:50:00	AAPL	Stock	39.975	39.975	39.975	39.975	1600.0
2017-08-10 06:00:00	AAPL	Stock	39.9875	39.9875	39.985	39.985	800.0
2017-08-10 06:05:00	AAPL	Stock	40.0	40.0	39.98	39.98	6340.0
2017-08-10 06:10:00	AAPL	Stock	39.9975	39.9975	39.9975	39.9975	600.0
2017-08-10 06:15:00	AAPL	Stock	39.9975	40.0	39.9975	40.0	2600.0
2017-08-10 06:30:00	AAPL	Stock	40.015	40.015	39.985	39.985	43580.0
2017-08-10 06:35:00	AAPL	Stock	39.985	39.985	39.985	39.985	800.0
2017-08-10 06:45:00	AAPL	Stock	39.9575	39.9575	39.9575	39.9575	800.0
2017-08-10 06:55:00	AAPL	Stock	39.955	39.955	39.9525	39.955	3596.0
2017-08-10 07:00:00	AAPL	Stock	39.9625	39.98	39.9625	39.9775	6400.0
2017-08-10 07:05:00	AAPL	Stock	39.965	39.965	39.9425	39.9425	19876.0
2017-08-10 07:10:00	AAPL	Stock	39.9375	39.95	39.9375	39.95	6676.0
2017-08-10 07:15:00	AAPL	Stock	39.9675	39.9825	39.955	39.9825	1600.0
2017-08-10 07:20:00	AAPL	Stock	39.955	39.9875	39.9375	39.9675	5044.0
2017-08-10 07:25:00	AAPL	Stock	39.9825	39.9825	39.9825	39.9825	4300.0
2017-08-10 07:30:00	AAPL	Stock	39.9825	40.0	39.9825	40.0	2900.0
2017-08-10 07:35:00	AAPL	Stock	39.9875	39.9875	39.9825	39.9825	7084.0
2017-08-10 07:40:00	AAPL	Stock	39.985	40.0	39.9725	40.0	4868.0
2017-08-10 07:45:00	AAPL	Stock	40.0	40.0	39.9975	40.0	29796.0
2017-08-10 07:50:00	AAPL	Stock	40.0125	40.025	40.005	40.005	3200.0
2017-08-10 07:55:00	AAPL	Stock	40.025	40.025	40.025	40.025	400.0
2017-08-10 08:00:00	AAPL	Stock	40.005	40.05	39.9375	40.03	92812.0
2017-08-10 08:05:00	AAPL	Stock	40.0275	40.0725	40.0275	40.0525	42740.0
2017-08-10 08:10:00	AAPL	Stock	40.0525	40.075	40.045	40.045	50552.0
2017-08-10 08:15:00	AAPL	Stock	40.0425	40.07	40.0375	40.07	46800.0
2017-08-10 08:20:00	AAPL	Stock	40.065	40.075	40.065	40.075	9336.0
2017-08-10 08:25:00	AAPL	Stock	40.0875	40.0875	40.075	40.075	14800.0
2017-08-10 08:30:00	AAPL	Stock	40.0825	40.1	40.055	40.055	83524.0
2017-08-10 08:35:00	AAPL	Stock	40.05	40.055	40.045	40.05	29516.0
2017-08-10 08:40:00	AAPL	Stock	40.05	40.05	40.03	40.04	57964.0
2017-08-10 08:45:00	AAPL	Stock	40.04	40.04	40.0125	40.025	52168.0
2017-08-10 08:50:00	AAPL	Stock	40.025	40.0575	40.025	40.0375	21116.0
2017-08-10 08:55:00	AAPL	Stock	40.0525	40.0525	40.0275	40.03	14980.0
2017-08-10 09:00:00	AAPL	Stock	40.05	40.05	40.0175	40.0275	17628.0
2017-08-10 09:05:00	AAPL	Stock	40.0275	40.0375	40.015	40.025	18832.0
2017-08-10 09:10:00	AAPL	Stock	40.0225	40.04	40.02	40.04	12604.0
2017-08-10 09:15:00	AAPL	Stock	40.04	40.0625	40.025	40.025	52388.0
2017-08-10 09:20:00	AAPL	Stock	40.025	40.0275	40.0175	40.0275	43936.0
2017-08-10 09:25:00	AAPL	Stock	40.03	40.0375	39.93	39.9975	148160.0
2017-08-10 09:30:00	AAPL	Stock	40.0	40.0025	39.845	39.955	4324156.0
2017-08-10 09:35:00	AAPL	Stock	39.96	39.975	39.8325	39.8575	2612796.0
2017-08-10 09:40:00	AAPL	Stock	39.855	39.8675	39.76	39.7975	2781780.0
2017-08-10 09:45:00	AAPL	Stock	39.795	39.8075	39.7125	39.7525	2603976.0

> showing 50 of 357,811 rows — these rows as CSV

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