PREVIEW / stock_1hour / 2011-12-01

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-12-01.parquet
  size:    923 KB
  rows:    43,946
  symbols: 3,533

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-01 04:00:00	AAPL	Stock	13.5957	13.6	13.5954	13.6	25200.0
2011-12-01 05:00:00	AAPL	Stock	13.625	13.6429	13.625	13.6429	21840.0
2011-12-01 06:00:00	AAPL	Stock	13.6379	13.6429	13.6379	13.6429	33740.0
2011-12-01 07:00:00	AAPL	Stock	13.65	13.7107	13.65	13.7054	559692.0
2011-12-01 08:00:00	AAPL	Stock	13.71	13.71	13.6286	13.6389	1641612.0
2011-12-01 09:00:00	AAPL	Stock	13.6361	13.7479	13.5982	13.7454	51803248.0
2011-12-01 10:00:00	AAPL	Stock	13.7425	13.7961	13.7179	13.7268	74772684.0
2011-12-01 11:00:00	AAPL	Stock	13.7261	13.7696	13.7179	13.7607	40524512.0
2011-12-01 12:00:00	AAPL	Stock	13.7611	13.8189	13.7543	13.79	36718948.0
2011-12-01 13:00:00	AAPL	Stock	13.79	13.8686	13.7611	13.8663	40973968.0
2011-12-01 14:00:00	AAPL	Stock	13.8652	13.8893	13.8393	13.8786	40449276.0
2011-12-01 15:00:00	AAPL	Stock	13.8786	13.8929	13.804	13.8507	79667532.0
2011-12-01 16:00:00	AAPL	Stock	13.8454	13.878	13.65	13.8464	11103876.0
2011-12-01 17:00:00	AAPL	Stock	13.8496	13.8571	13.8482	13.8554	215404.0
2011-12-01 18:00:00	AAPL	Stock	13.8507	13.8557	13.8232	13.8429	518784.0
2011-12-01 19:00:00	AAPL	Stock	13.8429	13.8643	13.8429	13.8643	481040.0
2011-12-01 05:00:00	MSFT	Stock	25.5	25.5	25.5	25.5	200.0
2011-12-01 08:00:00	MSFT	Stock	25.44	25.58	25.44	25.49	39355.0
2011-12-01 09:00:00	MSFT	Stock	25.42	25.65	25.32	25.39	4886274.0
2011-12-01 10:00:00	MSFT	Stock	25.39	25.49	25.27	25.3	7767067.0
2011-12-01 11:00:00	MSFT	Stock	25.3	25.38	25.2	25.35	6309729.0
2011-12-01 12:00:00	MSFT	Stock	25.35	25.36	25.275	25.31	4341903.0
2011-12-01 13:00:00	MSFT	Stock	25.306	25.39	25.28	25.375	3784613.0
2011-12-01 14:00:00	MSFT	Stock	25.375	25.38	25.285	25.3	4494958.0
2011-12-01 15:00:00	MSFT	Stock	25.3	25.37	25.26	25.27	12370975.0
2011-12-01 16:00:00	MSFT	Stock	25.273	25.345	25.22	25.27	3584080.0
2011-12-01 17:00:00	MSFT	Stock	25.27	25.28	25.26	25.27	2770.0
2011-12-01 18:00:00	MSFT	Stock	25.28	25.28	25.25	25.27	11447.0
2011-12-01 19:00:00	MSFT	Stock	25.26	25.33	25.26	25.33	11686.0
2011-12-01 07:00:00	NVDA	Stock	0.3968	0.3968	0.3682	0.3713	76000.0
2011-12-01 08:00:00	NVDA	Stock	0.393	0.393	0.3875	0.3882	64000.0
2011-12-01 09:00:00	NVDA	Stock	0.3882	0.395	0.3848	0.3933	60151160.0
2011-12-01 10:00:00	NVDA	Stock	0.3935	0.3948	0.3876	0.3888	83647920.0
2011-12-01 11:00:00	NVDA	Stock	0.3888	0.3919	0.3875	0.3908	70630920.0
2011-12-01 12:00:00	NVDA	Stock	0.3908	0.3915	0.388	0.3885	32167640.0
2011-12-01 13:00:00	NVDA	Stock	0.3885	0.3942	0.3883	0.3942	40902160.0
2011-12-01 14:00:00	NVDA	Stock	0.3942	0.395	0.3913	0.3935	93805800.0
2011-12-01 15:00:00	NVDA	Stock	0.3933	0.3965	0.392	0.3955	135275800.0
2011-12-01 16:00:00	NVDA	Stock	0.3955	0.396	0.3908	0.3952	4802760.0
2011-12-01 17:00:00	NVDA	Stock	0.3948	0.397	0.3948	0.397	202000.0
2011-12-01 19:00:00	NVDA	Stock	0.3933	0.3955	0.3933	0.3955	116000.0
2011-12-01 05:00:00	AMZN	Stock	9.675	9.7	9.6425	9.6425	16000.0
2011-12-01 07:00:00	AMZN	Stock	9.6425	9.6625	9.6255	9.637	47020.0
2011-12-01 08:00:00	AMZN	Stock	9.63	9.6325	9.5305	9.54	241140.0
2011-12-01 09:00:00	AMZN	Stock	9.545	9.849	9.5	9.78	24472760.0
2011-12-01 10:00:00	AMZN	Stock	9.7875	9.845	9.7675	9.7838	19611780.0
2011-12-01 11:00:00	AMZN	Stock	9.784	9.885	9.775	9.8845	24340100.0
2011-12-01 12:00:00	AMZN	Stock	9.885	9.9038	9.7375	9.8135	27772060.0
2011-12-01 13:00:00	AMZN	Stock	9.8165	9.8975	9.794	9.8975	11227100.0
2011-12-01 14:00:00	AMZN	Stock	9.897	9.8974	9.8025	9.8455	11438160.0

> showing 50 of 43,946 rows — these rows as CSV

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