PREVIEW / stock_5min / 2018-07-02

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-07-02.parquet
  size:    5.5 MB
  rows:    360,441
  symbols: 2,796

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-07-02 04:05:00	AAPL	Stock	45.9675	45.9675	45.9675	45.9675	400.0
2018-07-02 04:10:00	AAPL	Stock	45.9975	45.9975	45.9975	45.9975	1200.0
2018-07-02 04:15:00	AAPL	Stock	46.0	46.0	46.0	46.0	2000.0
2018-07-02 04:25:00	AAPL	Stock	45.9975	45.9975	45.9975	45.9975	400.0
2018-07-02 05:25:00	AAPL	Stock	46.0025	46.0025	46.0025	46.0025	1600.0
2018-07-02 05:35:00	AAPL	Stock	46.0025	46.0125	46.0025	46.0125	1080.0
2018-07-02 06:20:00	AAPL	Stock	45.975	46.0	45.975	45.9875	10796.0
2018-07-02 06:35:00	AAPL	Stock	45.9775	45.9775	45.9775	45.9775	1600.0
2018-07-02 06:50:00	AAPL	Stock	46.0	46.0	46.0	46.0	400.0
2018-07-02 07:00:00	AAPL	Stock	46.065	46.07	45.9275	46.0625	27864.0
2018-07-02 07:10:00	AAPL	Stock	46.0175	46.0175	46.0175	46.0175	400.0
2018-07-02 07:15:00	AAPL	Stock	46.06	46.07	46.06	46.07	4280.0
2018-07-02 07:20:00	AAPL	Stock	46.05	46.05	46.05	46.05	800.0
2018-07-02 07:25:00	AAPL	Stock	46.05	46.05	46.05	46.05	11600.0
2018-07-02 07:30:00	AAPL	Stock	46.0125	46.0125	46.0125	46.0125	400.0
2018-07-02 07:35:00	AAPL	Stock	46.0375	46.0375	46.0375	46.0375	8952.0
2018-07-02 07:45:00	AAPL	Stock	46.0075	46.0125	46.0075	46.0125	1600.0
2018-07-02 07:50:00	AAPL	Stock	46.0625	46.0625	46.05	46.05	1088.0
2018-07-02 08:00:00	AAPL	Stock	45.97	46.1125	45.97	46.095	46868.0
2018-07-02 08:05:00	AAPL	Stock	46.075	46.0825	46.005	46.005	3180.0
2018-07-02 08:10:00	AAPL	Stock	46.0075	46.0075	45.9875	45.9975	9192.0
2018-07-02 08:15:00	AAPL	Stock	45.9875	46.0	45.975	45.9975	10716.0
2018-07-02 08:20:00	AAPL	Stock	46.0	46.025	45.9975	46.025	5316.0
2018-07-02 08:30:00	AAPL	Stock	46.0	46.0	45.9825	46.0	6284.0
2018-07-02 08:35:00	AAPL	Stock	45.9825	46.0325	45.9825	46.025	3156.0
2018-07-02 08:40:00	AAPL	Stock	46.0025	46.025	45.9975	46.0	17160.0
2018-07-02 08:45:00	AAPL	Stock	46.0	46.0025	45.97	45.975	21096.0
2018-07-02 08:50:00	AAPL	Stock	45.995	46.2775	45.9625	45.9725	8200.0
2018-07-02 08:55:00	AAPL	Stock	45.9975	45.9975	45.975	45.975	1600.0
2018-07-02 09:00:00	AAPL	Stock	45.9675	46.0	45.9675	46.0	4376.0
2018-07-02 09:05:00	AAPL	Stock	46.0125	46.0125	46.0	46.01	4676.0
2018-07-02 09:10:00	AAPL	Stock	46.0	46.0	45.9975	45.9975	1200.0
2018-07-02 09:15:00	AAPL	Stock	45.9875	45.99	45.9675	45.9675	16208.0
2018-07-02 09:20:00	AAPL	Stock	45.965	45.965	45.915	45.92	60636.0
2018-07-02 09:25:00	AAPL	Stock	45.9125	45.99	45.9125	45.9725	18376.0
2018-07-02 09:30:00	AAPL	Stock	45.9675	46.0875	45.855	46.0875	3065208.0
2018-07-02 09:35:00	AAPL	Stock	46.0825	46.265	46.075	46.2475	1774828.0
2018-07-02 09:40:00	AAPL	Stock	46.2525	46.2925	46.145	46.2738	1645884.0
2018-07-02 09:45:00	AAPL	Stock	46.2738	46.545	46.2275	46.54	1990160.0
2018-07-02 09:50:00	AAPL	Stock	46.5425	46.5625	46.4275	46.5125	1378084.0
2018-07-02 09:55:00	AAPL	Stock	46.5175	46.54	46.445	46.53	928440.0
2018-07-02 10:00:00	AAPL	Stock	46.53	46.5825	46.48	46.515	1389436.0
2018-07-02 10:05:00	AAPL	Stock	46.52	46.545	46.4625	46.535	991528.0
2018-07-02 10:10:00	AAPL	Stock	46.5375	46.55	46.4125	46.4225	1042012.0
2018-07-02 10:15:00	AAPL	Stock	46.4225	46.5225	46.4225	46.5175	827760.0
2018-07-02 10:20:00	AAPL	Stock	46.5225	46.5425	46.46	46.51	788292.0
2018-07-02 10:25:00	AAPL	Stock	46.5075	46.5875	46.5075	46.5825	1036944.0
2018-07-02 10:30:00	AAPL	Stock	46.5862	46.6225	46.56	46.6225	847620.0
2018-07-02 10:35:00	AAPL	Stock	46.62	46.62	46.5425	46.5928	677508.0
2018-07-02 10:40:00	AAPL	Stock	46.5938	46.6688	46.5525	46.6552	891712.0

> showing 50 of 360,441 rows — these rows as CSV

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