PREVIEW / stock_5min / 2016-08-23

all stock 5-min files

  file:    by_date/stock_5min/2016/2016-08-23.parquet
  size:    5.3 MB
  rows:    349,800
  symbols: 3,255

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
2016-08-23 04:00:00	AAPL	Stock	27.1	27.14	27.1	27.1375	3200.0
2016-08-23 04:05:00	AAPL	Stock	27.1625	27.175	27.1625	27.175	800.0
2016-08-23 04:25:00	AAPL	Stock	27.17	27.17	27.17	27.17	800.0
2016-08-23 04:30:00	AAPL	Stock	27.1425	27.1425	27.1375	27.1375	2000.0
2016-08-23 04:50:00	AAPL	Stock	27.17	27.17	27.17	27.17	400.0
2016-08-23 05:00:00	AAPL	Stock	27.185	27.185	27.1675	27.17	2636.0
2016-08-23 05:40:00	AAPL	Stock	27.1925	27.1925	27.1925	27.1925	2000.0
2016-08-23 05:45:00	AAPL	Stock	27.1925	27.1925	27.1925	27.1925	400.0
2016-08-23 06:10:00	AAPL	Stock	27.2	27.2	27.2	27.2	400.0
2016-08-23 06:20:00	AAPL	Stock	27.175	27.175	27.175	27.175	800.0
2016-08-23 06:35:00	AAPL	Stock	27.175	27.175	27.175	27.175	472.0
2016-08-23 07:10:00	AAPL	Stock	27.17	27.175	27.17	27.175	3760.0
2016-08-23 07:15:00	AAPL	Stock	27.175	27.175	27.175	27.175	400.0
2016-08-23 07:20:00	AAPL	Stock	27.1575	27.1575	27.1575	27.1575	3600.0
2016-08-23 07:25:00	AAPL	Stock	27.1575	27.1575	27.1575	27.1575	400.0
2016-08-23 07:35:00	AAPL	Stock	27.17	27.17	27.17	27.17	800.0
2016-08-23 07:40:00	AAPL	Stock	27.17	27.17	27.1675	27.1675	4880.0
2016-08-23 07:45:00	AAPL	Stock	27.1675	27.1675	27.1675	27.1675	5920.0
2016-08-23 08:00:00	AAPL	Stock	27.15	27.175	27.1425	27.15	18836.0
2016-08-23 08:05:00	AAPL	Stock	27.1525	27.1525	27.1425	27.1425	5880.0
2016-08-23 08:10:00	AAPL	Stock	27.1425	27.1425	27.1425	27.1425	876.0
2016-08-23 08:15:00	AAPL	Stock	27.1375	27.1425	27.125	27.135	5960.0
2016-08-23 08:20:00	AAPL	Stock	27.1475	27.15	27.1375	27.1375	7748.0
2016-08-23 08:25:00	AAPL	Stock	27.135	27.1575	27.135	27.1575	4188.0
2016-08-23 08:30:00	AAPL	Stock	27.1575	27.16	27.1525	27.16	32644.0
2016-08-23 08:35:00	AAPL	Stock	27.16	27.16	27.14	27.14	27992.0
2016-08-23 08:40:00	AAPL	Stock	27.14	27.145	27.1375	27.145	6400.0
2016-08-23 08:45:00	AAPL	Stock	27.1375	27.1475	27.1375	27.1475	6800.0
2016-08-23 08:50:00	AAPL	Stock	27.145	27.145	27.1425	27.1425	12976.0
2016-08-23 08:55:00	AAPL	Stock	27.1525	27.155	27.1425	27.1425	9400.0
2016-08-23 09:00:00	AAPL	Stock	27.15	27.15	27.145	27.15	21544.0
2016-08-23 09:05:00	AAPL	Stock	27.15	27.15	27.1425	27.1475	41000.0
2016-08-23 09:10:00	AAPL	Stock	27.1425	27.1425	27.125	27.125	22388.0
2016-08-23 09:15:00	AAPL	Stock	27.1225	27.15	27.1225	27.15	35616.0
2016-08-23 09:20:00	AAPL	Stock	27.1475	27.155	27.1475	27.155	22880.0
2016-08-23 09:25:00	AAPL	Stock	27.1525	27.165	27.13	27.1325	182036.0
2016-08-23 09:30:00	AAPL	Stock	27.1525	27.2975	27.1325	27.2675	5012508.0
2016-08-23 09:35:00	AAPL	Stock	27.2675	27.3225	27.25	27.315	3166396.0
2016-08-23 09:40:00	AAPL	Stock	27.3148	27.33	27.28	27.2975	2589088.0
2016-08-23 09:45:00	AAPL	Stock	27.2975	27.3165	27.2825	27.2975	1835080.0
2016-08-23 09:50:00	AAPL	Stock	27.2975	27.3248	27.29	27.3225	1515520.0
2016-08-23 09:55:00	AAPL	Stock	27.3225	27.33	27.3025	27.325	1816060.0
2016-08-23 10:00:00	AAPL	Stock	27.3248	27.33	27.3075	27.315	1074960.0
2016-08-23 10:05:00	AAPL	Stock	27.315	27.3225	27.2825	27.305	1152088.0
2016-08-23 10:10:00	AAPL	Stock	27.305	27.324	27.29	27.3012	1270772.0
2016-08-23 10:15:00	AAPL	Stock	27.3	27.305	27.275	27.275	1510344.0
2016-08-23 10:20:00	AAPL	Stock	27.2775	27.305	27.2775	27.2925	870296.0
2016-08-23 10:25:00	AAPL	Stock	27.295	27.305	27.2875	27.2938	793080.0
2016-08-23 10:30:00	AAPL	Stock	27.295	27.3125	27.29	27.2942	715380.0
2016-08-23 10:35:00	AAPL	Stock	27.2925	27.295	27.27	27.29	883952.0

> showing 50 of 349,800 rows — these rows as CSV

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