PREVIEW / stock_5min / 2019-06-20

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-06-20.parquet
  size:    5.8 MB
  rows:    366,359
  symbols: 2,605

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-06-20 04:00:00	AAPL	Stock	50.0	50.1	50.0	50.0	8360.0
2019-06-20 04:20:00	AAPL	Stock	50.075	50.075	50.075	50.075	400.0
2019-06-20 04:30:00	AAPL	Stock	50.09	50.125	50.09	50.125	6400.0
2019-06-20 04:35:00	AAPL	Stock	50.125	50.1375	50.125	50.1375	800.0
2019-06-20 04:40:00	AAPL	Stock	50.1375	50.1375	50.1375	50.1375	1200.0
2019-06-20 04:50:00	AAPL	Stock	50.1	50.1	50.1	50.1	1600.0
2019-06-20 04:55:00	AAPL	Stock	50.075	50.075	50.075	50.075	1228.0
2019-06-20 05:00:00	AAPL	Stock	50.1	50.1	50.1	50.1	900.0
2019-06-20 05:05:00	AAPL	Stock	50.1	50.1	50.1	50.1	2552.0
2019-06-20 05:10:00	AAPL	Stock	50.125	50.15	50.125	50.15	3648.0
2019-06-20 05:20:00	AAPL	Stock	50.125	50.125	50.125	50.125	400.0
2019-06-20 05:30:00	AAPL	Stock	50.1725	50.2075	50.1725	50.2075	4052.0
2019-06-20 05:45:00	AAPL	Stock	50.095	50.125	49.97	49.97	32284.0
2019-06-20 06:05:00	AAPL	Stock	50.1	50.1	50.1	50.1	1988.0
2019-06-20 06:10:00	AAPL	Stock	50.0375	50.0375	50.0375	50.0375	400.0
2019-06-20 06:15:00	AAPL	Stock	50.0075	50.0425	49.9925	49.9925	5128.0
2019-06-20 06:25:00	AAPL	Stock	50.0025	50.0175	50.0	50.0	3500.0
2019-06-20 06:30:00	AAPL	Stock	50.0025	50.0025	50.0	50.0025	4000.0
2019-06-20 06:40:00	AAPL	Stock	50.0075	50.0075	50.005	50.005	3200.0
2019-06-20 06:45:00	AAPL	Stock	50.0725	50.1125	50.0625	50.0875	13108.0
2019-06-20 06:50:00	AAPL	Stock	50.0875	50.0875	50.0875	50.0875	12128.0
2019-06-20 07:00:00	AAPL	Stock	50.0625	50.0875	50.0	50.0375	25000.0
2019-06-20 07:05:00	AAPL	Stock	50.0375	50.075	50.0125	50.025	14396.0
2019-06-20 07:10:00	AAPL	Stock	50.0	50.025	50.0	50.025	3816.0
2019-06-20 07:15:00	AAPL	Stock	50.025	50.05	50.025	50.05	14460.0
2019-06-20 07:20:00	AAPL	Stock	50.05	50.1375	50.05	50.1375	22932.0
2019-06-20 07:25:00	AAPL	Stock	50.1	50.1	50.06	50.1	30200.0
2019-06-20 07:30:00	AAPL	Stock	50.0875	50.1125	50.0575	50.1	6556.0
2019-06-20 07:35:00	AAPL	Stock	50.0625	50.09	50.0625	50.075	16804.0
2019-06-20 07:40:00	AAPL	Stock	50.0975	50.1125	50.0625	50.0875	22828.0
2019-06-20 07:45:00	AAPL	Stock	50.0875	50.125	50.0625	50.1025	29956.0
2019-06-20 07:50:00	AAPL	Stock	50.1	50.125	50.0625	50.0925	18412.0
2019-06-20 07:55:00	AAPL	Stock	50.0875	50.105	50.085	50.105	6820.0
2019-06-20 08:00:00	AAPL	Stock	50.1225	50.22	50.0	50.2	136988.0
2019-06-20 08:05:00	AAPL	Stock	50.2	50.2275	50.14	50.155	32216.0
2019-06-20 08:10:00	AAPL	Stock	50.1575	50.1575	50.125	50.125	17292.0
2019-06-20 08:15:00	AAPL	Stock	50.1375	50.1775	50.1375	50.1765	24472.0
2019-06-20 08:20:00	AAPL	Stock	50.1775	50.1975	50.1725	50.1975	18240.0
2019-06-20 08:25:00	AAPL	Stock	50.205	50.205	50.2025	50.205	1976.0
2019-06-20 08:30:00	AAPL	Stock	50.205	50.2425	50.15	50.225	27808.0
2019-06-20 08:35:00	AAPL	Stock	50.23	50.2475	50.175	50.1775	44300.0
2019-06-20 08:40:00	AAPL	Stock	50.1975	50.2125	50.19	50.2	10484.0
2019-06-20 08:45:00	AAPL	Stock	50.1825	50.2	50.175	50.175	28792.0
2019-06-20 08:50:00	AAPL	Stock	50.175	50.2	50.15	50.155	35952.0
2019-06-20 08:55:00	AAPL	Stock	50.16	50.1875	50.1375	50.1375	21952.0
2019-06-20 09:00:00	AAPL	Stock	50.1675	50.1875	50.1375	50.1675	37308.0
2019-06-20 09:05:00	AAPL	Stock	50.1825	50.2	50.1675	50.2	44020.0
2019-06-20 09:10:00	AAPL	Stock	50.1875	50.21	50.1875	50.1975	32152.0
2019-06-20 09:15:00	AAPL	Stock	50.19	50.2	50.16	50.16	28500.0
2019-06-20 09:20:00	AAPL	Stock	50.1625	50.1875	50.14	50.175	21200.0

> showing 50 of 366,359 rows — these rows as CSV

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