PREVIEW / stock_1hour / 2012-12-18

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-12-18.parquet
  size:    976 KB
  rows:    45,615
  symbols: 3,510

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-12-18 04:00:00	AAPL	Stock	18.7429	18.7918	18.7071	18.7143	166684.0
2012-12-18 05:00:00	AAPL	Stock	18.7143	18.7161	18.5911	18.6275	95200.0
2012-12-18 06:00:00	AAPL	Stock	18.6271	18.6429	18.6071	18.6071	143892.0
2012-12-18 07:00:00	AAPL	Stock	18.5982	18.8214	18.5946	18.8125	4240824.0
2012-12-18 08:00:00	AAPL	Stock	18.8096	18.8518	18.7143	18.7264	9548504.0
2012-12-18 09:00:00	AAPL	Stock	18.7279	18.8	18.6168	18.6393	104065500.0
2012-12-18 10:00:00	AAPL	Stock	18.6289	18.7218	18.5804	18.6446	86466856.0
2012-12-18 11:00:00	AAPL	Stock	18.6493	18.855	18.625	18.8204	75283544.0
2012-12-18 12:00:00	AAPL	Stock	18.8243	19.0279	18.7779	18.9982	97169492.0
2012-12-18 13:00:00	AAPL	Stock	19.0046	19.0179	18.9018	18.9393	58185148.0
2012-12-18 14:00:00	AAPL	Stock	18.9386	18.9871	18.8493	18.9568	57780660.0
2012-12-18 15:00:00	AAPL	Stock	18.9532	19.1036	18.9357	19.0661	107813804.0
2012-12-18 16:00:00	AAPL	Stock	19.0653	19.0857	18.63	19.025	13766340.0
2012-12-18 17:00:00	AAPL	Stock	19.0179	19.0621	18.6823	19.0275	686028.0
2012-12-18 18:00:00	AAPL	Stock	19.0268	19.0493	19.0179	19.0386	238756.0
2012-12-18 19:00:00	AAPL	Stock	19.0464	19.0571	19.0325	19.0571	675500.0
2012-12-18 05:00:00	MSFT	Stock	27.19	27.19	27.19	27.19	100.0
2012-12-18 07:00:00	MSFT	Stock	27.2	27.25	27.2	27.24	2800.0
2012-12-18 08:00:00	MSFT	Stock	27.25	27.31	27.09	27.29	96383.0
2012-12-18 09:00:00	MSFT	Stock	27.28	27.33	27.09	27.18	4308831.0
2012-12-18 10:00:00	MSFT	Stock	27.17	27.43	27.14	27.355	8954882.0
2012-12-18 11:00:00	MSFT	Stock	27.35	27.49	27.3	27.44	6444763.0
2012-12-18 12:00:00	MSFT	Stock	27.44	27.5	27.38	27.495	4561800.0
2012-12-18 13:00:00	MSFT	Stock	27.495	27.5	27.37	27.5	5053731.0
2012-12-18 14:00:00	MSFT	Stock	27.5	27.54	27.44	27.456	4926990.0
2012-12-18 15:00:00	MSFT	Stock	27.46	27.63	27.45	27.57	11266007.0
2012-12-18 16:00:00	MSFT	Stock	27.56	27.639	27.068	27.54	2368303.0
2012-12-18 17:00:00	MSFT	Stock	27.54	27.59	27.341	27.59	30448.0
2012-12-18 18:00:00	MSFT	Stock	27.57	27.58	27.459	27.55	6610.0
2012-12-18 19:00:00	MSFT	Stock	27.58	27.58	27.49	27.49	7622.0
2012-12-18 09:00:00	NVDA	Stock	0.3135	0.3155	0.313	0.3148	39837600.0
2012-12-18 10:00:00	NVDA	Stock	0.315	0.3168	0.3135	0.3155	67775200.0
2012-12-18 11:00:00	NVDA	Stock	0.3158	0.3175	0.315	0.3156	45379240.0
2012-12-18 12:00:00	NVDA	Stock	0.3155	0.3172	0.3148	0.3168	42261720.0
2012-12-18 13:00:00	NVDA	Stock	0.3168	0.3169	0.3148	0.3155	32024440.0
2012-12-18 14:00:00	NVDA	Stock	0.3155	0.3158	0.3138	0.3138	46444040.0
2012-12-18 15:00:00	NVDA	Stock	0.314	0.315	0.3125	0.3143	114483640.0
2012-12-18 16:00:00	NVDA	Stock	0.3145	0.3164	0.3133	0.3133	4837640.0
2012-12-18 17:00:00	NVDA	Stock	0.3143	0.3143	0.3138	0.3143	47200.0
2012-12-18 18:00:00	NVDA	Stock	0.3138	0.3138	0.3138	0.3138	8000.0
2012-12-18 19:00:00	NVDA	Stock	0.3128	0.3138	0.3128	0.3138	36000.0
2012-12-18 06:00:00	AMZN	Stock	12.7375	12.7375	12.7	12.7	26000.0
2012-12-18 07:00:00	AMZN	Stock	12.728	12.762	12.728	12.75	104700.0
2012-12-18 08:00:00	AMZN	Stock	12.7985	12.799	12.68	12.7525	930380.0
2012-12-18 09:00:00	AMZN	Stock	12.7525	12.925	12.7285	12.8625	17543360.0
2012-12-18 10:00:00	AMZN	Stock	12.8695	13.047	12.8575	13.0175	16827700.0
2012-12-18 11:00:00	AMZN	Stock	13.0185	13.0935	12.9975	13.061	12880540.0
2012-12-18 12:00:00	AMZN	Stock	13.0605	13.154	13.02	13.154	10958300.0
2012-12-18 13:00:00	AMZN	Stock	13.15	13.1555	13.0375	13.0548	9005680.0
2012-12-18 14:00:00	AMZN	Stock	13.052	13.092	12.964	13.0035	12341800.0

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

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