PREVIEW / stock_5min / 2014-02-20

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-02-20.parquet
  size:    5.4 MB
  rows:    356,706
  symbols: 3,551

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-02-20 04:00:00	AAPL	Stock	19.1068	19.1068	19.1068	19.1068	5600.0
2014-02-20 04:05:00	AAPL	Stock	19.1139	19.1139	19.1139	19.1139	11200.0
2014-02-20 04:20:00	AAPL	Stock	19.1214	19.1214	19.1214	19.1214	2800.0
2014-02-20 04:30:00	AAPL	Stock	19.1118	19.1118	19.1082	19.1082	5600.0
2014-02-20 04:35:00	AAPL	Stock	19.1275	19.1275	19.1275	19.1275	8400.0
2014-02-20 04:55:00	AAPL	Stock	19.1336	19.1518	19.1336	19.1518	19600.0
2014-02-20 05:30:00	AAPL	Stock	19.14	19.14	19.14	19.14	2800.0
2014-02-20 06:00:00	AAPL	Stock	19.125	19.125	19.0536	19.0536	47600.0
2014-02-20 06:05:00	AAPL	Stock	19.0571	19.0571	19.0182	19.0182	74872.0
2014-02-20 06:10:00	AAPL	Stock	19.0179	19.0179	18.9957	18.9971	83972.0
2014-02-20 06:15:00	AAPL	Stock	19.0089	19.0089	18.965	18.965	60032.0
2014-02-20 06:20:00	AAPL	Stock	18.975	18.9757	18.9643	18.9643	43484.0
2014-02-20 06:25:00	AAPL	Stock	18.9639	18.9643	18.9532	18.9532	15120.0
2014-02-20 06:30:00	AAPL	Stock	18.9557	18.9661	18.9557	18.9636	36960.0
2014-02-20 06:35:00	AAPL	Stock	18.9764	18.9764	18.9764	18.9764	5600.0
2014-02-20 06:40:00	AAPL	Stock	18.9982	19.0	18.9982	19.0	16940.0
2014-02-20 06:45:00	AAPL	Stock	19.0179	19.0179	19.0179	19.0179	11200.0
2014-02-20 06:50:00	AAPL	Stock	19.0179	19.0282	19.0179	19.0179	40600.0
2014-02-20 06:55:00	AAPL	Stock	19.025	19.025	19.0089	19.0129	15400.0
2014-02-20 07:00:00	AAPL	Stock	19.0129	19.0179	19.0089	19.0089	26600.0
2014-02-20 07:05:00	AAPL	Stock	19.0014	19.0014	18.9664	18.9821	141232.0
2014-02-20 07:10:00	AAPL	Stock	18.9821	19.0	18.9786	19.0	200704.0
2014-02-20 07:15:00	AAPL	Stock	19.0	19.0357	19.0	19.0157	121912.0
2014-02-20 07:20:00	AAPL	Stock	19.0089	19.0089	19.0	19.0089	19040.0
2014-02-20 07:25:00	AAPL	Stock	19.0089	19.0089	18.9821	19.0	174188.0
2014-02-20 07:30:00	AAPL	Stock	19.0171	19.0171	19.0089	19.0089	33600.0
2014-02-20 07:35:00	AAPL	Stock	19.0043	19.0107	19.0025	19.0107	117264.0
2014-02-20 07:40:00	AAPL	Stock	19.0086	19.0086	19.0	19.0	71456.0
2014-02-20 07:45:00	AAPL	Stock	19.0171	19.0171	18.9993	19.0107	155960.0
2014-02-20 07:50:00	AAPL	Stock	19.0107	19.0107	19.0	19.0	230720.0
2014-02-20 07:55:00	AAPL	Stock	19.0018	19.0018	18.9911	18.9911	27636.0
2014-02-20 08:00:00	AAPL	Stock	19.0086	19.0361	18.9821	19.0354	287168.0
2014-02-20 08:05:00	AAPL	Stock	19.0286	19.0661	19.0286	19.0525	281344.0
2014-02-20 08:10:00	AAPL	Stock	19.0411	19.0536	19.0411	19.0425	11200.0
2014-02-20 08:15:00	AAPL	Stock	19.0457	19.0457	19.0357	19.0357	57484.0
2014-02-20 08:20:00	AAPL	Stock	19.0343	19.0357	19.0321	19.0357	15400.0
2014-02-20 08:25:00	AAPL	Stock	19.0254	19.0375	19.0246	19.0375	112448.0
2014-02-20 08:30:00	AAPL	Stock	19.0396	19.0482	19.0339	19.0482	115080.0
2014-02-20 08:35:00	AAPL	Stock	19.0482	19.0532	19.0357	19.0357	174328.0
2014-02-20 08:40:00	AAPL	Stock	19.0364	19.0414	19.0304	19.0321	226128.0
2014-02-20 08:45:00	AAPL	Stock	19.0325	19.0382	19.0321	19.0321	228116.0
2014-02-20 08:50:00	AAPL	Stock	19.0321	19.0329	19.0236	19.0268	241752.0
2014-02-20 08:55:00	AAPL	Stock	19.0296	19.0532	19.0296	19.0446	78372.0
2014-02-20 09:00:00	AAPL	Stock	19.0532	19.0782	19.0446	19.0646	161924.0
2014-02-20 09:05:00	AAPL	Stock	19.0693	19.0775	19.0604	19.0679	188720.0
2014-02-20 09:10:00	AAPL	Stock	19.0725	19.0725	19.06	19.0679	59360.0
2014-02-20 09:15:00	AAPL	Stock	19.0629	19.0714	19.0568	19.0589	153776.0
2014-02-20 09:20:00	AAPL	Stock	19.0696	19.0718	19.0646	19.0661	158312.0
2014-02-20 09:25:00	AAPL	Stock	19.0639	19.0807	19.0236	19.0239	543144.0
2014-02-20 09:30:00	AAPL	Stock	19.0354	19.1786	19.0107	19.1429	14832608.0

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

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