PREVIEW / stock_5min / 2017-01-26

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-01-26.parquet
  size:    5.4 MB
  rows:    350,330
  symbols: 3,124

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-26 04:00:00	AAPL	Stock	30.5	30.5	30.5	30.5	400.0
2017-01-26 04:35:00	AAPL	Stock	30.515	30.515	30.515	30.515	784.0
2017-01-26 05:10:00	AAPL	Stock	30.52	30.52	30.52	30.52	460.0
2017-01-26 06:05:00	AAPL	Stock	30.5025	30.5025	30.5025	30.5025	720.0
2017-01-26 06:20:00	AAPL	Stock	30.4825	30.4825	30.4825	30.4825	656.0
2017-01-26 06:40:00	AAPL	Stock	30.4825	30.495	30.4825	30.495	1200.0
2017-01-26 06:45:00	AAPL	Stock	30.4825	30.4825	30.4825	30.4825	1288.0
2017-01-26 07:05:00	AAPL	Stock	30.4925	30.4925	30.4875	30.4875	2000.0
2017-01-26 07:10:00	AAPL	Stock	30.4875	30.4875	30.4875	30.4875	440.0
2017-01-26 07:25:00	AAPL	Stock	30.495	30.495	30.495	30.495	892.0
2017-01-26 07:30:00	AAPL	Stock	30.5	30.5	30.5	30.5	400.0
2017-01-26 07:35:00	AAPL	Stock	30.5	30.5	30.5	30.5	2000.0
2017-01-26 07:45:00	AAPL	Stock	30.5	30.5	30.5	30.5	400.0
2017-01-26 07:50:00	AAPL	Stock	30.5	30.5	30.495	30.495	2560.0
2017-01-26 07:55:00	AAPL	Stock	30.485	30.485	30.4575	30.4575	3600.0
2017-01-26 08:00:00	AAPL	Stock	30.495	30.51	30.4	30.465	34704.0
2017-01-26 08:05:00	AAPL	Stock	30.4625	30.4625	30.445	30.4575	4600.0
2017-01-26 08:10:00	AAPL	Stock	30.46	30.46	30.45	30.45	3488.0
2017-01-26 08:15:00	AAPL	Stock	30.4525	30.4525	30.4525	30.4525	512.0
2017-01-26 08:20:00	AAPL	Stock	30.45	30.45	30.4425	30.4425	4744.0
2017-01-26 08:25:00	AAPL	Stock	30.4425	30.445	30.44	30.445	3600.0
2017-01-26 08:30:00	AAPL	Stock	30.4375	30.4375	30.415	30.415	6880.0
2017-01-26 08:35:00	AAPL	Stock	30.425	30.4375	30.425	30.435	9300.0
2017-01-26 08:40:00	AAPL	Stock	30.4325	30.4325	30.4275	30.4275	4800.0
2017-01-26 08:45:00	AAPL	Stock	30.435	30.4375	30.435	30.4375	14848.0
2017-01-26 08:50:00	AAPL	Stock	30.445	30.45	30.445	30.45	3600.0
2017-01-26 08:55:00	AAPL	Stock	30.4475	30.45	30.4475	30.45	9600.0
2017-01-26 09:00:00	AAPL	Stock	30.45	30.4625	30.45	30.4575	11468.0
2017-01-26 09:05:00	AAPL	Stock	30.455	30.455	30.445	30.445	52628.0
2017-01-26 09:10:00	AAPL	Stock	30.45	30.45	30.425	30.425	10656.0
2017-01-26 09:15:00	AAPL	Stock	30.44	30.4475	30.415	30.4475	12180.0
2017-01-26 09:20:00	AAPL	Stock	30.43	30.4475	30.4275	30.4375	16032.0
2017-01-26 09:25:00	AAPL	Stock	30.4475	30.4475	30.415	30.425	33952.0
2017-01-26 09:30:00	AAPL	Stock	30.4425	30.61	30.4175	30.555	5907372.0
2017-01-26 09:35:00	AAPL	Stock	30.5575	30.58	30.51	30.555	2106748.0
2017-01-26 09:40:00	AAPL	Stock	30.555	30.5558	30.4825	30.51	2096084.0
2017-01-26 09:45:00	AAPL	Stock	30.51	30.525	30.455	30.5025	1891672.0
2017-01-26 09:50:00	AAPL	Stock	30.5025	30.53	30.4975	30.5208	1318944.0
2017-01-26 09:55:00	AAPL	Stock	30.5188	30.5225	30.496	30.5062	1421400.0
2017-01-26 10:00:00	AAPL	Stock	30.5075	30.51	30.475	30.4925	1239592.0
2017-01-26 10:05:00	AAPL	Stock	30.4912	30.5125	30.48	30.5125	984948.0
2017-01-26 10:10:00	AAPL	Stock	30.511	30.53	30.495	30.515	998516.0
2017-01-26 10:15:00	AAPL	Stock	30.515	30.515	30.465	30.48	1060224.0
2017-01-26 10:20:00	AAPL	Stock	30.48	30.485	30.4325	30.4388	1672212.0
2017-01-26 10:25:00	AAPL	Stock	30.4375	30.439	30.4125	30.4255	1891208.0
2017-01-26 10:30:00	AAPL	Stock	30.425	30.465	30.425	30.45	1213576.0
2017-01-26 10:35:00	AAPL	Stock	30.4525	30.4625	30.4325	30.46	853580.0
2017-01-26 10:40:00	AAPL	Stock	30.4625	30.475	30.43	30.46	1297388.0
2017-01-26 10:45:00	AAPL	Stock	30.46	30.47	30.4525	30.4625	456888.0
2017-01-26 10:50:00	AAPL	Stock	30.4638	30.4775	30.4625	30.4715	619416.0

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

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