PREVIEW / stock_5min / 2017-01-03

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-01-03.parquet
  size:    5.6 MB
  rows:    364,726
  symbols: 3,142

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-01-03 04:00:00	AAPL	Stock	29.005	29.005	29.005	29.005	800.0
2017-01-03 04:05:00	AAPL	Stock	29.035	29.06	29.03	29.0375	10680.0
2017-01-03 04:10:00	AAPL	Stock	29.0	29.04	29.0	29.0375	3968.0
2017-01-03 04:15:00	AAPL	Stock	29.0425	29.0425	29.0	29.005	11680.0
2017-01-03 04:20:00	AAPL	Stock	29.0125	29.0125	29.0125	29.0125	960.0
2017-01-03 04:25:00	AAPL	Stock	29.0125	29.0125	29.0125	29.0125	1200.0
2017-01-03 04:30:00	AAPL	Stock	29.0125	29.0125	29.01	29.01	4620.0
2017-01-03 04:35:00	AAPL	Stock	29.0125	29.0125	29.0125	29.0125	428.0
2017-01-03 04:50:00	AAPL	Stock	29.0125	29.0125	29.0125	29.0125	800.0
2017-01-03 05:00:00	AAPL	Stock	29.0075	29.0075	29.005	29.0075	2960.0
2017-01-03 05:20:00	AAPL	Stock	29.015	29.015	29.0025	29.0025	1656.0
2017-01-03 05:40:00	AAPL	Stock	29.005	29.005	29.0	29.0	9456.0
2017-01-03 05:45:00	AAPL	Stock	29.0	29.0	29.0	29.0	480.0
2017-01-03 05:55:00	AAPL	Stock	29.005	29.005	29.005	29.005	400.0
2017-01-03 06:00:00	AAPL	Stock	29.0175	29.0175	29.0175	29.0175	2000.0
2017-01-03 06:10:00	AAPL	Stock	29.03	29.03	29.03	29.03	4396.0
2017-01-03 06:25:00	AAPL	Stock	29.035	29.045	29.035	29.045	3396.0
2017-01-03 06:40:00	AAPL	Stock	29.07	29.07	29.07	29.07	400.0
2017-01-03 07:00:00	AAPL	Stock	29.0575	29.0925	29.0575	29.0925	4756.0
2017-01-03 07:05:00	AAPL	Stock	29.095	29.095	29.075	29.075	4400.0
2017-01-03 07:10:00	AAPL	Stock	29.0875	29.0875	29.0875	29.0875	1800.0
2017-01-03 07:15:00	AAPL	Stock	29.0775	29.0775	29.0775	29.0775	1200.0
2017-01-03 07:20:00	AAPL	Stock	29.09	29.09	29.075	29.075	4640.0
2017-01-03 07:30:00	AAPL	Stock	29.04	29.04	29.03	29.0325	7600.0
2017-01-03 07:35:00	AAPL	Stock	29.0475	29.0475	29.0475	29.0475	800.0
2017-01-03 07:45:00	AAPL	Stock	29.045	29.0475	29.045	29.0475	2400.0
2017-01-03 07:50:00	AAPL	Stock	29.0375	29.0425	29.0175	29.0175	9560.0
2017-01-03 07:55:00	AAPL	Stock	29.015	29.0175	29.005	29.005	18600.0
2017-01-03 08:00:00	AAPL	Stock	29.02	29.1	29.015	29.05	45136.0
2017-01-03 08:10:00	AAPL	Stock	29.03	29.0375	29.0275	29.035	10148.0
2017-01-03 08:15:00	AAPL	Stock	29.035	29.0375	29.0125	29.035	43920.0
2017-01-03 08:20:00	AAPL	Stock	29.0175	29.0375	29.0	29.0	39040.0
2017-01-03 08:25:00	AAPL	Stock	29.0125	29.04	29.0125	29.025	24944.0
2017-01-03 08:30:00	AAPL	Stock	29.025	29.05	29.025	29.0425	33404.0
2017-01-03 08:35:00	AAPL	Stock	29.0425	29.0575	29.0425	29.055	14400.0
2017-01-03 08:40:00	AAPL	Stock	29.0575	29.06	29.05	29.05	46880.0
2017-01-03 08:45:00	AAPL	Stock	29.0525	29.055	29.0525	29.055	1000.0
2017-01-03 08:50:00	AAPL	Stock	29.055	29.0625	29.0175	29.0475	69044.0
2017-01-03 08:55:00	AAPL	Stock	29.0375	29.05	29.0275	29.05	23008.0
2017-01-03 09:00:00	AAPL	Stock	29.05	29.055	28.955	29.05	12480.0
2017-01-03 09:05:00	AAPL	Stock	29.05	29.0625	29.0425	29.0625	20936.0
2017-01-03 09:10:00	AAPL	Stock	29.05	29.0625	29.0375	29.0375	42588.0
2017-01-03 09:15:00	AAPL	Stock	29.0325	29.0375	29.0225	29.0375	13016.0
2017-01-03 09:20:00	AAPL	Stock	29.03	29.06	29.0275	29.06	17928.0
2017-01-03 09:25:00	AAPL	Stock	29.055	29.0575	28.95	28.95	122944.0
2017-01-03 09:30:00	AAPL	Stock	28.955	29.0825	28.875	29.0375	6770088.0
2017-01-03 09:35:00	AAPL	Stock	29.0375	29.0625	28.775	28.7975	4762960.0
2017-01-03 09:40:00	AAPL	Stock	28.7988	28.86	28.69	28.8542	4901724.0
2017-01-03 09:45:00	AAPL	Stock	28.8525	28.8588	28.765	28.805	2833420.0
2017-01-03 09:50:00	AAPL	Stock	28.8025	28.8475	28.7775	28.8185	2245100.0

> showing 50 of 364,726 rows — these rows as CSV

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