PREVIEW / stock_5min / 2013-04-19

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-04-19.parquet
  size:    4.9 MB
  rows:    325,788
  symbols: 3,473

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-04-19 04:10:00	AAPL	Stock	14.0264	14.0264	14.0264	14.0264	11200.0
2013-04-19 04:15:00	AAPL	Stock	14.0268	14.0268	14.0264	14.0264	14000.0
2013-04-19 04:20:00	AAPL	Stock	14.0268	14.0268	14.0268	14.0268	2800.0
2013-04-19 04:50:00	AAPL	Stock	14.0496	14.0536	14.0496	14.0536	8400.0
2013-04-19 05:05:00	AAPL	Stock	14.0557	14.0557	14.0557	14.0557	2800.0
2013-04-19 05:30:00	AAPL	Stock	14.0536	14.0536	14.0486	14.0486	23296.0
2013-04-19 05:45:00	AAPL	Stock	14.0679	14.0679	14.0679	14.0679	2800.0
2013-04-19 06:00:00	AAPL	Stock	14.0779	14.0779	14.0779	14.0779	2800.0
2013-04-19 06:15:00	AAPL	Stock	14.0779	14.0779	14.0779	14.0779	2800.0
2013-04-19 06:20:00	AAPL	Stock	14.0786	14.0786	14.0786	14.0786	5600.0
2013-04-19 06:30:00	AAPL	Stock	14.0632	14.0632	14.0486	14.0486	27244.0
2013-04-19 06:45:00	AAPL	Stock	14.0796	14.0796	14.0782	14.0796	8764.0
2013-04-19 07:00:00	AAPL	Stock	14.0607	14.0786	14.0536	14.0786	8596.0
2013-04-19 07:05:00	AAPL	Stock	14.0707	14.0707	14.0707	14.0707	2800.0
2013-04-19 07:10:00	AAPL	Stock	14.0696	14.0707	14.0554	14.0614	25200.0
2013-04-19 07:15:00	AAPL	Stock	14.0486	14.0625	14.0486	14.0625	38948.0
2013-04-19 07:20:00	AAPL	Stock	14.0571	14.0714	14.0571	14.0643	18592.0
2013-04-19 07:25:00	AAPL	Stock	14.0714	14.0714	14.0714	14.0714	25732.0
2013-04-19 07:30:00	AAPL	Stock	14.0736	14.0736	14.0529	14.0536	33712.0
2013-04-19 07:35:00	AAPL	Stock	14.0393	14.0714	14.0393	14.0507	61600.0
2013-04-19 07:40:00	AAPL	Stock	14.0543	14.0675	14.0539	14.0607	26600.0
2013-04-19 07:45:00	AAPL	Stock	14.0611	14.0679	14.0589	14.0589	30800.0
2013-04-19 07:50:00	AAPL	Stock	14.0536	14.0571	14.0368	14.045	155400.0
2013-04-19 07:55:00	AAPL	Stock	14.0446	14.0464	14.0361	14.0361	28280.0
2013-04-19 08:00:00	AAPL	Stock	14.0507	14.0714	14.0264	14.0357	252392.0
2013-04-19 08:05:00	AAPL	Stock	14.0357	14.0514	14.0307	14.0357	198520.0
2013-04-19 08:10:00	AAPL	Stock	14.0439	14.05	14.0357	14.0361	71596.0
2013-04-19 08:15:00	AAPL	Stock	14.0293	14.0357	14.0182	14.0182	164080.0
2013-04-19 08:20:00	AAPL	Stock	14.0186	14.0189	13.9829	13.9864	148260.0
2013-04-19 08:25:00	AAPL	Stock	13.9846	13.995	13.9654	13.9907	236684.0
2013-04-19 08:30:00	AAPL	Stock	13.9857	13.9986	13.9857	13.9893	59780.0
2013-04-19 08:35:00	AAPL	Stock	13.9964	13.9964	13.9696	13.9775	274680.0
2013-04-19 08:40:00	AAPL	Stock	13.98	13.9893	13.9718	13.9721	191660.0
2013-04-19 08:45:00	AAPL	Stock	13.9782	13.9782	13.9471	13.9471	380632.0
2013-04-19 08:50:00	AAPL	Stock	13.9493	13.9786	13.9493	13.9786	172480.0
2013-04-19 08:55:00	AAPL	Stock	13.9754	13.9839	13.97	13.9721	167860.0
2013-04-19 09:00:00	AAPL	Stock	13.9725	13.9825	13.9486	13.9621	113260.0
2013-04-19 09:05:00	AAPL	Stock	13.9418	13.9418	13.8964	13.9189	456624.0
2013-04-19 09:10:00	AAPL	Stock	13.92	13.9436	13.9143	13.9186	388276.0
2013-04-19 09:15:00	AAPL	Stock	13.9275	13.9275	13.9179	13.925	79436.0
2013-04-19 09:20:00	AAPL	Stock	13.925	13.9286	13.9154	13.9154	545020.0
2013-04-19 09:25:00	AAPL	Stock	13.9211	13.9357	13.8064	13.8629	2026360.0
2013-04-19 09:30:00	AAPL	Stock	13.8625	13.9764	13.7536	13.9414	54271392.0
2013-04-19 09:35:00	AAPL	Stock	13.9393	13.9436	13.8432	13.8461	13557796.0
2013-04-19 09:40:00	AAPL	Stock	13.8468	13.8675	13.8004	13.8404	23288692.0
2013-04-19 09:45:00	AAPL	Stock	13.8389	13.8496	13.77	13.8067	17432548.0
2013-04-19 09:50:00	AAPL	Stock	13.8029	13.9125	13.7946	13.9025	16726668.0
2013-04-19 09:55:00	AAPL	Stock	13.8977	13.9871	13.8304	13.9857	17317804.0
2013-04-19 10:00:00	AAPL	Stock	13.9854	14.0596	13.9757	14.0071	22762964.0
2013-04-19 10:05:00	AAPL	Stock	14.0086	14.1114	13.9929	14.1011	19197388.0

> showing 50 of 325,788 rows — these rows as CSV

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