PREVIEW / stock_1hour / 2013-09-04

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-09-04.parquet
  size:    1014 KB
  rows:    46,914
  symbols: 3,516

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-09-04 04:00:00	AAPL	Stock	17.4464	17.4464	17.4171	17.4375	48860.0
2013-09-04 05:00:00	AAPL	Stock	17.4332	17.4332	17.4332	17.4332	2800.0
2013-09-04 06:00:00	AAPL	Stock	17.4607	17.6071	17.4125	17.6071	234640.0
2013-09-04 07:00:00	AAPL	Stock	17.6071	17.8532	17.6071	17.8304	3062808.0
2013-09-04 08:00:00	AAPL	Stock	17.8225	17.8568	17.7146	17.8264	6490680.0
2013-09-04 09:00:00	AAPL	Stock	17.825	17.9375	17.7618	17.78	105769328.0
2013-09-04 10:00:00	AAPL	Stock	17.78	17.8654	17.7664	17.8512	59043040.0
2013-09-04 11:00:00	AAPL	Stock	17.8543	17.8571	17.7822	17.8483	28935480.0
2013-09-04 12:00:00	AAPL	Stock	17.8482	17.8518	17.7889	17.83	25123868.0
2013-09-04 13:00:00	AAPL	Stock	17.8296	17.8604	17.7996	17.8314	23517396.0
2013-09-04 14:00:00	AAPL	Stock	17.8296	17.8446	17.8036	17.8255	18552716.0
2013-09-04 15:00:00	AAPL	Stock	17.8239	17.83	17.7243	17.8089	55701772.0
2013-09-04 16:00:00	AAPL	Stock	17.8114	17.8242	17.7821	17.8129	12942440.0
2013-09-04 17:00:00	AAPL	Stock	17.8207	17.8311	17.8129	17.8307	732424.0
2013-09-04 18:00:00	AAPL	Stock	17.8307	17.8464	17.8129	17.8393	366660.0
2013-09-04 19:00:00	AAPL	Stock	17.8421	17.875	17.8368	17.875	467040.0
2013-09-04 04:00:00	MSFT	Stock	31.82	31.82	31.61	31.61	6800.0
2013-09-04 05:00:00	MSFT	Stock	31.75	31.75	31.75	31.75	500.0
2013-09-04 06:00:00	MSFT	Stock	31.7	31.74	31.65	31.68	3974.0
2013-09-04 07:00:00	MSFT	Stock	31.7	31.72	31.65	31.65	28502.0
2013-09-04 08:00:00	MSFT	Stock	31.68	31.7	31.5	31.57	163465.0
2013-09-04 09:00:00	MSFT	Stock	31.56	31.57	31.2	31.32	20051097.0
2013-09-04 10:00:00	MSFT	Stock	31.32	31.34	31.11	31.22	33541812.0
2013-09-04 11:00:00	MSFT	Stock	31.219	31.26	31.13	31.225	17797010.0
2013-09-04 12:00:00	MSFT	Stock	31.225	31.25	31.19	31.235	9313180.0
2013-09-04 13:00:00	MSFT	Stock	31.235	31.27	31.17	31.18	6054485.0
2013-09-04 14:00:00	MSFT	Stock	31.2	31.25	31.17	31.19	14225992.0
2013-09-04 15:00:00	MSFT	Stock	31.19	31.25	31.15	31.18	32958675.0
2013-09-04 16:00:00	MSFT	Stock	31.18	31.25	31.14	31.18	3312186.0
2013-09-04 17:00:00	MSFT	Stock	31.17	31.19	31.15	31.17	189829.0
2013-09-04 18:00:00	MSFT	Stock	31.18	31.19	31.17	31.19	27002.0
2013-09-04 19:00:00	MSFT	Stock	31.18	31.19	31.16	31.16	20009.0
2013-09-04 09:00:00	NVDA	Stock	0.369	0.3735	0.3685	0.3733	21065680.0
2013-09-04 10:00:00	NVDA	Stock	0.3735	0.3743	0.3725	0.3733	29238920.0
2013-09-04 11:00:00	NVDA	Stock	0.3733	0.3748	0.3728	0.374	27315600.0
2013-09-04 12:00:00	NVDA	Stock	0.374	0.3743	0.372	0.3731	20132400.0
2013-09-04 13:00:00	NVDA	Stock	0.3733	0.3743	0.3728	0.3736	23483040.0
2013-09-04 14:00:00	NVDA	Stock	0.3738	0.3743	0.3728	0.3736	24732720.0
2013-09-04 15:00:00	NVDA	Stock	0.3736	0.3738	0.372	0.3725	60896880.0
2013-09-04 16:00:00	NVDA	Stock	0.3728	0.3736	0.3684	0.3728	11857240.0
2013-09-04 18:00:00	NVDA	Stock	0.3728	0.3728	0.3728	0.3728	28000.0
2013-09-04 08:00:00	AMZN	Stock	14.44	14.44	14.44	14.44	250800.0
2013-09-04 09:00:00	AMZN	Stock	14.445	14.569	14.379	14.5395	5744860.0
2013-09-04 10:00:00	AMZN	Stock	14.531	14.684	14.5307	14.626	11026580.0
2013-09-04 11:00:00	AMZN	Stock	14.6255	14.725	14.617	14.716	6561380.0
2013-09-04 12:00:00	AMZN	Stock	14.716	14.7615	14.6735	14.6945	6641460.0
2013-09-04 13:00:00	AMZN	Stock	14.6885	14.734	14.6848	14.6995	2834420.0
2013-09-04 14:00:00	AMZN	Stock	14.695	14.7355	14.684	14.7135	3429520.0
2013-09-04 15:00:00	AMZN	Stock	14.718	14.7275	14.6295	14.677	8999680.0
2013-09-04 16:00:00	AMZN	Stock	14.682	14.7125	14.6439	14.682	1350840.0

> showing 50 of 46,914 rows — these rows as CSV

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