PREVIEW / stock_5min / 2017-04-06

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-04-06.parquet
  size:    5.4 MB
  rows:    356,378
  symbols: 3,049

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
2017-04-06 04:15:00	AAPL	Stock	35.9075	35.9075	35.9075	35.9075	744.0
2017-04-06 04:20:00	AAPL	Stock	35.925	35.925	35.925	35.925	3840.0
2017-04-06 04:25:00	AAPL	Stock	35.9225	35.9225	35.92	35.92	968.0
2017-04-06 04:35:00	AAPL	Stock	35.9225	35.9375	35.9225	35.9375	7856.0
2017-04-06 05:45:00	AAPL	Stock	35.965	35.975	35.965	35.975	4668.0
2017-04-06 05:50:00	AAPL	Stock	35.975	36.0	35.975	36.0	1600.0
2017-04-06 06:10:00	AAPL	Stock	35.9925	35.9925	35.99	35.99	7600.0
2017-04-06 06:30:00	AAPL	Stock	35.98	36.0	35.98	36.0	4392.0
2017-04-06 06:35:00	AAPL	Stock	36.0	36.0	36.0	36.0	800.0
2017-04-06 06:40:00	AAPL	Stock	36.0075	36.0325	36.0075	36.0325	18188.0
2017-04-06 06:45:00	AAPL	Stock	36.035	36.05	36.035	36.05	6116.0
2017-04-06 06:50:00	AAPL	Stock	36.05	36.05	36.05	36.05	1084.0
2017-04-06 06:55:00	AAPL	Stock	36.05	36.05	36.05	36.05	2800.0
2017-04-06 07:00:00	AAPL	Stock	36.04	36.06	36.04	36.0575	8388.0
2017-04-06 07:05:00	AAPL	Stock	36.05	36.0575	36.0375	36.0375	4724.0
2017-04-06 07:10:00	AAPL	Stock	36.0375	36.0375	36.0375	36.0375	2332.0
2017-04-06 07:15:00	AAPL	Stock	36.035	36.05	36.035	36.05	25268.0
2017-04-06 07:20:00	AAPL	Stock	36.0325	36.0325	36.0325	36.0325	1600.0
2017-04-06 07:30:00	AAPL	Stock	36.03	36.03	36.03	36.03	800.0
2017-04-06 07:35:00	AAPL	Stock	36.0475	36.0475	36.0475	36.0475	400.0
2017-04-06 07:40:00	AAPL	Stock	36.0475	36.0475	36.045	36.0475	9628.0
2017-04-06 07:45:00	AAPL	Stock	36.0475	36.0475	36.035	36.0375	3200.0
2017-04-06 07:50:00	AAPL	Stock	36.035	36.035	36.025	36.025	22372.0
2017-04-06 07:55:00	AAPL	Stock	36.025	36.025	36.025	36.025	8000.0
2017-04-06 08:00:00	AAPL	Stock	36.025	36.06	36.0075	36.02	43988.0
2017-04-06 08:05:00	AAPL	Stock	36.0225	36.025	36.0225	36.025	2800.0
2017-04-06 08:10:00	AAPL	Stock	36.025	36.025	36.0	36.0	18480.0
2017-04-06 08:15:00	AAPL	Stock	36.0175	36.0175	36.0	36.0025	3244.0
2017-04-06 08:20:00	AAPL	Stock	36.0125	36.0125	35.9875	35.9875	14400.0
2017-04-06 08:25:00	AAPL	Stock	36.025	36.025	36.01	36.0125	20640.0
2017-04-06 08:30:00	AAPL	Stock	36.025	36.0425	36.0125	36.0425	66964.0
2017-04-06 08:35:00	AAPL	Stock	36.05	36.05	36.0175	36.0175	6640.0
2017-04-06 08:40:00	AAPL	Stock	36.0225	36.0325	36.005	36.005	6140.0
2017-04-06 08:45:00	AAPL	Stock	36.03	36.0425	36.03	36.0425	5200.0
2017-04-06 08:50:00	AAPL	Stock	36.0475	36.0475	36.0275	36.0275	1200.0
2017-04-06 08:55:00	AAPL	Stock	36.0375	36.0375	36.0375	36.0375	600.0
2017-04-06 09:00:00	AAPL	Stock	36.0425	36.07	36.0425	36.0625	37188.0
2017-04-06 09:05:00	AAPL	Stock	36.07	36.09	36.055	36.09	42028.0
2017-04-06 09:10:00	AAPL	Stock	36.09	36.095	36.0725	36.0825	42396.0
2017-04-06 09:15:00	AAPL	Stock	36.075	36.0875	36.065	36.0825	14496.0
2017-04-06 09:20:00	AAPL	Stock	36.0775	36.1	36.075	36.0775	54452.0
2017-04-06 09:25:00	AAPL	Stock	36.0825	36.0825	36.05	36.065	74600.0
2017-04-06 09:30:00	AAPL	Stock	36.0725	36.1225	36.0125	36.065	4172124.0
2017-04-06 09:35:00	AAPL	Stock	36.06	36.1075	36.0575	36.084	1798472.0
2017-04-06 09:40:00	AAPL	Stock	36.0825	36.1125	36.04	36.0488	1663936.0
2017-04-06 09:45:00	AAPL	Stock	36.045	36.0575	35.955	36.0037	3159924.0
2017-04-06 09:50:00	AAPL	Stock	36.0025	36.11	35.993	36.1075	2067808.0
2017-04-06 09:55:00	AAPL	Stock	36.1075	36.13	36.065	36.0775	1196580.0
2017-04-06 10:00:00	AAPL	Stock	36.08	36.0975	35.99	36.01	1472112.0
2017-04-06 10:05:00	AAPL	Stock	36.0125	36.045	36.0125	36.035	1132628.0

> showing 50 of 356,378 rows — these rows as CSV

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