PREVIEW / stock_5min / 2020-01-31

all stock 5-min files

  file:    by_date/stock_5min/2020/2020-01-31.parquet
  size:    6.1 MB
  rows:    377,330
  symbols: 2,437

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
2020-01-31 04:00:00	AAPL	Stock	80.7025	80.7025	80.7025	80.7025	772.0
2020-01-31 04:05:00	AAPL	Stock	80.7175	80.75	80.715	80.75	8340.0
2020-01-31 04:15:00	AAPL	Stock	80.685	80.685	80.685	80.685	400.0
2020-01-31 04:20:00	AAPL	Stock	80.685	80.685	80.685	80.685	400.0
2020-01-31 04:25:00	AAPL	Stock	80.66	80.66	80.66	80.66	1600.0
2020-01-31 04:30:00	AAPL	Stock	80.66	80.66	80.66	80.66	4372.0
2020-01-31 04:35:00	AAPL	Stock	80.625	80.625	80.625	80.625	1948.0
2020-01-31 04:40:00	AAPL	Stock	80.655	80.655	80.655	80.655	400.0
2020-01-31 04:55:00	AAPL	Stock	80.635	80.635	80.635	80.635	812.0
2020-01-31 05:00:00	AAPL	Stock	80.575	80.575	80.575	80.575	16892.0
2020-01-31 05:05:00	AAPL	Stock	80.63	80.63	80.63	80.63	800.0
2020-01-31 05:10:00	AAPL	Stock	80.61	80.61	80.61	80.61	400.0
2020-01-31 05:20:00	AAPL	Stock	80.5775	80.58	80.5175	80.5175	15880.0
2020-01-31 05:25:00	AAPL	Stock	80.51	80.51	80.4375	80.4375	1200.0
2020-01-31 05:30:00	AAPL	Stock	80.42	80.42	80.31	80.31	6520.0
2020-01-31 05:35:00	AAPL	Stock	80.33	80.37	80.325	80.37	3600.0
2020-01-31 05:40:00	AAPL	Stock	80.3075	80.325	80.3	80.315	4400.0
2020-01-31 05:45:00	AAPL	Stock	80.37	80.39	80.37	80.39	3400.0
2020-01-31 05:55:00	AAPL	Stock	80.385	80.39	80.385	80.39	1200.0
2020-01-31 06:00:00	AAPL	Stock	80.4325	80.445	80.4325	80.445	3784.0
2020-01-31 06:05:00	AAPL	Stock	80.44	80.4475	80.3925	80.3925	3200.0
2020-01-31 06:15:00	AAPL	Stock	80.4375	80.45	80.4375	80.45	1764.0
2020-01-31 06:20:00	AAPL	Stock	80.4725	80.4725	80.4725	80.4725	400.0
2020-01-31 06:25:00	AAPL	Stock	80.45	80.45	80.39	80.4475	12000.0
2020-01-31 06:30:00	AAPL	Stock	80.3925	80.475	80.3925	80.475	3880.0
2020-01-31 06:45:00	AAPL	Stock	80.4	80.4575	80.4	80.4575	1200.0
2020-01-31 06:50:00	AAPL	Stock	80.4025	80.45	80.4025	80.45	2000.0
2020-01-31 06:55:00	AAPL	Stock	80.495	80.495	80.495	80.495	748.0
2020-01-31 07:00:00	AAPL	Stock	80.4525	80.62	80.4525	80.5625	28696.0
2020-01-31 07:05:00	AAPL	Stock	80.5625	80.625	80.5475	80.585	37148.0
2020-01-31 07:10:00	AAPL	Stock	80.575	80.65	80.575	80.5875	87492.0
2020-01-31 07:15:00	AAPL	Stock	80.5825	80.6575	80.5725	80.6575	32836.0
2020-01-31 07:20:00	AAPL	Stock	80.6075	80.695	80.6	80.65	88000.0
2020-01-31 07:25:00	AAPL	Stock	80.655	80.66	80.5875	80.5875	32940.0
2020-01-31 07:30:00	AAPL	Stock	80.575	80.65	80.565	80.6375	9408.0
2020-01-31 07:35:00	AAPL	Stock	80.6375	80.6825	80.6	80.6825	7868.0
2020-01-31 07:40:00	AAPL	Stock	80.675	80.6825	80.6625	80.67	14760.0
2020-01-31 07:45:00	AAPL	Stock	80.64	80.64	80.525	80.525	28444.0
2020-01-31 07:50:00	AAPL	Stock	80.5275	80.55	80.5	80.525	25128.0
2020-01-31 07:55:00	AAPL	Stock	80.505	80.55	80.505	80.55	12576.0
2020-01-31 08:00:00	AAPL	Stock	80.58	80.6875	80.425	80.4525	176264.0
2020-01-31 08:05:00	AAPL	Stock	80.47	80.475	80.415	80.45	29484.0
2020-01-31 08:10:00	AAPL	Stock	80.4425	80.4425	80.405	80.4275	34844.0
2020-01-31 08:15:00	AAPL	Stock	80.425	80.4575	80.4075	80.4125	25252.0
2020-01-31 08:20:00	AAPL	Stock	80.44	80.5275	80.44	80.5	40660.0
2020-01-31 08:25:00	AAPL	Stock	80.5	80.5125	80.43	80.5125	25760.0
2020-01-31 08:30:00	AAPL	Stock	80.5	80.5375	80.5	80.5	15624.0
2020-01-31 08:35:00	AAPL	Stock	80.5	80.5475	80.4275	80.44	38296.0
2020-01-31 08:40:00	AAPL	Stock	80.44	80.5	80.425	80.5	29432.0
2020-01-31 08:45:00	AAPL	Stock	80.475	80.5025	80.475	80.475	28204.0

> showing 50 of 377,330 rows — these rows as CSV

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