PREVIEW / stock_1hour / 2012-11-01

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-11-01.parquet
  size:    958 KB
  rows:    45,812
  symbols: 3,479

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-01 05:00:00	AAPL	Stock	21.25	21.25	21.25	21.25	4144.0
2012-11-01 06:00:00	AAPL	Stock	21.2404	21.2411	21.2404	21.2411	5936.0
2012-11-01 07:00:00	AAPL	Stock	21.2854	21.3304	21.2679	21.3207	77616.0
2012-11-01 08:00:00	AAPL	Stock	21.3161	21.3571	21.2536	21.3571	1297968.0
2012-11-01 09:00:00	AAPL	Stock	21.3579	21.4211	21.2204	21.2625	51933140.0
2012-11-01 10:00:00	AAPL	Stock	21.2714	21.5161	21.2582	21.4971	72983428.0
2012-11-01 11:00:00	AAPL	Stock	21.4975	21.5357	21.395	21.4268	48459880.0
2012-11-01 12:00:00	AAPL	Stock	21.4268	21.4286	21.3532	21.3554	26421276.0
2012-11-01 13:00:00	AAPL	Stock	21.3571	21.3618	21.25	21.2682	44010624.0
2012-11-01 14:00:00	AAPL	Stock	21.275	21.3925	21.2618	21.3172	38434088.0
2012-11-01 15:00:00	AAPL	Stock	21.3211	21.3411	21.2611	21.3043	47834640.0
2012-11-01 16:00:00	AAPL	Stock	21.3014	21.4336	21.2964	21.3143	17415664.0
2012-11-01 17:00:00	AAPL	Stock	21.3121	21.325	21.3086	21.3214	118832.0
2012-11-01 18:00:00	AAPL	Stock	21.3211	21.3286	21.3125	21.3161	129248.0
2012-11-01 19:00:00	AAPL	Stock	21.3207	21.3304	21.3207	21.3304	76132.0
2012-11-01 08:00:00	MSFT	Stock	28.7	28.8	28.62	28.73	4400.0
2012-11-01 09:00:00	MSFT	Stock	28.7	29.21	28.68	29.17	9691793.0
2012-11-01 10:00:00	MSFT	Stock	29.18	29.315	29.08	29.29	12169296.0
2012-11-01 11:00:00	MSFT	Stock	29.29	29.46	29.28	29.454	10753492.0
2012-11-01 12:00:00	MSFT	Stock	29.455	29.56	29.42	29.435	8846299.0
2012-11-01 13:00:00	MSFT	Stock	29.44	29.52	29.34	29.475	5003066.0
2012-11-01 14:00:00	MSFT	Stock	29.475	29.54	29.39	29.505	7371439.0
2012-11-01 15:00:00	MSFT	Stock	29.5	29.53	29.43	29.53	13093923.0
2012-11-01 16:00:00	MSFT	Stock	29.52	29.6	28.535	29.52	4546428.0
2012-11-01 17:00:00	MSFT	Stock	29.51	29.66	29.51	29.65	40272.0
2012-11-01 18:00:00	MSFT	Stock	29.64	29.65	29.6	29.6	5785.0
2012-11-01 19:00:00	MSFT	Stock	29.61	29.64	29.6	29.64	6309.0
2012-11-01 08:00:00	NVDA	Stock	0.2992	0.2992	0.2992	0.2992	224000.0
2012-11-01 09:00:00	NVDA	Stock	0.3	0.3058	0.3	0.3055	41620080.0
2012-11-01 10:00:00	NVDA	Stock	0.3055	0.308	0.3055	0.3068	67275200.0
2012-11-01 11:00:00	NVDA	Stock	0.3069	0.3105	0.3055	0.3103	43141280.0
2012-11-01 12:00:00	NVDA	Stock	0.3105	0.311	0.3093	0.3105	28478720.0
2012-11-01 13:00:00	NVDA	Stock	0.3103	0.3119	0.3098	0.3113	44552520.0
2012-11-01 14:00:00	NVDA	Stock	0.3113	0.3135	0.31	0.3121	78517280.0
2012-11-01 15:00:00	NVDA	Stock	0.312	0.314	0.3115	0.3138	142904520.0
2012-11-01 16:00:00	NVDA	Stock	0.3138	0.3163	0.3114	0.3138	22053480.0
2012-11-01 17:00:00	NVDA	Stock	0.314	0.315	0.3135	0.315	68000.0
2012-11-01 18:00:00	NVDA	Stock	0.3153	0.3155	0.3153	0.3155	112000.0
2012-11-01 08:00:00	AMZN	Stock	11.73	11.73	11.641	11.641	125220.0
2012-11-01 09:00:00	AMZN	Stock	11.661	11.7275	11.661	11.695	10644740.0
2012-11-01 10:00:00	AMZN	Stock	11.6995	11.724	11.6255	11.643	12682560.0
2012-11-01 11:00:00	AMZN	Stock	11.6445	11.6555	11.567	11.6005	9499400.0
2012-11-01 12:00:00	AMZN	Stock	11.604	11.6425	11.588	11.5975	6408120.0
2012-11-01 13:00:00	AMZN	Stock	11.599	11.625	11.577	11.6155	8619200.0
2012-11-01 14:00:00	AMZN	Stock	11.615	11.62	11.5935	11.602	7717560.0
2012-11-01 15:00:00	AMZN	Stock	11.6055	11.6175	11.575	11.6035	15585640.0
2012-11-01 16:00:00	AMZN	Stock	11.606	11.6314	11.594	11.607	5187720.0
2012-11-01 17:00:00	AMZN	Stock	11.62	11.625	11.62	11.625	20660.0
2012-11-01 18:00:00	AMZN	Stock	11.64	11.65	11.64	11.6485	50000.0
2012-11-01 19:00:00	AMZN	Stock	11.6495	11.6495	11.6495	11.6495	8000.0

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

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