PREVIEW / stock_5min / 2014-03-04

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-03-04.parquet
  size:    5.8 MB
  rows:    386,866
  symbols: 3,547

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-03-04 04:00:00	AAPL	Stock	18.9175	18.9643	18.9175	18.9643	11200.0
2014-03-04 04:15:00	AAPL	Stock	18.9214	18.9214	18.9214	18.9214	5600.0
2014-03-04 05:30:00	AAPL	Stock	18.9586	18.965	18.9586	18.965	15568.0
2014-03-04 05:35:00	AAPL	Stock	18.9707	18.9725	18.9707	18.9725	11200.0
2014-03-04 05:45:00	AAPL	Stock	18.9621	18.9771	18.9621	18.9771	35448.0
2014-03-04 05:50:00	AAPL	Stock	18.9986	18.9993	18.9986	18.9993	5880.0
2014-03-04 05:55:00	AAPL	Stock	19.0107	19.025	19.0107	19.025	37800.0
2014-03-04 06:00:00	AAPL	Stock	19.0357	19.0357	19.0054	19.0054	5600.0
2014-03-04 06:05:00	AAPL	Stock	19.0089	19.0279	19.0	19.0221	58324.0
2014-03-04 06:10:00	AAPL	Stock	19.0357	19.0357	19.0357	19.0357	5600.0
2014-03-04 06:15:00	AAPL	Stock	19.0007	19.0114	19.0	19.0	28000.0
2014-03-04 06:20:00	AAPL	Stock	19.0	19.0	19.0	19.0	2800.0
2014-03-04 06:30:00	AAPL	Stock	19.0143	19.0143	18.9804	19.0	37800.0
2014-03-04 06:35:00	AAPL	Stock	19.0	19.0	18.995	18.995	18200.0
2014-03-04 06:40:00	AAPL	Stock	19.0214	19.0254	19.0196	19.0254	11200.0
2014-03-04 06:45:00	AAPL	Stock	19.0107	19.0107	19.0107	19.0107	11200.0
2014-03-04 06:55:00	AAPL	Stock	19.0046	19.0046	19.0046	19.0046	2800.0
2014-03-04 07:00:00	AAPL	Stock	19.0068	19.0068	19.0068	19.0068	2800.0
2014-03-04 07:05:00	AAPL	Stock	19.0189	19.0307	19.0189	19.0307	35700.0
2014-03-04 07:10:00	AAPL	Stock	19.0236	19.0236	19.0179	19.0179	36400.0
2014-03-04 07:15:00	AAPL	Stock	19.0268	19.0268	19.0179	19.0179	32200.0
2014-03-04 07:20:00	AAPL	Stock	19.0161	19.0214	19.0161	19.0179	25200.0
2014-03-04 07:25:00	AAPL	Stock	19.0168	19.0179	19.0143	19.0168	27104.0
2014-03-04 07:30:00	AAPL	Stock	19.0168	19.0168	19.0161	19.0161	11732.0
2014-03-04 07:35:00	AAPL	Stock	19.0161	19.0161	19.0161	19.0161	25200.0
2014-03-04 07:45:00	AAPL	Stock	19.0054	19.01	19.0	19.0071	42000.0
2014-03-04 07:55:00	AAPL	Stock	19.0036	19.0071	18.995	19.0	42000.0
2014-03-04 08:00:00	AAPL	Stock	19.0036	19.0236	18.9825	18.9843	223860.0
2014-03-04 08:05:00	AAPL	Stock	18.9911	18.9911	18.9679	18.9679	75684.0
2014-03-04 08:10:00	AAPL	Stock	18.9693	18.975	18.9471	18.9471	185276.0
2014-03-04 08:15:00	AAPL	Stock	18.9493	18.9539	18.9429	18.9539	201404.0
2014-03-04 08:20:00	AAPL	Stock	18.955	18.9643	18.955	18.9643	151480.0
2014-03-04 08:25:00	AAPL	Stock	18.9579	18.9646	18.9464	18.9464	113904.0
2014-03-04 08:30:00	AAPL	Stock	18.9471	18.9554	18.9379	18.955	217056.0
2014-03-04 08:35:00	AAPL	Stock	18.9482	18.9546	18.9379	18.9546	116060.0
2014-03-04 08:40:00	AAPL	Stock	18.9554	18.9568	18.9471	18.9557	67200.0
2014-03-04 08:45:00	AAPL	Stock	18.9571	18.9643	18.9561	18.9561	124516.0
2014-03-04 08:50:00	AAPL	Stock	18.9643	18.9718	18.9568	18.9718	50400.0
2014-03-04 08:55:00	AAPL	Stock	18.9718	18.9718	18.9643	18.9718	99400.0
2014-03-04 09:00:00	AAPL	Stock	18.9718	18.9746	18.9718	18.9743	33600.0
2014-03-04 09:05:00	AAPL	Stock	18.965	18.9796	18.965	18.9696	70000.0
2014-03-04 09:10:00	AAPL	Stock	18.9743	18.9743	18.9643	18.9661	47600.0
2014-03-04 09:15:00	AAPL	Stock	18.965	18.9693	18.9589	18.9693	149772.0
2014-03-04 09:20:00	AAPL	Stock	18.97	18.9786	18.9661	18.9711	113204.0
2014-03-04 09:25:00	AAPL	Stock	18.9711	18.975	18.96	18.96	142800.0
2014-03-04 09:30:00	AAPL	Stock	18.9643	19.0229	18.9	18.9554	12208000.0
2014-03-04 09:35:00	AAPL	Stock	18.9554	18.9732	18.9111	18.9457	4556916.0
2014-03-04 09:40:00	AAPL	Stock	18.9554	18.9604	18.9064	18.9262	4406024.0
2014-03-04 09:45:00	AAPL	Stock	18.9286	18.9543	18.9175	18.9347	2365020.0
2014-03-04 09:50:00	AAPL	Stock	18.9364	18.9811	18.9337	18.9584	4212376.0

> showing 50 of 386,866 rows — these rows as CSV

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