PREVIEW / stock_5min / 2018-09-21

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-09-21.parquet
  size:    5.7 MB
  rows:    364,000
  symbols: 2,786

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-09-21 04:00:00	AAPL	Stock	55.19	55.25	55.19	55.25	2300.0
2018-09-21 04:20:00	AAPL	Stock	55.2975	55.36	55.2975	55.31	8748.0
2018-09-21 04:30:00	AAPL	Stock	55.31	55.31	55.25	55.25	6648.0
2018-09-21 04:55:00	AAPL	Stock	55.1375	55.1375	55.1	55.1	6360.0
2018-09-21 05:20:00	AAPL	Stock	55.1	55.1125	55.08	55.08	4596.0
2018-09-21 05:45:00	AAPL	Stock	55.1875	55.1875	55.1875	55.1875	3200.0
2018-09-21 05:50:00	AAPL	Stock	55.175	55.175	55.175	55.175	872.0
2018-09-21 06:05:00	AAPL	Stock	55.175	55.175	55.175	55.175	400.0
2018-09-21 06:15:00	AAPL	Stock	55.195	55.2	55.195	55.2	4400.0
2018-09-21 06:35:00	AAPL	Stock	55.1875	55.1875	55.1875	55.1875	1120.0
2018-09-21 06:50:00	AAPL	Stock	55.1275	55.1275	55.1275	55.1275	400.0
2018-09-21 06:55:00	AAPL	Stock	55.125	55.125	55.125	55.125	2000.0
2018-09-21 07:00:00	AAPL	Stock	55.1575	55.1575	55.125	55.155	12584.0
2018-09-21 07:05:00	AAPL	Stock	55.14	55.14	55.1	55.1	21524.0
2018-09-21 07:10:00	AAPL	Stock	55.0975	55.0975	55.0975	55.0975	3848.0
2018-09-21 07:20:00	AAPL	Stock	55.0875	55.0875	55.0875	55.0875	400.0
2018-09-21 07:25:00	AAPL	Stock	55.0675	55.0675	55.05	55.05	5620.0
2018-09-21 07:30:00	AAPL	Stock	55.075	55.075	55.0	55.0175	24420.0
2018-09-21 07:35:00	AAPL	Stock	55.005	55.01	55.0	55.0	4304.0
2018-09-21 07:40:00	AAPL	Stock	54.98	55.025	54.98	55.025	3400.0
2018-09-21 07:45:00	AAPL	Stock	55.0125	55.0125	55.0125	55.0125	400.0
2018-09-21 07:50:00	AAPL	Stock	55.04	55.04	55.04	55.04	400.0
2018-09-21 07:55:00	AAPL	Stock	55.0425	55.0875	55.0425	55.075	5628.0
2018-09-21 08:00:00	AAPL	Stock	55.155	55.1575	55.0	55.085	84344.0
2018-09-21 08:05:00	AAPL	Stock	55.1	55.15	55.1	55.125	15056.0
2018-09-21 08:10:00	AAPL	Stock	55.1125	55.1125	55.0875	55.0975	9996.0
2018-09-21 08:15:00	AAPL	Stock	55.0975	55.0975	55.04	55.04	36768.0
2018-09-21 08:20:00	AAPL	Stock	55.085	55.0875	55.065	55.0875	6892.0
2018-09-21 08:25:00	AAPL	Stock	55.1	55.1	55.0625	55.0875	16444.0
2018-09-21 08:30:00	AAPL	Stock	55.085	55.1125	55.085	55.1125	9916.0
2018-09-21 08:35:00	AAPL	Stock	55.1175	55.125	55.11	55.125	7120.0
2018-09-21 08:40:00	AAPL	Stock	55.1375	55.145	55.1275	55.145	4560.0
2018-09-21 08:45:00	AAPL	Stock	55.145	55.1875	55.145	55.17	52424.0
2018-09-21 08:50:00	AAPL	Stock	55.1875	55.225	55.175	55.225	19576.0
2018-09-21 08:55:00	AAPL	Stock	55.205	55.2125	55.1775	55.185	21344.0
2018-09-21 09:00:00	AAPL	Stock	55.18	55.23	55.1625	55.215	62028.0
2018-09-21 09:05:00	AAPL	Stock	55.2325	55.2325	55.1625	55.1625	41776.0
2018-09-21 09:10:00	AAPL	Stock	55.165	55.2225	55.165	55.22	56828.0
2018-09-21 09:15:00	AAPL	Stock	55.2125	55.3	55.2125	55.2875	101152.0
2018-09-21 09:20:00	AAPL	Stock	55.2875	55.3	55.26	55.3	147336.0
2018-09-21 09:25:00	AAPL	Stock	55.2975	55.3375	55.155	55.19	388576.0
2018-09-21 09:30:00	AAPL	Stock	55.1425	55.2925	54.9878	55.1525	34982880.0
2018-09-21 09:35:00	AAPL	Stock	55.1575	55.3	55.0825	55.2925	2382476.0
2018-09-21 09:40:00	AAPL	Stock	55.295	55.34	55.1825	55.19	2370188.0
2018-09-21 09:45:00	AAPL	Stock	55.1925	55.2275	55.0125	55.035	1601184.0
2018-09-21 09:50:00	AAPL	Stock	55.0375	55.1062	54.95	54.9675	1981416.0
2018-09-21 09:55:00	AAPL	Stock	54.9675	55.0275	54.935	54.9508	1915488.0
2018-09-21 10:00:00	AAPL	Stock	54.95	54.965	54.87	54.9135	1833764.0
2018-09-21 10:05:00	AAPL	Stock	54.9175	54.9875	54.8175	54.985	1721832.0
2018-09-21 10:10:00	AAPL	Stock	54.9885	54.9925	54.895	54.93	1009780.0

> showing 50 of 364,000 rows — these rows as CSV

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