PREVIEW / stock_1hour / 2013-03-12

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-03-12.parquet
  size:    970 KB
  rows:    45,533
  symbols: 3,465

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
2013-03-12 04:00:00	AAPL	Stock	15.5382	15.5382	15.5382	15.5382	2800.0
2013-03-12 05:00:00	AAPL	Stock	15.5625	15.5893	15.5539	15.5604	47600.0
2013-03-12 06:00:00	AAPL	Stock	15.5875	15.5893	15.5721	15.5857	28000.0
2013-03-12 07:00:00	AAPL	Stock	15.5854	15.5857	15.4679	15.4696	832076.0
2013-03-12 08:00:00	AAPL	Stock	15.4925	15.6068	15.4861	15.5057	2713256.0
2013-03-12 09:00:00	AAPL	Stock	15.5104	15.6743	15.4821	15.5954	82533976.0
2013-03-12 10:00:00	AAPL	Stock	15.595	15.6293	15.3871	15.4482	88356128.0
2013-03-12 11:00:00	AAPL	Stock	15.4514	15.4525	15.3314	15.4146	70508592.0
2013-03-12 12:00:00	AAPL	Stock	15.4157	15.4375	15.3571	15.4207	33817224.0
2013-03-12 13:00:00	AAPL	Stock	15.4189	15.4789	15.3664	15.39	39364948.0
2013-03-12 14:00:00	AAPL	Stock	15.3914	15.3961	15.3161	15.3246	39409468.0
2013-03-12 15:00:00	AAPL	Stock	15.3218	15.4064	15.2704	15.3036	76507620.0
2013-03-12 16:00:00	AAPL	Stock	15.3036	15.6458	15.2882	15.2918	26095132.0
2013-03-12 17:00:00	AAPL	Stock	15.2914	15.3011	15.2521	15.2639	1079372.0
2013-03-12 18:00:00	AAPL	Stock	15.2675	15.275	15.2464	15.275	414176.0
2013-03-12 19:00:00	AAPL	Stock	15.2732	15.2775	15.2511	15.2554	422352.0
2013-03-12 07:00:00	MSFT	Stock	27.84	27.84	27.84	27.84	500.0
2013-03-12 08:00:00	MSFT	Stock	27.84	27.84	27.71	27.81	5815.0
2013-03-12 09:00:00	MSFT	Stock	27.77	27.91	27.74	27.87	3023218.0
2013-03-12 10:00:00	MSFT	Stock	27.87	27.88	27.74	27.76	5112851.0
2013-03-12 11:00:00	MSFT	Stock	27.76	27.77	27.64	27.735	8537740.0
2013-03-12 12:00:00	MSFT	Stock	27.738	27.8	27.7	27.782	3529681.0
2013-03-12 13:00:00	MSFT	Stock	27.787	27.805	27.74	27.754	3157498.0
2013-03-12 14:00:00	MSFT	Stock	27.76	27.81	27.74	27.78	3749434.0
2013-03-12 15:00:00	MSFT	Stock	27.784	27.95	27.78	27.92	7969764.0
2013-03-12 16:00:00	MSFT	Stock	27.92	27.93	27.716	27.716	1876962.0
2013-03-12 17:00:00	MSFT	Stock	27.92	27.94	27.92	27.94	3300.0
2013-03-12 18:00:00	MSFT	Stock	27.92	27.93	27.92	27.93	3870.0
2013-03-12 19:00:00	MSFT	Stock	27.93	27.93	27.92	27.92	2995.0
2013-03-12 09:00:00	NVDA	Stock	0.3163	0.3183	0.3153	0.3163	28308320.0
2013-03-12 10:00:00	NVDA	Stock	0.3163	0.3179	0.316	0.3163	40196720.0
2013-03-12 11:00:00	NVDA	Stock	0.3165	0.3165	0.3145	0.3159	37280720.0
2013-03-12 12:00:00	NVDA	Stock	0.316	0.3163	0.314	0.3145	21663920.0
2013-03-12 13:00:00	NVDA	Stock	0.3145	0.3163	0.314	0.3153	18670000.0
2013-03-12 14:00:00	NVDA	Stock	0.3155	0.3158	0.3148	0.3158	25744000.0
2013-03-12 15:00:00	NVDA	Stock	0.3158	0.3195	0.3155	0.3188	124934640.0
2013-03-12 16:00:00	NVDA	Stock	0.3188	0.3188	0.3168	0.3173	3398600.0
2013-03-12 18:00:00	NVDA	Stock	0.3165	0.3165	0.3165	0.3165	12000.0
2013-03-12 04:00:00	AMZN	Stock	13.5065	13.5065	13.5065	13.5065	2000.0
2013-03-12 05:00:00	AMZN	Stock	13.5875	13.5875	13.5875	13.5875	2000.0
2013-03-12 08:00:00	AMZN	Stock	13.55	13.55	13.5305	13.5305	4000.0
2013-03-12 09:00:00	AMZN	Stock	13.5305	13.8175	13.518	13.7476	16620700.0
2013-03-12 10:00:00	AMZN	Stock	13.749	13.87	13.7415	13.763	13682100.0
2013-03-12 11:00:00	AMZN	Stock	13.7715	13.784	13.582	13.7175	12008820.0
2013-03-12 12:00:00	AMZN	Stock	13.707	13.718	13.654	13.6895	4694780.0
2013-03-12 13:00:00	AMZN	Stock	13.6955	13.7125	13.6265	13.636	3182740.0
2013-03-12 14:00:00	AMZN	Stock	13.6365	13.672	13.6	13.6435	3880520.0
2013-03-12 15:00:00	AMZN	Stock	13.645	13.714	13.6445	13.709	7804920.0
2013-03-12 16:00:00	AMZN	Stock	13.7065	13.7178	13.6384	13.7	2683220.0
2013-03-12 18:00:00	AMZN	Stock	13.687	13.687	13.686	13.686	4000.0

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

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