PREVIEW / stock_1hour / 2013-05-02

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-05-02.parquet
  size:    999 KB
  rows:    46,078
  symbols: 3,482

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-05-02 05:00:00	AAPL	Stock	15.7171	15.7171	15.7171	15.7171	2800.0
2013-05-02 06:00:00	AAPL	Stock	15.7411	15.75	15.7407	15.75	40712.0
2013-05-02 07:00:00	AAPL	Stock	15.7675	15.84	15.7554	15.825	916244.0
2013-05-02 08:00:00	AAPL	Stock	15.825	15.8393	15.7607	15.8086	3111444.0
2013-05-02 09:00:00	AAPL	Stock	15.8089	15.9748	15.7368	15.8846	84903112.0
2013-05-02 10:00:00	AAPL	Stock	15.8807	15.9885	15.875	15.9489	67897228.0
2013-05-02 11:00:00	AAPL	Stock	15.9496	16.01	15.9164	15.9832	59959900.0
2013-05-02 12:00:00	AAPL	Stock	15.9832	15.9907	15.9307	15.9621	32081672.0
2013-05-02 13:00:00	AAPL	Stock	15.965	16.0161	15.9571	15.995	41236440.0
2013-05-02 14:00:00	AAPL	Stock	15.9947	16.0211	15.9746	15.9939	33305244.0
2013-05-02 15:00:00	AAPL	Stock	15.9939	15.9975	15.9111	15.913	61216232.0
2013-05-02 16:00:00	AAPL	Stock	15.9129	16.0079	15.9011	15.9193	7096124.0
2013-05-02 17:00:00	AAPL	Stock	15.9221	15.969	15.9114	15.9261	545720.0
2013-05-02 18:00:00	AAPL	Stock	15.9171	15.9239	15.9114	15.915	111496.0
2013-05-02 19:00:00	AAPL	Stock	15.9143	15.9254	15.9125	15.9254	116928.0
2013-05-02 07:00:00	MSFT	Stock	32.7	32.78	32.69	32.72	4011.0
2013-05-02 08:00:00	MSFT	Stock	32.73	32.85	32.73	32.75	27867.0
2013-05-02 09:00:00	MSFT	Stock	32.75	32.79	32.39	32.644	5707733.0
2013-05-02 10:00:00	MSFT	Stock	32.65	32.72	32.545	32.67	5249690.0
2013-05-02 11:00:00	MSFT	Stock	32.67	32.72	32.64	32.69	4794074.0
2013-05-02 12:00:00	MSFT	Stock	32.69	32.96	32.685	32.95	5262436.0
2013-05-02 13:00:00	MSFT	Stock	32.945	33.1	32.915	33.09	5799001.0
2013-05-02 14:00:00	MSFT	Stock	33.09	33.12	33.025	33.1	5165343.0
2013-05-02 15:00:00	MSFT	Stock	33.1	33.17	33.02	33.16	10629391.0
2013-05-02 16:00:00	MSFT	Stock	33.16	33.2	32.61	33.16	1661226.0
2013-05-02 17:00:00	MSFT	Stock	33.15	33.16	33.09	33.09	8563.0
2013-05-02 18:00:00	MSFT	Stock	33.12	33.14	33.09	33.1	8862.0
2013-05-02 19:00:00	MSFT	Stock	33.1	33.16	33.1	33.16	4666.0
2013-05-02 08:00:00	NVDA	Stock	0.343	0.343	0.343	0.343	4000.0
2013-05-02 09:00:00	NVDA	Stock	0.343	0.3438	0.339	0.339	24398840.0
2013-05-02 10:00:00	NVDA	Stock	0.339	0.3422	0.339	0.3406	32061560.0
2013-05-02 11:00:00	NVDA	Stock	0.3406	0.3444	0.3404	0.343	37429600.0
2013-05-02 12:00:00	NVDA	Stock	0.343	0.3433	0.3408	0.3416	56279680.0
2013-05-02 13:00:00	NVDA	Stock	0.3418	0.3451	0.3415	0.3439	35522000.0
2013-05-02 14:00:00	NVDA	Stock	0.3439	0.3453	0.3438	0.3449	19395160.0
2013-05-02 15:00:00	NVDA	Stock	0.3449	0.3462	0.3448	0.3453	48256880.0
2013-05-02 16:00:00	NVDA	Stock	0.3453	0.346	0.3428	0.346	11615160.0
2013-05-02 18:00:00	NVDA	Stock	0.3453	0.3453	0.3453	0.3453	20000.0
2013-05-02 07:00:00	AMZN	Stock	12.4565	12.458	12.455	12.455	6000.0
2013-05-02 08:00:00	AMZN	Stock	12.45	12.489	12.443	12.451	136540.0
2013-05-02 09:00:00	AMZN	Stock	12.45	12.49	12.289	12.3165	11974200.0
2013-05-02 10:00:00	AMZN	Stock	12.3147	12.4945	12.313	12.4745	18570000.0
2013-05-02 11:00:00	AMZN	Stock	12.4725	12.6465	12.4615	12.5636	17639020.0
2013-05-02 12:00:00	AMZN	Stock	12.5641	12.59	12.53	12.555	5121820.0
2013-05-02 13:00:00	AMZN	Stock	12.558	12.6195	12.555	12.6044	5478020.0
2013-05-02 14:00:00	AMZN	Stock	12.6045	12.6155	12.5775	12.609	5750660.0
2013-05-02 15:00:00	AMZN	Stock	12.6065	12.6375	12.594	12.6275	11769080.0
2013-05-02 16:00:00	AMZN	Stock	12.6275	12.6276	12.4314	12.5975	1624500.0
2013-05-02 17:00:00	AMZN	Stock	12.5965	12.6275	12.5775	12.6275	111700.0
2013-05-02 18:00:00	AMZN	Stock	12.579	12.579	12.579	12.579	2000.0

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

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