PREVIEW / stock_5min / 2017-08-29

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-08-29.parquet
  size:    5.3 MB
  rows:    346,337
  symbols: 2,980

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-29 04:00:00	AAPL	Stock	40.05	40.05	39.95	39.95	2020.0
2017-08-29 04:05:00	AAPL	Stock	39.975	39.975	39.975	39.975	1600.0
2017-08-29 04:10:00	AAPL	Stock	39.975	40.0	39.975	40.0	5996.0
2017-08-29 04:25:00	AAPL	Stock	39.92	39.945	39.92	39.945	2392.0
2017-08-29 04:30:00	AAPL	Stock	39.95	39.95	39.95	39.95	3600.0
2017-08-29 04:40:00	AAPL	Stock	39.9075	39.9075	39.8875	39.8875	3796.0
2017-08-29 04:45:00	AAPL	Stock	39.9125	39.9125	39.9	39.9	2228.0
2017-08-29 04:50:00	AAPL	Stock	39.8875	39.8875	39.8875	39.8875	3872.0
2017-08-29 04:55:00	AAPL	Stock	39.945	39.945	39.9125	39.9125	2712.0
2017-08-29 05:00:00	AAPL	Stock	39.9025	39.9025	39.875	39.8875	11096.0
2017-08-29 05:10:00	AAPL	Stock	39.9	39.9	39.9	39.9	2480.0
2017-08-29 05:15:00	AAPL	Stock	39.9225	39.9225	39.9225	39.9225	400.0
2017-08-29 05:20:00	AAPL	Stock	39.93	39.93	39.925	39.925	2800.0
2017-08-29 05:30:00	AAPL	Stock	39.975	39.975	39.975	39.975	1644.0
2017-08-29 05:35:00	AAPL	Stock	39.975	40.0	39.975	40.0	2000.0
2017-08-29 05:40:00	AAPL	Stock	40.0	40.025	40.0	40.025	1268.0
2017-08-29 05:45:00	AAPL	Stock	40.0375	40.0375	40.025	40.025	13824.0
2017-08-29 05:50:00	AAPL	Stock	40.025	40.025	40.025	40.025	4720.0
2017-08-29 05:55:00	AAPL	Stock	40.025	40.025	40.025	40.025	4056.0
2017-08-29 06:00:00	AAPL	Stock	40.0025	40.005	40.0025	40.0025	12420.0
2017-08-29 06:05:00	AAPL	Stock	40.0025	40.0025	39.9775	39.9775	10400.0
2017-08-29 06:10:00	AAPL	Stock	40.0	40.0375	40.0	40.035	19168.0
2017-08-29 06:15:00	AAPL	Stock	40.0	40.0	40.0	40.0	400.0
2017-08-29 06:20:00	AAPL	Stock	40.0	40.035	40.0	40.035	14448.0
2017-08-29 06:25:00	AAPL	Stock	40.035	40.04	40.03	40.0375	8536.0
2017-08-29 06:30:00	AAPL	Stock	40.025	40.05	40.025	40.05	2264.0
2017-08-29 06:35:00	AAPL	Stock	40.06	40.0675	40.05	40.05	2796.0
2017-08-29 06:45:00	AAPL	Stock	40.045	40.08	40.045	40.08	4200.0
2017-08-29 06:55:00	AAPL	Stock	40.09	40.09	40.09	40.09	2000.0
2017-08-29 07:00:00	AAPL	Stock	40.095	40.0975	40.075	40.0825	6000.0
2017-08-29 07:05:00	AAPL	Stock	40.085	40.0875	40.075	40.0875	9552.0
2017-08-29 07:10:00	AAPL	Stock	40.075	40.1	40.065	40.0875	33904.0
2017-08-29 07:15:00	AAPL	Stock	40.095	40.095	40.07	40.07	14360.0
2017-08-29 07:20:00	AAPL	Stock	40.075	40.075	40.065	40.065	7180.0
2017-08-29 07:25:00	AAPL	Stock	40.0625	40.0625	40.05	40.05	1320.0
2017-08-29 07:30:00	AAPL	Stock	40.0675	40.0875	40.06	40.075	9256.0
2017-08-29 07:35:00	AAPL	Stock	40.0825	40.0925	40.0825	40.0925	2000.0
2017-08-29 07:40:00	AAPL	Stock	40.0925	40.0925	40.075	40.075	3600.0
2017-08-29 07:45:00	AAPL	Stock	40.0625	40.0625	40.0325	40.0325	8000.0
2017-08-29 07:50:00	AAPL	Stock	40.025	40.045	40.0025	40.0425	46764.0
2017-08-29 07:55:00	AAPL	Stock	40.0375	40.065	40.03	40.0375	28284.0
2017-08-29 08:00:00	AAPL	Stock	40.0725	40.0975	40.0025	40.0725	77320.0
2017-08-29 08:05:00	AAPL	Stock	40.0375	40.0625	40.02	40.025	28564.0
2017-08-29 08:10:00	AAPL	Stock	40.0425	40.075	40.0125	40.075	40440.0
2017-08-29 08:15:00	AAPL	Stock	40.0725	40.0875	40.05	40.0725	25528.0
2017-08-29 08:20:00	AAPL	Stock	40.075	40.09	40.05	40.05	59652.0
2017-08-29 08:25:00	AAPL	Stock	40.04	40.05	40.025	40.025	28120.0
2017-08-29 08:30:00	AAPL	Stock	40.03	40.0625	40.025	40.0625	16740.0
2017-08-29 08:35:00	AAPL	Stock	40.06	40.0625	40.0225	40.0225	44324.0
2017-08-29 08:40:00	AAPL	Stock	40.0125	40.05	40.0125	40.015	93128.0

> showing 50 of 346,337 rows — these rows as CSV

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