PREVIEW / stock_1hour / 2011-08-12

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-08-12.parquet
  size:    932 KB
  rows:    44,141
  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
2011-08-12 04:00:00	AAPL	Stock	13.2561	13.3036	13.2304	13.3025	70000.0
2011-08-12 05:00:00	AAPL	Stock	13.3025	13.3893	13.3025	13.3893	25200.0
2011-08-12 06:00:00	AAPL	Stock	13.4136	13.4136	13.3546	13.3546	16800.0
2011-08-12 07:00:00	AAPL	Stock	13.3496	13.4496	13.3393	13.4375	1053752.0
2011-08-12 08:00:00	AAPL	Stock	13.4411	13.485	13.3879	13.4696	5615652.0
2011-08-12 09:00:00	AAPL	Stock	13.4689	13.5357	13.3932	13.4293	97704264.0
2011-08-12 10:00:00	AAPL	Stock	13.4266	13.5279	13.3654	13.4686	118856248.0
2011-08-12 11:00:00	AAPL	Stock	13.4675	13.5586	13.4518	13.5357	71282204.0
2011-08-12 12:00:00	AAPL	Stock	13.5361	13.5446	13.4564	13.4864	46602052.0
2011-08-12 13:00:00	AAPL	Stock	13.4836	13.5265	13.4771	13.5082	34387584.0
2011-08-12 14:00:00	AAPL	Stock	13.5089	13.5179	13.4414	13.4607	57819356.0
2011-08-12 15:00:00	AAPL	Stock	13.4636	13.4807	13.4329	13.4593	77566524.0
2011-08-12 16:00:00	AAPL	Stock	13.4582	13.5	13.4518	13.4646	10672564.0
2011-08-12 17:00:00	AAPL	Stock	13.4643	13.4686	13.4611	13.4675	225540.0
2011-08-12 18:00:00	AAPL	Stock	13.4675	13.48	13.4607	13.4714	136276.0
2011-08-12 19:00:00	AAPL	Stock	13.4714	13.4821	13.4682	13.4821	247772.0
2011-08-12 08:00:00	MSFT	Stock	25.2	25.25	25.17	25.22	20863.0
2011-08-12 09:00:00	MSFT	Stock	25.22	25.27	24.74	24.85	10963047.0
2011-08-12 10:00:00	MSFT	Stock	24.86	25.1	24.65	25.01	14688808.0
2011-08-12 11:00:00	MSFT	Stock	25.02	25.27	24.94	25.245	5922697.0
2011-08-12 12:00:00	MSFT	Stock	25.245	25.265	25.08	25.18	5289827.0
2011-08-12 13:00:00	MSFT	Stock	25.18	25.28	25.12	25.269	5076326.0
2011-08-12 14:00:00	MSFT	Stock	25.27	25.335	25.08	25.145	6778339.0
2011-08-12 15:00:00	MSFT	Stock	25.145	25.25	25.04	25.09	11695397.0
2011-08-12 16:00:00	MSFT	Stock	25.09	25.2	25.034	25.16	4127948.0
2011-08-12 17:00:00	MSFT	Stock	25.15	25.2	25.15	25.17	10480.0
2011-08-12 18:00:00	MSFT	Stock	25.18	25.3	25.1	25.3	11126.0
2011-08-12 19:00:00	MSFT	Stock	25.24	25.24	25.18	25.24	800.0
2011-08-12 07:00:00	NVDA	Stock	0.382	0.382	0.3682	0.3713	3813400.0
2011-08-12 08:00:00	NVDA	Stock	0.3713	0.3763	0.3668	0.3748	42858840.0
2011-08-12 09:00:00	NVDA	Stock	0.375	0.3763	0.337	0.3442	722253720.0
2011-08-12 10:00:00	NVDA	Stock	0.3442	0.347	0.3303	0.331	622533320.0
2011-08-12 11:00:00	NVDA	Stock	0.3308	0.3378	0.3308	0.3348	373163720.0
2011-08-12 12:00:00	NVDA	Stock	0.335	0.3368	0.3168	0.3178	420701520.0
2011-08-12 13:00:00	NVDA	Stock	0.3178	0.3273	0.3175	0.3245	345474880.0
2011-08-12 14:00:00	NVDA	Stock	0.3245	0.3258	0.3185	0.3235	213628440.0
2011-08-12 15:00:00	NVDA	Stock	0.3235	0.3253	0.3196	0.3215	406422720.0
2011-08-12 16:00:00	NVDA	Stock	0.3215	0.335	0.3213	0.3225	14410560.0
2011-08-12 17:00:00	NVDA	Stock	0.3225	0.3228	0.3218	0.3228	860200.0
2011-08-12 18:00:00	NVDA	Stock	0.3223	0.323	0.322	0.3225	242240.0
2011-08-12 19:00:00	NVDA	Stock	0.3223	0.3228	0.3213	0.3228	508880.0
2011-08-12 04:00:00	AMZN	Stock	9.8815	9.89	9.851	9.89	10000.0
2011-08-12 05:00:00	AMZN	Stock	9.9105	9.916	9.9105	9.916	4000.0
2011-08-12 07:00:00	AMZN	Stock	9.949	9.952	9.949	9.9515	12000.0
2011-08-12 08:00:00	AMZN	Stock	9.931	10.025	9.931	10.0	124940.0
2011-08-12 09:00:00	AMZN	Stock	9.985	10.028	9.8605	9.9006	15639800.0
2011-08-12 10:00:00	AMZN	Stock	9.9075	10.11	9.876	10.068	23460120.0
2011-08-12 11:00:00	AMZN	Stock	10.067	10.228	10.057	10.175	19720940.0
2011-08-12 12:00:00	AMZN	Stock	10.1715	10.175	10.0575	10.0965	11283720.0
2011-08-12 13:00:00	AMZN	Stock	10.0993	10.183	10.089	10.159	8548000.0

> showing 50 of 44,141 rows — these rows as CSV

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