PREVIEW / stock_5min / 2017-01-04

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-01-04.parquet
  size:    5.6 MB
  rows:    367,837
  symbols: 3,167

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-04 04:15:00	AAPL	Stock	28.9925	28.9925	28.99	28.99	1484.0
2017-01-04 04:45:00	AAPL	Stock	29.0675	29.0675	29.0675	29.0675	1200.0
2017-01-04 04:50:00	AAPL	Stock	29.0675	29.0675	29.0675	29.0675	400.0
2017-01-04 06:05:00	AAPL	Stock	29.0375	29.075	29.0375	29.075	2092.0
2017-01-04 06:20:00	AAPL	Stock	29.05	29.05	29.0375	29.05	5856.0
2017-01-04 06:25:00	AAPL	Stock	29.05	29.05	29.05	29.05	788.0
2017-01-04 06:30:00	AAPL	Stock	29.05	29.05	29.05	29.05	2000.0
2017-01-04 06:50:00	AAPL	Stock	29.02	29.02	29.02	29.02	2000.0
2017-01-04 07:05:00	AAPL	Stock	29.05	29.05	29.05	29.05	2476.0
2017-01-04 07:10:00	AAPL	Stock	29.0625	29.075	29.0275	29.0275	3200.0
2017-01-04 07:15:00	AAPL	Stock	29.03	29.03	29.025	29.025	6400.0
2017-01-04 07:20:00	AAPL	Stock	29.02	29.025	29.02	29.02	5200.0
2017-01-04 07:25:00	AAPL	Stock	29.0125	29.0125	28.9875	28.9875	18160.0
2017-01-04 07:30:00	AAPL	Stock	28.975	28.975	28.9675	28.9675	8000.0
2017-01-04 07:35:00	AAPL	Stock	28.965	28.975	28.9625	28.975	3600.0
2017-01-04 07:40:00	AAPL	Stock	28.9825	28.9825	28.9825	28.9825	400.0
2017-01-04 07:45:00	AAPL	Stock	28.9825	28.9825	28.9625	28.9625	14000.0
2017-01-04 07:50:00	AAPL	Stock	28.9675	28.9675	28.95	28.95	51136.0
2017-01-04 08:00:00	AAPL	Stock	28.9625	29.025	28.9625	28.9925	16000.0
2017-01-04 08:05:00	AAPL	Stock	28.9875	28.9925	28.9875	28.9875	7200.0
2017-01-04 08:15:00	AAPL	Stock	28.9925	29.0225	28.99	29.0225	35160.0
2017-01-04 08:20:00	AAPL	Stock	29.0025	29.0025	29.0025	29.0025	3600.0
2017-01-04 08:30:00	AAPL	Stock	29.005	29.005	28.9775	28.9775	17632.0
2017-01-04 08:35:00	AAPL	Stock	28.975	29.01	28.975	29.01	11200.0
2017-01-04 08:40:00	AAPL	Stock	29.01	29.01	28.985	28.9975	6100.0
2017-01-04 08:45:00	AAPL	Stock	28.99	29.0	28.99	29.0	8696.0
2017-01-04 08:50:00	AAPL	Stock	29.0075	29.0125	29.0075	29.0125	3712.0
2017-01-04 08:55:00	AAPL	Stock	29.0	29.0	28.9525	28.9525	26120.0
2017-01-04 09:00:00	AAPL	Stock	28.975	28.975	28.975	28.975	4000.0
2017-01-04 09:05:00	AAPL	Stock	28.9625	28.975	28.955	28.955	13540.0
2017-01-04 09:10:00	AAPL	Stock	28.955	28.9625	28.95	28.9625	48964.0
2017-01-04 09:15:00	AAPL	Stock	28.9625	28.9875	28.9625	28.985	40464.0
2017-01-04 09:20:00	AAPL	Stock	28.9875	28.9875	28.965	28.965	18272.0
2017-01-04 09:25:00	AAPL	Stock	28.96	29.0225	28.9225	28.97	153384.0
2017-01-04 09:30:00	AAPL	Stock	28.965	29.1025	28.9375	29.0975	4784176.0
2017-01-04 09:35:00	AAPL	Stock	29.0962	29.1	29.0575	29.06	2602396.0
2017-01-04 09:40:00	AAPL	Stock	29.06	29.1275	29.0302	29.06	2711368.0
2017-01-04 09:45:00	AAPL	Stock	29.06	29.11	29.0575	29.085	1358068.0
2017-01-04 09:50:00	AAPL	Stock	29.085	29.1162	29.0725	29.095	1668340.0
2017-01-04 09:55:00	AAPL	Stock	29.095	29.1048	29.0625	29.0675	1159548.0
2017-01-04 10:00:00	AAPL	Stock	29.0698	29.1	29.065	29.0962	1280560.0
2017-01-04 10:05:00	AAPL	Stock	29.095	29.0975	29.065	29.0825	1011624.0
2017-01-04 10:10:00	AAPL	Stock	29.0825	29.0825	29.04	29.0525	1283508.0
2017-01-04 10:15:00	AAPL	Stock	29.055	29.0575	29.03	29.0475	835524.0
2017-01-04 10:20:00	AAPL	Stock	29.05	29.0525	29.0125	29.0335	910020.0
2017-01-04 10:25:00	AAPL	Stock	29.0325	29.0525	29.02	29.0225	814880.0
2017-01-04 10:30:00	AAPL	Stock	29.0225	29.0362	28.9675	28.9765	1653856.0
2017-01-04 10:35:00	AAPL	Stock	28.9775	29.0025	28.975	28.9825	953128.0
2017-01-04 10:40:00	AAPL	Stock	28.9825	29.0188	28.9825	28.9975	854436.0
2017-01-04 10:45:00	AAPL	Stock	29.0	29.0275	28.9775	29.0028	1004928.0

> showing 50 of 367,837 rows — these rows as CSV

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