PREVIEW / stock_5min / 2019-08-19

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-08-19.parquet
  size:    5.6 MB
  rows:    356,503
  symbols: 2,561

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
2019-08-19 04:00:00	AAPL	Stock	52.15	52.265	52.15	52.225	15212.0
2019-08-19 04:05:00	AAPL	Stock	52.25	52.25	52.2375	52.25	10156.0
2019-08-19 04:15:00	AAPL	Stock	52.335	52.3725	52.335	52.3725	7176.0
2019-08-19 04:25:00	AAPL	Stock	52.3	52.3	52.19	52.3	1200.0
2019-08-19 04:35:00	AAPL	Stock	52.25	52.25	52.15	52.15	10000.0
2019-08-19 05:10:00	AAPL	Stock	52.2675	52.2675	52.2675	52.2675	400.0
2019-08-19 05:20:00	AAPL	Stock	52.22	52.22	52.22	52.22	400.0
2019-08-19 05:45:00	AAPL	Stock	52.245	52.25	52.245	52.25	3800.0
2019-08-19 05:50:00	AAPL	Stock	52.3075	52.3075	52.3075	52.3075	800.0
2019-08-19 06:05:00	AAPL	Stock	52.36	52.3725	52.3375	52.3725	4400.0
2019-08-19 06:10:00	AAPL	Stock	52.42	52.4375	52.375	52.4375	18092.0
2019-08-19 06:15:00	AAPL	Stock	52.42	52.42	52.4025	52.4025	5600.0
2019-08-19 06:25:00	AAPL	Stock	52.4125	52.44	52.4125	52.44	3000.0
2019-08-19 06:30:00	AAPL	Stock	52.35	52.4225	52.35	52.4125	3964.0
2019-08-19 06:35:00	AAPL	Stock	52.4	52.4	52.4	52.4	800.0
2019-08-19 06:40:00	AAPL	Stock	52.4175	52.4225	52.4175	52.4225	2036.0
2019-08-19 06:45:00	AAPL	Stock	52.44	52.4925	52.44	52.49	2988.0
2019-08-19 06:55:00	AAPL	Stock	52.45	52.5825	52.45	52.4975	10800.0
2019-08-19 07:00:00	AAPL	Stock	52.4275	52.5	52.4125	52.475	50888.0
2019-08-19 07:05:00	AAPL	Stock	52.46	52.465	52.4425	52.4575	6668.0
2019-08-19 07:10:00	AAPL	Stock	52.47	52.4875	52.46	52.4625	11900.0
2019-08-19 07:15:00	AAPL	Stock	52.4625	52.4875	52.4625	52.4875	12016.0
2019-08-19 07:20:00	AAPL	Stock	52.485	52.5175	52.485	52.4875	54744.0
2019-08-19 07:25:00	AAPL	Stock	52.5	52.5625	52.4975	52.535	12592.0
2019-08-19 07:30:00	AAPL	Stock	52.5475	52.5575	52.525	52.5575	14232.0
2019-08-19 07:35:00	AAPL	Stock	52.5875	52.6275	52.55	52.625	58416.0
2019-08-19 07:40:00	AAPL	Stock	52.5925	52.635	52.5925	52.6125	17212.0
2019-08-19 07:45:00	AAPL	Stock	52.6225	52.6225	52.6	52.6125	14140.0
2019-08-19 07:50:00	AAPL	Stock	52.605	52.615	52.6	52.6	13104.0
2019-08-19 07:55:00	AAPL	Stock	52.6125	52.62	52.5975	52.6	3580.0
2019-08-19 08:00:00	AAPL	Stock	52.48	52.63	52.4425	52.625	218388.0
2019-08-19 08:05:00	AAPL	Stock	52.5925	52.61	52.5675	52.58	14448.0
2019-08-19 08:10:00	AAPL	Stock	52.6	52.61	52.565	52.5875	25628.0
2019-08-19 08:15:00	AAPL	Stock	52.5875	52.6125	52.5375	52.555	10928.0
2019-08-19 08:20:00	AAPL	Stock	52.5525	52.6325	52.55	52.6	103152.0
2019-08-19 08:25:00	AAPL	Stock	52.6	52.6325	52.5675	52.6225	26512.0
2019-08-19 08:30:00	AAPL	Stock	52.6	52.675	52.6	52.675	30936.0
2019-08-19 08:35:00	AAPL	Stock	52.675	52.6975	52.66	52.6625	31412.0
2019-08-19 08:40:00	AAPL	Stock	52.6625	52.675	52.64	52.64	47044.0
2019-08-19 08:45:00	AAPL	Stock	52.645	52.71	52.645	52.6775	20648.0
2019-08-19 08:50:00	AAPL	Stock	52.7075	52.7125	52.65	52.65	41120.0
2019-08-19 08:55:00	AAPL	Stock	52.6925	52.7	52.6325	52.6375	11716.0
2019-08-19 09:00:00	AAPL	Stock	52.675	52.675	52.6175	52.6175	28116.0
2019-08-19 09:05:00	AAPL	Stock	52.6175	52.65	52.6175	52.6375	37228.0
2019-08-19 09:10:00	AAPL	Stock	52.6275	52.6475	52.6275	52.6278	25652.0
2019-08-19 09:15:00	AAPL	Stock	52.6275	52.6675	52.6275	52.6675	52780.0
2019-08-19 09:20:00	AAPL	Stock	52.6875	52.6875	52.65	52.65	62736.0
2019-08-19 09:25:00	AAPL	Stock	52.6475	52.6775	52.6275	52.655	64460.0
2019-08-19 09:30:00	AAPL	Stock	52.6725	52.9075	52.5062	52.9025	7561168.0
2019-08-19 09:35:00	AAPL	Stock	52.9075	53.0875	52.905	53.051	3814128.0

> showing 50 of 356,503 rows — these rows as CSV

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