PREVIEW / stock_1hour / 2011-08-05

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-08-05.parquet
  size:    986 KB
  rows:    46,679
  symbols: 3,559

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
2011-08-05 04:00:00	AAPL	Stock	13.3929	13.3929	13.0236	13.1607	495600.0
2011-08-05 05:00:00	AAPL	Stock	13.1846	13.2568	13.1786	13.2029	685580.0
2011-08-05 06:00:00	AAPL	Stock	13.1929	13.3714	13.1929	13.3429	624568.0
2011-08-05 07:00:00	AAPL	Stock	13.3393	13.3929	13.3214	13.3857	1426992.0
2011-08-05 08:00:00	AAPL	Stock	13.3889	13.6232	13.2743	13.6071	19976096.0
2011-08-05 09:00:00	AAPL	Stock	13.6071	13.6964	13.2164	13.3196	208512416.0
2011-08-05 10:00:00	AAPL	Stock	13.3193	13.5536	13.2432	13.4536	201980072.0
2011-08-05 11:00:00	AAPL	Stock	13.4547	13.4589	12.9489	13.0804	176592332.0
2011-08-05 12:00:00	AAPL	Stock	13.0757	13.5282	13.0396	13.4689	221620868.0
2011-08-05 13:00:00	AAPL	Stock	13.4668	13.5307	13.2589	13.4914	115419136.0
2011-08-05 14:00:00	AAPL	Stock	13.4954	13.5064	13.3289	13.3814	77143024.0
2011-08-05 15:00:00	AAPL	Stock	13.3848	13.3929	13.2096	13.3482	143462620.0
2011-08-05 16:00:00	AAPL	Stock	13.3521	13.3754	13.2174	13.3257	30998408.0
2011-08-05 17:00:00	AAPL	Stock	13.3354	13.3714	13.3289	13.3618	486052.0
2011-08-05 18:00:00	AAPL	Stock	13.3732	13.3732	13.3436	13.3536	171724.0
2011-08-05 19:00:00	AAPL	Stock	13.3539	13.3607	13.3304	13.3607	765996.0
2011-08-05 04:00:00	MSFT	Stock	25.75	25.75	25.57	25.57	1300.0
2011-08-05 05:00:00	MSFT	Stock	25.22	25.57	25.22	25.57	765.0
2011-08-05 06:00:00	MSFT	Stock	25.42	25.68	25.41	25.68	12490.0
2011-08-05 07:00:00	MSFT	Stock	25.67	25.99	25.65	25.82	23919.0
2011-08-05 08:00:00	MSFT	Stock	25.8	26.19	25.67	25.95	167531.0
2011-08-05 09:00:00	MSFT	Stock	25.95	26.0	25.31	25.403	16651378.0
2011-08-05 10:00:00	MSFT	Stock	25.4	25.99	25.31	25.69	18823744.0
2011-08-05 11:00:00	MSFT	Stock	25.69	25.695	25.23	25.28	14676858.0
2011-08-05 12:00:00	MSFT	Stock	25.28	26.1	25.23	25.895	17448121.0
2011-08-05 13:00:00	MSFT	Stock	25.9	26.04	25.62	25.897	9136415.0
2011-08-05 14:00:00	MSFT	Stock	25.89	25.92	25.51	25.6	7650739.0
2011-08-05 15:00:00	MSFT	Stock	25.58	25.74	25.29	25.7	19156191.0
2011-08-05 16:00:00	MSFT	Stock	25.705	25.76	25.433	25.62	5641186.0
2011-08-05 17:00:00	MSFT	Stock	25.94	25.94	25.58	25.61	4011.0
2011-08-05 18:00:00	MSFT	Stock	25.68	25.69	25.68	25.68	15170.0
2011-08-05 19:00:00	MSFT	Stock	25.63	25.63	25.63	25.63	425.0
2011-08-05 07:00:00	NVDA	Stock	0.3278	0.3278	0.3253	0.3255	128000.0
2011-08-05 08:00:00	NVDA	Stock	0.331	0.3438	0.3268	0.3415	985280.0
2011-08-05 09:00:00	NVDA	Stock	0.341	0.347	0.3265	0.327	143557560.0
2011-08-05 10:00:00	NVDA	Stock	0.3268	0.3376	0.325	0.3293	235971560.0
2011-08-05 11:00:00	NVDA	Stock	0.3293	0.3293	0.3153	0.3155	197437920.0
2011-08-05 12:00:00	NVDA	Stock	0.316	0.334	0.315	0.332	191040320.0
2011-08-05 13:00:00	NVDA	Stock	0.332	0.335	0.328	0.3333	100919560.0
2011-08-05 14:00:00	NVDA	Stock	0.3334	0.3348	0.326	0.3275	131154320.0
2011-08-05 15:00:00	NVDA	Stock	0.3275	0.3278	0.3204	0.3235	225698080.0
2011-08-05 16:00:00	NVDA	Stock	0.3238	0.3278	0.3205	0.3245	41985640.0
2011-08-05 17:00:00	NVDA	Stock	0.3245	0.3245	0.3245	0.3245	12760.0
2011-08-05 18:00:00	NVDA	Stock	0.3245	0.3245	0.3245	0.3245	40000.0
2011-08-05 19:00:00	NVDA	Stock	0.3243	0.3243	0.3213	0.3213	12000.0
2011-08-05 07:00:00	AMZN	Stock	9.9635	10.039	9.9635	10.039	31000.0
2011-08-05 08:00:00	AMZN	Stock	10.01	10.2155	9.9605	10.1875	758520.0
2011-08-05 09:00:00	AMZN	Stock	10.1865	10.366	9.909	10.011	25858360.0
2011-08-05 10:00:00	AMZN	Stock	10.013	10.2475	9.9655	10.106	33053120.0
2011-08-05 11:00:00	AMZN	Stock	10.111	10.115	9.742	9.7805	30511540.0

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

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