PREVIEW / stock_5min / 2019-03-19

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-03-19.parquet
  size:    5.8 MB
  rows:    363,418
  symbols: 2,641

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-03-19 04:00:00	AAPL	Stock	47.0375	47.0375	47.0375	47.0375	432.0
2019-03-19 04:15:00	AAPL	Stock	47.085	47.085	47.085	47.085	3600.0
2019-03-19 04:20:00	AAPL	Stock	47.085	47.085	47.085	47.085	896.0
2019-03-19 05:20:00	AAPL	Stock	47.2175	47.2175	47.2175	47.2175	3768.0
2019-03-19 05:30:00	AAPL	Stock	47.2175	47.2225	47.2175	47.2225	6204.0
2019-03-19 05:40:00	AAPL	Stock	47.2175	47.225	47.2175	47.225	800.0
2019-03-19 05:55:00	AAPL	Stock	47.24	47.24	47.24	47.24	600.0
2019-03-19 06:00:00	AAPL	Stock	47.24	47.25	47.24	47.24	13564.0
2019-03-19 06:05:00	AAPL	Stock	47.225	47.225	47.2	47.225	28544.0
2019-03-19 06:10:00	AAPL	Stock	47.225	47.225	47.225	47.225	2796.0
2019-03-19 06:30:00	AAPL	Stock	47.25	47.25	47.25	47.25	400.0
2019-03-19 06:45:00	AAPL	Stock	47.225	47.225	47.225	47.225	800.0
2019-03-19 06:50:00	AAPL	Stock	47.225	47.225	47.2	47.2	18304.0
2019-03-19 07:00:00	AAPL	Stock	47.205	47.225	47.1525	47.2	20168.0
2019-03-19 07:05:00	AAPL	Stock	47.2125	47.2325	47.2125	47.2325	4840.0
2019-03-19 07:10:00	AAPL	Stock	47.235	47.24	47.225	47.2375	4556.0
2019-03-19 07:15:00	AAPL	Stock	47.24	47.2475	47.24	47.2475	3388.0
2019-03-19 07:20:00	AAPL	Stock	47.2475	47.25	47.2375	47.25	10692.0
2019-03-19 07:25:00	AAPL	Stock	47.2375	47.25	47.235	47.25	9648.0
2019-03-19 07:30:00	AAPL	Stock	47.25	47.315	47.2475	47.2625	17104.0
2019-03-19 07:35:00	AAPL	Stock	47.3	47.3	47.2375	47.2425	25312.0
2019-03-19 07:40:00	AAPL	Stock	47.275	47.2925	47.25	47.2675	14416.0
2019-03-19 07:45:00	AAPL	Stock	47.2825	47.2825	47.2625	47.2625	8012.0
2019-03-19 07:50:00	AAPL	Stock	47.2525	47.2525	47.2075	47.22	33004.0
2019-03-19 07:55:00	AAPL	Stock	47.2475	47.25	47.23	47.23	5284.0
2019-03-19 08:00:00	AAPL	Stock	47.1625	47.3125	47.1625	47.23	116668.0
2019-03-19 08:05:00	AAPL	Stock	47.2375	47.26	47.225	47.2575	18860.0
2019-03-19 08:10:00	AAPL	Stock	47.255	47.27	47.23	47.24	18948.0
2019-03-19 08:15:00	AAPL	Stock	47.2525	47.2525	47.2375	47.2525	12280.0
2019-03-19 08:20:00	AAPL	Stock	47.26	47.275	47.25	47.275	9636.0
2019-03-19 08:25:00	AAPL	Stock	47.275	47.275	47.225	47.225	37468.0
2019-03-19 08:30:00	AAPL	Stock	47.2175	47.25	47.2	47.24	37876.0
2019-03-19 08:35:00	AAPL	Stock	47.23	47.245	47.2025	47.21	30104.0
2019-03-19 08:40:00	AAPL	Stock	47.2075	47.22	47.195	47.2175	36052.0
2019-03-19 08:45:00	AAPL	Stock	47.227	47.2275	47.2175	47.22	7324.0
2019-03-19 08:50:00	AAPL	Stock	47.2175	47.2375	47.2125	47.2325	18744.0
2019-03-19 08:55:00	AAPL	Stock	47.2275	47.2325	47.2225	47.2225	19256.0
2019-03-19 09:00:00	AAPL	Stock	47.23	47.2475	47.2125	47.2375	28444.0
2019-03-19 09:05:00	AAPL	Stock	47.23	47.235	47.1875	47.2075	70784.0
2019-03-19 09:10:00	AAPL	Stock	47.195	47.2275	47.1925	47.2275	35524.0
2019-03-19 09:15:00	AAPL	Stock	47.22	47.235	47.13	47.13	177208.0
2019-03-19 09:20:00	AAPL	Stock	47.1325	47.1325	47.075	47.1	141100.0
2019-03-19 09:25:00	AAPL	Stock	47.1	47.125	47.075	47.075	110332.0
2019-03-19 09:30:00	AAPL	Stock	47.06	47.2075	47.0	47.1625	5419056.0
2019-03-19 09:35:00	AAPL	Stock	47.1675	47.2475	47.1225	47.13	2597932.0
2019-03-19 09:40:00	AAPL	Stock	47.1325	47.16	47.0175	47.13	2588828.0
2019-03-19 09:45:00	AAPL	Stock	47.1325	47.18	47.065	47.0685	1989516.0
2019-03-19 09:50:00	AAPL	Stock	47.0692	47.165	47.0325	47.1175	1776988.0
2019-03-19 09:55:00	AAPL	Stock	47.12	47.14	47.0275	47.0375	2227488.0
2019-03-19 10:00:00	AAPL	Stock	47.04	47.085	46.9575	46.9652	2455540.0

> showing 50 of 363,418 rows — these rows as CSV

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