PREVIEW / stock_1hour / 2011-02-24

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-02-24.parquet
  size:    945 KB
  rows:    44,962
  symbols: 3,530

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-02-24 04:00:00	AAPL	Stock	12.2625	12.2625	12.2625	12.2625	2800.0
2011-02-24 05:00:00	AAPL	Stock	12.2436	12.25	12.2429	12.2429	11200.0
2011-02-24 06:00:00	AAPL	Stock	12.2107	12.225	12.2107	12.2125	89600.0
2011-02-24 07:00:00	AAPL	Stock	12.2125	12.215	12.1725	12.1786	208600.0
2011-02-24 08:00:00	AAPL	Stock	12.1911	12.2843	12.175	12.2739	2553908.0
2011-02-24 09:00:00	AAPL	Stock	12.2768	12.3332	12.2521	12.2839	69105988.0
2011-02-24 10:00:00	AAPL	Stock	12.2839	12.2943	12.1861	12.1864	76089244.0
2011-02-24 11:00:00	AAPL	Stock	12.1864	12.2082	12.1275	12.175	81192524.0
2011-02-24 12:00:00	AAPL	Stock	12.175	12.1918	12.1293	12.1843	35924476.0
2011-02-24 13:00:00	AAPL	Stock	12.1839	12.1964	12.0846	12.0964	48263432.0
2011-02-24 14:00:00	AAPL	Stock	12.095	12.2286	12.0936	12.2218	71399216.0
2011-02-24 15:00:00	AAPL	Stock	12.2207	12.2857	12.2021	12.2346	84727972.0
2011-02-24 16:00:00	AAPL	Stock	12.235	12.2781	12.1808	12.2107	15745184.0
2011-02-24 17:00:00	AAPL	Stock	12.2107	12.2364	12.2107	12.2229	883008.0
2011-02-24 18:00:00	AAPL	Stock	12.2314	12.2493	12.225	12.2464	435792.0
2011-02-24 19:00:00	AAPL	Stock	12.2482	12.2564	12.2482	12.2554	154476.0
2011-02-24 04:00:00	MSFT	Stock	26.39	26.39	26.38	26.38	200.0
2011-02-24 06:00:00	MSFT	Stock	26.38	26.4	26.35	26.35	1100.0
2011-02-24 07:00:00	MSFT	Stock	26.44	26.55	26.39	26.4	7525.0
2011-02-24 08:00:00	MSFT	Stock	26.44	26.64	26.4	26.53	21404.0
2011-02-24 09:00:00	MSFT	Stock	26.54	26.95	26.54	26.92	6967876.0
2011-02-24 10:00:00	MSFT	Stock	26.92	27.06	26.78	26.82	11485288.0
2011-02-24 11:00:00	MSFT	Stock	26.82	26.85	26.62	26.7	6674071.0
2011-02-24 12:00:00	MSFT	Stock	26.695	26.72	26.58	26.688	4571231.0
2011-02-24 13:00:00	MSFT	Stock	26.68	26.74	26.5	26.546	5291872.0
2011-02-24 14:00:00	MSFT	Stock	26.55	26.93	26.54	26.88	11424703.0
2011-02-24 15:00:00	MSFT	Stock	26.88	26.95	26.75	26.76	10921660.0
2011-02-24 16:00:00	MSFT	Stock	26.77	26.88	26.699	26.699	4024024.0
2011-02-24 17:00:00	MSFT	Stock	26.75	26.77	26.59	26.77	47600.0
2011-02-24 18:00:00	MSFT	Stock	26.77	26.79	26.77	26.77	5794.0
2011-02-24 19:00:00	MSFT	Stock	26.79	26.79	26.79	26.79	2000.0
2011-02-24 04:00:00	NVDA	Stock	0.5468	0.5468	0.5468	0.5468	4000.0
2011-02-24 06:00:00	NVDA	Stock	0.547	0.547	0.547	0.547	20800.0
2011-02-24 07:00:00	NVDA	Stock	0.5472	0.5498	0.5435	0.545	678920.0
2011-02-24 08:00:00	NVDA	Stock	0.545	0.5588	0.545	0.5585	2286320.0
2011-02-24 09:00:00	NVDA	Stock	0.557	0.571	0.5545	0.5662	182336560.0
2011-02-24 10:00:00	NVDA	Stock	0.5662	0.576	0.5632	0.5652	250183880.0
2011-02-24 11:00:00	NVDA	Stock	0.565	0.5665	0.5552	0.5595	185510160.0
2011-02-24 12:00:00	NVDA	Stock	0.5592	0.5602	0.554	0.5595	132604360.0
2011-02-24 13:00:00	NVDA	Stock	0.5595	0.561	0.5515	0.5538	130413920.0
2011-02-24 14:00:00	NVDA	Stock	0.5538	0.5648	0.5535	0.5612	166161960.0
2011-02-24 15:00:00	NVDA	Stock	0.561	0.5715	0.5595	0.5662	182051480.0
2011-02-24 16:00:00	NVDA	Stock	0.5668	0.5692	0.5626	0.567	4511600.0
2011-02-24 17:00:00	NVDA	Stock	0.5652	0.5675	0.5528	0.5675	344800.0
2011-02-24 18:00:00	NVDA	Stock	0.5662	0.5672	0.5655	0.5662	245960.0
2011-02-24 19:00:00	NVDA	Stock	0.5662	0.5675	0.5662	0.5662	214400.0
2011-02-24 04:00:00	AMZN	Stock	8.8125	8.8125	8.8125	8.8125	2000.0
2011-02-24 08:00:00	AMZN	Stock	8.803	8.8655	8.8025	8.8655	13600.0
2011-02-24 09:00:00	AMZN	Stock	8.864	8.9593	8.802	8.954	12699020.0
2011-02-24 10:00:00	AMZN	Stock	8.954	8.9875	8.858	8.889	16017360.0

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

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