PREVIEW / stock_5min / 2019-11-20

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-11-20.parquet
  size:    5.9 MB
  rows:    375,096
  symbols: 2,500

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
2019-11-20 04:00:00	AAPL	Stock	66.2475	66.2475	66.1525	66.1525	7720.0
2019-11-20 04:05:00	AAPL	Stock	66.0875	66.0875	66.075	66.075	2564.0
2019-11-20 04:10:00	AAPL	Stock	66.0875	66.0875	66.0875	66.0875	800.0
2019-11-20 04:20:00	AAPL	Stock	66.17	66.17	66.17	66.17	400.0
2019-11-20 04:30:00	AAPL	Stock	66.14	66.1825	66.14	66.1825	944.0
2019-11-20 04:35:00	AAPL	Stock	66.1875	66.23	66.1875	66.23	3188.0
2019-11-20 04:40:00	AAPL	Stock	66.2225	66.2225	66.2225	66.2225	800.0
2019-11-20 04:50:00	AAPL	Stock	66.2025	66.215	66.2025	66.215	2596.0
2019-11-20 04:55:00	AAPL	Stock	66.215	66.22	66.215	66.22	1000.0
2019-11-20 05:00:00	AAPL	Stock	66.215	66.215	66.215	66.215	1132.0
2019-11-20 05:05:00	AAPL	Stock	66.2075	66.2075	66.2025	66.2025	1668.0
2019-11-20 05:10:00	AAPL	Stock	66.19	66.19	66.165	66.165	3712.0
2019-11-20 05:15:00	AAPL	Stock	66.15	66.15	66.15	66.15	400.0
2019-11-20 05:20:00	AAPL	Stock	66.155	66.155	66.155	66.155	404.0
2019-11-20 05:35:00	AAPL	Stock	66.14	66.14	66.1	66.1	11544.0
2019-11-20 05:40:00	AAPL	Stock	66.09	66.09	66.09	66.09	400.0
2019-11-20 05:50:00	AAPL	Stock	66.1375	66.1375	66.09	66.09	5440.0
2019-11-20 06:05:00	AAPL	Stock	66.15	66.15	66.05	66.05	12348.0
2019-11-20 06:10:00	AAPL	Stock	66.07	66.07	66.07	66.07	4000.0
2019-11-20 06:15:00	AAPL	Stock	66.1475	66.1475	66.1475	66.1475	400.0
2019-11-20 06:20:00	AAPL	Stock	66.13	66.13	66.075	66.075	7732.0
2019-11-20 06:25:00	AAPL	Stock	66.0775	66.0775	66.075	66.075	1400.0
2019-11-20 06:35:00	AAPL	Stock	66.1225	66.1375	66.1225	66.1375	2900.0
2019-11-20 06:45:00	AAPL	Stock	66.1925	66.2125	66.1925	66.195	23680.0
2019-11-20 06:50:00	AAPL	Stock	66.215	66.25	66.215	66.25	3600.0
2019-11-20 06:55:00	AAPL	Stock	66.25	66.255	66.25	66.255	2832.0
2019-11-20 07:00:00	AAPL	Stock	66.275	66.3075	66.2575	66.2575	5420.0
2019-11-20 07:05:00	AAPL	Stock	66.275	66.275	66.275	66.275	3600.0
2019-11-20 07:10:00	AAPL	Stock	66.275	66.3375	66.275	66.3175	35328.0
2019-11-20 07:15:00	AAPL	Stock	66.3175	66.3225	66.3125	66.3125	7600.0
2019-11-20 07:20:00	AAPL	Stock	66.3075	66.3075	66.25	66.2525	41304.0
2019-11-20 07:25:00	AAPL	Stock	66.255	66.2575	66.25	66.25	8660.0
2019-11-20 07:30:00	AAPL	Stock	66.25	66.25	66.225	66.25	12756.0
2019-11-20 07:35:00	AAPL	Stock	66.2475	66.25	66.235	66.235	8972.0
2019-11-20 07:40:00	AAPL	Stock	66.25	66.275	66.22	66.22	25632.0
2019-11-20 07:45:00	AAPL	Stock	66.225	66.27	66.225	66.2625	8600.0
2019-11-20 07:50:00	AAPL	Stock	66.2625	66.27	66.22	66.225	7712.0
2019-11-20 07:55:00	AAPL	Stock	66.2225	66.2375	66.2075	66.2225	8908.0
2019-11-20 08:00:00	AAPL	Stock	66.255	66.3325	66.2	66.2025	88388.0
2019-11-20 08:05:00	AAPL	Stock	66.2088	66.295	66.2088	66.275	16284.0
2019-11-20 08:10:00	AAPL	Stock	66.2425	66.245	66.2025	66.225	9200.0
2019-11-20 08:15:00	AAPL	Stock	66.225	66.275	66.2175	66.275	20296.0
2019-11-20 08:20:00	AAPL	Stock	66.2515	66.3375	66.2515	66.2875	25168.0
2019-11-20 08:25:00	AAPL	Stock	66.32	66.32	66.2875	66.2875	9780.0
2019-11-20 08:30:00	AAPL	Stock	66.2925	66.325	66.2925	66.3125	8236.0
2019-11-20 08:35:00	AAPL	Stock	66.3025	66.3125	66.275	66.275	15024.0
2019-11-20 08:40:00	AAPL	Stock	66.28	66.3	66.28	66.3	7960.0
2019-11-20 08:45:00	AAPL	Stock	66.2875	66.2875	66.215	66.215	64160.0
2019-11-20 08:50:00	AAPL	Stock	66.225	66.2498	66.2152	66.2472	15300.0
2019-11-20 08:55:00	AAPL	Stock	66.2275	66.2385	66.216	66.225	18680.0

> showing 50 of 375,096 rows — these rows as CSV

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