PREVIEW / stock_1hour / 2011-11-28

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-11-28.parquet
  size:    939 KB
  rows:    45,367
  symbols: 3,538

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-11-28 04:00:00	AAPL	Stock	13.2561	13.3214	13.2536	13.3036	38080.0
2011-11-28 05:00:00	AAPL	Stock	13.3254	13.3432	13.3254	13.3429	25760.0
2011-11-28 06:00:00	AAPL	Stock	13.3571	13.3643	13.3036	13.3257	114660.0
2011-11-28 07:00:00	AAPL	Stock	13.3393	13.3532	13.2882	13.3304	1214248.0
2011-11-28 08:00:00	AAPL	Stock	13.3336	13.3568	13.2604	13.3004	3488856.0
2011-11-28 09:00:00	AAPL	Stock	13.3011	13.3393	13.2261	13.3214	75071724.0
2011-11-28 10:00:00	AAPL	Stock	13.3196	13.3536	13.3043	13.3286	47876472.0
2011-11-28 11:00:00	AAPL	Stock	13.3282	13.3929	13.3175	13.3775	36392692.0
2011-11-28 12:00:00	AAPL	Stock	13.3786	13.4018	13.3614	13.3743	25463284.0
2011-11-28 13:00:00	AAPL	Stock	13.3739	13.4364	13.3629	13.4036	28098952.0
2011-11-28 14:00:00	AAPL	Stock	13.4021	13.4543	13.3882	13.4082	34709668.0
2011-11-28 15:00:00	AAPL	Stock	13.4079	13.4357	13.3486	13.4293	60973304.0
2011-11-28 16:00:00	AAPL	Stock	13.4301	13.4375	13.3357	13.4332	28625744.0
2011-11-28 17:00:00	AAPL	Stock	13.4286	13.4357	13.4214	13.4321	91952.0
2011-11-28 18:00:00	AAPL	Stock	13.43	13.4357	13.4179	13.4196	257096.0
2011-11-28 19:00:00	AAPL	Stock	13.4239	13.4321	13.4196	13.4268	177296.0
2011-11-28 06:00:00	MSFT	Stock	25.0	25.0	25.0	25.0	600.0
2011-11-28 07:00:00	MSFT	Stock	24.96	24.96	24.78	24.81	7275.0
2011-11-28 08:00:00	MSFT	Stock	24.8	24.92	24.3	24.8	78030.0
2011-11-28 09:00:00	MSFT	Stock	24.81	24.97	24.693	24.81	5010634.0
2011-11-28 10:00:00	MSFT	Stock	24.81	24.95	24.8	24.84	6033686.0
2011-11-28 11:00:00	MSFT	Stock	24.836	24.88	24.75	24.81	6455073.0
2011-11-28 12:00:00	MSFT	Stock	24.8	24.84	24.76	24.782	3614169.0
2011-11-28 13:00:00	MSFT	Stock	24.78	24.89	24.77	24.81	3138150.0
2011-11-28 14:00:00	MSFT	Stock	24.8	24.895	24.75	24.79	3743714.0
2011-11-28 15:00:00	MSFT	Stock	24.78	24.91	24.69	24.9	9111977.0
2011-11-28 16:00:00	MSFT	Stock	24.89	24.92	24.8	24.848	8110989.0
2011-11-28 17:00:00	MSFT	Stock	24.85	24.85	24.82	24.82	2179.0
2011-11-28 18:00:00	MSFT	Stock	24.87	24.87	24.84	24.86	30483.0
2011-11-28 19:00:00	MSFT	Stock	24.86	24.86	24.84	24.84	5122.0
2011-11-28 06:00:00	NVDA	Stock	0.3525	0.3525	0.3525	0.3525	50320.0
2011-11-28 07:00:00	NVDA	Stock	0.3625	0.3668	0.3625	0.3668	146040.0
2011-11-28 08:00:00	NVDA	Stock	0.3638	0.3665	0.3612	0.3662	436240.0
2011-11-28 09:00:00	NVDA	Stock	0.3662	0.3713	0.3625	0.3708	86551120.0
2011-11-28 10:00:00	NVDA	Stock	0.3708	0.3745	0.3698	0.3728	121429560.0
2011-11-28 11:00:00	NVDA	Stock	0.3725	0.3763	0.371	0.3749	101009520.0
2011-11-28 12:00:00	NVDA	Stock	0.375	0.3755	0.369	0.369	73433800.0
2011-11-28 13:00:00	NVDA	Stock	0.369	0.3718	0.3662	0.3685	64122520.0
2011-11-28 14:00:00	NVDA	Stock	0.3685	0.372	0.368	0.3692	71780080.0
2011-11-28 15:00:00	NVDA	Stock	0.3692	0.3718	0.3668	0.3713	129960160.0
2011-11-28 16:00:00	NVDA	Stock	0.3705	0.3718	0.3705	0.3713	10178920.0
2011-11-28 17:00:00	NVDA	Stock	0.3713	0.3713	0.3713	0.3713	48000.0
2011-11-28 18:00:00	NVDA	Stock	0.3692	0.3708	0.369	0.3692	123200.0
2011-11-28 19:00:00	NVDA	Stock	0.37	0.37	0.37	0.37	20000.0
2011-11-28 04:00:00	AMZN	Stock	9.431	9.4695	9.425	9.4695	14000.0
2011-11-28 05:00:00	AMZN	Stock	9.425	9.45	9.395	9.45	18000.0
2011-11-28 06:00:00	AMZN	Stock	9.45	9.475	9.43	9.44	20000.0
2011-11-28 07:00:00	AMZN	Stock	9.45	9.4725	9.41	9.437	139780.0
2011-11-28 08:00:00	AMZN	Stock	9.41	9.522	9.375	9.4875	976520.0
2011-11-28 09:00:00	AMZN	Stock	9.4875	9.6675	9.48	9.6205	31790020.0

> showing 50 of 45,367 rows — these rows as CSV

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