PREVIEW / stock_5min / 2020-03-20

all stock 5-min files

  file:    by_date/stock_5min/2020/2020-03-20.parquet
  size:    6.7 MB
  rows:    427,206
  symbols: 2,455

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-03-20 04:00:00	AAPL	Stock	63.525	64.25	63.25	64.25	34780.0
2020-03-20 04:05:00	AAPL	Stock	64.195	64.4975	64.195	64.3	27584.0
2020-03-20 04:10:00	AAPL	Stock	64.3725	64.6	64.25	64.6	12220.0
2020-03-20 04:15:00	AAPL	Stock	64.5	64.5025	64.2775	64.375	15136.0
2020-03-20 04:20:00	AAPL	Stock	64.285	64.285	64.085	64.085	6292.0
2020-03-20 04:25:00	AAPL	Stock	64.225	64.3	64.1275	64.25	6624.0
2020-03-20 04:30:00	AAPL	Stock	64.245	64.25	63.605	63.75	34996.0
2020-03-20 04:35:00	AAPL	Stock	63.8325	63.85	63.75	63.75	6752.0
2020-03-20 04:40:00	AAPL	Stock	63.75	63.75	63.75	63.75	2480.0
2020-03-20 04:45:00	AAPL	Stock	63.7625	64.1	63.75	64.1	17788.0
2020-03-20 04:50:00	AAPL	Stock	64.02	64.2975	64.0125	64.175	20792.0
2020-03-20 04:55:00	AAPL	Stock	64.2125	64.4175	64.2125	64.35	32696.0
2020-03-20 05:00:00	AAPL	Stock	64.35	64.385	64.265	64.35	12376.0
2020-03-20 05:05:00	AAPL	Stock	64.39	64.39	64.25	64.25	30132.0
2020-03-20 05:10:00	AAPL	Stock	64.25	64.35	64.2475	64.2475	11356.0
2020-03-20 05:15:00	AAPL	Stock	64.325	64.5	64.325	64.5	14624.0
2020-03-20 05:20:00	AAPL	Stock	64.5	64.5	64.3625	64.4225	2852.0
2020-03-20 05:25:00	AAPL	Stock	64.36	64.36	64.275	64.29	4672.0
2020-03-20 05:30:00	AAPL	Stock	64.2525	64.2525	64.25	64.25	1400.0
2020-03-20 05:35:00	AAPL	Stock	64.425	64.425	64.365	64.365	1580.0
2020-03-20 05:40:00	AAPL	Stock	64.3325	64.3325	64.325	64.325	2088.0
2020-03-20 05:45:00	AAPL	Stock	64.35	64.42	64.3175	64.42	7516.0
2020-03-20 05:50:00	AAPL	Stock	64.295	64.61	64.295	64.61	10016.0
2020-03-20 05:55:00	AAPL	Stock	64.625	64.625	64.5325	64.575	2732.0
2020-03-20 06:00:00	AAPL	Stock	64.5375	64.5875	64.5375	64.5875	1200.0
2020-03-20 06:05:00	AAPL	Stock	64.575	64.625	64.575	64.625	7396.0
2020-03-20 06:10:00	AAPL	Stock	64.625	64.6425	64.5625	64.5625	11232.0
2020-03-20 06:15:00	AAPL	Stock	64.5625	64.5625	64.3875	64.4375	9864.0
2020-03-20 06:20:00	AAPL	Stock	64.375	64.475	64.35	64.45	5772.0
2020-03-20 06:25:00	AAPL	Stock	64.4825	64.5225	64.375	64.375	13516.0
2020-03-20 06:30:00	AAPL	Stock	64.375	64.4375	64.3125	64.37	13276.0
2020-03-20 06:35:00	AAPL	Stock	64.375	64.38	64.37	64.375	8360.0
2020-03-20 06:40:00	AAPL	Stock	64.4125	64.4125	64.0025	64.065	25768.0
2020-03-20 06:45:00	AAPL	Stock	64.065	64.065	63.8875	64.025	27836.0
2020-03-20 06:50:00	AAPL	Stock	64.0425	64.1075	64.0225	64.0525	18736.0
2020-03-20 06:55:00	AAPL	Stock	64.0	64.0	63.9475	63.9525	5200.0
2020-03-20 07:00:00	AAPL	Stock	63.9475	64.0	63.25	63.44	186740.0
2020-03-20 07:05:00	AAPL	Stock	63.4625	63.4875	63.24	63.35	67980.0
2020-03-20 07:10:00	AAPL	Stock	63.35	63.35	63.0	63.0375	59792.0
2020-03-20 07:15:00	AAPL	Stock	63.0425	63.125	62.8875	63.12	118296.0
2020-03-20 07:20:00	AAPL	Stock	62.975	63.01	62.5125	62.5125	115592.0
2020-03-20 07:25:00	AAPL	Stock	62.505	62.97	62.5	62.9375	130556.0
2020-03-20 07:30:00	AAPL	Stock	62.9525	63.25	62.9375	62.95	72812.0
2020-03-20 07:35:00	AAPL	Stock	63.015	63.0325	62.6575	62.75	49916.0
2020-03-20 07:40:00	AAPL	Stock	62.8325	62.9675	62.815	62.815	22092.0
2020-03-20 07:45:00	AAPL	Stock	62.87	63.0625	62.835	62.9525	39164.0
2020-03-20 07:50:00	AAPL	Stock	62.975	63.1525	62.8125	63.105	35096.0
2020-03-20 07:55:00	AAPL	Stock	63.1	63.175	62.885	62.995	52652.0
2020-03-20 08:00:00	AAPL	Stock	63.6725	63.6725	62.5025	63.07	290312.0
2020-03-20 08:05:00	AAPL	Stock	63.0525	63.0875	62.9325	62.995	67836.0

> showing 50 of 427,206 rows — these rows as CSV

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