PREVIEW / stock_5min / 2017-10-03

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-10-03.parquet
  size:    5.5 MB
  rows:    358,519
  symbols: 2,977

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-10-03 04:00:00	AAPL	Stock	38.4425	38.4425	38.4425	38.4425	3200.0
2017-10-03 05:50:00	AAPL	Stock	38.4625	38.4625	38.4625	38.4625	400.0
2017-10-03 07:15:00	AAPL	Stock	38.4625	38.4625	38.4625	38.4625	1600.0
2017-10-03 07:25:00	AAPL	Stock	38.4575	38.4625	38.4375	38.4625	45132.0
2017-10-03 07:30:00	AAPL	Stock	38.45	38.45	38.4425	38.4425	4400.0
2017-10-03 07:35:00	AAPL	Stock	38.4425	38.4425	38.4425	38.4425	2400.0
2017-10-03 07:55:00	AAPL	Stock	38.445	38.445	38.445	38.445	1200.0
2017-10-03 08:00:00	AAPL	Stock	38.4425	38.4875	38.44	38.4875	24400.0
2017-10-03 08:05:00	AAPL	Stock	38.4925	38.4925	38.48	38.485	13200.0
2017-10-03 08:10:00	AAPL	Stock	38.4875	38.4875	38.4875	38.4875	800.0
2017-10-03 08:15:00	AAPL	Stock	38.495	38.505	38.4925	38.5	11532.0
2017-10-03 08:20:00	AAPL	Stock	38.5	38.5	38.4875	38.49	5800.0
2017-10-03 08:25:00	AAPL	Stock	38.4825	38.49	38.4825	38.49	1400.0
2017-10-03 08:30:00	AAPL	Stock	38.4925	38.4925	38.48	38.4875	3600.0
2017-10-03 08:35:00	AAPL	Stock	38.48	38.4875	38.475	38.475	9548.0
2017-10-03 08:40:00	AAPL	Stock	38.475	38.4875	38.4525	38.4525	7680.0
2017-10-03 08:45:00	AAPL	Stock	38.475	38.4875	38.475	38.4875	3600.0
2017-10-03 08:50:00	AAPL	Stock	38.455	38.455	38.455	38.455	2000.0
2017-10-03 08:55:00	AAPL	Stock	38.4625	38.4725	38.4625	38.4725	8820.0
2017-10-03 09:00:00	AAPL	Stock	38.47	38.485	38.47	38.485	18448.0
2017-10-03 09:05:00	AAPL	Stock	38.485	38.485	38.48	38.48	5200.0
2017-10-03 09:10:00	AAPL	Stock	38.48	38.485	38.4775	38.485	3964.0
2017-10-03 09:15:00	AAPL	Stock	38.4875	38.49	38.4775	38.4775	9848.0
2017-10-03 09:20:00	AAPL	Stock	38.4775	38.49	38.4775	38.49	4800.0
2017-10-03 09:25:00	AAPL	Stock	38.49	38.5025	38.465	38.5	32684.0
2017-10-03 09:30:00	AAPL	Stock	38.4825	38.6458	38.4775	38.6375	3453360.0
2017-10-03 09:35:00	AAPL	Stock	38.6392	38.755	38.62	38.6825	2704668.0
2017-10-03 09:40:00	AAPL	Stock	38.685	38.7	38.58	38.6142	1648432.0
2017-10-03 09:45:00	AAPL	Stock	38.6175	38.6825	38.5975	38.675	1345292.0
2017-10-03 09:50:00	AAPL	Stock	38.6775	38.69	38.5925	38.595	1379400.0
2017-10-03 09:55:00	AAPL	Stock	38.5925	38.6525	38.565	38.578	949096.0
2017-10-03 10:00:00	AAPL	Stock	38.5795	38.65	38.5752	38.6375	932336.0
2017-10-03 10:05:00	AAPL	Stock	38.6375	38.6425	38.5952	38.6025	723972.0
2017-10-03 10:10:00	AAPL	Stock	38.6038	38.62	38.5088	38.525	1658716.0
2017-10-03 10:15:00	AAPL	Stock	38.5225	38.56	38.5165	38.56	1265756.0
2017-10-03 10:20:00	AAPL	Stock	38.5625	38.61	38.545	38.585	631680.0
2017-10-03 10:25:00	AAPL	Stock	38.5835	38.5835	38.515	38.54	711132.0
2017-10-03 10:30:00	AAPL	Stock	38.548	38.61	38.54	38.5915	583368.0
2017-10-03 10:35:00	AAPL	Stock	38.5925	38.6035	38.57	38.59	475548.0
2017-10-03 10:40:00	AAPL	Stock	38.5975	38.6002	38.5625	38.5625	421464.0
2017-10-03 10:45:00	AAPL	Stock	38.5628	38.5925	38.5575	38.585	462140.0
2017-10-03 10:50:00	AAPL	Stock	38.5862	38.595	38.555	38.58	479256.0
2017-10-03 10:55:00	AAPL	Stock	38.58	38.65	38.58	38.6028	1035020.0
2017-10-03 11:00:00	AAPL	Stock	38.6	38.6475	38.5825	38.635	704204.0
2017-10-03 11:05:00	AAPL	Stock	38.6325	38.65	38.6075	38.6287	552728.0
2017-10-03 11:10:00	AAPL	Stock	38.63	38.6575	38.6025	38.65	542068.0
2017-10-03 11:15:00	AAPL	Stock	38.6475	38.6555	38.62	38.6425	460980.0
2017-10-03 11:20:00	AAPL	Stock	38.6412	38.6625	38.63	38.66	649372.0
2017-10-03 11:25:00	AAPL	Stock	38.66	38.6625	38.641	38.6525	472600.0
2017-10-03 11:30:00	AAPL	Stock	38.652	38.6675	38.645	38.655	452960.0

> showing 50 of 358,519 rows — these rows as CSV

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