PREVIEW / stock_5min / 2016-04-01

all stock 5-min files

  file:    by_date/stock_5min/2016/2016-04-01.parquet
  size:    5.4 MB
  rows:    356,686
  symbols: 3,345

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-04-01 04:00:00	AAPL	Stock	27.1725	27.1725	27.1	27.1	1200.0
2016-04-01 04:10:00	AAPL	Stock	27.1	27.125	27.1	27.125	5200.0
2016-04-01 04:30:00	AAPL	Stock	27.1125	27.1125	27.1125	27.1125	800.0
2016-04-01 04:35:00	AAPL	Stock	27.125	27.125	27.125	27.125	2800.0
2016-04-01 04:50:00	AAPL	Stock	27.15	27.15	27.15	27.15	400.0
2016-04-01 05:55:00	AAPL	Stock	27.1375	27.1375	27.1375	27.1375	428.0
2016-04-01 06:30:00	AAPL	Stock	27.1175	27.1175	27.1175	27.1175	7000.0
2016-04-01 06:35:00	AAPL	Stock	27.1125	27.1125	27.1125	27.1125	800.0
2016-04-01 06:40:00	AAPL	Stock	27.12	27.12	27.12	27.12	1600.0
2016-04-01 06:55:00	AAPL	Stock	27.1125	27.1125	27.1125	27.1125	2320.0
2016-04-01 07:05:00	AAPL	Stock	27.13	27.13	27.13	27.13	8000.0
2016-04-01 07:15:00	AAPL	Stock	27.15	27.15	27.15	27.15	4400.0
2016-04-01 07:20:00	AAPL	Stock	27.15	27.1825	27.15	27.1825	4520.0
2016-04-01 07:25:00	AAPL	Stock	27.1875	27.1925	27.1875	27.1925	18000.0
2016-04-01 07:30:00	AAPL	Stock	27.17	27.17	27.17	27.17	400.0
2016-04-01 07:40:00	AAPL	Stock	27.19	27.19	27.165	27.165	5180.0
2016-04-01 07:45:00	AAPL	Stock	27.165	27.175	27.165	27.175	6092.0
2016-04-01 07:50:00	AAPL	Stock	27.16	27.1625	27.1575	27.16	6080.0
2016-04-01 08:00:00	AAPL	Stock	27.1725	27.25	27.1125	27.2125	245908.0
2016-04-01 08:05:00	AAPL	Stock	27.23	27.2375	27.2	27.2125	20020.0
2016-04-01 08:10:00	AAPL	Stock	27.2125	27.2125	27.2125	27.2125	14000.0
2016-04-01 08:15:00	AAPL	Stock	27.23	27.235	27.2125	27.23	11804.0
2016-04-01 08:20:00	AAPL	Stock	27.225	27.25	27.2075	27.2475	34208.0
2016-04-01 08:25:00	AAPL	Stock	27.2275	27.25	27.225	27.225	3600.0
2016-04-01 08:30:00	AAPL	Stock	27.225	27.2875	27.225	27.2625	57024.0
2016-04-01 08:35:00	AAPL	Stock	27.2525	27.2525	27.2125	27.2225	68756.0
2016-04-01 08:40:00	AAPL	Stock	27.205	27.225	27.19	27.2075	52920.0
2016-04-01 08:45:00	AAPL	Stock	27.21	27.2225	27.21	27.2225	7600.0
2016-04-01 08:50:00	AAPL	Stock	27.22	27.225	27.195	27.195	38620.0
2016-04-01 08:55:00	AAPL	Stock	27.1925	27.1925	27.1525	27.1875	36092.0
2016-04-01 09:00:00	AAPL	Stock	27.1875	27.2	27.1525	27.1625	32712.0
2016-04-01 09:05:00	AAPL	Stock	27.1625	27.1625	27.155	27.1575	9200.0
2016-04-01 09:10:00	AAPL	Stock	27.165	27.1975	27.165	27.1875	6000.0
2016-04-01 09:15:00	AAPL	Stock	27.18	27.18	27.1625	27.1675	20576.0
2016-04-01 09:20:00	AAPL	Stock	27.1625	27.1625	27.15	27.1525	16460.0
2016-04-01 09:25:00	AAPL	Stock	27.1625	27.2175	27.1625	27.1825	141648.0
2016-04-01 09:30:00	AAPL	Stock	27.185	27.2725	27.13	27.1905	4286588.0
2016-04-01 09:35:00	AAPL	Stock	27.1915	27.1915	27.0825	27.1025	2630356.0
2016-04-01 09:40:00	AAPL	Stock	27.1025	27.1025	27.05	27.0602	1961380.0
2016-04-01 09:45:00	AAPL	Stock	27.06	27.1875	27.0525	27.1675	2486992.0
2016-04-01 09:50:00	AAPL	Stock	27.1675	27.1775	27.1	27.1075	1874024.0
2016-04-01 09:55:00	AAPL	Stock	27.1075	27.175	27.105	27.1725	1619716.0
2016-04-01 10:00:00	AAPL	Stock	27.1725	27.1875	27.1175	27.14	1593800.0
2016-04-01 10:05:00	AAPL	Stock	27.14	27.2475	27.1395	27.2475	2020452.0
2016-04-01 10:10:00	AAPL	Stock	27.2475	27.295	27.245	27.275	1881800.0
2016-04-01 10:15:00	AAPL	Stock	27.2752	27.3142	27.24	27.26	1596480.0
2016-04-01 10:20:00	AAPL	Stock	27.265	27.2975	27.24	27.2825	925396.0
2016-04-01 10:25:00	AAPL	Stock	27.2825	27.29	27.2028	27.205	1323168.0
2016-04-01 10:30:00	AAPL	Stock	27.205	27.2575	27.205	27.256	710088.0
2016-04-01 10:35:00	AAPL	Stock	27.2535	27.3275	27.2535	27.3225	1336716.0

> showing 50 of 356,686 rows — these rows as CSV

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