PREVIEW / stock_1hour / 2013-02-15

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-02-15.parquet
  size:    968 KB
  rows:    45,005
  symbols: 3,461

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-02-15 06:00:00	AAPL	Stock	16.7268	16.7268	16.6786	16.6786	16800.0
2013-02-15 07:00:00	AAPL	Stock	16.6821	16.6964	16.6786	16.6875	58660.0
2013-02-15 08:00:00	AAPL	Stock	16.7104	16.75	16.6836	16.7207	1311436.0
2013-02-15 09:00:00	AAPL	Stock	16.7279	16.7664	16.6536	16.7346	68658016.0
2013-02-15 10:00:00	AAPL	Stock	16.7293	16.7914	16.6718	16.6929	51391760.0
2013-02-15 11:00:00	AAPL	Stock	16.6957	16.6982	16.6336	16.6521	29155308.0
2013-02-15 12:00:00	AAPL	Stock	16.6554	16.6554	16.55	16.59	41626928.0
2013-02-15 13:00:00	AAPL	Stock	16.5946	16.6268	16.5571	16.5975	24497704.0
2013-02-15 14:00:00	AAPL	Stock	16.5957	16.6086	16.455	16.4871	61325460.0
2013-02-15 15:00:00	AAPL	Stock	16.4868	16.5032	16.4257	16.4375	85843436.0
2013-02-15 16:00:00	AAPL	Stock	16.4356	16.5919	16.4271	16.4286	16908108.0
2013-02-15 17:00:00	AAPL	Stock	16.4279	16.43	16.4204	16.4289	361452.0
2013-02-15 18:00:00	AAPL	Stock	16.4282	16.4282	16.4036	16.42	91952.0
2013-02-15 19:00:00	AAPL	Stock	16.4154	16.4286	16.4143	16.4232	134232.0
2013-02-15 04:00:00	MSFT	Stock	28.09	28.09	28.09	28.09	226.0
2013-02-15 07:00:00	MSFT	Stock	28.05	28.05	28.05	28.05	200.0
2013-02-15 08:00:00	MSFT	Stock	28.0	28.05	28.0	28.01	13000.0
2013-02-15 09:00:00	MSFT	Stock	28.01	28.16	27.85	28.12	12809604.0
2013-02-15 10:00:00	MSFT	Stock	28.12	28.15	27.975	28.0	5302531.0
2013-02-15 11:00:00	MSFT	Stock	28.01	28.025	27.95	27.99	4467996.0
2013-02-15 12:00:00	MSFT	Stock	27.988	28.02	27.96	28.0	2971235.0
2013-02-15 13:00:00	MSFT	Stock	28.0	28.01	27.96	27.998	2575062.0
2013-02-15 14:00:00	MSFT	Stock	27.992	28.01	27.875	27.88	7746342.0
2013-02-15 15:00:00	MSFT	Stock	27.88	28.02	27.88	28.02	9972231.0
2013-02-15 16:00:00	MSFT	Stock	28.01	28.02	27.98	28.02	2947124.0
2013-02-15 17:00:00	MSFT	Stock	28.0	28.02	27.99	27.99	62275.0
2013-02-15 18:00:00	MSFT	Stock	28.01	28.06	28.01	28.02	3250.0
2013-02-15 19:00:00	MSFT	Stock	28.01	28.02	28.01	28.02	3952.0
2013-02-15 08:00:00	NVDA	Stock	0.3175	0.318	0.3175	0.318	33200.0
2013-02-15 09:00:00	NVDA	Stock	0.3175	0.3183	0.316	0.3171	92410640.0
2013-02-15 10:00:00	NVDA	Stock	0.317	0.3173	0.314	0.3143	109301800.0
2013-02-15 11:00:00	NVDA	Stock	0.3144	0.3145	0.312	0.3126	83578600.0
2013-02-15 12:00:00	NVDA	Stock	0.3128	0.313	0.3113	0.3114	44544320.0
2013-02-15 13:00:00	NVDA	Stock	0.3113	0.3133	0.3113	0.313	61714600.0
2013-02-15 14:00:00	NVDA	Stock	0.313	0.316	0.3128	0.316	119568280.0
2013-02-15 15:00:00	NVDA	Stock	0.316	0.3198	0.3158	0.3185	204430000.0
2013-02-15 16:00:00	NVDA	Stock	0.3185	0.321	0.3154	0.3185	17457120.0
2013-02-15 17:00:00	NVDA	Stock	0.3185	0.3185	0.3185	0.3185	800000.0
2013-02-15 19:00:00	NVDA	Stock	0.3175	0.3175	0.3175	0.3175	16000.0
2013-02-15 07:00:00	AMZN	Stock	13.45	13.4505	13.45	13.4505	10000.0
2013-02-15 08:00:00	AMZN	Stock	13.4205	13.45	13.418	13.424	101300.0
2013-02-15 09:00:00	AMZN	Stock	13.417	13.446	13.3095	13.353	15704940.0
2013-02-15 10:00:00	AMZN	Stock	13.3588	13.3815	13.2723	13.3165	12825480.0
2013-02-15 11:00:00	AMZN	Stock	13.314	13.3438	13.2322	13.252	9092960.0
2013-02-15 12:00:00	AMZN	Stock	13.248	13.272	13.2145	13.2445	5779660.0
2013-02-15 13:00:00	AMZN	Stock	13.245	13.3131	13.2442	13.306	4653180.0
2013-02-15 14:00:00	AMZN	Stock	13.306	13.3184	13.1555	13.227	14037820.0
2013-02-15 15:00:00	AMZN	Stock	13.227	13.2655	13.194	13.2565	13755960.0
2013-02-15 16:00:00	AMZN	Stock	13.256	13.2848	13.2248	13.256	806700.0
2013-02-15 17:00:00	AMZN	Stock	13.2825	13.292	13.28	13.28	17000.0

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

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