PREVIEW / stock_5min / 2018-04-20

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-04-20.parquet
  size:    5.3 MB
  rows:    346,246
  symbols: 2,839

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-04-20 04:00:00	AAPL	Stock	43.075	43.075	43.0	43.0	5680.0
2018-04-20 04:05:00	AAPL	Stock	43.0725	43.0725	43.0725	43.0725	1920.0
2018-04-20 04:10:00	AAPL	Stock	43.0625	43.0625	43.055	43.055	4760.0
2018-04-20 04:20:00	AAPL	Stock	43.0025	43.0025	43.0	43.0	4188.0
2018-04-20 04:35:00	AAPL	Stock	43.0	43.0	43.0	43.0	1200.0
2018-04-20 04:50:00	AAPL	Stock	43.0025	43.0025	43.0025	43.0025	400.0
2018-04-20 05:25:00	AAPL	Stock	43.05	43.0725	43.05	43.0725	2872.0
2018-04-20 05:35:00	AAPL	Stock	43.075	43.075	43.075	43.075	2848.0
2018-04-20 05:40:00	AAPL	Stock	43.07	43.07	43.065	43.065	2400.0
2018-04-20 05:45:00	AAPL	Stock	43.065	43.065	43.035	43.035	2008.0
2018-04-20 05:50:00	AAPL	Stock	43.0575	43.0575	43.005	43.005	5600.0
2018-04-20 05:55:00	AAPL	Stock	43.0225	43.0475	43.0	43.0	11256.0
2018-04-20 06:05:00	AAPL	Stock	42.9375	42.9625	42.9375	42.96	20888.0
2018-04-20 06:15:00	AAPL	Stock	43.0	43.0	43.0	43.0	1684.0
2018-04-20 06:30:00	AAPL	Stock	42.96	42.96	42.96	42.96	2604.0
2018-04-20 06:35:00	AAPL	Stock	42.95	42.96	42.8875	42.96	11756.0
2018-04-20 06:40:00	AAPL	Stock	42.95	42.95	42.95	42.95	6800.0
2018-04-20 06:45:00	AAPL	Stock	42.9825	43.0	42.9825	43.0	2560.0
2018-04-20 06:50:00	AAPL	Stock	42.9825	43.0	42.9825	43.0	10376.0
2018-04-20 06:55:00	AAPL	Stock	43.005	43.0325	43.005	43.0325	1200.0
2018-04-20 07:00:00	AAPL	Stock	43.03	43.105	43.015	43.1025	24136.0
2018-04-20 07:05:00	AAPL	Stock	43.1025	43.1125	43.075	43.1	14368.0
2018-04-20 07:10:00	AAPL	Stock	43.125	43.1275	43.125	43.1275	2400.0
2018-04-20 07:15:00	AAPL	Stock	43.1125	43.1125	43.0625	43.075	17380.0
2018-04-20 07:20:00	AAPL	Stock	43.075	43.075	43.05	43.05	16240.0
2018-04-20 07:25:00	AAPL	Stock	43.0575	43.0575	43.0375	43.0425	7080.0
2018-04-20 07:30:00	AAPL	Stock	43.0625	43.1	43.055	43.055	4552.0
2018-04-20 07:35:00	AAPL	Stock	43.0725	43.0975	43.04	43.0975	15028.0
2018-04-20 07:40:00	AAPL	Stock	43.095	43.28	43.095	43.1125	22436.0
2018-04-20 07:45:00	AAPL	Stock	43.1125	43.1125	43.1125	43.1125	480.0
2018-04-20 07:50:00	AAPL	Stock	43.1375	43.145	43.1125	43.1125	15800.0
2018-04-20 07:55:00	AAPL	Stock	43.1075	43.1075	43.0625	43.0625	27908.0
2018-04-20 08:00:00	AAPL	Stock	43.105	43.225	43.0075	43.0625	102916.0
2018-04-20 08:05:00	AAPL	Stock	43.06	43.06	43.0525	43.0525	2000.0
2018-04-20 08:10:00	AAPL	Stock	43.0525	43.055	43.025	43.025	27400.0
2018-04-20 08:15:00	AAPL	Stock	43.0225	43.0325	43.01	43.0325	27660.0
2018-04-20 08:20:00	AAPL	Stock	43.0325	43.0325	43.0075	43.0075	54548.0
2018-04-20 08:25:00	AAPL	Stock	43.0075	43.035	42.9825	43.0	107192.0
2018-04-20 08:30:00	AAPL	Stock	42.995	43.0	42.9375	42.9375	63740.0
2018-04-20 08:35:00	AAPL	Stock	42.9375	42.9425	42.9225	42.9375	37008.0
2018-04-20 08:40:00	AAPL	Stock	42.9375	42.9625	42.9375	42.9625	59912.0
2018-04-20 08:45:00	AAPL	Stock	42.9525	43.025	42.95	43.0	133400.0
2018-04-20 08:50:00	AAPL	Stock	42.965	43.0	42.95	42.9975	48620.0
2018-04-20 08:55:00	AAPL	Stock	42.9975	43.0	42.97	42.9875	37228.0
2018-04-20 09:00:00	AAPL	Stock	42.9875	43.125	42.9775	43.0	81040.0
2018-04-20 09:05:00	AAPL	Stock	43.015	43.015	42.9875	42.9975	34924.0
2018-04-20 09:10:00	AAPL	Stock	42.995	43.005	42.985	42.9875	32236.0
2018-04-20 09:15:00	AAPL	Stock	42.9975	42.9975	42.945	42.95	93904.0
2018-04-20 09:20:00	AAPL	Stock	42.95	42.95	42.79	42.8225	429536.0
2018-04-20 09:25:00	AAPL	Stock	42.8125	42.8125	42.6225	42.6425	893612.0

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

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