PREVIEW / stock_5min / 2020-07-01

all stock 5-min files

  file:    by_date/stock_5min/2020/2020-07-01.parquet
  size:    6.5 MB
  rows:    413,306
  symbols: 2,440

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-07-01 04:00:00	AAPL	Stock	91.035	91.035	91.0025	91.0025	1660.0
2020-07-01 04:10:00	AAPL	Stock	91.115	91.115	91.115	91.115	2688.0
2020-07-01 04:30:00	AAPL	Stock	91.03	91.03	91.03	91.03	400.0
2020-07-01 05:05:00	AAPL	Stock	91.0525	91.0525	91.0	91.0	4940.0
2020-07-01 05:10:00	AAPL	Stock	91.0	91.0	91.0	91.0	1360.0
2020-07-01 06:10:00	AAPL	Stock	91.0325	91.0325	91.0325	91.0325	824.0
2020-07-01 06:20:00	AAPL	Stock	91.025	91.025	91.025	91.025	1920.0
2020-07-01 06:25:00	AAPL	Stock	90.95	90.95	90.95	90.95	1184.0
2020-07-01 06:30:00	AAPL	Stock	90.9725	90.9975	90.9725	90.9975	3196.0
2020-07-01 06:35:00	AAPL	Stock	90.9375	90.9375	90.875	90.8775	3696.0
2020-07-01 06:40:00	AAPL	Stock	90.845	90.845	90.7775	90.7775	3396.0
2020-07-01 06:45:00	AAPL	Stock	90.77	90.8075	90.755	90.8075	2000.0
2020-07-01 06:50:00	AAPL	Stock	90.7575	90.7575	90.75	90.75	8368.0
2020-07-01 06:55:00	AAPL	Stock	90.7075	90.7075	90.7075	90.7075	5600.0
2020-07-01 07:00:00	AAPL	Stock	90.765	90.8025	90.65	90.65	28036.0
2020-07-01 07:05:00	AAPL	Stock	90.6425	90.715	90.6425	90.6825	17708.0
2020-07-01 07:10:00	AAPL	Stock	90.7	90.7125	90.69	90.6925	5480.0
2020-07-01 07:15:00	AAPL	Stock	90.7125	90.7625	90.7125	90.7625	7712.0
2020-07-01 07:20:00	AAPL	Stock	90.7275	90.9375	90.675	90.76	37968.0
2020-07-01 07:25:00	AAPL	Stock	90.7875	90.8	90.7875	90.8	800.0
2020-07-01 07:30:00	AAPL	Stock	90.75	90.75	90.625	90.625	29660.0
2020-07-01 07:35:00	AAPL	Stock	90.58	90.64	90.58	90.63	2820.0
2020-07-01 07:40:00	AAPL	Stock	90.6375	90.6375	90.575	90.575	2852.0
2020-07-01 07:45:00	AAPL	Stock	90.5875	90.625	90.57	90.57	16240.0
2020-07-01 07:50:00	AAPL	Stock	90.595	90.6375	90.595	90.6375	6612.0
2020-07-01 07:55:00	AAPL	Stock	90.6725	90.7	90.6525	90.7	5916.0
2020-07-01 08:00:00	AAPL	Stock	90.57	90.875	90.5325	90.8675	91148.0
2020-07-01 08:05:00	AAPL	Stock	90.8675	90.8775	90.86	90.8765	19604.0
2020-07-01 08:10:00	AAPL	Stock	90.8125	90.8125	90.725	90.7725	13844.0
2020-07-01 08:15:00	AAPL	Stock	90.765	90.8235	90.75	90.775	15492.0
2020-07-01 08:20:00	AAPL	Stock	90.775	90.985	90.775	90.9375	24212.0
2020-07-01 08:25:00	AAPL	Stock	90.945	90.97	90.9025	90.97	29740.0
2020-07-01 08:30:00	AAPL	Stock	90.94	91.0	90.94	90.965	8820.0
2020-07-01 08:35:00	AAPL	Stock	90.9825	91.097	90.9825	91.0025	53900.0
2020-07-01 08:40:00	AAPL	Stock	91.05	91.05	91.0	91.0375	21788.0
2020-07-01 08:45:00	AAPL	Stock	91.05	91.1225	91.0125	91.025	19484.0
2020-07-01 08:50:00	AAPL	Stock	91.05	91.1225	91.0325	91.079	11812.0
2020-07-01 08:55:00	AAPL	Stock	91.115	91.3	91.115	91.3	54976.0
2020-07-01 09:00:00	AAPL	Stock	91.3025	91.55	91.3025	91.525	168728.0
2020-07-01 09:05:00	AAPL	Stock	91.5	91.55	91.39	91.4375	54704.0
2020-07-01 09:10:00	AAPL	Stock	91.445	91.4475	91.3075	91.38	35552.0
2020-07-01 09:15:00	AAPL	Stock	91.325	91.38	91.325	91.3775	45924.0
2020-07-01 09:20:00	AAPL	Stock	91.375	91.38	91.35	91.35	46180.0
2020-07-01 09:25:00	AAPL	Stock	91.3875	91.5	91.25	91.2825	72312.0
2020-07-01 09:30:00	AAPL	Stock	91.255	91.8375	91.2325	91.6942	4717340.0
2020-07-01 09:35:00	AAPL	Stock	91.685	91.82	91.4398	91.5825	2118080.0
2020-07-01 09:40:00	AAPL	Stock	91.605	91.7848	91.585	91.655	1714260.0
2020-07-01 09:45:00	AAPL	Stock	91.65	91.67	91.2975	91.4463	1761960.0
2020-07-01 09:50:00	AAPL	Stock	91.45	91.6025	91.34	91.435	1723420.0
2020-07-01 09:55:00	AAPL	Stock	91.4562	91.5	91.15	91.4925	1772956.0

> showing 50 of 413,306 rows — these rows as CSV

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