PREVIEW / stock_1hour / 2012-10-03

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-10-03.parquet
  size:    940 KB
  rows:    45,041
  symbols: 3,456

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-10-03 04:00:00	AAPL	Stock	23.6425	23.7464	23.6425	23.7143	34804.0
2012-10-03 05:00:00	AAPL	Stock	23.75	23.75	23.75	23.75	16800.0
2012-10-03 06:00:00	AAPL	Stock	23.7507	23.7661	23.75	23.75	56728.0
2012-10-03 07:00:00	AAPL	Stock	23.7161	23.75	23.7161	23.7357	252308.0
2012-10-03 08:00:00	AAPL	Stock	23.7325	23.7407	23.5793	23.66	2113216.0
2012-10-03 09:00:00	AAPL	Stock	23.6536	23.8489	23.6536	23.7621	68742604.0
2012-10-03 10:00:00	AAPL	Stock	23.7621	23.8571	23.6654	23.7371	82914160.0
2012-10-03 11:00:00	AAPL	Stock	23.743	23.9082	23.7232	23.8791	46206580.0
2012-10-03 12:00:00	AAPL	Stock	23.8821	23.9018	23.8214	23.8471	27699392.0
2012-10-03 13:00:00	AAPL	Stock	23.8495	23.8714	23.7579	23.7784	32802112.0
2012-10-03 14:00:00	AAPL	Stock	23.78	23.8393	23.7411	23.8029	31508736.0
2012-10-03 15:00:00	AAPL	Stock	23.8039	23.995	23.7589	23.9929	82825148.0
2012-10-03 16:00:00	AAPL	Stock	23.9907	23.9955	23.82	23.9821	15832964.0
2012-10-03 17:00:00	AAPL	Stock	23.9782	23.9904	23.9757	23.9904	373828.0
2012-10-03 18:00:00	AAPL	Stock	23.9893	24.0032	23.9825	23.9868	430724.0
2012-10-03 19:00:00	AAPL	Stock	23.9946	24.0071	23.9857	24.0	356664.0
2012-10-03 07:00:00	MSFT	Stock	29.69	29.69	29.5	29.68	31102.0
2012-10-03 08:00:00	MSFT	Stock	29.71	29.75	29.7	29.73	38750.0
2012-10-03 09:00:00	MSFT	Stock	29.73	29.8	29.67	29.74	3418258.0
2012-10-03 10:00:00	MSFT	Stock	29.75	29.95	29.68	29.9	8498252.0
2012-10-03 11:00:00	MSFT	Stock	29.9	29.99	29.84	29.895	6495129.0
2012-10-03 12:00:00	MSFT	Stock	29.9	29.93	29.81	29.83	5881337.0
2012-10-03 13:00:00	MSFT	Stock	29.83	29.85	29.74	29.74	3767580.0
2012-10-03 14:00:00	MSFT	Stock	29.745	29.8	29.69	29.735	4136749.0
2012-10-03 15:00:00	MSFT	Stock	29.74	29.9	29.71	29.86	9715925.0
2012-10-03 16:00:00	MSFT	Stock	29.85	29.972	29.81	29.84	1897128.0
2012-10-03 17:00:00	MSFT	Stock	29.85	29.9	29.81	29.89	24696.0
2012-10-03 18:00:00	MSFT	Stock	29.89	29.9	29.86	29.9	8791.0
2012-10-03 19:00:00	MSFT	Stock	29.89	29.92	29.89	29.92	634.0
2012-10-03 09:00:00	NVDA	Stock	0.3298	0.331	0.3268	0.3274	33727440.0
2012-10-03 10:00:00	NVDA	Stock	0.3278	0.3293	0.3261	0.3268	69332400.0
2012-10-03 11:00:00	NVDA	Stock	0.3266	0.3293	0.3264	0.3271	40998120.0
2012-10-03 12:00:00	NVDA	Stock	0.3271	0.328	0.3268	0.327	22809440.0
2012-10-03 13:00:00	NVDA	Stock	0.3269	0.3273	0.3254	0.3254	31769800.0
2012-10-03 14:00:00	NVDA	Stock	0.3253	0.3265	0.3243	0.3259	74219400.0
2012-10-03 15:00:00	NVDA	Stock	0.326	0.3275	0.3255	0.326	80071680.0
2012-10-03 16:00:00	NVDA	Stock	0.326	0.3291	0.326	0.3267	67302280.0
2012-10-03 17:00:00	NVDA	Stock	0.326	0.326	0.326	0.326	744400.0
2012-10-03 19:00:00	NVDA	Stock	0.326	0.326	0.326	0.326	4000.0
2012-10-03 09:00:00	AMZN	Stock	12.5335	12.6465	12.478	12.501	5227100.0
2012-10-03 10:00:00	AMZN	Stock	12.508	12.601	12.491	12.577	6514860.0
2012-10-03 11:00:00	AMZN	Stock	12.588	12.712	12.588	12.672	7250900.0
2012-10-03 12:00:00	AMZN	Stock	12.6715	12.695	12.6375	12.689	3447300.0
2012-10-03 13:00:00	AMZN	Stock	12.689	12.732	12.6575	12.666	5116800.0
2012-10-03 14:00:00	AMZN	Stock	12.669	12.774	12.6661	12.7525	8943520.0
2012-10-03 15:00:00	AMZN	Stock	12.7525	12.805	12.7245	12.792	15135540.0
2012-10-03 16:00:00	AMZN	Stock	12.7923	12.797	12.6164	12.6164	1839300.0
2012-10-03 17:00:00	AMZN	Stock	12.795	12.8025	12.795	12.8025	234020.0
2012-10-03 18:00:00	AMZN	Stock	12.8055	12.807	12.8055	12.807	20300.0
2012-10-03 19:00:00	AMZN	Stock	12.796	12.796	12.794	12.794	7800.0

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

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