PREVIEW / stock_5min / 2018-04-02

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-04-02.parquet
  size:    5.7 MB
  rows:    367,300
  symbols: 2,881

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-04-02 04:00:00	AAPL	Stock	41.9	41.9	41.85	41.85	3524.0
2018-04-02 04:05:00	AAPL	Stock	41.9775	41.9775	41.925	41.925	10940.0
2018-04-02 04:15:00	AAPL	Stock	41.9275	41.9275	41.9275	41.9275	568.0
2018-04-02 04:20:00	AAPL	Stock	41.9375	41.9375	41.925	41.925	7536.0
2018-04-02 04:45:00	AAPL	Stock	41.93	41.95	41.925	41.95	4764.0
2018-04-02 04:50:00	AAPL	Stock	41.95	41.95	41.95	41.95	2212.0
2018-04-02 05:00:00	AAPL	Stock	41.95	41.95	41.925	41.925	26000.0
2018-04-02 05:05:00	AAPL	Stock	41.9275	41.9275	41.9275	41.9275	4000.0
2018-04-02 05:50:00	AAPL	Stock	41.9375	41.9375	41.9375	41.9375	760.0
2018-04-02 06:05:00	AAPL	Stock	42.0175	42.0475	42.0175	42.0475	10000.0
2018-04-02 06:10:00	AAPL	Stock	42.0475	42.0475	42.0475	42.0475	8664.0
2018-04-02 06:20:00	AAPL	Stock	42.0225	42.0225	42.0	42.02	2272.0
2018-04-02 06:50:00	AAPL	Stock	42.0	42.0	42.0	42.0	3940.0
2018-04-02 06:55:00	AAPL	Stock	42.0	42.0	41.975	41.975	2800.0
2018-04-02 07:00:00	AAPL	Stock	42.0	42.0	41.85	41.85	60120.0
2018-04-02 07:05:00	AAPL	Stock	41.87	41.875	41.87	41.875	12000.0
2018-04-02 07:10:00	AAPL	Stock	41.91	41.925	41.8625	41.925	28252.0
2018-04-02 07:15:00	AAPL	Stock	41.8775	41.9025	41.825	41.84	15988.0
2018-04-02 07:20:00	AAPL	Stock	41.835	41.8725	41.815	41.8275	30528.0
2018-04-02 07:25:00	AAPL	Stock	41.8625	41.8625	41.8525	41.8525	4500.0
2018-04-02 07:30:00	AAPL	Stock	41.8425	41.8425	41.7975	41.7975	5252.0
2018-04-02 07:35:00	AAPL	Stock	41.7975	41.8375	41.7975	41.8	22200.0
2018-04-02 07:40:00	AAPL	Stock	41.8	41.815	41.79	41.79	13488.0
2018-04-02 07:45:00	AAPL	Stock	41.8	41.8325	41.8	41.805	8920.0
2018-04-02 07:50:00	AAPL	Stock	41.8175	41.8375	41.8075	41.8375	1600.0
2018-04-02 07:55:00	AAPL	Stock	41.825	41.8375	41.8	41.8	13488.0
2018-04-02 08:00:00	AAPL	Stock	41.8125	41.975	41.8025	41.8175	56200.0
2018-04-02 08:05:00	AAPL	Stock	41.8325	41.945	41.8275	41.87	30632.0
2018-04-02 08:10:00	AAPL	Stock	41.87	41.925	41.8525	41.925	25640.0
2018-04-02 08:15:00	AAPL	Stock	41.88	41.9025	41.88	41.8825	13216.0
2018-04-02 08:20:00	AAPL	Stock	41.875	41.875	41.825	41.8375	10800.0
2018-04-02 08:25:00	AAPL	Stock	41.8175	41.8975	41.8175	41.8975	11340.0
2018-04-02 08:30:00	AAPL	Stock	41.8425	41.8875	41.8425	41.8825	1600.0
2018-04-02 08:35:00	AAPL	Stock	41.8875	41.9125	41.875	41.9125	23108.0
2018-04-02 08:40:00	AAPL	Stock	41.8675	41.9275	41.8675	41.8975	16212.0
2018-04-02 08:45:00	AAPL	Stock	41.8875	41.9	41.8875	41.9	5216.0
2018-04-02 08:50:00	AAPL	Stock	41.8925	41.965	41.89	41.9475	29000.0
2018-04-02 08:55:00	AAPL	Stock	41.9475	41.9675	41.9275	41.9625	43300.0
2018-04-02 09:00:00	AAPL	Stock	41.925	41.975	41.925	41.975	9076.0
2018-04-02 09:05:00	AAPL	Stock	41.9525	41.9825	41.9425	41.975	31196.0
2018-04-02 09:10:00	AAPL	Stock	41.9732	41.9732	41.94	41.94	7324.0
2018-04-02 09:15:00	AAPL	Stock	41.975	41.975	41.9065	41.9375	32852.0
2018-04-02 09:20:00	AAPL	Stock	41.9375	41.9525	41.9175	41.9375	42320.0
2018-04-02 09:25:00	AAPL	Stock	41.9375	42.0025	41.9225	41.9525	162960.0
2018-04-02 09:30:00	AAPL	Stock	41.97	42.145	41.9025	42.0925	5124148.0
2018-04-02 09:35:00	AAPL	Stock	42.0962	42.235	42.09	42.155	3149184.0
2018-04-02 09:40:00	AAPL	Stock	42.155	42.18	42.0862	42.1132	1633944.0
2018-04-02 09:45:00	AAPL	Stock	42.115	42.125	41.9425	41.9972	2063604.0
2018-04-02 09:50:00	AAPL	Stock	41.995	41.995	41.865	41.885	2365376.0
2018-04-02 09:55:00	AAPL	Stock	41.89	42.0	41.8325	41.9725	2041084.0

> showing 50 of 367,300 rows — these rows as CSV

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