PREVIEW / stock_5min / 2019-04-02

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-04-02.parquet
  size:    5.8 MB
  rows:    365,848
  symbols: 2,640

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
2019-04-02 04:35:00	AAPL	Stock	47.7025	47.7025	47.64	47.6425	3400.0
2019-04-02 05:50:00	AAPL	Stock	47.6975	47.6975	47.6975	47.6975	4000.0
2019-04-02 06:00:00	AAPL	Stock	47.7025	47.7025	47.7025	47.7025	400.0
2019-04-02 06:10:00	AAPL	Stock	47.67	47.67	47.67	47.67	2400.0
2019-04-02 06:25:00	AAPL	Stock	47.6975	47.7025	47.6975	47.7025	5584.0
2019-04-02 06:35:00	AAPL	Stock	47.7025	47.705	47.7025	47.705	2120.0
2019-04-02 06:45:00	AAPL	Stock	47.7	47.7	47.7	47.7	400.0
2019-04-02 07:00:00	AAPL	Stock	47.7375	47.74	47.7375	47.74	2812.0
2019-04-02 07:05:00	AAPL	Stock	47.73	47.79	47.73	47.79	4896.0
2019-04-02 07:10:00	AAPL	Stock	47.7575	47.7575	47.75	47.75	4980.0
2019-04-02 07:15:00	AAPL	Stock	47.7725	47.7725	47.7375	47.765	3200.0
2019-04-02 07:20:00	AAPL	Stock	47.7525	47.7525	47.7525	47.7525	1020.0
2019-04-02 07:25:00	AAPL	Stock	47.765	47.775	47.75	47.75	3576.0
2019-04-02 07:30:00	AAPL	Stock	47.745	47.75	47.745	47.75	3800.0
2019-04-02 07:35:00	AAPL	Stock	47.75	47.75	47.75	47.75	1792.0
2019-04-02 07:40:00	AAPL	Stock	47.7725	47.785	47.7725	47.785	2472.0
2019-04-02 07:45:00	AAPL	Stock	47.7425	47.7425	47.7375	47.7375	1600.0
2019-04-02 07:55:00	AAPL	Stock	47.76	47.76	47.7525	47.7525	800.0
2019-04-02 08:00:00	AAPL	Stock	47.7375	47.9275	47.7025	47.8	70760.0
2019-04-02 08:05:00	AAPL	Stock	47.8	47.8	47.78	47.8	3364.0
2019-04-02 08:10:00	AAPL	Stock	47.8	47.8	47.775	47.775	9304.0
2019-04-02 08:15:00	AAPL	Stock	47.77	47.77	47.77	47.77	400.0
2019-04-02 08:20:00	AAPL	Stock	47.775	47.785	47.7625	47.765	9960.0
2019-04-02 08:25:00	AAPL	Stock	47.7725	47.7725	47.75	47.75	1876.0
2019-04-02 08:30:00	AAPL	Stock	47.75	47.75	47.7	47.7	18064.0
2019-04-02 08:35:00	AAPL	Stock	47.705	47.7375	47.7	47.7	12320.0
2019-04-02 08:40:00	AAPL	Stock	47.77	47.77	47.75	47.75	3384.0
2019-04-02 08:45:00	AAPL	Stock	47.75	47.75	47.7125	47.7125	4800.0
2019-04-02 08:50:00	AAPL	Stock	47.7075	47.725	47.7075	47.725	1400.0
2019-04-02 08:55:00	AAPL	Stock	47.7058	47.725	47.7058	47.725	1600.0
2019-04-02 09:00:00	AAPL	Stock	47.7125	47.725	47.7125	47.7125	2780.0
2019-04-02 09:05:00	AAPL	Stock	47.725	47.725	47.715	47.715	4128.0
2019-04-02 09:10:00	AAPL	Stock	47.715	47.725	47.7025	47.7125	11208.0
2019-04-02 09:15:00	AAPL	Stock	47.7025	47.725	47.7	47.715	12196.0
2019-04-02 09:20:00	AAPL	Stock	47.715	47.72	47.7	47.72	9960.0
2019-04-02 09:25:00	AAPL	Stock	47.725	47.765	47.725	47.765	40244.0
2019-04-02 09:30:00	AAPL	Stock	47.7725	48.0707	47.7625	48.055	3977580.0
2019-04-02 09:35:00	AAPL	Stock	48.0565	48.2075	48.0565	48.135	3244116.0
2019-04-02 09:40:00	AAPL	Stock	48.14	48.1712	48.0825	48.1225	1855784.0
2019-04-02 09:45:00	AAPL	Stock	48.1225	48.27	48.0875	48.225	2605704.0
2019-04-02 09:50:00	AAPL	Stock	48.225	48.235	48.1025	48.1125	1414828.0
2019-04-02 09:55:00	AAPL	Stock	48.115	48.1398	47.89	47.925	1943404.0
2019-04-02 10:00:00	AAPL	Stock	47.9225	48.0275	47.8825	48.0232	1847032.0
2019-04-02 10:05:00	AAPL	Stock	48.02	48.14	48.005	48.1325	1187476.0
2019-04-02 10:10:00	AAPL	Stock	48.1325	48.1825	48.075	48.1725	979044.0
2019-04-02 10:15:00	AAPL	Stock	48.1725	48.195	48.1225	48.1875	938744.0
2019-04-02 10:20:00	AAPL	Stock	48.1888	48.2275	48.169	48.18	968388.0
2019-04-02 10:25:00	AAPL	Stock	48.1775	48.2475	48.1625	48.205	1028168.0
2019-04-02 10:30:00	AAPL	Stock	48.205	48.2075	48.165	48.1925	570604.0
2019-04-02 10:35:00	AAPL	Stock	48.195	48.2025	48.1125	48.14	714212.0

> showing 50 of 365,848 rows — these rows as CSV

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