PREVIEW / stock_5min / 2017-07-11

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-07-11.parquet
  size:    5.3 MB
  rows:    350,552
  symbols: 3,001

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
2017-07-11 04:00:00	AAPL	Stock	36.2325	36.25	36.225	36.25	7792.0
2017-07-11 04:05:00	AAPL	Stock	36.25	36.25	36.25	36.25	640.0
2017-07-11 04:15:00	AAPL	Stock	36.275	36.275	36.275	36.275	400.0
2017-07-11 04:20:00	AAPL	Stock	36.25	36.25	36.25	36.25	1300.0
2017-07-11 05:10:00	AAPL	Stock	36.25	36.25	36.25	36.25	1148.0
2017-07-11 05:50:00	AAPL	Stock	36.2125	36.2125	36.2125	36.2125	4000.0
2017-07-11 06:00:00	AAPL	Stock	36.2275	36.2275	36.2275	36.2275	2000.0
2017-07-11 06:10:00	AAPL	Stock	36.2025	36.2025	36.2025	36.2025	1100.0
2017-07-11 06:30:00	AAPL	Stock	36.2125	36.2125	36.2125	36.2125	1200.0
2017-07-11 06:35:00	AAPL	Stock	36.215	36.22	36.19	36.22	11292.0
2017-07-11 06:40:00	AAPL	Stock	36.2025	36.22	36.2	36.2125	16708.0
2017-07-11 06:50:00	AAPL	Stock	36.2375	36.2375	36.2375	36.2375	400.0
2017-07-11 07:05:00	AAPL	Stock	36.2125	36.2125	36.2125	36.2125	1208.0
2017-07-11 07:20:00	AAPL	Stock	36.2125	36.225	36.1625	36.1625	23056.0
2017-07-11 07:25:00	AAPL	Stock	36.14	36.15	36.1225	36.15	19396.0
2017-07-11 07:30:00	AAPL	Stock	36.15	36.15	36.15	36.15	9200.0
2017-07-11 07:35:00	AAPL	Stock	36.1525	36.1525	36.1475	36.1475	24000.0
2017-07-11 07:40:00	AAPL	Stock	36.1275	36.1275	36.1125	36.1275	5164.0
2017-07-11 07:45:00	AAPL	Stock	36.13	36.13	36.1025	36.1025	4920.0
2017-07-11 07:50:00	AAPL	Stock	36.125	36.125	36.125	36.125	800.0
2017-07-11 07:55:00	AAPL	Stock	36.125	36.125	36.125	36.125	800.0
2017-07-11 08:00:00	AAPL	Stock	36.125	36.2375	36.1025	36.15	40420.0
2017-07-11 08:05:00	AAPL	Stock	36.15	36.175	36.15	36.175	24984.0
2017-07-11 08:10:00	AAPL	Stock	36.15	36.165	36.1325	36.135	11772.0
2017-07-11 08:15:00	AAPL	Stock	36.1325	36.1375	36.125	36.125	18500.0
2017-07-11 08:20:00	AAPL	Stock	36.125	36.15	36.0875	36.09	42036.0
2017-07-11 08:25:00	AAPL	Stock	36.095	36.125	36.0875	36.12	35916.0
2017-07-11 08:30:00	AAPL	Stock	36.1225	36.1475	36.11	36.1475	3304.0
2017-07-11 08:35:00	AAPL	Stock	36.1425	36.1425	36.1425	36.1425	400.0
2017-07-11 08:40:00	AAPL	Stock	36.1325	36.1325	36.13	36.13	4800.0
2017-07-11 08:45:00	AAPL	Stock	36.1425	36.1425	36.1375	36.1375	6208.0
2017-07-11 08:50:00	AAPL	Stock	36.1375	36.15	36.1375	36.15	4032.0
2017-07-11 08:55:00	AAPL	Stock	36.1625	36.18	36.1575	36.17	18020.0
2017-07-11 09:00:00	AAPL	Stock	36.15	36.15	36.125	36.125	34560.0
2017-07-11 09:05:00	AAPL	Stock	36.125	36.1375	36.1125	36.1375	22484.0
2017-07-11 09:10:00	AAPL	Stock	36.1575	36.1575	36.11	36.125	15540.0
2017-07-11 09:15:00	AAPL	Stock	36.125	36.1475	36.125	36.1375	27224.0
2017-07-11 09:20:00	AAPL	Stock	36.1575	36.1575	36.1425	36.1475	22464.0
2017-07-11 09:25:00	AAPL	Stock	36.14	36.195	36.11	36.1825	97584.0
2017-07-11 09:30:00	AAPL	Stock	36.1825	36.2675	36.13	36.205	2933912.0
2017-07-11 09:35:00	AAPL	Stock	36.2025	36.23	36.105	36.1475	1389316.0
2017-07-11 09:40:00	AAPL	Stock	36.1512	36.195	36.105	36.185	1722416.0
2017-07-11 09:45:00	AAPL	Stock	36.1825	36.1975	36.145	36.19	1074676.0
2017-07-11 09:50:00	AAPL	Stock	36.19	36.2075	36.17	36.195	1292408.0
2017-07-11 09:55:00	AAPL	Stock	36.195	36.2445	36.1925	36.2045	1416268.0
2017-07-11 10:00:00	AAPL	Stock	36.205	36.205	36.16	36.1758	1200040.0
2017-07-11 10:05:00	AAPL	Stock	36.1738	36.285	36.1625	36.2762	1336296.0
2017-07-11 10:10:00	AAPL	Stock	36.275	36.2945	36.25	36.2875	968692.0
2017-07-11 10:15:00	AAPL	Stock	36.285	36.3725	36.255	36.3713	1891836.0
2017-07-11 10:20:00	AAPL	Stock	36.37	36.4	36.3425	36.3675	1242748.0

> showing 50 of 350,552 rows — these rows as CSV

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