PREVIEW / stock_1hour / 2012-11-14

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-11-14.parquet
  size:    944 KB
  rows:    44,681
  symbols: 3,478

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-11-14 04:00:00	AAPL	Stock	19.5	19.55	19.5	19.55	10360.0
2012-11-14 05:00:00	AAPL	Stock	19.5696	19.5696	19.5	19.5	108920.0
2012-11-14 06:00:00	AAPL	Stock	19.5	19.5004	19.5	19.5004	5600.0
2012-11-14 07:00:00	AAPL	Stock	19.4946	19.4954	19.4332	19.4379	388696.0
2012-11-14 08:00:00	AAPL	Stock	19.4514	19.49	19.4357	19.4857	1459388.0
2012-11-14 09:00:00	AAPL	Stock	19.4871	19.5518	19.3757	19.4204	62713784.0
2012-11-14 10:00:00	AAPL	Stock	19.415	19.4729	19.2643	19.3286	77100744.0
2012-11-14 11:00:00	AAPL	Stock	19.3221	19.4943	19.3171	19.4723	59003924.0
2012-11-14 12:00:00	AAPL	Stock	19.475	19.4836	19.3407	19.3493	33236588.0
2012-11-14 13:00:00	AAPL	Stock	19.3532	19.4464	19.3396	19.4036	36217944.0
2012-11-14 14:00:00	AAPL	Stock	19.4052	19.4561	19.2836	19.3036	57287524.0
2012-11-14 15:00:00	AAPL	Stock	19.3046	19.3179	19.1493	19.1836	111546764.0
2012-11-14 16:00:00	AAPL	Stock	19.1761	19.3501	19.1314	19.1821	19032916.0
2012-11-14 17:00:00	AAPL	Stock	19.1839	19.1839	19.1307	19.1396	638988.0
2012-11-14 18:00:00	AAPL	Stock	19.1432	19.1704	19.1414	19.1586	302932.0
2012-11-14 19:00:00	AAPL	Stock	19.1571	19.1571	19.1414	19.1429	346024.0
2012-11-14 04:00:00	MSFT	Stock	27.45	27.45	27.45	27.45	100.0
2012-11-14 06:00:00	MSFT	Stock	27.3	27.3	27.3	27.3	500.0
2012-11-14 07:00:00	MSFT	Stock	27.3	27.3	27.18	27.2	15150.0
2012-11-14 08:00:00	MSFT	Stock	27.19	27.2	27.1	27.16	56423.0
2012-11-14 09:00:00	MSFT	Stock	27.16	27.29	27.1	27.18	6091768.0
2012-11-14 10:00:00	MSFT	Stock	27.18	27.27	27.06	27.084	10387996.0
2012-11-14 11:00:00	MSFT	Stock	27.08	27.15	27.06	27.12	7468649.0
2012-11-14 12:00:00	MSFT	Stock	27.112	27.12	27.0	27.025	7982176.0
2012-11-14 13:00:00	MSFT	Stock	27.02	27.07	26.985	27.02	8473526.0
2012-11-14 14:00:00	MSFT	Stock	27.02	27.06	26.97	27.002	9900449.0
2012-11-14 15:00:00	MSFT	Stock	27.0	27.01	26.8	26.83	18111943.0
2012-11-14 16:00:00	MSFT	Stock	26.845	27.06	26.825	26.83	5383677.0
2012-11-14 17:00:00	MSFT	Stock	26.88	26.88	26.83	26.88	5349.0
2012-11-14 18:00:00	MSFT	Stock	26.85	26.88	26.85	26.87	7100.0
2012-11-14 19:00:00	MSFT	Stock	26.88	26.88	26.85	26.85	4467.0
2012-11-14 04:00:00	NVDA	Stock	0.3075	0.3075	0.305	0.305	8000.0
2012-11-14 05:00:00	NVDA	Stock	0.3025	0.3025	0.3025	0.3025	4000.0
2012-11-14 06:00:00	NVDA	Stock	0.3025	0.3025	0.3025	0.3025	4000.0
2012-11-14 07:00:00	NVDA	Stock	0.3008	0.3008	0.3008	0.3008	12000.0
2012-11-14 08:00:00	NVDA	Stock	0.3	0.3	0.2975	0.2975	68760.0
2012-11-14 09:00:00	NVDA	Stock	0.2998	0.2998	0.2955	0.298	72292600.0
2012-11-14 10:00:00	NVDA	Stock	0.2978	0.3005	0.2952	0.2964	177927160.0
2012-11-14 11:00:00	NVDA	Stock	0.2964	0.2966	0.295	0.2962	72716040.0
2012-11-14 12:00:00	NVDA	Stock	0.2961	0.2962	0.294	0.2942	35904320.0
2012-11-14 13:00:00	NVDA	Stock	0.2942	0.2955	0.294	0.2944	32001600.0
2012-11-14 14:00:00	NVDA	Stock	0.2945	0.2948	0.2918	0.2921	49868800.0
2012-11-14 15:00:00	NVDA	Stock	0.2922	0.2922	0.2882	0.2885	149166760.0
2012-11-14 16:00:00	NVDA	Stock	0.2888	0.2958	0.288	0.2895	9184680.0
2012-11-14 17:00:00	NVDA	Stock	0.2895	0.29	0.2895	0.29	218000.0
2012-11-14 18:00:00	NVDA	Stock	0.2912	0.2912	0.2902	0.2902	99000.0
2012-11-14 19:00:00	NVDA	Stock	0.2902	0.2912	0.2902	0.2912	32000.0
2012-11-14 08:00:00	AMZN	Stock	11.3625	11.3625	11.3	11.3	116600.0
2012-11-14 09:00:00	AMZN	Stock	11.3225	11.3705	11.29	11.335	5822220.0
2012-11-14 10:00:00	AMZN	Stock	11.335	11.357	11.205	11.2213	9837980.0

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

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