PREVIEW / stock_5min / 2020-07-14

all stock 5-min files

  file:    by_date/stock_5min/2020/2020-07-14.parquet
  size:    6.6 MB
  rows:    415,819
  symbols: 2,447

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-14 04:00:00	AAPL	Stock	95.9	96.0525	95.9	96.0525	20656.0
2020-07-14 04:05:00	AAPL	Stock	96.0	96.0475	96.0	96.0475	1852.0
2020-07-14 04:10:00	AAPL	Stock	96.05	96.1175	96.05	96.1	7484.0
2020-07-14 04:15:00	AAPL	Stock	96.1825	96.2225	96.1	96.1	5908.0
2020-07-14 04:25:00	AAPL	Stock	96.075	96.1025	96.075	96.1025	844.0
2020-07-14 04:30:00	AAPL	Stock	96.155	96.155	96.155	96.155	1200.0
2020-07-14 04:35:00	AAPL	Stock	96.22	96.2225	96.2175	96.2175	2676.0
2020-07-14 04:40:00	AAPL	Stock	96.2225	96.2225	96.2225	96.2225	2228.0
2020-07-14 04:45:00	AAPL	Stock	96.2225	96.33	96.2225	96.33	9656.0
2020-07-14 04:50:00	AAPL	Stock	96.3175	96.3175	96.255	96.315	2676.0
2020-07-14 04:55:00	AAPL	Stock	96.2475	96.2475	96.2475	96.2475	644.0
2020-07-14 05:00:00	AAPL	Stock	96.2	96.2	96.1675	96.2	3088.0
2020-07-14 05:05:00	AAPL	Stock	96.1775	96.1775	96.1	96.1	6104.0
2020-07-14 05:10:00	AAPL	Stock	96.0	96.0	96.0	96.0	412.0
2020-07-14 05:15:00	AAPL	Stock	96.1575	96.1575	96.1575	96.1575	776.0
2020-07-14 05:25:00	AAPL	Stock	96.3	96.3	96.3	96.3	1180.0
2020-07-14 05:30:00	AAPL	Stock	96.3	96.315	96.2575	96.2575	1928.0
2020-07-14 05:35:00	AAPL	Stock	96.275	96.275	96.275	96.275	400.0
2020-07-14 05:40:00	AAPL	Stock	96.2375	96.2375	96.2375	96.2375	800.0
2020-07-14 05:45:00	AAPL	Stock	96.21	96.21	96.205	96.205	800.0
2020-07-14 05:55:00	AAPL	Stock	96.1	96.19	96.1	96.105	7200.0
2020-07-14 06:00:00	AAPL	Stock	96.135	96.1425	96.135	96.1425	800.0
2020-07-14 06:05:00	AAPL	Stock	96.13	96.13	96.13	96.13	1000.0
2020-07-14 06:15:00	AAPL	Stock	96.125	96.125	96.0	96.0	1680.0
2020-07-14 06:20:00	AAPL	Stock	96.0075	96.0075	96.005	96.005	980.0
2020-07-14 06:25:00	AAPL	Stock	96.0225	96.0225	96.0125	96.0125	1196.0
2020-07-14 06:30:00	AAPL	Stock	96.0	96.0	96.0	96.0	896.0
2020-07-14 06:35:00	AAPL	Stock	95.82	95.82	95.82	95.82	800.0
2020-07-14 06:40:00	AAPL	Stock	95.88	95.88	95.88	95.88	3552.0
2020-07-14 06:45:00	AAPL	Stock	95.8175	95.875	95.8175	95.875	7172.0
2020-07-14 06:50:00	AAPL	Stock	95.8325	95.8325	95.82	95.82	936.0
2020-07-14 06:55:00	AAPL	Stock	95.8875	95.8875	95.7575	95.7575	3796.0
2020-07-14 07:00:00	AAPL	Stock	95.845	96.0725	95.765	96.0725	41452.0
2020-07-14 07:05:00	AAPL	Stock	96.0625	96.17	96.0025	96.1125	79680.0
2020-07-14 07:10:00	AAPL	Stock	96.1225	96.1525	95.77	95.875	52828.0
2020-07-14 07:15:00	AAPL	Stock	95.8775	95.8775	95.7825	95.8125	40408.0
2020-07-14 07:20:00	AAPL	Stock	95.85	95.925	95.8475	95.8975	17140.0
2020-07-14 07:25:00	AAPL	Stock	95.9075	96.025	95.9075	96.0175	18704.0
2020-07-14 07:30:00	AAPL	Stock	96.015	96.0725	96.015	96.07	10272.0
2020-07-14 07:35:00	AAPL	Stock	96.095	96.3025	96.095	96.3	55124.0
2020-07-14 07:40:00	AAPL	Stock	96.275	96.4825	96.275	96.4825	62368.0
2020-07-14 07:45:00	AAPL	Stock	96.485	96.51	96.35	96.3825	55736.0
2020-07-14 07:50:00	AAPL	Stock	96.475	96.575	96.39	96.575	38400.0
2020-07-14 07:55:00	AAPL	Stock	96.5975	96.7	96.5975	96.6	34088.0
2020-07-14 08:00:00	AAPL	Stock	95.924	96.6975	95.765	96.4975	153496.0
2020-07-14 08:05:00	AAPL	Stock	96.5	96.5625	96.5	96.525	20284.0
2020-07-14 08:10:00	AAPL	Stock	96.525	96.525	96.4075	96.4075	40488.0
2020-07-14 08:15:00	AAPL	Stock	96.375	96.4125	96.3125	96.3525	45072.0
2020-07-14 08:20:00	AAPL	Stock	96.38	96.46	96.195	96.195	50704.0
2020-07-14 08:25:00	AAPL	Stock	96.1925	96.195	96.05	96.14	31864.0

> showing 50 of 415,819 rows — these rows as CSV

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