PREVIEW / stock_5min / 2020-04-08

all stock 5-min files

  file:    by_date/stock_5min/2020/2020-04-08.parquet
  size:    6.4 MB
  rows:    401,736
  symbols: 2,432

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-04-08 04:00:00	AAPL	Stock	65.0	65.0	65.0	65.0	2548.0
2020-04-08 04:05:00	AAPL	Stock	65.1925	65.1925	65.1925	65.1925	3616.0
2020-04-08 04:10:00	AAPL	Stock	65.0	65.0	65.0	65.0	708.0
2020-04-08 04:20:00	AAPL	Stock	64.79	64.79	64.79	64.79	548.0
2020-04-08 04:25:00	AAPL	Stock	64.645	64.645	64.6125	64.6125	12280.0
2020-04-08 04:30:00	AAPL	Stock	64.36	64.45	64.355	64.45	2800.0
2020-04-08 04:55:00	AAPL	Stock	64.7675	64.83	64.7675	64.83	2816.0
2020-04-08 05:10:00	AAPL	Stock	64.815	64.815	64.8	64.8	5800.0
2020-04-08 05:25:00	AAPL	Stock	64.675	64.75	64.675	64.75	3284.0
2020-04-08 05:30:00	AAPL	Stock	64.75	64.75	64.75	64.75	800.0
2020-04-08 05:40:00	AAPL	Stock	64.835	64.835	64.835	64.835	616.0
2020-04-08 05:45:00	AAPL	Stock	64.85	64.85	64.8475	64.8475	1200.0
2020-04-08 05:50:00	AAPL	Stock	64.8225	64.8225	64.675	64.675	9228.0
2020-04-08 06:00:00	AAPL	Stock	64.7	64.7	64.7	64.7	1428.0
2020-04-08 06:20:00	AAPL	Stock	64.9175	64.9175	64.9175	64.9175	496.0
2020-04-08 06:30:00	AAPL	Stock	64.985	65.0	64.985	65.0	1236.0
2020-04-08 06:35:00	AAPL	Stock	64.995	65.125	64.92	65.125	6684.0
2020-04-08 06:40:00	AAPL	Stock	65.125	65.2475	65.12	65.2475	17428.0
2020-04-08 06:45:00	AAPL	Stock	65.235	65.245	65.14	65.14	2892.0
2020-04-08 06:50:00	AAPL	Stock	65.135	65.145	65.13	65.1375	2716.0
2020-04-08 06:55:00	AAPL	Stock	65.175	65.175	65.175	65.175	800.0
2020-04-08 07:00:00	AAPL	Stock	65.135	65.31	65.135	65.31	18360.0
2020-04-08 07:05:00	AAPL	Stock	65.3575	65.59	65.3575	65.495	44172.0
2020-04-08 07:10:00	AAPL	Stock	65.5625	65.6775	65.5125	65.665	29744.0
2020-04-08 07:15:00	AAPL	Stock	65.6875	65.7125	65.625	65.625	17364.0
2020-04-08 07:20:00	AAPL	Stock	65.625	65.7	65.6025	65.6625	17440.0
2020-04-08 07:25:00	AAPL	Stock	65.685	65.69	65.5625	65.63	28488.0
2020-04-08 07:30:00	AAPL	Stock	65.6	65.6	65.4475	65.5	28204.0
2020-04-08 07:35:00	AAPL	Stock	65.5225	65.62	65.5225	65.5725	14096.0
2020-04-08 07:40:00	AAPL	Stock	65.575	65.59	65.375	65.375	15816.0
2020-04-08 07:45:00	AAPL	Stock	65.425	65.425	65.3375	65.4025	5004.0
2020-04-08 07:50:00	AAPL	Stock	65.47	65.575	65.47	65.545	17292.0
2020-04-08 07:55:00	AAPL	Stock	65.5425	65.625	65.5425	65.575	23376.0
2020-04-08 08:00:00	AAPL	Stock	65.2875	65.7225	65.175	65.7125	111960.0
2020-04-08 08:05:00	AAPL	Stock	65.7075	65.9625	65.665	65.865	102480.0
2020-04-08 08:10:00	AAPL	Stock	65.875	65.9475	65.775	65.8625	47708.0
2020-04-08 08:15:00	AAPL	Stock	65.8675	65.87	65.76	65.8125	48624.0
2020-04-08 08:20:00	AAPL	Stock	65.7975	65.82	65.7	65.7	74764.0
2020-04-08 08:25:00	AAPL	Stock	65.705	65.75	65.7	65.725	59336.0
2020-04-08 08:30:00	AAPL	Stock	65.7025	65.8025	65.7	65.7495	24444.0
2020-04-08 08:35:00	AAPL	Stock	65.74	65.7425	65.6025	65.625	39160.0
2020-04-08 08:40:00	AAPL	Stock	65.65	65.6725	65.555	65.67	76264.0
2020-04-08 08:45:00	AAPL	Stock	65.6925	65.75	65.625	65.6875	51908.0
2020-04-08 08:50:00	AAPL	Stock	65.6225	65.63	65.43	65.4325	61592.0
2020-04-08 08:55:00	AAPL	Stock	65.425	65.525	65.4068	65.525	73664.0
2020-04-08 09:00:00	AAPL	Stock	65.5	65.6625	65.5	65.615	71800.0
2020-04-08 09:05:00	AAPL	Stock	65.5975	65.7475	65.5775	65.6025	139964.0
2020-04-08 09:10:00	AAPL	Stock	65.635	65.6975	65.6	65.6	23788.0
2020-04-08 09:15:00	AAPL	Stock	65.6125	65.6812	65.575	65.675	40972.0
2020-04-08 09:20:00	AAPL	Stock	65.6812	65.7175	65.66	65.685	54064.0

> showing 50 of 401,736 rows — these rows as CSV

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