PREVIEW / stock_1hour / 2012-07-24

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-07-24.parquet
  size:    925 KB
  rows:    43,768
  symbols: 3,472

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
2012-07-24 04:00:00	AAPL	Stock	21.5536	21.6	21.5536	21.6	31640.0
2012-07-24 05:00:00	AAPL	Stock	21.5821	21.5964	21.5821	21.5964	33600.0
2012-07-24 06:00:00	AAPL	Stock	21.5982	21.5982	21.5714	21.5821	58520.0
2012-07-24 07:00:00	AAPL	Stock	21.5714	21.5982	21.4971	21.5304	1015476.0
2012-07-24 08:00:00	AAPL	Stock	21.545	21.7314	21.4879	21.7079	3742648.0
2012-07-24 09:00:00	AAPL	Stock	21.7086	21.7743	21.6	21.6368	92962912.0
2012-07-24 10:00:00	AAPL	Stock	21.6479	21.6786	21.5714	21.6314	54531232.0
2012-07-24 11:00:00	AAPL	Stock	21.6343	21.6714	21.5757	21.5839	43158668.0
2012-07-24 12:00:00	AAPL	Stock	21.5821	21.5875	21.4154	21.5571	57548484.0
2012-07-24 13:00:00	AAPL	Stock	21.5543	21.5554	21.4529	21.5204	27021036.0
2012-07-24 14:00:00	AAPL	Stock	21.5221	21.5225	21.4339	21.4711	37542568.0
2012-07-24 15:00:00	AAPL	Stock	21.4689	21.555	21.3754	21.4743	96221188.0
2012-07-24 16:00:00	AAPL	Stock	21.4746	21.6357	20.1786	20.2946	86431268.0
2012-07-24 17:00:00	AAPL	Stock	20.2957	21.4614	20.2954	20.3589	35371980.0
2012-07-24 18:00:00	AAPL	Stock	20.3589	20.3839	20.3257	20.3486	3352776.0
2012-07-24 19:00:00	AAPL	Stock	20.3482	20.3525	20.2725	20.2786	3595424.0
2012-07-24 07:00:00	MSFT	Stock	29.25	29.25	29.25	29.25	500.0
2012-07-24 08:00:00	MSFT	Stock	29.25	29.327	29.22	29.23	3025.0
2012-07-24 09:00:00	MSFT	Stock	29.23	29.485	29.12	29.15	4772556.0
2012-07-24 10:00:00	MSFT	Stock	29.14	29.24	29.06	29.121	6564907.0
2012-07-24 11:00:00	MSFT	Stock	29.125	29.21	29.05	29.062	5096916.0
2012-07-24 12:00:00	MSFT	Stock	29.07	29.1	28.95	29.082	6277374.0
2012-07-24 13:00:00	MSFT	Stock	29.085	29.12	29.03	29.1	4890119.0
2012-07-24 14:00:00	MSFT	Stock	29.11	29.11	28.94	28.99	4941897.0
2012-07-24 15:00:00	MSFT	Stock	29.0	29.16	28.9	29.16	12761846.0
2012-07-24 16:00:00	MSFT	Stock	29.16	29.19	28.9	28.9	1476883.0
2012-07-24 17:00:00	MSFT	Stock	28.9	29.15	28.9	28.96	11938.0
2012-07-24 18:00:00	MSFT	Stock	28.96	29.01	28.93	28.94	11173.0
2012-07-24 19:00:00	MSFT	Stock	28.94	28.98	28.94	28.98	1200.0
2012-07-24 09:00:00	NVDA	Stock	0.327	0.3275	0.3214	0.3233	34238600.0
2012-07-24 10:00:00	NVDA	Stock	0.3233	0.324	0.3203	0.3229	53495200.0
2012-07-24 11:00:00	NVDA	Stock	0.323	0.3258	0.3205	0.3208	44677960.0
2012-07-24 12:00:00	NVDA	Stock	0.3206	0.3248	0.3171	0.321	36117280.0
2012-07-24 13:00:00	NVDA	Stock	0.321	0.3218	0.3188	0.321	35763040.0
2012-07-24 14:00:00	NVDA	Stock	0.321	0.3243	0.319	0.3203	36882880.0
2012-07-24 15:00:00	NVDA	Stock	0.32	0.3243	0.318	0.3213	91336440.0
2012-07-24 16:00:00	NVDA	Stock	0.321	0.322	0.3153	0.3153	13376600.0
2012-07-24 17:00:00	NVDA	Stock	0.3158	0.321	0.3158	0.3175	676400.0
2012-07-24 18:00:00	NVDA	Stock	0.3175	0.3175	0.3168	0.3168	18000.0
2012-07-24 19:00:00	NVDA	Stock	0.3168	0.3168	0.3168	0.3168	6000.0
2012-07-24 07:00:00	AMZN	Stock	11.2565	11.257	11.215	11.215	12000.0
2012-07-24 08:00:00	AMZN	Stock	11.2545	11.3025	11.225	11.3025	462560.0
2012-07-24 09:00:00	AMZN	Stock	11.3	11.3485	11.203	11.2345	61344200.0
2012-07-24 10:00:00	AMZN	Stock	11.2332	11.3145	11.159	11.205	6551540.0
2012-07-24 11:00:00	AMZN	Stock	11.2	11.2802	11.1886	11.2165	5124880.0
2012-07-24 12:00:00	AMZN	Stock	11.214	11.27	11.131	11.1725	4668460.0
2012-07-24 13:00:00	AMZN	Stock	11.17	11.1765	11.1155	11.1495	4727660.0
2012-07-24 14:00:00	AMZN	Stock	11.1485	11.3	11.07	11.1	4886540.0
2012-07-24 15:00:00	AMZN	Stock	11.0935	11.287	11.0615	11.151	9596200.0
2012-07-24 16:00:00	AMZN	Stock	11.152	11.2199	10.955	10.992	1680440.0

> showing 50 of 43,768 rows — these rows as CSV

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