PREVIEW / stock_5min / 2019-07-23

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-07-23.parquet
  size:    5.6 MB
  rows:    354,214
  symbols: 2,576

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-23 04:00:00	AAPL	Stock	52.0	52.0	51.8775	51.8775	6000.0
2019-07-23 04:05:00	AAPL	Stock	51.875	51.875	51.875	51.875	3984.0
2019-07-23 04:15:00	AAPL	Stock	51.9175	51.9175	51.9175	51.9175	3276.0
2019-07-23 04:20:00	AAPL	Stock	51.9125	51.9125	51.9125	51.9125	400.0
2019-07-23 04:25:00	AAPL	Stock	51.935	51.935	51.935	51.935	1000.0
2019-07-23 04:30:00	AAPL	Stock	51.9625	51.9625	51.9625	51.9625	2400.0
2019-07-23 04:40:00	AAPL	Stock	51.925	51.925	51.9	51.9	4800.0
2019-07-23 04:55:00	AAPL	Stock	51.9	51.91	51.885	51.9075	12704.0
2019-07-23 05:05:00	AAPL	Stock	51.9075	51.9125	51.8875	51.8875	4416.0
2019-07-23 05:20:00	AAPL	Stock	51.93	51.93	51.93	51.93	400.0
2019-07-23 06:10:00	AAPL	Stock	51.975	51.9775	51.975	51.9775	2200.0
2019-07-23 06:15:00	AAPL	Stock	52.0	52.0	52.0	52.0	800.0
2019-07-23 06:20:00	AAPL	Stock	52.0	52.0	52.0	52.0	1600.0
2019-07-23 06:25:00	AAPL	Stock	52.015	52.0325	52.0125	52.0325	4400.0
2019-07-23 06:30:00	AAPL	Stock	52.0475	52.0475	52.025	52.025	4904.0
2019-07-23 06:45:00	AAPL	Stock	51.9925	51.9925	51.9925	51.9925	1176.0
2019-07-23 06:50:00	AAPL	Stock	51.975	51.975	51.975	51.975	800.0
2019-07-23 07:00:00	AAPL	Stock	52.0	52.0	51.975	51.975	22868.0
2019-07-23 07:05:00	AAPL	Stock	51.9725	52.0	51.96	51.9975	32924.0
2019-07-23 07:10:00	AAPL	Stock	51.9875	51.9875	51.9625	51.9875	4040.0
2019-07-23 07:15:00	AAPL	Stock	51.975	52.025	51.975	52.0225	15336.0
2019-07-23 07:20:00	AAPL	Stock	52.0225	52.025	52.005	52.025	6248.0
2019-07-23 07:25:00	AAPL	Stock	52.0125	52.025	51.9825	51.9825	9620.0
2019-07-23 07:30:00	AAPL	Stock	51.9925	52.0375	51.9925	52.0375	15580.0
2019-07-23 07:35:00	AAPL	Stock	52.04	52.0625	52.015	52.015	27344.0
2019-07-23 07:40:00	AAPL	Stock	52.0425	52.055	52.0275	52.0275	6400.0
2019-07-23 07:45:00	AAPL	Stock	52.0125	52.0225	52.0125	52.0225	2268.0
2019-07-23 07:50:00	AAPL	Stock	52.005	52.005	51.975	51.9925	13292.0
2019-07-23 07:55:00	AAPL	Stock	51.9975	52.015	51.995	52.015	10600.0
2019-07-23 08:00:00	AAPL	Stock	52.0	52.0375	51.9625	52.0375	95648.0
2019-07-23 08:05:00	AAPL	Stock	52.0375	52.07	51.6775	52.07	40804.0
2019-07-23 08:10:00	AAPL	Stock	52.07	52.07	52.04	52.04	11248.0
2019-07-23 08:15:00	AAPL	Stock	52.0375	52.0625	52.0375	52.0625	13964.0
2019-07-23 08:20:00	AAPL	Stock	52.0725	52.0775	52.0625	52.065	58040.0
2019-07-23 08:25:00	AAPL	Stock	52.075	52.0975	52.075	52.0875	15084.0
2019-07-23 08:30:00	AAPL	Stock	52.0825	52.115	52.08	52.1125	11820.0
2019-07-23 08:35:00	AAPL	Stock	52.1125	52.15	52.1125	52.15	57440.0
2019-07-23 08:40:00	AAPL	Stock	52.145	52.17	52.125	52.1375	40276.0
2019-07-23 08:45:00	AAPL	Stock	52.1375	52.15	52.1	52.1	33904.0
2019-07-23 08:50:00	AAPL	Stock	52.12	52.125	52.085	52.085	16064.0
2019-07-23 08:55:00	AAPL	Stock	52.0775	52.1125	52.0775	52.0918	13076.0
2019-07-23 09:00:00	AAPL	Stock	52.09	52.11	52.075	52.0835	30292.0
2019-07-23 09:05:00	AAPL	Stock	52.095	52.11	52.0875	52.105	25940.0
2019-07-23 09:10:00	AAPL	Stock	52.115	52.1375	52.115	52.1225	31732.0
2019-07-23 09:15:00	AAPL	Stock	52.1075	52.1225	52.095	52.1	9648.0
2019-07-23 09:20:00	AAPL	Stock	52.105	52.12	52.1025	52.1025	10608.0
2019-07-23 09:25:00	AAPL	Stock	52.1025	52.13	52.0875	52.12	67376.0
2019-07-23 09:30:00	AAPL	Stock	52.0925	52.1975	51.925	51.95	4601956.0
2019-07-23 09:35:00	AAPL	Stock	51.9525	52.025	51.8575	51.9	2011588.0
2019-07-23 09:40:00	AAPL	Stock	51.895	52.0575	51.8713	52.0125	1601360.0

> showing 50 of 354,214 rows — these rows as CSV

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