PREVIEW / stock_5min / 2019-10-21

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-10-21.parquet
  size:    5.6 MB
  rows:    353,339
  symbols: 2,492

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-10-21 04:00:00	AAPL	Stock	59.31	59.375	59.31	59.3625	20020.0
2019-10-21 04:20:00	AAPL	Stock	59.3575	59.3575	59.3575	59.3575	1808.0
2019-10-21 04:40:00	AAPL	Stock	59.3875	59.3875	59.3875	59.3875	1200.0
2019-10-21 04:50:00	AAPL	Stock	59.3675	59.3875	59.3625	59.375	22032.0
2019-10-21 05:00:00	AAPL	Stock	59.3625	59.375	59.3625	59.375	2388.0
2019-10-21 05:15:00	AAPL	Stock	59.3675	59.3775	59.3675	59.3775	6400.0
2019-10-21 05:45:00	AAPL	Stock	59.3775	59.3775	59.3775	59.3775	1620.0
2019-10-21 06:20:00	AAPL	Stock	59.3675	59.375	59.3675	59.375	7636.0
2019-10-21 06:25:00	AAPL	Stock	59.375	59.375	59.375	59.375	764.0
2019-10-21 06:30:00	AAPL	Stock	59.375	59.4225	59.375	59.375	2456.0
2019-10-21 06:35:00	AAPL	Stock	59.375	59.375	59.375	59.375	400.0
2019-10-21 06:50:00	AAPL	Stock	59.375	59.375	59.375	59.375	756.0
2019-10-21 06:55:00	AAPL	Stock	59.375	59.4	59.375	59.4	1200.0
2019-10-21 07:00:00	AAPL	Stock	59.3525	59.3775	59.2875	59.3	53292.0
2019-10-21 07:05:00	AAPL	Stock	59.3	59.32	59.3	59.3	23200.0
2019-10-21 07:10:00	AAPL	Stock	59.3	59.3	59.3	59.3	2400.0
2019-10-21 07:15:00	AAPL	Stock	59.3	59.3125	59.3	59.3125	4960.0
2019-10-21 07:20:00	AAPL	Stock	59.3225	59.3225	59.2925	59.315	9536.0
2019-10-21 07:25:00	AAPL	Stock	59.31	59.375	59.31	59.375	29932.0
2019-10-21 07:30:00	AAPL	Stock	59.37	59.4125	59.34	59.4	22252.0
2019-10-21 07:35:00	AAPL	Stock	59.41	59.4375	59.41	59.4375	20124.0
2019-10-21 07:40:00	AAPL	Stock	59.425	59.4375	59.4025	59.4025	12152.0
2019-10-21 07:45:00	AAPL	Stock	59.42	59.4225	59.4125	59.4125	2000.0
2019-10-21 07:50:00	AAPL	Stock	59.4225	59.425	59.4125	59.4125	8184.0
2019-10-21 07:55:00	AAPL	Stock	59.41	59.4375	59.41	59.4375	2800.0
2019-10-21 08:00:00	AAPL	Stock	59.35	59.525	59.2778	59.47	212800.0
2019-10-21 08:05:00	AAPL	Stock	59.4625	59.485	59.43	59.4725	28140.0
2019-10-21 08:10:00	AAPL	Stock	59.46	59.49	59.46	59.4625	33656.0
2019-10-21 08:15:00	AAPL	Stock	59.4625	59.4875	59.4575	59.4625	26324.0
2019-10-21 08:20:00	AAPL	Stock	59.4575	59.4625	59.4425	59.4625	21564.0
2019-10-21 08:25:00	AAPL	Stock	59.4612	59.4625	59.4375	59.4525	24416.0
2019-10-21 08:30:00	AAPL	Stock	59.45	59.45	59.4	59.4225	119036.0
2019-10-21 08:35:00	AAPL	Stock	59.4175	59.505	59.408	59.495	136736.0
2019-10-21 08:40:00	AAPL	Stock	59.485	59.5125	59.485	59.5	56516.0
2019-10-21 08:45:00	AAPL	Stock	59.4925	59.5	59.4375	59.44	45124.0
2019-10-21 08:50:00	AAPL	Stock	59.4432	59.4565	59.4075	59.4225	41216.0
2019-10-21 08:55:00	AAPL	Stock	59.42	59.4225	59.3875	59.4075	43332.0
2019-10-21 09:00:00	AAPL	Stock	59.4125	59.42	59.38	59.385	29216.0
2019-10-21 09:05:00	AAPL	Stock	59.39	59.415	59.3775	59.4125	21304.0
2019-10-21 09:10:00	AAPL	Stock	59.41	59.42	59.39	59.4175	27232.0
2019-10-21 09:15:00	AAPL	Stock	59.4125	59.4475	59.4125	59.435	46584.0
2019-10-21 09:20:00	AAPL	Stock	59.4275	59.435	59.375	59.41	67676.0
2019-10-21 09:25:00	AAPL	Stock	59.41	59.425	59.3775	59.4125	26172.0
2019-10-21 09:30:00	AAPL	Stock	59.4125	59.6375	59.33	59.6025	4539344.0
2019-10-21 09:35:00	AAPL	Stock	59.6075	59.8675	59.6025	59.815	3030968.0
2019-10-21 09:40:00	AAPL	Stock	59.8175	60.0	59.8025	59.99	2873900.0
2019-10-21 09:45:00	AAPL	Stock	59.9875	60.0	59.81	59.817	2340760.0
2019-10-21 09:50:00	AAPL	Stock	59.8195	59.88	59.7475	59.7825	1449496.0
2019-10-21 09:55:00	AAPL	Stock	59.7825	59.95	59.7675	59.925	1910692.0
2019-10-21 10:00:00	AAPL	Stock	59.9178	59.99	59.9002	59.9125	1549736.0

> showing 50 of 353,339 rows — these rows as CSV

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