PREVIEW / stock_5min / 2018-05-25

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-05-25.parquet
  size:    5.4 MB
  rows:    348,617
  symbols: 2,822

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
2018-05-25 04:25:00	AAPL	Stock	47.195	47.195	47.195	47.195	1412.0
2018-05-25 04:30:00	AAPL	Stock	47.195	47.195	47.195	47.195	1252.0
2018-05-25 04:50:00	AAPL	Stock	47.255	47.2625	47.2225	47.2225	1600.0
2018-05-25 06:00:00	AAPL	Stock	47.165	47.165	47.165	47.165	400.0
2018-05-25 07:00:00	AAPL	Stock	47.21	47.215	47.1475	47.2025	35564.0
2018-05-25 07:05:00	AAPL	Stock	47.18	47.18	47.18	47.18	400.0
2018-05-25 07:10:00	AAPL	Stock	47.1775	47.1775	47.14	47.1425	10904.0
2018-05-25 07:15:00	AAPL	Stock	47.1575	47.1575	47.1375	47.1375	3440.0
2018-05-25 07:20:00	AAPL	Stock	47.125	47.125	47.0925	47.0925	9200.0
2018-05-25 07:25:00	AAPL	Stock	47.1125	47.1425	47.1125	47.1425	800.0
2018-05-25 07:30:00	AAPL	Stock	47.1	47.145	47.1	47.1425	2312.0
2018-05-25 07:35:00	AAPL	Stock	47.135	47.135	47.135	47.135	400.0
2018-05-25 07:40:00	AAPL	Stock	47.1075	47.1125	47.075	47.1125	8144.0
2018-05-25 07:45:00	AAPL	Stock	47.095	47.095	47.075	47.075	9600.0
2018-05-25 07:50:00	AAPL	Stock	47.0675	47.0675	47.0375	47.0375	14000.0
2018-05-25 07:55:00	AAPL	Stock	47.05	47.0925	47.05	47.075	1572.0
2018-05-25 08:00:00	AAPL	Stock	47.125	47.2198	47.05	47.075	18444.0
2018-05-25 08:05:00	AAPL	Stock	47.075	47.075	47.05	47.075	16300.0
2018-05-25 08:10:00	AAPL	Stock	47.0375	47.05	47.0375	47.04	5820.0
2018-05-25 08:15:00	AAPL	Stock	47.0775	47.0775	47.04	47.04	5708.0
2018-05-25 08:20:00	AAPL	Stock	47.0575	47.065	47.04	47.0525	10800.0
2018-05-25 08:25:00	AAPL	Stock	47.05	47.075	47.05	47.075	1840.0
2018-05-25 08:30:00	AAPL	Stock	47.0675	47.1	47.0675	47.1	2868.0
2018-05-25 08:35:00	AAPL	Stock	47.0875	47.0875	47.0625	47.0625	8200.0
2018-05-25 08:40:00	AAPL	Stock	47.06	47.06	47.025	47.0325	32008.0
2018-05-25 08:45:00	AAPL	Stock	47.0325	47.04	47.0175	47.04	11000.0
2018-05-25 08:50:00	AAPL	Stock	47.0475	47.0625	47.0475	47.0625	8084.0
2018-05-25 08:55:00	AAPL	Stock	47.0668	47.0668	47.0275	47.0275	12264.0
2018-05-25 09:00:00	AAPL	Stock	47.0375	47.0375	47.0	47.01	20108.0
2018-05-25 09:05:00	AAPL	Stock	47.0	47.005	46.9625	46.98	45088.0
2018-05-25 09:10:00	AAPL	Stock	46.9925	47.0125	46.9875	47.0125	14872.0
2018-05-25 09:15:00	AAPL	Stock	47.0075	47.0075	46.975	46.975	14000.0
2018-05-25 09:20:00	AAPL	Stock	46.995	47.02	46.995	47.02	27304.0
2018-05-25 09:25:00	AAPL	Stock	47.0375	47.0725	47.0	47.0625	24620.0
2018-05-25 09:30:00	AAPL	Stock	47.0575	47.185	46.9125	46.9272	2852140.0
2018-05-25 09:35:00	AAPL	Stock	46.9275	47.05	46.92	47.0125	1403044.0
2018-05-25 09:40:00	AAPL	Stock	47.01	47.0472	46.96	46.9725	880912.0
2018-05-25 09:45:00	AAPL	Stock	46.97	47.1	46.965	47.09	972420.0
2018-05-25 09:50:00	AAPL	Stock	47.0875	47.0875	47.034	47.06	829284.0
2018-05-25 09:55:00	AAPL	Stock	47.06	47.1325	47.045	47.1135	847892.0
2018-05-25 10:00:00	AAPL	Stock	47.1128	47.16	47.085	47.13	1047712.0
2018-05-25 10:05:00	AAPL	Stock	47.1315	47.1638	47.085	47.1575	928360.0
2018-05-25 10:10:00	AAPL	Stock	47.1575	47.21	47.155	47.1975	1081720.0
2018-05-25 10:15:00	AAPL	Stock	47.1975	47.26	47.1975	47.2475	1610512.0
2018-05-25 10:20:00	AAPL	Stock	47.2472	47.3075	47.2268	47.3075	1777988.0
2018-05-25 10:25:00	AAPL	Stock	47.3075	47.3625	47.2802	47.3275	1619428.0
2018-05-25 10:30:00	AAPL	Stock	47.325	47.3725	47.3025	47.3125	1198384.0
2018-05-25 10:35:00	AAPL	Stock	47.3138	47.365	47.3125	47.3625	949828.0
2018-05-25 10:40:00	AAPL	Stock	47.365	47.3725	47.3038	47.3488	1208156.0
2018-05-25 10:45:00	AAPL	Stock	47.35	47.35	47.27	47.272	1034464.0

> showing 50 of 348,617 rows — these rows as CSV

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