PREVIEW / stock_1hour / 2013-08-21

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-08-21.parquet
  size:    1004 KB
  rows:    46,749
  symbols: 3,526

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-21 04:00:00	AAPL	Stock	17.9196	17.9196	17.9089	17.9089	14000.0
2013-08-21 05:00:00	AAPL	Stock	17.9136	17.9143	17.8775	17.8775	8400.0
2013-08-21 06:00:00	AAPL	Stock	17.8607	17.8946	17.8568	17.8811	265888.0
2013-08-21 07:00:00	AAPL	Stock	17.8575	17.9864	17.8575	17.9554	522424.0
2013-08-21 08:00:00	AAPL	Stock	17.9471	17.9964	17.8571	17.9521	2209956.0
2013-08-21 09:00:00	AAPL	Stock	17.95	18.1125	17.9411	18.0896	59580780.0
2013-08-21 10:00:00	AAPL	Stock	18.0896	18.0921	17.9179	18.0079	70538468.0
2013-08-21 11:00:00	AAPL	Stock	18.0079	18.0571	17.9554	17.9969	38156216.0
2013-08-21 12:00:00	AAPL	Stock	17.9957	18.0143	17.9468	17.9643	19619012.0
2013-08-21 13:00:00	AAPL	Stock	17.9629	17.9893	17.9218	17.9757	24939460.0
2013-08-21 14:00:00	AAPL	Stock	17.9743	18.0521	17.9	18.0361	56131880.0
2013-08-21 15:00:00	AAPL	Stock	18.0393	18.0429	17.9321	17.9436	45928848.0
2013-08-21 16:00:00	AAPL	Stock	17.9439	18.0625	17.8954	17.9439	12797400.0
2013-08-21 17:00:00	AAPL	Stock	17.9246	17.9414	17.9154	17.9268	312340.0
2013-08-21 18:00:00	AAPL	Stock	17.9189	17.9389	17.9189	17.9286	312648.0
2013-08-21 19:00:00	AAPL	Stock	17.9254	17.9254	17.8982	17.9	325668.0
2013-08-21 07:00:00	MSFT	Stock	31.58	31.58	31.58	31.58	200.0
2013-08-21 08:00:00	MSFT	Stock	31.58	31.6	31.5	31.51	3100.0
2013-08-21 09:00:00	MSFT	Stock	31.57	31.93	31.54	31.85	3339263.0
2013-08-21 10:00:00	MSFT	Stock	31.853	31.99	31.84	31.85	5758844.0
2013-08-21 11:00:00	MSFT	Stock	31.85	31.905	31.79	31.84	4760418.0
2013-08-21 12:00:00	MSFT	Stock	31.84	32.01	31.81	31.91	2794294.0
2013-08-21 13:00:00	MSFT	Stock	31.91	31.92	31.79	31.81	1653171.0
2013-08-21 14:00:00	MSFT	Stock	31.805	32.0	31.6	31.91	7211460.0
2013-08-21 15:00:00	MSFT	Stock	31.9	32.0	31.58	31.61	6970556.0
2013-08-21 16:00:00	MSFT	Stock	31.61	31.97	31.54	31.6	4275721.0
2013-08-21 17:00:00	MSFT	Stock	31.61	31.61	31.55	31.55	27197.0
2013-08-21 18:00:00	MSFT	Stock	31.54	31.54	31.51	31.52	1790.0
2013-08-21 19:00:00	MSFT	Stock	31.54	31.54	31.5	31.51	8370.0
2013-08-21 09:00:00	NVDA	Stock	0.3715	0.3748	0.3705	0.3747	16097640.0
2013-08-21 10:00:00	NVDA	Stock	0.3745	0.3758	0.3728	0.375	45750720.0
2013-08-21 11:00:00	NVDA	Stock	0.3751	0.3755	0.372	0.372	30693200.0
2013-08-21 12:00:00	NVDA	Stock	0.372	0.3733	0.3718	0.3728	22388720.0
2013-08-21 13:00:00	NVDA	Stock	0.3729	0.375	0.3725	0.3743	18844120.0
2013-08-21 14:00:00	NVDA	Stock	0.3744	0.3763	0.3725	0.3746	57112680.0
2013-08-21 15:00:00	NVDA	Stock	0.3746	0.3753	0.3718	0.3723	57495760.0
2013-08-21 16:00:00	NVDA	Stock	0.372	0.374	0.3705	0.374	10236040.0
2013-08-21 17:00:00	NVDA	Stock	0.3738	0.3738	0.372	0.372	83080.0
2013-08-21 19:00:00	NVDA	Stock	0.3705	0.3705	0.3705	0.3705	8000.0
2013-08-21 08:00:00	AMZN	Stock	14.3545	14.3545	14.3475	14.3475	14000.0
2013-08-21 09:00:00	AMZN	Stock	14.3065	14.3456	14.25	14.305	4623320.0
2013-08-21 10:00:00	AMZN	Stock	14.3165	14.425	14.3125	14.411	5369120.0
2013-08-21 11:00:00	AMZN	Stock	14.4062	14.411	14.2358	14.2715	5574240.0
2013-08-21 12:00:00	AMZN	Stock	14.272	14.2875	14.2355	14.261	3448660.0
2013-08-21 13:00:00	AMZN	Stock	14.2667	14.3055	14.235	14.3055	2237700.0
2013-08-21 14:00:00	AMZN	Stock	14.3	14.3885	14.1915	14.3415	6404860.0
2013-08-21 15:00:00	AMZN	Stock	14.346	14.38	14.219	14.2285	5361740.0
2013-08-21 16:00:00	AMZN	Stock	14.2285	14.3042	14.2025	14.2125	2837260.0
2013-08-21 17:00:00	AMZN	Stock	14.3545	14.3545	14.2115	14.2115	32420.0
2013-08-21 19:00:00	AMZN	Stock	14.2005	14.2005	14.199	14.199	19960.0

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

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