PREVIEW / stock_5min / 2017-09-25

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-09-25.parquet
  size:    5.4 MB
  rows:    350,630
  symbols: 2,970

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-09-25 04:00:00	AAPL	Stock	37.7475	37.7475	37.7475	37.7475	800.0
2017-09-25 04:05:00	AAPL	Stock	37.7025	37.7025	37.7025	37.7025	400.0
2017-09-25 04:20:00	AAPL	Stock	37.76	37.76	37.76	37.76	1600.0
2017-09-25 04:25:00	AAPL	Stock	37.785	37.785	37.785	37.785	600.0
2017-09-25 04:35:00	AAPL	Stock	37.75	37.75	37.75	37.75	400.0
2017-09-25 05:15:00	AAPL	Stock	37.8	37.8	37.8	37.8	400.0
2017-09-25 05:45:00	AAPL	Stock	37.7625	37.7625	37.75	37.75	3620.0
2017-09-25 05:50:00	AAPL	Stock	37.725	37.75	37.725	37.7325	2000.0
2017-09-25 05:55:00	AAPL	Stock	37.75	37.75	37.75	37.75	516.0
2017-09-25 06:00:00	AAPL	Stock	37.725	37.725	37.4125	37.5125	26352.0
2017-09-25 06:05:00	AAPL	Stock	37.6225	37.6675	37.5875	37.5875	23156.0
2017-09-25 06:10:00	AAPL	Stock	37.625	37.625	37.6225	37.6225	1600.0
2017-09-25 06:15:00	AAPL	Stock	37.625	37.6375	37.625	37.625	8400.0
2017-09-25 06:20:00	AAPL	Stock	37.6275	37.675	37.575	37.575	17428.0
2017-09-25 06:30:00	AAPL	Stock	37.6	37.6	37.575	37.5875	3140.0
2017-09-25 06:35:00	AAPL	Stock	37.65	37.65	37.65	37.65	3200.0
2017-09-25 06:40:00	AAPL	Stock	37.65	37.65	37.65	37.65	6400.0
2017-09-25 06:55:00	AAPL	Stock	37.6425	37.6625	37.6425	37.6525	1604.0
2017-09-25 07:00:00	AAPL	Stock	37.6725	37.7575	37.67	37.7	28392.0
2017-09-25 07:05:00	AAPL	Stock	37.695	37.78	37.695	37.7775	20800.0
2017-09-25 07:10:00	AAPL	Stock	37.775	37.775	37.7375	37.7375	19600.0
2017-09-25 07:15:00	AAPL	Stock	37.7475	37.75	37.705	37.725	10800.0
2017-09-25 07:20:00	AAPL	Stock	37.745	37.745	37.7175	37.725	8240.0
2017-09-25 07:25:00	AAPL	Stock	37.6925	37.6925	37.66	37.675	17948.0
2017-09-25 07:30:00	AAPL	Stock	37.6975	37.7125	37.6425	37.6625	34228.0
2017-09-25 07:35:00	AAPL	Stock	37.67	37.7325	37.67	37.7325	19872.0
2017-09-25 07:40:00	AAPL	Stock	37.7125	37.7125	37.655	37.655	12852.0
2017-09-25 07:45:00	AAPL	Stock	37.645	37.665	37.6375	37.6625	37624.0
2017-09-25 07:50:00	AAPL	Stock	37.6625	37.6625	37.6575	37.6575	4840.0
2017-09-25 07:55:00	AAPL	Stock	37.6575	37.66	37.63	37.6425	12348.0
2017-09-25 08:00:00	AAPL	Stock	37.5	38.05	37.5	37.5925	96772.0
2017-09-25 08:05:00	AAPL	Stock	37.595	37.65	37.5875	37.5875	47680.0
2017-09-25 08:10:00	AAPL	Stock	37.5825	37.6175	37.55	37.575	73860.0
2017-09-25 08:15:00	AAPL	Stock	37.57	37.57	37.5125	37.525	118376.0
2017-09-25 08:20:00	AAPL	Stock	37.52	37.525	37.49	37.49	285264.0
2017-09-25 08:25:00	AAPL	Stock	37.4925	37.5125	37.4775	37.4975	103164.0
2017-09-25 08:30:00	AAPL	Stock	37.49	37.5275	37.4775	37.5	79088.0
2017-09-25 08:35:00	AAPL	Stock	37.4975	37.565	37.4975	37.5475	88684.0
2017-09-25 08:40:00	AAPL	Stock	37.5475	37.56	37.52	37.5375	54624.0
2017-09-25 08:45:00	AAPL	Stock	37.5275	37.535	37.495	37.515	92816.0
2017-09-25 08:50:00	AAPL	Stock	37.515	37.515	37.4775	37.49	127272.0
2017-09-25 08:55:00	AAPL	Stock	37.4975	37.5	37.4925	37.4925	101940.0
2017-09-25 09:00:00	AAPL	Stock	37.4925	37.5	37.465	37.465	267224.0
2017-09-25 09:05:00	AAPL	Stock	37.475	37.4875	37.435	37.4525	156596.0
2017-09-25 09:10:00	AAPL	Stock	37.455	37.4625	37.425	37.46	132132.0
2017-09-25 09:15:00	AAPL	Stock	37.46	37.4625	37.425	37.43	144884.0
2017-09-25 09:20:00	AAPL	Stock	37.445	37.5275	37.4425	37.5175	329080.0
2017-09-25 09:25:00	AAPL	Stock	37.5125	37.52	37.475	37.495	397172.0
2017-09-25 09:30:00	AAPL	Stock	37.495	37.52	37.29	37.4475	14262652.0
2017-09-25 09:35:00	AAPL	Stock	37.46	37.6	37.375	37.57	6849652.0

> showing 50 of 350,630 rows — these rows as CSV

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