PREVIEW / stock_5min / 2017-01-19

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-01-19.parquet
  size:    5.4 MB
  rows:    356,080
  symbols: 3,113

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-19 05:45:00	AAPL	Stock	29.9775	29.9775	29.9775	29.9775	596.0
2017-01-19 05:50:00	AAPL	Stock	29.9625	29.9625	29.9625	29.9625	3672.0
2017-01-19 05:55:00	AAPL	Stock	29.965	29.965	29.9625	29.9625	5880.0
2017-01-19 06:00:00	AAPL	Stock	30.0	30.02	30.0	30.02	4948.0
2017-01-19 06:05:00	AAPL	Stock	30.0175	30.05	30.0175	30.05	20824.0
2017-01-19 06:10:00	AAPL	Stock	30.0625	30.0625	30.0625	30.0625	2720.0
2017-01-19 06:15:00	AAPL	Stock	30.0625	30.0625	30.0625	30.0625	400.0
2017-01-19 06:25:00	AAPL	Stock	30.06	30.0625	30.06	30.0625	1444.0
2017-01-19 06:30:00	AAPL	Stock	30.0425	30.0625	30.0425	30.0425	6752.0
2017-01-19 06:35:00	AAPL	Stock	30.0075	30.0125	29.9925	30.0125	29240.0
2017-01-19 06:40:00	AAPL	Stock	29.9925	30.0	29.9925	30.0	21200.0
2017-01-19 06:45:00	AAPL	Stock	30.0125	30.0125	30.0125	30.0125	400.0
2017-01-19 06:50:00	AAPL	Stock	30.0125	30.0125	30.0125	30.0125	400.0
2017-01-19 07:00:00	AAPL	Stock	30.0125	30.0125	30.0075	30.0075	1872.0
2017-01-19 07:05:00	AAPL	Stock	29.9975	29.9975	29.9275	29.9275	33196.0
2017-01-19 07:10:00	AAPL	Stock	29.945	29.945	29.9325	29.9375	6552.0
2017-01-19 07:15:00	AAPL	Stock	29.965	29.965	29.965	29.965	400.0
2017-01-19 07:20:00	AAPL	Stock	29.95	29.9725	29.95	29.95	5988.0
2017-01-19 07:25:00	AAPL	Stock	29.95	29.95	29.94	29.95	28392.0
2017-01-19 07:30:00	AAPL	Stock	29.95	29.9675	29.95	29.9675	6400.0
2017-01-19 07:40:00	AAPL	Stock	29.945	29.9625	29.94	29.9625	3888.0
2017-01-19 07:45:00	AAPL	Stock	29.95	29.9675	29.94	29.94	15196.0
2017-01-19 07:50:00	AAPL	Stock	29.94	29.94	29.9375	29.9375	6332.0
2017-01-19 07:55:00	AAPL	Stock	29.9325	29.9375	29.9325	29.9375	4400.0
2017-01-19 08:00:00	AAPL	Stock	29.98	29.98	29.9175	29.9175	42608.0
2017-01-19 08:05:00	AAPL	Stock	29.915	29.915	29.8975	29.9125	54096.0
2017-01-19 08:10:00	AAPL	Stock	29.9075	29.93	29.8825	29.8825	52540.0
2017-01-19 08:15:00	AAPL	Stock	29.8825	29.9025	29.875	29.9025	50568.0
2017-01-19 08:20:00	AAPL	Stock	29.9125	29.9125	29.8875	29.9125	33200.0
2017-01-19 08:25:00	AAPL	Stock	29.91	29.92	29.875	29.9125	73544.0
2017-01-19 08:30:00	AAPL	Stock	29.9	29.9325	29.9	29.93	37316.0
2017-01-19 08:35:00	AAPL	Stock	29.92	29.925	29.9	29.92	19816.0
2017-01-19 08:40:00	AAPL	Stock	29.9	29.91	29.8925	29.91	1804.0
2017-01-19 08:45:00	AAPL	Stock	29.91	29.91	29.8925	29.9	21960.0
2017-01-19 08:50:00	AAPL	Stock	29.9	29.915	29.8775	29.8775	60340.0
2017-01-19 08:55:00	AAPL	Stock	29.8875	29.91	29.8775	29.9	15936.0
2017-01-19 09:00:00	AAPL	Stock	29.905	29.9075	29.78	29.81	306892.0
2017-01-19 09:05:00	AAPL	Stock	29.8125	29.8525	29.8125	29.8525	60836.0
2017-01-19 09:10:00	AAPL	Stock	29.84	29.8525	29.825	29.85	53640.0
2017-01-19 09:15:00	AAPL	Stock	29.8475	29.88	29.8475	29.875	90452.0
2017-01-19 09:20:00	AAPL	Stock	29.8775	29.8775	29.8625	29.8625	13804.0
2017-01-19 09:25:00	AAPL	Stock	29.8625	29.8775	29.8425	29.85	85340.0
2017-01-19 09:30:00	AAPL	Stock	29.85	29.99	29.8425	29.95	5534572.0
2017-01-19 09:35:00	AAPL	Stock	29.95	30.0	29.915	29.925	2276340.0
2017-01-19 09:40:00	AAPL	Stock	29.9275	29.95	29.8975	29.9485	2145736.0
2017-01-19 09:45:00	AAPL	Stock	29.9475	30.0	29.945	29.9825	1768368.0
2017-01-19 09:50:00	AAPL	Stock	29.98	30.0025	29.9675	29.9795	1754024.0
2017-01-19 09:55:00	AAPL	Stock	29.9788	30.0125	29.9768	30.005	2067104.0
2017-01-19 10:00:00	AAPL	Stock	30.005	30.0125	29.9525	29.9778	1639796.0
2017-01-19 10:05:00	AAPL	Stock	29.98	29.995	29.9425	29.945	1174300.0

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

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