PREVIEW / stock_5min / 2013-08-22

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-08-22.parquet
  size:    4.3 MB
  rows:    280,311
  symbols: 3,505

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
2013-08-22 04:00:00	AAPL	Stock	17.9771	18.0339	17.9771	18.0339	22400.0
2013-08-22 04:05:00	AAPL	Stock	18.0475	18.0475	18.0475	18.0475	4760.0
2013-08-22 04:45:00	AAPL	Stock	18.0	18.0	18.0	18.0	2800.0
2013-08-22 05:15:00	AAPL	Stock	18.0225	18.0225	18.0225	18.0225	2800.0
2013-08-22 05:35:00	AAPL	Stock	18.0321	18.0321	18.0321	18.0321	2800.0
2013-08-22 05:50:00	AAPL	Stock	18.0268	18.0304	18.0268	18.0268	21000.0
2013-08-22 06:30:00	AAPL	Stock	18.0311	18.0311	18.0311	18.0311	2800.0
2013-08-22 06:50:00	AAPL	Stock	18.0318	18.0318	18.0318	18.0318	2800.0
2013-08-22 06:55:00	AAPL	Stock	18.0321	18.0321	18.0321	18.0321	13272.0
2013-08-22 07:00:00	AAPL	Stock	18.0075	18.0075	17.9946	17.9946	47320.0
2013-08-22 07:10:00	AAPL	Stock	18.0	18.0	18.0	18.0	26992.0
2013-08-22 07:15:00	AAPL	Stock	18.0129	18.0268	18.0125	18.0143	63952.0
2013-08-22 07:20:00	AAPL	Stock	18.0071	18.0214	18.0071	18.0214	38640.0
2013-08-22 07:25:00	AAPL	Stock	18.0257	18.0257	18.0214	18.0214	19600.0
2013-08-22 07:30:00	AAPL	Stock	18.0264	18.0307	18.0264	18.0307	5880.0
2013-08-22 07:40:00	AAPL	Stock	18.0282	18.0321	18.0282	18.0321	35560.0
2013-08-22 07:45:00	AAPL	Stock	18.0446	18.0671	18.0446	18.0571	112952.0
2013-08-22 07:50:00	AAPL	Stock	18.0511	18.0511	18.05	18.05	5600.0
2013-08-22 07:55:00	AAPL	Stock	18.05	18.0604	18.05	18.0604	16800.0
2013-08-22 08:00:00	AAPL	Stock	18.0571	18.0571	18.0143	18.0143	275268.0
2013-08-22 08:05:00	AAPL	Stock	18.0143	18.025	17.9846	17.9864	166740.0
2013-08-22 08:10:00	AAPL	Stock	18.0007	18.0107	18.0	18.0	56392.0
2013-08-22 08:15:00	AAPL	Stock	17.9936	18.0157	17.9936	18.0071	117320.0
2013-08-22 08:20:00	AAPL	Stock	18.0071	18.0104	18.0036	18.01	81480.0
2013-08-22 08:25:00	AAPL	Stock	18.0036	18.0043	17.9893	18.0014	117824.0
2013-08-22 08:30:00	AAPL	Stock	18.0036	18.0068	17.9986	18.0068	97272.0
2013-08-22 08:35:00	AAPL	Stock	18.0086	18.0171	18.0061	18.0164	60900.0
2013-08-22 08:40:00	AAPL	Stock	18.0143	18.0307	18.0143	18.0307	66892.0
2013-08-22 08:45:00	AAPL	Stock	18.025	18.0425	18.0232	18.0236	102592.0
2013-08-22 08:50:00	AAPL	Stock	18.0214	18.0439	18.0214	18.0393	107212.0
2013-08-22 08:55:00	AAPL	Stock	18.0393	18.0493	18.0368	18.0493	159460.0
2013-08-22 09:00:00	AAPL	Stock	18.0482	18.0493	18.0429	18.0475	150612.0
2013-08-22 09:05:00	AAPL	Stock	18.0479	18.0482	18.0357	18.0418	211680.0
2013-08-22 09:10:00	AAPL	Stock	18.0375	18.0479	18.0325	18.0479	162120.0
2013-08-22 09:15:00	AAPL	Stock	18.0464	18.0464	18.0357	18.0357	119756.0
2013-08-22 09:20:00	AAPL	Stock	18.0357	18.0357	18.0214	18.0321	138572.0
2013-08-22 09:25:00	AAPL	Stock	18.0264	18.0357	18.0179	18.0354	414344.0
2013-08-22 09:30:00	AAPL	Stock	18.03	18.0429	17.9571	18.0068	11775596.0
2013-08-22 09:35:00	AAPL	Stock	18.0067	18.0568	18.0	18.0071	8795528.0
2013-08-22 09:40:00	AAPL	Stock	18.0071	18.0121	17.9598	17.9718	9659188.0
2013-08-22 09:45:00	AAPL	Stock	17.9771	18.0032	17.9718	17.9736	5430124.0
2013-08-22 09:50:00	AAPL	Stock	17.9786	17.9807	17.9089	17.9419	11702712.0
2013-08-22 09:55:00	AAPL	Stock	17.9382	17.9786	17.8982	17.9296	7559188.0
2013-08-22 10:00:00	AAPL	Stock	17.9296	17.9415	17.8889	17.9218	7985712.0
2013-08-22 10:05:00	AAPL	Stock	17.9239	17.9546	17.9239	17.9339	6553820.0
2013-08-22 10:10:00	AAPL	Stock	17.9346	17.9621	17.9168	17.9425	6473880.0
2013-08-22 10:15:00	AAPL	Stock	17.9411	17.9739	17.9321	17.9605	4504248.0
2013-08-22 10:20:00	AAPL	Stock	17.9643	17.9686	17.9493	17.965	2500428.0
2013-08-22 10:25:00	AAPL	Stock	17.9654	17.9654	17.9304	17.9307	2456944.0
2013-08-22 10:30:00	AAPL	Stock	17.9343	17.9461	17.9307	17.9314	1467536.0

> showing 50 of 280,311 rows — these rows as CSV

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