PREVIEW / stock_5min / 2018-06-08

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-06-08.parquet
  size:    5.5 MB
  rows:    358,299
  symbols: 2,811

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-06-08 04:00:00	AAPL	Stock	47.9375	47.9375	47.26	47.2625	43704.0
2018-06-08 04:05:00	AAPL	Stock	47.25	47.25	47.1	47.1	10764.0
2018-06-08 04:10:00	AAPL	Stock	47.05	47.25	47.0475	47.25	14040.0
2018-06-08 04:15:00	AAPL	Stock	47.2175	47.375	47.1325	47.3	36648.0
2018-06-08 04:20:00	AAPL	Stock	47.4	47.4	47.33	47.345	3100.0
2018-06-08 04:25:00	AAPL	Stock	47.375	47.375	47.3625	47.3625	1788.0
2018-06-08 04:30:00	AAPL	Stock	47.35	47.35	47.35	47.35	3788.0
2018-06-08 04:35:00	AAPL	Stock	47.35	47.355	47.3025	47.355	18600.0
2018-06-08 04:40:00	AAPL	Stock	47.38	47.4125	47.38	47.4125	800.0
2018-06-08 04:45:00	AAPL	Stock	47.4225	47.4725	47.4225	47.4625	1780.0
2018-06-08 04:50:00	AAPL	Stock	47.375	47.375	47.35	47.35	800.0
2018-06-08 04:55:00	AAPL	Stock	47.35	47.4125	47.35	47.3875	12340.0
2018-06-08 05:00:00	AAPL	Stock	47.3875	47.3875	47.3875	47.3875	1880.0
2018-06-08 05:10:00	AAPL	Stock	47.3725	47.4125	47.3675	47.3775	2160.0
2018-06-08 05:15:00	AAPL	Stock	47.35	47.35	47.35	47.35	9656.0
2018-06-08 05:20:00	AAPL	Stock	47.3125	47.375	47.3125	47.375	3600.0
2018-06-08 05:25:00	AAPL	Stock	47.3225	47.3225	47.3175	47.3175	2000.0
2018-06-08 05:30:00	AAPL	Stock	47.4175	47.4375	47.4175	47.4375	2000.0
2018-06-08 05:35:00	AAPL	Stock	47.4375	47.4375	47.375	47.375	9436.0
2018-06-08 05:40:00	AAPL	Stock	47.3775	47.3875	47.37	47.375	5424.0
2018-06-08 05:45:00	AAPL	Stock	47.375	47.375	47.3625	47.3625	23048.0
2018-06-08 05:50:00	AAPL	Stock	47.315	47.315	47.2375	47.2375	8160.0
2018-06-08 06:00:00	AAPL	Stock	47.31	47.31	47.3	47.3	4000.0
2018-06-08 06:05:00	AAPL	Stock	47.3325	47.3375	47.3325	47.3375	2800.0
2018-06-08 06:10:00	AAPL	Stock	47.3625	47.4625	47.3625	47.4625	44388.0
2018-06-08 06:15:00	AAPL	Stock	47.435	47.5525	47.435	47.525	9456.0
2018-06-08 06:20:00	AAPL	Stock	47.5275	47.5275	47.525	47.525	5600.0
2018-06-08 06:25:00	AAPL	Stock	47.5175	47.5325	47.5175	47.525	23384.0
2018-06-08 06:30:00	AAPL	Stock	47.525	47.525	47.515	47.515	5000.0
2018-06-08 06:35:00	AAPL	Stock	47.475	47.475	47.4475	47.45	9212.0
2018-06-08 06:40:00	AAPL	Stock	47.4475	47.4475	47.3925	47.3925	11428.0
2018-06-08 06:45:00	AAPL	Stock	47.3925	47.3925	47.3375	47.355	42808.0
2018-06-08 06:50:00	AAPL	Stock	47.355	47.3925	47.355	47.375	8220.0
2018-06-08 06:55:00	AAPL	Stock	47.395	47.395	47.38	47.38	6856.0
2018-06-08 07:00:00	AAPL	Stock	47.415	47.7	47.3875	47.6275	150736.0
2018-06-08 07:05:00	AAPL	Stock	47.625	47.6725	47.5525	47.6625	117896.0
2018-06-08 07:10:00	AAPL	Stock	47.65	47.68	47.625	47.68	35560.0
2018-06-08 07:15:00	AAPL	Stock	47.675	47.7225	47.675	47.7225	37012.0
2018-06-08 07:20:00	AAPL	Stock	47.7125	47.7975	47.7125	47.7925	71800.0
2018-06-08 07:25:00	AAPL	Stock	47.7875	47.8775	47.7875	47.85	114580.0
2018-06-08 07:30:00	AAPL	Stock	47.82	47.82	47.7625	47.7625	25748.0
2018-06-08 07:35:00	AAPL	Stock	47.7675	47.7675	47.7125	47.7275	131132.0
2018-06-08 07:40:00	AAPL	Stock	47.7225	47.8	47.7225	47.7875	133260.0
2018-06-08 07:45:00	AAPL	Stock	47.7975	47.825	47.775	47.825	36404.0
2018-06-08 07:50:00	AAPL	Stock	47.8325	47.8375	47.7725	47.7725	43820.0
2018-06-08 07:55:00	AAPL	Stock	47.77	47.775	47.7	47.7375	55876.0
2018-06-08 08:00:00	AAPL	Stock	47.755	47.8375	47.4	47.775	199664.0
2018-06-08 08:05:00	AAPL	Stock	47.775	47.7875	47.7025	47.715	126532.0
2018-06-08 08:10:00	AAPL	Stock	47.7225	47.7225	47.6325	47.6325	92756.0
2018-06-08 08:15:00	AAPL	Stock	47.65	47.675	47.64	47.645	28528.0

> showing 50 of 358,299 rows — these rows as CSV

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