PREVIEW / stock_5min / 2017-09-01

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-09-01.parquet
  size:    5.2 MB
  rows:    339,000
  symbols: 2,964

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-09-01 04:25:00	AAPL	Stock	41.095	41.095	41.095	41.095	4000.0
2017-09-01 05:25:00	AAPL	Stock	41.095	41.095	41.095	41.095	2976.0
2017-09-01 06:10:00	AAPL	Stock	41.11	41.11	41.105	41.105	1600.0
2017-09-01 06:15:00	AAPL	Stock	41.11	41.1125	41.11	41.11	1544.0
2017-09-01 06:25:00	AAPL	Stock	41.12	41.12	41.12	41.12	800.0
2017-09-01 06:30:00	AAPL	Stock	41.12	41.12	41.12	41.12	3200.0
2017-09-01 06:35:00	AAPL	Stock	41.12	41.125	41.12	41.125	2408.0
2017-09-01 06:40:00	AAPL	Stock	41.125	41.125	41.12	41.12	5284.0
2017-09-01 07:00:00	AAPL	Stock	41.1125	41.15	41.1125	41.145	23220.0
2017-09-01 07:05:00	AAPL	Stock	41.15	41.15	41.1275	41.15	18640.0
2017-09-01 07:10:00	AAPL	Stock	41.1475	41.155	41.1475	41.155	10852.0
2017-09-01 07:15:00	AAPL	Stock	41.15	41.165	41.15	41.165	6716.0
2017-09-01 07:20:00	AAPL	Stock	41.1625	41.1625	41.1625	41.1625	1624.0
2017-09-01 07:25:00	AAPL	Stock	41.1675	41.175	41.1575	41.1575	3200.0
2017-09-01 07:35:00	AAPL	Stock	41.155	41.1575	41.15	41.1575	6064.0
2017-09-01 07:40:00	AAPL	Stock	41.16	41.16	41.16	41.16	800.0
2017-09-01 07:45:00	AAPL	Stock	41.165	41.17	41.1625	41.1675	7600.0
2017-09-01 07:50:00	AAPL	Stock	41.17	41.17	41.165	41.17	5420.0
2017-09-01 07:55:00	AAPL	Stock	41.17	41.17	41.1625	41.165	11652.0
2017-09-01 08:00:00	AAPL	Stock	41.15	41.1725	41.1125	41.1625	54608.0
2017-09-01 08:05:00	AAPL	Stock	41.1525	41.1725	41.1525	41.1725	13704.0
2017-09-01 08:10:00	AAPL	Stock	41.1725	41.1825	41.1725	41.175	69048.0
2017-09-01 08:15:00	AAPL	Stock	41.175	41.1825	41.175	41.175	4800.0
2017-09-01 08:20:00	AAPL	Stock	41.175	41.18	41.175	41.175	10108.0
2017-09-01 08:25:00	AAPL	Stock	41.1775	41.1825	41.175	41.1775	13712.0
2017-09-01 08:30:00	AAPL	Stock	41.1825	41.195	41.125	41.1875	103296.0
2017-09-01 08:35:00	AAPL	Stock	41.185	41.19	41.15	41.155	32636.0
2017-09-01 08:40:00	AAPL	Stock	41.1625	41.175	41.155	41.175	27120.0
2017-09-01 08:45:00	AAPL	Stock	41.17	41.17	41.1275	41.145	47496.0
2017-09-01 08:50:00	AAPL	Stock	41.1375	41.1525	41.12	41.125	42868.0
2017-09-01 08:55:00	AAPL	Stock	41.1225	41.1425	41.115	41.1375	28208.0
2017-09-01 09:00:00	AAPL	Stock	41.1425	41.1725	41.1425	41.17	66884.0
2017-09-01 09:05:00	AAPL	Stock	41.165	41.1675	41.1625	41.165	5200.0
2017-09-01 09:10:00	AAPL	Stock	41.1625	41.1625	41.145	41.145	29988.0
2017-09-01 09:15:00	AAPL	Stock	41.155	41.16	41.15	41.155	6288.0
2017-09-01 09:20:00	AAPL	Stock	41.145	41.16	41.145	41.15	7372.0
2017-09-01 09:25:00	AAPL	Stock	41.1625	41.2075	41.16	41.2	64840.0
2017-09-01 09:30:00	AAPL	Stock	41.2	41.235	41.1475	41.1675	4197812.0
2017-09-01 09:35:00	AAPL	Stock	41.1675	41.185	41.1325	41.1525	1986408.0
2017-09-01 09:40:00	AAPL	Stock	41.155	41.1675	41.1125	41.1512	1890304.0
2017-09-01 09:45:00	AAPL	Stock	41.15	41.1575	41.095	41.105	1225704.0
2017-09-01 09:50:00	AAPL	Stock	41.105	41.125	40.9875	41.0112	2672188.0
2017-09-01 09:55:00	AAPL	Stock	41.01	41.062	40.9875	40.9975	1693052.0
2017-09-01 10:00:00	AAPL	Stock	40.99	41.0375	40.9525	40.9825	2333308.0
2017-09-01 10:05:00	AAPL	Stock	40.9812	41.02	40.9625	40.9873	1083896.0
2017-09-01 10:10:00	AAPL	Stock	40.9865	41.06	40.9825	41.0575	1192120.0
2017-09-01 10:15:00	AAPL	Stock	41.0565	41.0575	41.0175	41.0375	991440.0
2017-09-01 10:20:00	AAPL	Stock	41.0412	41.0575	41.01	41.0127	784752.0
2017-09-01 10:25:00	AAPL	Stock	41.0125	41.0325	40.9888	41.0275	797824.0
2017-09-01 10:30:00	AAPL	Stock	41.0262	41.0375	41.0075	41.03	649836.0

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

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