PREVIEW / stock_5min / 2019-07-29

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-07-29.parquet
  size:    5.6 MB
  rows:    358,148
  symbols: 2,596

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-07-29 04:00:00	AAPL	Stock	51.9625	51.9625	51.9625	51.9625	872.0
2019-07-29 04:10:00	AAPL	Stock	51.975	51.975	51.975	51.975	1968.0
2019-07-29 04:30:00	AAPL	Stock	51.885	51.885	51.885	51.885	1200.0
2019-07-29 04:55:00	AAPL	Stock	51.9075	51.9075	51.8825	51.8825	800.0
2019-07-29 05:00:00	AAPL	Stock	51.875	51.9425	51.875	51.9425	800.0
2019-07-29 05:15:00	AAPL	Stock	51.95	51.95	51.9	51.9	2400.0
2019-07-29 05:20:00	AAPL	Stock	51.8625	51.8625	51.8625	51.8625	4000.0
2019-07-29 05:25:00	AAPL	Stock	51.86	51.86	51.86	51.86	400.0
2019-07-29 05:40:00	AAPL	Stock	51.9075	51.9075	51.9075	51.9075	400.0
2019-07-29 05:45:00	AAPL	Stock	51.875	51.875	51.875	51.875	800.0
2019-07-29 05:50:00	AAPL	Stock	51.875	51.875	51.875	51.875	400.0
2019-07-29 05:55:00	AAPL	Stock	51.875	51.875	51.875	51.875	400.0
2019-07-29 06:00:00	AAPL	Stock	51.88	51.88	51.88	51.88	400.0
2019-07-29 06:30:00	AAPL	Stock	51.95	51.95	51.9375	51.9375	1200.0
2019-07-29 06:35:00	AAPL	Stock	51.9375	51.9375	51.9375	51.9375	800.0
2019-07-29 06:55:00	AAPL	Stock	51.8475	51.8875	51.8475	51.8875	1200.0
2019-07-29 07:00:00	AAPL	Stock	51.8975	51.92	51.8975	51.92	2140.0
2019-07-29 07:05:00	AAPL	Stock	51.9125	51.9375	51.9125	51.9375	2800.0
2019-07-29 07:10:00	AAPL	Stock	51.9575	51.9725	51.9375	51.9625	8608.0
2019-07-29 07:15:00	AAPL	Stock	51.9525	51.9525	51.95	51.9525	2332.0
2019-07-29 07:25:00	AAPL	Stock	51.975	51.995	51.975	51.995	4076.0
2019-07-29 07:30:00	AAPL	Stock	51.9925	52.0025	51.9925	52.0025	3188.0
2019-07-29 07:35:00	AAPL	Stock	52.0375	52.05	52.035	52.035	6300.0
2019-07-29 07:40:00	AAPL	Stock	52.065	52.065	52.065	52.065	800.0
2019-07-29 07:45:00	AAPL	Stock	52.075	52.095	52.075	52.095	3100.0
2019-07-29 07:50:00	AAPL	Stock	52.0725	52.0875	52.0725	52.08	1200.0
2019-07-29 08:00:00	AAPL	Stock	51.925	52.0875	51.881	52.056	62420.0
2019-07-29 08:05:00	AAPL	Stock	52.03	52.0425	52.03	52.0425	4400.0
2019-07-29 08:10:00	AAPL	Stock	52.0425	52.0425	52.025	52.0425	2000.0
2019-07-29 08:15:00	AAPL	Stock	52.0375	52.05	52.025	52.025	21480.0
2019-07-29 08:20:00	AAPL	Stock	52.05	52.05	52.0175	52.0175	4800.0
2019-07-29 08:25:00	AAPL	Stock	52.0375	52.05	52.035	52.0375	28288.0
2019-07-29 08:30:00	AAPL	Stock	52.003	52.0475	52.003	52.0125	29372.0
2019-07-29 08:35:00	AAPL	Stock	52.045	52.045	52.035	52.035	5600.0
2019-07-29 08:40:00	AAPL	Stock	52.025	52.0375	52.0175	52.025	18104.0
2019-07-29 08:45:00	AAPL	Stock	52.025	52.045	52.025	52.0425	5488.0
2019-07-29 08:50:00	AAPL	Stock	52.0475	52.085	52.0375	52.085	10260.0
2019-07-29 08:55:00	AAPL	Stock	52.075	52.1	52.0725	52.075	37212.0
2019-07-29 09:00:00	AAPL	Stock	52.0975	52.11	52.075	52.105	31720.0
2019-07-29 09:05:00	AAPL	Stock	52.1	52.1475	52.084	52.1325	80516.0
2019-07-29 09:10:00	AAPL	Stock	52.1325	52.14	52.0875	52.1125	91700.0
2019-07-29 09:15:00	AAPL	Stock	52.115	52.115	52.0875	52.115	11788.0
2019-07-29 09:20:00	AAPL	Stock	52.105	52.115	52.0875	52.09	21612.0
2019-07-29 09:25:00	AAPL	Stock	52.1125	52.1725	52.1	52.1	37376.0
2019-07-29 09:30:00	AAPL	Stock	52.1175	52.38	52.11	52.3335	3861796.0
2019-07-29 09:35:00	AAPL	Stock	52.3432	52.425	52.295	52.371	2018200.0
2019-07-29 09:40:00	AAPL	Stock	52.37	52.3743	52.17	52.24	2109476.0
2019-07-29 09:45:00	AAPL	Stock	52.2425	52.3875	52.2225	52.3835	1256092.0
2019-07-29 09:50:00	AAPL	Stock	52.3825	52.42	52.3	52.315	1379628.0
2019-07-29 09:55:00	AAPL	Stock	52.3075	52.355	52.24	52.2425	1536504.0

> showing 50 of 358,148 rows — these rows as CSV

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