PREVIEW / stock_1hour / 2011-12-19

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-12-19.parquet
  size:    939 KB
  rows:    44,985
  symbols: 3,535

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
2011-12-19 05:00:00	AAPL	Stock	13.6571	13.6571	13.6507	13.6507	8400.0
2011-12-19 06:00:00	AAPL	Stock	13.6557	13.6557	13.6557	13.6557	2800.0
2011-12-19 07:00:00	AAPL	Stock	13.6786	13.6786	13.6429	13.6518	232764.0
2011-12-19 08:00:00	AAPL	Stock	13.6457	13.6675	13.625	13.6571	746060.0
2011-12-19 09:00:00	AAPL	Stock	13.6607	13.7446	13.6454	13.7405	35110152.0
2011-12-19 10:00:00	AAPL	Stock	13.7407	13.7425	13.6754	13.6875	35751688.0
2011-12-19 11:00:00	AAPL	Stock	13.6846	13.6957	13.6257	13.6636	35075908.0
2011-12-19 12:00:00	AAPL	Stock	13.6639	13.6993	13.6578	13.6954	15459920.0
2011-12-19 13:00:00	AAPL	Stock	13.6954	13.7268	13.6693	13.7129	21500444.0
2011-12-19 14:00:00	AAPL	Stock	13.7132	13.7168	13.6621	13.6796	16138808.0
2011-12-19 15:00:00	AAPL	Stock	13.6795	13.6854	13.5886	13.6382	51410800.0
2011-12-19 16:00:00	AAPL	Stock	13.6482	13.6804	13.6396	13.6775	18762912.0
2011-12-19 17:00:00	AAPL	Stock	13.6714	13.6964	13.6504	13.6607	1232868.0
2011-12-19 18:00:00	AAPL	Stock	13.6661	13.6907	13.6504	13.6904	372652.0
2011-12-19 19:00:00	AAPL	Stock	13.6907	13.7143	13.6893	13.7093	398748.0
2011-12-19 04:00:00	MSFT	Stock	26.0	26.01	26.0	26.01	200.0
2011-12-19 07:00:00	MSFT	Stock	26.0	26.07	26.0	26.07	8400.0
2011-12-19 08:00:00	MSFT	Stock	26.06	26.06	26.0	26.0	31450.0
2011-12-19 09:00:00	MSFT	Stock	25.99	26.12	25.89	25.9	4966639.0
2011-12-19 10:00:00	MSFT	Stock	25.9	25.92	25.78	25.81	7428723.0
2011-12-19 11:00:00	MSFT	Stock	25.8	25.82	25.74	25.8	5243924.0
2011-12-19 12:00:00	MSFT	Stock	25.79	25.84	25.76	25.8	4242349.0
2011-12-19 13:00:00	MSFT	Stock	25.8	25.8	25.72	25.758	5315850.0
2011-12-19 14:00:00	MSFT	Stock	25.76	25.76	25.62	25.695	3384856.0
2011-12-19 15:00:00	MSFT	Stock	25.7	25.7	25.46	25.52	14791714.0
2011-12-19 16:00:00	MSFT	Stock	25.52	25.996	25.5	25.59	5083650.0
2011-12-19 17:00:00	MSFT	Stock	25.53	25.59	25.53	25.59	9552.0
2011-12-19 18:00:00	MSFT	Stock	25.53	25.6	25.53	25.58	17340.0
2011-12-19 19:00:00	MSFT	Stock	25.6	25.6	25.57	25.57	6000.0
2011-12-19 08:00:00	NVDA	Stock	0.3398	0.342	0.3378	0.34	81520.0
2011-12-19 09:00:00	NVDA	Stock	0.3402	0.3433	0.3365	0.3413	41173800.0
2011-12-19 10:00:00	NVDA	Stock	0.3413	0.3415	0.3362	0.3368	56536520.0
2011-12-19 11:00:00	NVDA	Stock	0.3365	0.3373	0.3315	0.3329	73585400.0
2011-12-19 12:00:00	NVDA	Stock	0.333	0.335	0.3322	0.333	40019680.0
2011-12-19 13:00:00	NVDA	Stock	0.333	0.337	0.333	0.3362	50588120.0
2011-12-19 14:00:00	NVDA	Stock	0.336	0.3362	0.3318	0.3324	60606840.0
2011-12-19 15:00:00	NVDA	Stock	0.3325	0.3325	0.3278	0.3288	129046440.0
2011-12-19 16:00:00	NVDA	Stock	0.3288	0.3342	0.328	0.329	10847400.0
2011-12-19 17:00:00	NVDA	Stock	0.329	0.33	0.329	0.33	81720.0
2011-12-19 18:00:00	NVDA	Stock	0.33	0.332	0.33	0.332	56000.0
2011-12-19 19:00:00	NVDA	Stock	0.332	0.3338	0.332	0.3325	119000.0
2011-12-19 07:00:00	AMZN	Stock	9.1595	9.1595	9.1585	9.1595	16000.0
2011-12-19 08:00:00	AMZN	Stock	9.1055	9.123	9.0995	9.1	102100.0
2011-12-19 09:00:00	AMZN	Stock	9.11	9.125	9.0205	9.0838	15690360.0
2011-12-19 10:00:00	AMZN	Stock	9.084	9.1585	9.0566	9.0725	15560260.0
2011-12-19 11:00:00	AMZN	Stock	9.0702	9.0942	9.0285	9.0585	10506840.0
2011-12-19 12:00:00	AMZN	Stock	9.057	9.13	9.053	9.0995	7732020.0
2011-12-19 13:00:00	AMZN	Stock	9.0975	9.107	9.0705	9.0925	6885460.0
2011-12-19 14:00:00	AMZN	Stock	9.0935	9.105	9.05	9.056	7811860.0
2011-12-19 15:00:00	AMZN	Stock	9.0545	9.0565	8.95	8.974	20968420.0

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

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