PREVIEW / stock_5min / 2020-03-26

all stock 5-min files

  file:    by_date/stock_5min/2020/2020-03-26.parquet
  size:    6.7 MB
  rows:    419,786
  symbols: 2,443

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-26 04:00:00	AAPL	Stock	60.8	60.97	60.75	60.75	21520.0
2020-03-26 04:05:00	AAPL	Stock	60.765	60.7675	60.7525	60.7525	7172.0
2020-03-26 04:10:00	AAPL	Stock	61.0	61.0	60.8	60.805	9008.0
2020-03-26 04:15:00	AAPL	Stock	60.9225	60.9225	60.5325	60.5325	15752.0
2020-03-26 04:20:00	AAPL	Stock	60.5325	60.5325	60.5325	60.5325	460.0
2020-03-26 04:25:00	AAPL	Stock	60.6925	60.75	60.6925	60.75	7588.0
2020-03-26 04:30:00	AAPL	Stock	60.6275	60.75	60.5775	60.75	3588.0
2020-03-26 04:35:00	AAPL	Stock	60.8375	60.8375	60.75	60.75	8552.0
2020-03-26 04:40:00	AAPL	Stock	60.7025	60.715	60.5	60.5	11704.0
2020-03-26 04:45:00	AAPL	Stock	60.6975	60.725	60.6975	60.725	1600.0
2020-03-26 04:50:00	AAPL	Stock	60.75	60.78	60.75	60.78	2944.0
2020-03-26 04:55:00	AAPL	Stock	60.7	60.825	60.7	60.825	800.0
2020-03-26 05:00:00	AAPL	Stock	61.0	61.0	61.0	61.0	400.0
2020-03-26 05:05:00	AAPL	Stock	61.1125	61.1325	61.1125	61.1125	6568.0
2020-03-26 05:10:00	AAPL	Stock	60.8275	60.8275	60.78	60.78	2120.0
2020-03-26 05:15:00	AAPL	Stock	60.78	60.78	60.75	60.75	1200.0
2020-03-26 05:30:00	AAPL	Stock	60.8675	60.8675	60.7825	60.7825	1684.0
2020-03-26 05:35:00	AAPL	Stock	60.8	60.8	60.8	60.8	800.0
2020-03-26 05:45:00	AAPL	Stock	60.9425	61.03	60.9425	61.03	868.0
2020-03-26 05:55:00	AAPL	Stock	60.98	60.98	60.98	60.98	400.0
2020-03-26 06:00:00	AAPL	Stock	61.03	61.03	61.025	61.025	2520.0
2020-03-26 06:10:00	AAPL	Stock	61.125	61.125	61.05	61.0625	3440.0
2020-03-26 06:15:00	AAPL	Stock	61.0625	61.0625	61.0625	61.0625	400.0
2020-03-26 06:20:00	AAPL	Stock	61.05	61.125	61.05	61.125	2800.0
2020-03-26 06:25:00	AAPL	Stock	61.1	61.1	61.1	61.1	4724.0
2020-03-26 06:30:00	AAPL	Stock	61.125	61.2125	61.125	61.2125	2000.0
2020-03-26 06:35:00	AAPL	Stock	61.3375	61.425	61.3375	61.425	2940.0
2020-03-26 06:40:00	AAPL	Stock	61.425	61.45	61.42	61.42	3872.0
2020-03-26 06:45:00	AAPL	Stock	61.25	61.2525	61.245	61.25	19484.0
2020-03-26 06:50:00	AAPL	Stock	61.3225	61.3225	61.075	61.12	7116.0
2020-03-26 06:55:00	AAPL	Stock	61.07	61.07	61.07	61.07	400.0
2020-03-26 07:00:00	AAPL	Stock	61.0075	61.3075	61.0	61.2675	61352.0
2020-03-26 07:05:00	AAPL	Stock	61.2675	61.2675	61.1125	61.225	36596.0
2020-03-26 07:10:00	AAPL	Stock	61.2125	61.275	61.2125	61.2625	36424.0
2020-03-26 07:15:00	AAPL	Stock	61.2625	61.35	61.2125	61.3	23472.0
2020-03-26 07:20:00	AAPL	Stock	61.3225	61.4	61.295	61.295	23552.0
2020-03-26 07:25:00	AAPL	Stock	61.3375	61.4	61.325	61.335	51328.0
2020-03-26 07:30:00	AAPL	Stock	61.3275	61.4	61.26	61.315	19016.0
2020-03-26 07:35:00	AAPL	Stock	61.33	61.33	61.255	61.255	18892.0
2020-03-26 07:40:00	AAPL	Stock	61.25	61.25	61.09	61.09	35616.0
2020-03-26 07:45:00	AAPL	Stock	61.09	61.09	60.82	60.82	101584.0
2020-03-26 07:50:00	AAPL	Stock	60.8125	60.8475	60.625	60.6425	55608.0
2020-03-26 07:55:00	AAPL	Stock	60.65	60.75	60.625	60.6725	26308.0
2020-03-26 08:00:00	AAPL	Stock	60.6275	61.4	60.535	60.6375	176952.0
2020-03-26 08:05:00	AAPL	Stock	60.669	60.669	60.455	60.455	76136.0
2020-03-26 08:10:00	AAPL	Stock	60.4675	60.4675	60.3125	60.3275	82832.0
2020-03-26 08:15:00	AAPL	Stock	60.3275	60.6375	60.215	60.5875	120728.0
2020-03-26 08:20:00	AAPL	Stock	60.645	60.645	60.275	60.275	111504.0
2020-03-26 08:25:00	AAPL	Stock	60.2525	60.32	60.1575	60.2475	72176.0
2020-03-26 08:30:00	AAPL	Stock	60.1625	60.8	60.1	60.6275	448412.0

> showing 50 of 419,786 rows — these rows as CSV

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