PREVIEW / stock_5min / 2015-07-31

all stock 5-min files

  file:    by_date/stock_5min/2015/2015-07-31.parquet
  size:    5.4 MB
  rows:    356,027
  symbols: 3,485

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
2015-07-31 04:00:00	AAPL	Stock	30.615	30.615	30.615	30.615	800.0
2015-07-31 04:45:00	AAPL	Stock	30.655	30.655	30.655	30.655	800.0
2015-07-31 05:05:00	AAPL	Stock	30.6625	30.6625	30.6625	30.6625	800.0
2015-07-31 05:45:00	AAPL	Stock	30.6625	30.67	30.6575	30.67	11800.0
2015-07-31 06:30:00	AAPL	Stock	30.6475	30.6475	30.6475	30.6475	4000.0
2015-07-31 06:45:00	AAPL	Stock	30.615	30.615	30.615	30.615	800.0
2015-07-31 06:50:00	AAPL	Stock	30.615	30.615	30.615	30.615	1200.0
2015-07-31 06:55:00	AAPL	Stock	30.5975	30.5975	30.5975	30.5975	2800.0
2015-07-31 07:00:00	AAPL	Stock	30.5975	30.5975	30.5825	30.5825	800.0
2015-07-31 07:05:00	AAPL	Stock	30.55	30.5625	30.55	30.5625	4740.0
2015-07-31 07:10:00	AAPL	Stock	30.525	30.525	30.51	30.525	40440.0
2015-07-31 07:15:00	AAPL	Stock	30.5375	30.5375	30.5375	30.5375	5600.0
2015-07-31 07:20:00	AAPL	Stock	30.5275	30.535	30.5275	30.535	9560.0
2015-07-31 07:25:00	AAPL	Stock	30.535	30.535	30.5275	30.5275	2000.0
2015-07-31 07:30:00	AAPL	Stock	30.535	30.55	30.535	30.55	12928.0
2015-07-31 07:35:00	AAPL	Stock	30.5375	30.5375	30.5275	30.5375	8000.0
2015-07-31 07:40:00	AAPL	Stock	30.5275	30.55	30.5275	30.55	3916.0
2015-07-31 07:45:00	AAPL	Stock	30.5375	30.5725	30.5375	30.5725	23200.0
2015-07-31 08:00:00	AAPL	Stock	30.5375	30.55	30.53	30.5375	42028.0
2015-07-31 08:05:00	AAPL	Stock	30.5475	30.55	30.5375	30.5375	29592.0
2015-07-31 08:10:00	AAPL	Stock	30.5475	30.55	30.5375	30.5375	22800.0
2015-07-31 08:15:00	AAPL	Stock	30.5375	30.5425	30.5375	30.5382	8660.0
2015-07-31 08:20:00	AAPL	Stock	30.5375	30.5375	30.52	30.52	49980.0
2015-07-31 08:25:00	AAPL	Stock	30.52	30.5225	30.51	30.5225	26732.0
2015-07-31 08:30:00	AAPL	Stock	30.525	30.56	30.525	30.545	52808.0
2015-07-31 08:35:00	AAPL	Stock	30.5358	30.56	30.5325	30.56	36696.0
2015-07-31 08:40:00	AAPL	Stock	30.5625	30.6225	30.5625	30.605	56636.0
2015-07-31 08:45:00	AAPL	Stock	30.6025	30.6075	30.5725	30.5725	22508.0
2015-07-31 08:50:00	AAPL	Stock	30.5725	30.5775	30.57	30.5775	4800.0
2015-07-31 08:55:00	AAPL	Stock	30.5825	30.625	30.5825	30.6225	56856.0
2015-07-31 09:00:00	AAPL	Stock	30.6375	30.65	30.625	30.63	46832.0
2015-07-31 09:05:00	AAPL	Stock	30.63	30.635	30.625	30.6275	17852.0
2015-07-31 09:10:00	AAPL	Stock	30.635	30.645	30.6275	30.635	52240.0
2015-07-31 09:15:00	AAPL	Stock	30.635	30.635	30.6275	30.635	8704.0
2015-07-31 09:20:00	AAPL	Stock	30.6375	30.665	30.6375	30.665	109152.0
2015-07-31 09:25:00	AAPL	Stock	30.67	30.6975	30.625	30.6275	51592.0
2015-07-31 09:30:00	AAPL	Stock	30.65	30.6605	30.4625	30.495	7413460.0
2015-07-31 09:35:00	AAPL	Stock	30.4925	30.5125	30.4375	30.4425	3037352.0
2015-07-31 09:40:00	AAPL	Stock	30.4475	30.465	30.375	30.4225	4574240.0
2015-07-31 09:45:00	AAPL	Stock	30.423	30.475	30.38	30.3975	3077700.0
2015-07-31 09:50:00	AAPL	Stock	30.4	30.445	30.3925	30.4025	2367816.0
2015-07-31 09:55:00	AAPL	Stock	30.405	30.4425	30.3775	30.3862	3095608.0
2015-07-31 10:00:00	AAPL	Stock	30.385	30.405	30.34	30.3412	4519296.0
2015-07-31 10:05:00	AAPL	Stock	30.345	30.375	30.3025	30.375	4532552.0
2015-07-31 10:10:00	AAPL	Stock	30.3725	30.38	30.3275	30.3475	3032080.0
2015-07-31 10:15:00	AAPL	Stock	30.3488	30.36	30.2275	30.2525	5545176.0
2015-07-31 10:20:00	AAPL	Stock	30.2525	30.335	30.2475	30.31	4078284.0
2015-07-31 10:25:00	AAPL	Stock	30.31	30.3375	30.2962	30.3225	2007672.0
2015-07-31 10:30:00	AAPL	Stock	30.325	30.33	30.285	30.2925	2239940.0
2015-07-31 10:35:00	AAPL	Stock	30.2925	30.365	30.285	30.316	2264020.0

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

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