PREVIEW / stock_5min / 2014-11-03

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-11-03.parquet
  size:    5.5 MB
  rows:    367,257
  symbols: 3,559

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
2014-11-03 04:05:00	AAPL	Stock	27.0	27.0	27.0	27.0	18000.0
2014-11-03 04:20:00	AAPL	Stock	26.99	26.99	26.99	26.99	436.0
2014-11-03 04:25:00	AAPL	Stock	26.9625	26.9625	26.96	26.96	4312.0
2014-11-03 04:30:00	AAPL	Stock	26.9675	26.9675	26.9675	26.9675	4800.0
2014-11-03 04:40:00	AAPL	Stock	26.965	26.965	26.965	26.965	560.0
2014-11-03 04:45:00	AAPL	Stock	26.965	26.965	26.9475	26.9475	4000.0
2014-11-03 04:50:00	AAPL	Stock	26.9375	26.9375	26.9375	26.9375	2000.0
2014-11-03 05:10:00	AAPL	Stock	26.975	26.975	26.975	26.975	572.0
2014-11-03 05:15:00	AAPL	Stock	26.975	26.98	26.975	26.98	2000.0
2014-11-03 05:30:00	AAPL	Stock	26.99	26.995	26.9775	26.9775	9520.0
2014-11-03 06:10:00	AAPL	Stock	26.9875	26.9875	26.9875	26.9875	2000.0
2014-11-03 06:25:00	AAPL	Stock	26.9975	27.0	26.9975	27.0	3600.0
2014-11-03 06:30:00	AAPL	Stock	27.025	27.025	27.0	27.0	5804.0
2014-11-03 06:35:00	AAPL	Stock	27.0	27.0	26.98	26.98	7276.0
2014-11-03 06:40:00	AAPL	Stock	26.97	26.97	26.97	26.97	1200.0
2014-11-03 06:45:00	AAPL	Stock	26.975	26.985	26.9725	26.985	6748.0
2014-11-03 06:55:00	AAPL	Stock	26.9775	26.9775	26.975	26.975	5612.0
2014-11-03 07:00:00	AAPL	Stock	26.985	26.985	26.975	26.985	2000.0
2014-11-03 07:05:00	AAPL	Stock	26.9825	26.985	26.9775	26.9825	10704.0
2014-11-03 07:10:00	AAPL	Stock	26.9875	26.9875	26.9825	26.985	9200.0
2014-11-03 07:15:00	AAPL	Stock	26.9825	26.9875	26.975	26.975	8592.0
2014-11-03 07:20:00	AAPL	Stock	26.975	26.975	26.965	26.965	14400.0
2014-11-03 07:25:00	AAPL	Stock	26.975	26.975	26.975	26.975	400.0
2014-11-03 07:30:00	AAPL	Stock	26.975	26.975	26.9625	26.9725	6580.0
2014-11-03 07:35:00	AAPL	Stock	26.9675	26.9775	26.965	26.975	17200.0
2014-11-03 07:45:00	AAPL	Stock	26.975	26.9875	26.975	26.9875	25124.0
2014-11-03 07:50:00	AAPL	Stock	26.9775	26.9825	26.975	26.9825	18728.0
2014-11-03 07:55:00	AAPL	Stock	26.9925	26.9925	26.9925	26.9925	15576.0
2014-11-03 08:00:00	AAPL	Stock	26.9925	27.01	26.9625	27.01	113544.0
2014-11-03 08:05:00	AAPL	Stock	27.0175	27.025	27.005	27.005	21032.0
2014-11-03 08:10:00	AAPL	Stock	27.0025	27.005	27.0	27.0	21600.0
2014-11-03 08:15:00	AAPL	Stock	27.0025	27.0125	27.0	27.0125	31952.0
2014-11-03 08:20:00	AAPL	Stock	27.0075	27.025	27.005	27.025	22700.0
2014-11-03 08:25:00	AAPL	Stock	27.025	27.035	27.015	27.035	27688.0
2014-11-03 08:30:00	AAPL	Stock	27.0375	27.0425	27.0125	27.0425	61872.0
2014-11-03 08:35:00	AAPL	Stock	27.025	27.0375	27.025	27.03	28080.0
2014-11-03 08:40:00	AAPL	Stock	27.0325	27.05	27.0325	27.0425	40232.0
2014-11-03 08:45:00	AAPL	Stock	27.0425	27.0625	27.0375	27.05	59456.0
2014-11-03 08:50:00	AAPL	Stock	27.0575	27.07	27.0525	27.07	34268.0
2014-11-03 08:55:00	AAPL	Stock	27.0725	27.095	27.0675	27.0675	115784.0
2014-11-03 09:00:00	AAPL	Stock	27.0675	27.0875	27.0675	27.075	38764.0
2014-11-03 09:05:00	AAPL	Stock	27.075	27.0925	27.07	27.0925	60444.0
2014-11-03 09:10:00	AAPL	Stock	27.0925	27.1075	27.08	27.1075	931412.0
2014-11-03 09:15:00	AAPL	Stock	27.1025	27.105	27.08	27.09	23368.0
2014-11-03 09:20:00	AAPL	Stock	27.09	27.11	27.08	27.08	78120.0
2014-11-03 09:25:00	AAPL	Stock	27.0875	27.09	27.04	27.055	99828.0
2014-11-03 09:30:00	AAPL	Stock	27.055	27.105	27.0025	27.0912	8545804.0
2014-11-03 09:35:00	AAPL	Stock	27.0925	27.1725	27.0888	27.17	5765444.0
2014-11-03 09:40:00	AAPL	Stock	27.17	27.2	27.15	27.2	4835648.0
2014-11-03 09:45:00	AAPL	Stock	27.2	27.23	27.18	27.225	3560780.0

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

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