PREVIEW / stock_5min / 2018-09-20

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-09-20.parquet
  size:    5.8 MB
  rows:    366,286
  symbols: 2,802

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-09-20 04:05:00	AAPL	Stock	54.75	54.75	54.75	54.75	3800.0
2018-09-20 04:15:00	AAPL	Stock	54.7625	54.7625	54.7625	54.7625	444.0
2018-09-20 04:35:00	AAPL	Stock	54.7625	54.7625	54.7375	54.7375	1684.0
2018-09-20 05:10:00	AAPL	Stock	54.7375	54.7375	54.7375	54.7375	2000.0
2018-09-20 06:30:00	AAPL	Stock	54.75	54.75	54.75	54.75	4000.0
2018-09-20 06:35:00	AAPL	Stock	54.815	54.815	54.8125	54.8125	1212.0
2018-09-20 06:40:00	AAPL	Stock	54.85	54.85	54.85	54.85	4800.0
2018-09-20 06:45:00	AAPL	Stock	54.875	54.875	54.875	54.875	400.0
2018-09-20 06:50:00	AAPL	Stock	54.8625	54.8775	54.8625	54.8775	1392.0
2018-09-20 07:00:00	AAPL	Stock	54.8775	54.9	54.85	54.85	5196.0
2018-09-20 07:05:00	AAPL	Stock	54.895	54.9	54.855	54.8725	32800.0
2018-09-20 07:10:00	AAPL	Stock	54.8375	54.85	54.8375	54.85	14432.0
2018-09-20 07:15:00	AAPL	Stock	54.85	54.8625	54.7575	54.7575	20036.0
2018-09-20 07:20:00	AAPL	Stock	54.79	54.8225	54.785	54.8225	15904.0
2018-09-20 07:25:00	AAPL	Stock	54.8425	54.85	54.8325	54.85	16684.0
2018-09-20 07:30:00	AAPL	Stock	54.85	54.915	54.85	54.8875	7856.0
2018-09-20 07:35:00	AAPL	Stock	54.895	54.92	54.895	54.9	58712.0
2018-09-20 07:40:00	AAPL	Stock	54.915	54.915	54.915	54.915	400.0
2018-09-20 07:45:00	AAPL	Stock	54.9225	54.9625	54.9225	54.9375	24936.0
2018-09-20 07:50:00	AAPL	Stock	54.9375	54.9375	54.9	54.925	22336.0
2018-09-20 07:55:00	AAPL	Stock	54.9375	54.955	54.9275	54.95	36168.0
2018-09-20 08:00:00	AAPL	Stock	54.8725	54.98	54.785	54.965	161028.0
2018-09-20 08:05:00	AAPL	Stock	54.975	55.025	54.9625	55.025	80784.0
2018-09-20 08:10:00	AAPL	Stock	55.055	55.0875	55.0175	55.0175	110472.0
2018-09-20 08:15:00	AAPL	Stock	55.075	55.125	55.0525	55.095	48888.0
2018-09-20 08:20:00	AAPL	Stock	55.1	55.1	55.035	55.035	33808.0
2018-09-20 08:25:00	AAPL	Stock	55.025	55.0625	55.0	55.0125	39844.0
2018-09-20 08:30:00	AAPL	Stock	55.0125	55.11	55.0125	55.1	48480.0
2018-09-20 08:35:00	AAPL	Stock	55.11	55.125	55.0875	55.1	79076.0
2018-09-20 08:40:00	AAPL	Stock	55.1225	55.165	55.115	55.1625	47672.0
2018-09-20 08:45:00	AAPL	Stock	55.1675	55.1725	55.145	55.15	40420.0
2018-09-20 08:50:00	AAPL	Stock	55.145	55.16	55.1025	55.145	24392.0
2018-09-20 08:55:00	AAPL	Stock	55.15	55.16	55.1375	55.1425	28596.0
2018-09-20 09:00:00	AAPL	Stock	55.15	55.1525	55.1075	55.135	51120.0
2018-09-20 09:05:00	AAPL	Stock	55.12	55.12	55.1	55.1075	24268.0
2018-09-20 09:10:00	AAPL	Stock	55.1075	55.125	55.08	55.1	70320.0
2018-09-20 09:15:00	AAPL	Stock	55.09	55.1025	55.08	55.1	37628.0
2018-09-20 09:20:00	AAPL	Stock	55.125	55.125	55.05	55.05	43996.0
2018-09-20 09:25:00	AAPL	Stock	55.0525	55.0825	55.0375	55.0825	46736.0
2018-09-20 09:30:00	AAPL	Stock	55.08	55.1575	54.82	54.8475	5017756.0
2018-09-20 09:35:00	AAPL	Stock	54.85	55.1375	54.7875	55.1235	2543400.0
2018-09-20 09:40:00	AAPL	Stock	55.1175	55.375	55.1	55.35	3107252.0
2018-09-20 09:45:00	AAPL	Stock	55.35	55.425	55.25	55.2675	2108976.0
2018-09-20 09:50:00	AAPL	Stock	55.2725	55.305	55.14	55.1912	1960860.0
2018-09-20 09:55:00	AAPL	Stock	55.1925	55.34	55.1825	55.3125	1680360.0
2018-09-20 10:00:00	AAPL	Stock	55.3125	55.535	55.3045	55.4635	2832564.0
2018-09-20 10:05:00	AAPL	Stock	55.465	55.57	55.4525	55.465	1877684.0
2018-09-20 10:10:00	AAPL	Stock	55.465	55.5112	55.4025	55.5062	1389824.0
2018-09-20 10:15:00	AAPL	Stock	55.5062	55.5175	55.3892	55.4475	1192004.0
2018-09-20 10:20:00	AAPL	Stock	55.447	55.5375	55.4225	55.4505	1551012.0

> showing 50 of 366,286 rows — these rows as CSV

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