PREVIEW / stock_5min / 2020-03-12

all stock 5-min files

  file:    by_date/stock_5min/2020/2020-03-12.parquet
  size:    6.9 MB
  rows:    432,377
  symbols: 2,488

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-12 04:00:00	AAPL	Stock	65.95	66.185	65.875	65.875	69636.0
2020-03-12 04:05:00	AAPL	Stock	65.875	66.185	65.75	65.75	29644.0
2020-03-12 04:10:00	AAPL	Stock	65.755	65.7575	65.525	65.75	22716.0
2020-03-12 04:15:00	AAPL	Stock	65.75	65.96	65.75	65.905	12552.0
2020-03-12 04:20:00	AAPL	Stock	65.825	65.825	65.7475	65.7475	15516.0
2020-03-12 04:25:00	AAPL	Stock	65.76	65.76	65.5275	65.555	23432.0
2020-03-12 04:30:00	AAPL	Stock	65.57	65.71	65.4125	65.6075	35488.0
2020-03-12 04:35:00	AAPL	Stock	65.3425	65.35	65.25	65.35	7252.0
2020-03-12 04:40:00	AAPL	Stock	65.3325	65.35	65.25	65.3	7848.0
2020-03-12 04:45:00	AAPL	Stock	65.29	65.29	65.0575	65.18	22208.0
2020-03-12 04:50:00	AAPL	Stock	65.125	65.285	65.125	65.285	12292.0
2020-03-12 04:55:00	AAPL	Stock	65.325	65.5	65.25	65.275	12152.0
2020-03-12 05:00:00	AAPL	Stock	65.275	65.275	65.1875	65.1875	6400.0
2020-03-12 05:05:00	AAPL	Stock	65.175	65.25	65.15	65.15	2800.0
2020-03-12 05:10:00	AAPL	Stock	65.075	65.1125	65.05	65.0875	5892.0
2020-03-12 05:20:00	AAPL	Stock	65.0875	65.2475	65.0575	65.125	17692.0
2020-03-12 05:25:00	AAPL	Stock	65.085	65.125	64.9475	64.97	35540.0
2020-03-12 05:30:00	AAPL	Stock	64.95	65.075	64.95	65.075	10100.0
2020-03-12 05:35:00	AAPL	Stock	65.005	65.005	64.9475	64.95	13620.0
2020-03-12 05:40:00	AAPL	Stock	64.9475	65.05	64.8775	64.9375	24508.0
2020-03-12 05:45:00	AAPL	Stock	65.0	65.35	65.0	65.25	31336.0
2020-03-12 05:50:00	AAPL	Stock	65.35	65.355	65.22	65.25	18364.0
2020-03-12 05:55:00	AAPL	Stock	65.175	65.25	65.125	65.125	7188.0
2020-03-12 06:00:00	AAPL	Stock	65.0675	65.125	65.05	65.05	3740.0
2020-03-12 06:05:00	AAPL	Stock	65.1375	65.1375	65.0	65.1225	11464.0
2020-03-12 06:10:00	AAPL	Stock	65.1975	65.325	65.175	65.175	24660.0
2020-03-12 06:15:00	AAPL	Stock	65.0575	65.125	65.04	65.125	3068.0
2020-03-12 06:20:00	AAPL	Stock	65.085	65.1075	64.9975	65.0425	24380.0
2020-03-12 06:25:00	AAPL	Stock	65.0875	65.3375	65.0875	65.3375	15744.0
2020-03-12 06:30:00	AAPL	Stock	65.215	65.32	65.1925	65.32	3904.0
2020-03-12 06:35:00	AAPL	Stock	65.25	65.2775	65.175	65.2775	5116.0
2020-03-12 06:40:00	AAPL	Stock	65.22	65.3725	65.22	65.3725	5036.0
2020-03-12 06:45:00	AAPL	Stock	65.2775	65.335	65.17	65.335	3708.0
2020-03-12 06:50:00	AAPL	Stock	65.3075	65.3075	65.1375	65.205	5684.0
2020-03-12 06:55:00	AAPL	Stock	65.175	65.375	65.16	65.375	9140.0
2020-03-12 07:00:00	AAPL	Stock	65.4025	65.7475	65.0875	65.105	231808.0
2020-03-12 07:05:00	AAPL	Stock	65.1075	65.125	64.8475	64.87	152352.0
2020-03-12 07:10:00	AAPL	Stock	64.8125	64.9	64.76	64.825	79252.0
2020-03-12 07:15:00	AAPL	Stock	64.8	64.9825	64.8	64.85	67016.0
2020-03-12 07:20:00	AAPL	Stock	64.875	64.9125	64.695	64.7375	82228.0
2020-03-12 07:25:00	AAPL	Stock	64.7375	64.7375	64.625	64.645	59564.0
2020-03-12 07:30:00	AAPL	Stock	64.6675	64.675	64.5	64.675	113812.0
2020-03-12 07:35:00	AAPL	Stock	64.675	64.775	64.5875	64.625	83976.0
2020-03-12 07:40:00	AAPL	Stock	64.67	64.815	64.5725	64.575	152276.0
2020-03-12 07:45:00	AAPL	Stock	64.58	64.6475	64.53	64.6125	28772.0
2020-03-12 07:50:00	AAPL	Stock	64.62	64.6975	64.345	64.3775	109372.0
2020-03-12 07:55:00	AAPL	Stock	64.385	64.3975	64.275	64.325	47300.0
2020-03-12 08:00:00	AAPL	Stock	64.35	65.4338	64.0825	64.11	530380.0
2020-03-12 08:05:00	AAPL	Stock	64.1	64.1725	63.9	63.9375	144708.0
2020-03-12 08:10:00	AAPL	Stock	63.9375	64.0	63.865	63.915	83328.0

> showing 50 of 432,377 rows — these rows as CSV

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