PREVIEW / stock_1hour / 2012-11-12

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-11-12.parquet
  size:    920 KB
  rows:    43,806
  symbols: 3,447

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-12 04:00:00	AAPL	Stock	19.8214	19.8214	19.6429	19.6429	65240.0
2012-11-12 05:00:00	AAPL	Stock	19.6429	19.6464	19.6429	19.6464	22400.0
2012-11-12 06:00:00	AAPL	Stock	19.6679	19.7107	19.6679	19.7107	77924.0
2012-11-12 07:00:00	AAPL	Stock	19.7054	19.7536	19.6857	19.6961	590380.0
2012-11-12 08:00:00	AAPL	Stock	19.6964	19.7429	19.6432	19.6711	2076872.0
2012-11-12 09:00:00	AAPL	Stock	19.6704	19.8036	19.6111	19.6689	74407256.0
2012-11-12 10:00:00	AAPL	Stock	19.6618	19.6768	19.3993	19.4086	75716984.0
2012-11-12 11:00:00	AAPL	Stock	19.4089	19.4461	19.2375	19.2917	94266368.0
2012-11-12 12:00:00	AAPL	Stock	19.2961	19.5364	19.275	19.5325	67159680.0
2012-11-12 13:00:00	AAPL	Stock	19.5325	19.5821	19.3493	19.423	67000976.0
2012-11-12 14:00:00	AAPL	Stock	19.4243	19.5	19.3225	19.3807	44374736.0
2012-11-12 15:00:00	AAPL	Stock	19.3764	19.4704	19.3043	19.3929	71388296.0
2012-11-12 16:00:00	AAPL	Stock	19.3889	19.5936	19.2944	19.3907	7223664.0
2012-11-12 17:00:00	AAPL	Stock	19.387	19.5607	19.3868	19.3957	841204.0
2012-11-12 18:00:00	AAPL	Stock	19.3843	19.3868	19.3596	19.3607	183736.0
2012-11-12 19:00:00	AAPL	Stock	19.3707	19.3707	19.3268	19.3393	387240.0
2012-11-12 04:00:00	MSFT	Stock	28.83	28.83	28.83	28.83	100.0
2012-11-12 07:00:00	MSFT	Stock	28.9	28.9	28.83	28.9	13750.0
2012-11-12 08:00:00	MSFT	Stock	28.94	28.97	28.84	28.85	38831.0
2012-11-12 09:00:00	MSFT	Stock	28.85	29.01	28.6	28.76	5097873.0
2012-11-12 10:00:00	MSFT	Stock	28.75	28.758	28.32	28.325	10560774.0
2012-11-12 11:00:00	MSFT	Stock	28.33	28.33	28.24	28.28	8874097.0
2012-11-12 12:00:00	MSFT	Stock	28.285	28.5	28.28	28.478	8064736.0
2012-11-12 13:00:00	MSFT	Stock	28.474	28.53	28.41	28.435	4396923.0
2012-11-12 14:00:00	MSFT	Stock	28.43	28.438	28.27	28.29	7266502.0
2012-11-12 15:00:00	MSFT	Stock	28.29	28.42	28.21	28.23	13953979.0
2012-11-12 16:00:00	MSFT	Stock	28.24	28.69	28.21	28.28	1529014.0
2012-11-12 17:00:00	MSFT	Stock	28.237	28.29	28.22	28.27	119849.0
2012-11-12 18:00:00	MSFT	Stock	28.27	28.35	28.25	28.25	41018.0
2012-11-12 19:00:00	MSFT	Stock	28.27	28.27	28.22	28.22	9911.0
2012-11-12 08:00:00	NVDA	Stock	0.307	0.307	0.307	0.307	44000.0
2012-11-12 09:00:00	NVDA	Stock	0.3058	0.3065	0.2958	0.2975	124211160.0
2012-11-12 10:00:00	NVDA	Stock	0.2975	0.2995	0.2958	0.2962	98237200.0
2012-11-12 11:00:00	NVDA	Stock	0.2964	0.298	0.295	0.2968	86373280.0
2012-11-12 12:00:00	NVDA	Stock	0.2968	0.2975	0.2954	0.297	55104800.0
2012-11-12 13:00:00	NVDA	Stock	0.297	0.2972	0.2952	0.2972	52499640.0
2012-11-12 14:00:00	NVDA	Stock	0.2972	0.2978	0.2962	0.297	50916360.0
2012-11-12 15:00:00	NVDA	Stock	0.2968	0.3	0.2965	0.298	152139480.0
2012-11-12 16:00:00	NVDA	Stock	0.298	0.2994	0.2978	0.2985	537840.0
2012-11-12 17:00:00	NVDA	Stock	0.298	0.3044	0.298	0.3044	610960.0
2012-11-12 18:00:00	NVDA	Stock	0.3	0.3	0.3	0.3	10000.0
2012-11-12 19:00:00	NVDA	Stock	0.3	0.3	0.298	0.298	96000.0
2012-11-12 08:00:00	AMZN	Stock	11.3925	11.4035	11.3755	11.4	37040.0
2012-11-12 09:00:00	AMZN	Stock	11.3735	11.461	11.325	11.3665	5963600.0
2012-11-12 10:00:00	AMZN	Stock	11.3675	11.3895	11.3015	11.3125	7703540.0
2012-11-12 11:00:00	AMZN	Stock	11.315	11.33	11.2705	11.2941	5679580.0
2012-11-12 12:00:00	AMZN	Stock	11.295	11.4065	11.2775	11.4055	3781880.0
2012-11-12 13:00:00	AMZN	Stock	11.4022	11.4345	11.3645	11.389	5137920.0
2012-11-12 14:00:00	AMZN	Stock	11.386	11.407	11.345	11.3652	6264940.0
2012-11-12 15:00:00	AMZN	Stock	11.367	11.3765	11.3095	11.3285	6432520.0

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

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