PREVIEW / stock_5min / 2017-01-20

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-01-20.parquet
  size:    5.3 MB
  rows:    348,600
  symbols: 3,089

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-20 04:10:00	AAPL	Stock	29.9475	29.9475	29.945	29.945	1600.0
2017-01-20 05:45:00	AAPL	Stock	29.995	30.0	29.995	30.0	1924.0
2017-01-20 06:15:00	AAPL	Stock	30.035	30.035	30.0225	30.0225	1952.0
2017-01-20 06:20:00	AAPL	Stock	30.0225	30.0425	30.0225	30.0425	1852.0
2017-01-20 06:50:00	AAPL	Stock	30.0325	30.0375	30.0325	30.0375	1200.0
2017-01-20 07:00:00	AAPL	Stock	30.0425	30.0425	30.0425	30.0425	400.0
2017-01-20 07:05:00	AAPL	Stock	30.035	30.035	30.035	30.035	4000.0
2017-01-20 07:10:00	AAPL	Stock	30.035	30.035	30.035	30.035	16000.0
2017-01-20 07:15:00	AAPL	Stock	30.035	30.035	30.035	30.035	4400.0
2017-01-20 07:20:00	AAPL	Stock	30.0375	30.04	30.0375	30.04	800.0
2017-01-20 07:25:00	AAPL	Stock	30.0375	30.0375	30.0375	30.0375	1200.0
2017-01-20 07:30:00	AAPL	Stock	30.035	30.035	30.025	30.025	4652.0
2017-01-20 07:35:00	AAPL	Stock	30.0225	30.0225	30.02	30.02	4880.0
2017-01-20 07:40:00	AAPL	Stock	30.02	30.02	30.02	30.02	21504.0
2017-01-20 07:55:00	AAPL	Stock	30.025	30.05	30.025	30.05	20724.0
2017-01-20 08:00:00	AAPL	Stock	30.05	30.05	29.875	30.0375	38696.0
2017-01-20 08:05:00	AAPL	Stock	30.0425	30.0425	30.025	30.025	8400.0
2017-01-20 08:10:00	AAPL	Stock	30.025	30.0375	30.025	30.0325	6000.0
2017-01-20 08:15:00	AAPL	Stock	30.025	30.0525	30.025	30.0525	9600.0
2017-01-20 08:20:00	AAPL	Stock	30.0275	30.05	30.0275	30.0325	14764.0
2017-01-20 08:25:00	AAPL	Stock	30.0375	30.0375	30.0325	30.0375	10016.0
2017-01-20 08:30:00	AAPL	Stock	30.035	30.05	30.0125	30.0125	8116.0
2017-01-20 08:35:00	AAPL	Stock	30.04	30.055	30.04	30.055	25420.0
2017-01-20 08:40:00	AAPL	Stock	30.055	30.06	30.055	30.06	7196.0
2017-01-20 08:45:00	AAPL	Stock	30.055	30.055	30.04	30.0525	24396.0
2017-01-20 08:50:00	AAPL	Stock	30.0425	30.0525	30.03	30.03	9320.0
2017-01-20 08:55:00	AAPL	Stock	30.03	30.04	30.03	30.0375	12200.0
2017-01-20 09:00:00	AAPL	Stock	30.0375	30.0475	30.0375	30.0475	3296.0
2017-01-20 09:05:00	AAPL	Stock	30.05	30.055	30.0375	30.05	32556.0
2017-01-20 09:10:00	AAPL	Stock	30.04	30.0475	30.04	30.0475	12736.0
2017-01-20 09:15:00	AAPL	Stock	30.0475	30.05	30.025	30.025	13484.0
2017-01-20 09:20:00	AAPL	Stock	30.02	30.0375	30.0175	30.03	9200.0
2017-01-20 09:25:00	AAPL	Stock	30.03	30.0975	30.005	30.0925	761108.0
2017-01-20 09:30:00	AAPL	Stock	30.05	30.1125	29.985	30.0188	12255056.0
2017-01-20 09:35:00	AAPL	Stock	30.02	30.0725	30.0	30.0475	2640744.0
2017-01-20 09:40:00	AAPL	Stock	30.05	30.0625	29.9975	30.04	2287788.0
2017-01-20 09:45:00	AAPL	Stock	30.0425	30.045	30.0075	30.031	1372604.0
2017-01-20 09:50:00	AAPL	Stock	30.0325	30.0425	30.015	30.035	1414368.0
2017-01-20 09:55:00	AAPL	Stock	30.03	30.0475	30.02	30.03	1373972.0
2017-01-20 10:00:00	AAPL	Stock	30.032	30.0375	30.015	30.025	1061356.0
2017-01-20 10:05:00	AAPL	Stock	30.0225	30.0275	29.995	30.0025	1596804.0
2017-01-20 10:10:00	AAPL	Stock	30.0035	30.0125	29.975	29.9938	1138244.0
2017-01-20 10:15:00	AAPL	Stock	29.9932	30.0075	29.985	30.0012	933604.0
2017-01-20 10:20:00	AAPL	Stock	30.0025	30.0075	29.9575	29.96	1761556.0
2017-01-20 10:25:00	AAPL	Stock	29.96	29.99	29.96	29.99	784680.0
2017-01-20 10:30:00	AAPL	Stock	29.9888	30.0025	29.98	30.0	841204.0
2017-01-20 10:35:00	AAPL	Stock	30.0	30.0038	29.995	30.0002	681844.0
2017-01-20 10:40:00	AAPL	Stock	30.0	30.0025	29.985	30.0	651156.0
2017-01-20 10:45:00	AAPL	Stock	29.9975	30.0175	29.9975	30.0168	1149120.0
2017-01-20 10:50:00	AAPL	Stock	30.015	30.03	30.0075	30.023	783800.0

> showing 50 of 348,600 rows — these rows as CSV

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