PREVIEW / stock_5min / 2019-07-15

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-07-15.parquet
  size:    5.5 MB
  rows:    347,020
  symbols: 2,572

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-07-15 04:20:00	AAPL	Stock	50.8825	50.8825	50.865	50.865	1200.0
2019-07-15 05:20:00	AAPL	Stock	50.8875	50.8875	50.8875	50.8875	1000.0
2019-07-15 05:35:00	AAPL	Stock	50.8625	50.8625	50.8625	50.8625	2000.0
2019-07-15 05:40:00	AAPL	Stock	50.865	50.865	50.865	50.865	400.0
2019-07-15 06:00:00	AAPL	Stock	50.865	50.865	50.865	50.865	4320.0
2019-07-15 07:00:00	AAPL	Stock	50.88	50.9525	50.88	50.925	13828.0
2019-07-15 07:15:00	AAPL	Stock	50.9625	50.9625	50.9325	50.9325	2000.0
2019-07-15 07:20:00	AAPL	Stock	50.9375	50.9375	50.9325	50.9325	1108.0
2019-07-15 07:30:00	AAPL	Stock	50.9625	50.9625	50.95	50.9525	4736.0
2019-07-15 07:40:00	AAPL	Stock	50.93	50.9375	50.93	50.9375	7108.0
2019-07-15 07:50:00	AAPL	Stock	50.9625	50.9625	50.9625	50.9625	8848.0
2019-07-15 07:55:00	AAPL	Stock	50.9625	50.9625	50.95	50.95	1800.0
2019-07-15 08:00:00	AAPL	Stock	50.9125	50.9875	50.9	50.9625	48728.0
2019-07-15 08:10:00	AAPL	Stock	50.9625	50.9725	50.9625	50.9725	5996.0
2019-07-15 08:15:00	AAPL	Stock	50.9675	50.9875	50.9625	50.9625	16008.0
2019-07-15 08:20:00	AAPL	Stock	50.9575	50.9575	50.94	50.94	1000.0
2019-07-15 08:25:00	AAPL	Stock	50.975	50.9875	50.975	50.9875	2200.0
2019-07-15 08:30:00	AAPL	Stock	50.98	50.9875	50.975	50.975	5152.0
2019-07-15 08:35:00	AAPL	Stock	50.9875	50.9875	50.9575	50.9575	1200.0
2019-07-15 08:45:00	AAPL	Stock	50.975	50.9975	50.975	50.9975	6924.0
2019-07-15 08:50:00	AAPL	Stock	51.0	51.0	50.9975	50.9993	17764.0
2019-07-15 08:55:00	AAPL	Stock	51.0	51.0	50.9775	50.9775	7008.0
2019-07-15 09:00:00	AAPL	Stock	50.9675	50.9675	50.965	50.965	2228.0
2019-07-15 09:05:00	AAPL	Stock	50.9775	50.9975	50.975	50.995	4184.0
2019-07-15 09:10:00	AAPL	Stock	50.9975	50.9975	50.9875	50.9975	33800.0
2019-07-15 09:15:00	AAPL	Stock	51.0	51.0225	50.9975	50.9975	10960.0
2019-07-15 09:20:00	AAPL	Stock	51.0175	51.0325	51.0175	51.025	5484.0
2019-07-15 09:25:00	AAPL	Stock	51.0275	51.03	51.0125	51.0275	44224.0
2019-07-15 09:30:00	AAPL	Stock	51.0225	51.3775	51.0	51.35	5073236.0
2019-07-15 09:35:00	AAPL	Stock	51.3425	51.4525	51.3325	51.385	2391252.0
2019-07-15 09:40:00	AAPL	Stock	51.385	51.4675	51.35	51.3525	1654220.0
2019-07-15 09:45:00	AAPL	Stock	51.355	51.365	51.262	51.31	2686572.0
2019-07-15 09:50:00	AAPL	Stock	51.3055	51.3055	51.2025	51.2475	1653084.0
2019-07-15 09:55:00	AAPL	Stock	51.245	51.2975	51.1763	51.29	1122056.0
2019-07-15 10:00:00	AAPL	Stock	51.286	51.3525	51.255	51.2612	1289404.0
2019-07-15 10:05:00	AAPL	Stock	51.26	51.2975	51.215	51.2662	1261448.0
2019-07-15 10:10:00	AAPL	Stock	51.265	51.2975	51.2403	51.28	681992.0
2019-07-15 10:15:00	AAPL	Stock	51.2788	51.3425	51.2675	51.3375	923344.0
2019-07-15 10:20:00	AAPL	Stock	51.3375	51.3475	51.29	51.3125	933636.0
2019-07-15 10:25:00	AAPL	Stock	51.3125	51.3162	51.2525	51.28	705692.0
2019-07-15 10:30:00	AAPL	Stock	51.2725	51.2975	51.265	51.2788	666672.0
2019-07-15 10:35:00	AAPL	Stock	51.2775	51.2925	51.235	51.2575	664828.0
2019-07-15 10:40:00	AAPL	Stock	51.26	51.2975	51.2475	51.283	449528.0
2019-07-15 10:45:00	AAPL	Stock	51.2825	51.2825	51.22	51.2375	519012.0
2019-07-15 10:50:00	AAPL	Stock	51.2375	51.275	51.2325	51.2425	503092.0
2019-07-15 10:55:00	AAPL	Stock	51.245	51.255	51.225	51.2325	303716.0
2019-07-15 11:00:00	AAPL	Stock	51.2325	51.245	51.225	51.231	361652.0
2019-07-15 11:05:00	AAPL	Stock	51.2305	51.2425	51.2	51.205	584388.0
2019-07-15 11:10:00	AAPL	Stock	51.205	51.2425	51.2025	51.2275	345368.0
2019-07-15 11:15:00	AAPL	Stock	51.225	51.2738	51.2225	51.2525	536380.0

> showing 50 of 347,020 rows — these rows as CSV

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