PREVIEW / stock_5min / 2020-05-01

all stock 5-min files

  file:    by_date/stock_5min/2020/2020-05-01.parquet
  size:    6.3 MB
  rows:    399,861
  symbols: 2,394

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-05-01 04:00:00	AAPL	Stock	71.32	71.4175	71.125	71.125	11892.0
2020-05-01 04:05:00	AAPL	Stock	71.12	71.125	71.0	71.0	4160.0
2020-05-01 04:10:00	AAPL	Stock	71.0025	71.0025	71.0	71.0	4596.0
2020-05-01 04:20:00	AAPL	Stock	71.08	71.08	71.0325	71.0325	1304.0
2020-05-01 04:25:00	AAPL	Stock	71.13	71.2225	71.13	71.2225	4040.0
2020-05-01 04:30:00	AAPL	Stock	71.22	71.22	71.1425	71.1425	1200.0
2020-05-01 04:40:00	AAPL	Stock	71.125	71.125	71.125	71.125	2124.0
2020-05-01 04:50:00	AAPL	Stock	71.275	71.275	71.245	71.245	3200.0
2020-05-01 05:00:00	AAPL	Stock	71.325	71.4	71.325	71.4	3800.0
2020-05-01 05:05:00	AAPL	Stock	71.4	71.4975	71.4	71.495	3480.0
2020-05-01 05:10:00	AAPL	Stock	71.375	71.375	71.37	71.375	4048.0
2020-05-01 05:20:00	AAPL	Stock	71.28	71.28	71.28	71.28	400.0
2020-05-01 05:25:00	AAPL	Stock	71.2775	71.2775	71.2775	71.2775	416.0
2020-05-01 05:35:00	AAPL	Stock	71.25	71.25	71.2	71.2	1600.0
2020-05-01 05:45:00	AAPL	Stock	71.25	71.25	71.125	71.135	3888.0
2020-05-01 06:05:00	AAPL	Stock	71.2625	71.2625	71.26	71.26	800.0
2020-05-01 06:15:00	AAPL	Stock	71.4375	71.5	71.4375	71.5	12236.0
2020-05-01 06:20:00	AAPL	Stock	71.4975	71.5	71.4975	71.5	14860.0
2020-05-01 06:25:00	AAPL	Stock	71.555	71.5725	71.555	71.5725	2512.0
2020-05-01 06:30:00	AAPL	Stock	71.56	71.5975	71.56	71.5975	5176.0
2020-05-01 06:35:00	AAPL	Stock	71.62	71.65	71.5	71.5	6528.0
2020-05-01 06:40:00	AAPL	Stock	71.395	71.395	71.355	71.355	800.0
2020-05-01 06:50:00	AAPL	Stock	71.345	71.43	71.325	71.3775	11076.0
2020-05-01 07:00:00	AAPL	Stock	71.38	71.525	71.35	71.375	41716.0
2020-05-01 07:05:00	AAPL	Stock	71.3775	71.3775	71.155	71.175	45336.0
2020-05-01 07:10:00	AAPL	Stock	71.1525	71.215	71.05	71.2125	37756.0
2020-05-01 07:15:00	AAPL	Stock	71.225	71.26	71.2125	71.245	14972.0
2020-05-01 07:20:00	AAPL	Stock	71.275	71.2925	71.12	71.125	31124.0
2020-05-01 07:25:00	AAPL	Stock	71.15	71.1975	71.1025	71.125	19636.0
2020-05-01 07:30:00	AAPL	Stock	71.1125	71.205	71.0875	71.205	20580.0
2020-05-01 07:35:00	AAPL	Stock	71.2	71.22	71.125	71.135	31028.0
2020-05-01 07:40:00	AAPL	Stock	71.1625	71.35	71.1625	71.35	29960.0
2020-05-01 07:45:00	AAPL	Stock	71.35	71.4425	71.305	71.4375	28764.0
2020-05-01 07:50:00	AAPL	Stock	71.4375	71.445	71.33	71.425	39104.0
2020-05-01 07:55:00	AAPL	Stock	71.4025	71.41	71.35	71.375	26684.0
2020-05-01 08:00:00	AAPL	Stock	71.455	71.55	71.0275	71.225	225884.0
2020-05-01 08:05:00	AAPL	Stock	71.2125	71.4375	71.1875	71.4375	75004.0
2020-05-01 08:10:00	AAPL	Stock	71.45	71.675	71.3775	71.5	132240.0
2020-05-01 08:15:00	AAPL	Stock	71.5325	71.575	71.2825	71.2825	55316.0
2020-05-01 08:20:00	AAPL	Stock	71.279	71.42	71.2	71.2	50356.0
2020-05-01 08:25:00	AAPL	Stock	71.2125	71.32	71.1875	71.1875	56792.0
2020-05-01 08:30:00	AAPL	Stock	71.245	71.45	71.2075	71.3682	85240.0
2020-05-01 08:35:00	AAPL	Stock	71.4	71.5475	71.4	71.45	86568.0
2020-05-01 08:40:00	AAPL	Stock	71.4875	71.5625	71.4425	71.4875	45736.0
2020-05-01 08:45:00	AAPL	Stock	71.4875	71.6225	71.4875	71.6025	65312.0
2020-05-01 08:50:00	AAPL	Stock	71.6075	71.6975	71.5025	71.685	117420.0
2020-05-01 08:55:00	AAPL	Stock	71.685	71.8125	71.6625	71.6775	144348.0
2020-05-01 09:00:00	AAPL	Stock	71.72	71.72	71.525	71.59	85184.0
2020-05-01 09:05:00	AAPL	Stock	71.59	71.745	71.555	71.725	108512.0
2020-05-01 09:10:00	AAPL	Stock	71.7375	71.935	71.725	71.825	218408.0

> showing 50 of 399,861 rows — these rows as CSV

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