PREVIEW / stock_1hour / 2012-10-05

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-10-05.parquet
  size:    929 KB
  rows:    43,876
  symbols: 3,457

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-10-05 04:00:00	AAPL	Stock	23.7857	23.7857	23.7857	23.7857	11200.0
2012-10-05 06:00:00	AAPL	Stock	23.8132	23.8132	23.8036	23.8036	26600.0
2012-10-05 07:00:00	AAPL	Stock	23.7961	23.8075	23.7679	23.8032	373352.0
2012-10-05 08:00:00	AAPL	Stock	23.8018	23.8571	23.7339	23.8061	3254048.0
2012-10-05 09:00:00	AAPL	Stock	23.8064	23.8429	23.665	23.7504	67079152.0
2012-10-05 10:00:00	AAPL	Stock	23.7479	23.7761	23.55	23.5536	80289076.0
2012-10-05 11:00:00	AAPL	Stock	23.5561	23.6029	23.4414	23.4589	80442600.0
2012-10-05 12:00:00	AAPL	Stock	23.4593	23.5529	23.3132	23.5259	103530056.0
2012-10-05 13:00:00	AAPL	Stock	23.5257	23.5857	23.4007	23.5282	60183592.0
2012-10-05 14:00:00	AAPL	Stock	23.5284	23.5284	23.3304	23.3521	53184628.0
2012-10-05 15:00:00	AAPL	Stock	23.3504	23.4093	23.26	23.3064	115215660.0
2012-10-05 16:00:00	AAPL	Stock	23.3089	23.6255	23.2964	23.3143	14043400.0
2012-10-05 17:00:00	AAPL	Stock	23.3068	23.3107	23.2732	23.2732	1495704.0
2012-10-05 18:00:00	AAPL	Stock	23.2732	23.2779	23.25	23.25	288848.0
2012-10-05 19:00:00	AAPL	Stock	23.2561	23.2893	23.2511	23.2893	333844.0
2012-10-05 08:00:00	MSFT	Stock	30.0	30.17	30.0	30.17	28043.0
2012-10-05 09:00:00	MSFT	Stock	30.15	30.25	29.93	29.992	6117325.0
2012-10-05 10:00:00	MSFT	Stock	30.0	30.1	29.91	29.934	7366267.0
2012-10-05 11:00:00	MSFT	Stock	29.935	30.02	29.9	29.98	3941237.0
2012-10-05 12:00:00	MSFT	Stock	29.98	30.03	29.94	30.016	2536444.0
2012-10-05 13:00:00	MSFT	Stock	30.02	30.05	29.93	29.962	2959081.0
2012-10-05 14:00:00	MSFT	Stock	29.965	30.0	29.81	29.815	3478992.0
2012-10-05 15:00:00	MSFT	Stock	29.81	29.85	29.74	29.84	10066698.0
2012-10-05 16:00:00	MSFT	Stock	29.85	29.94	29.83	29.88	3256405.0
2012-10-05 17:00:00	MSFT	Stock	29.86	29.9	29.86	29.9	2178.0
2012-10-05 19:00:00	MSFT	Stock	29.87	29.87	29.86	29.86	1650.0
2012-10-05 07:00:00	NVDA	Stock	0.3488	0.3488	0.3488	0.3488	12000.0
2012-10-05 08:00:00	NVDA	Stock	0.3415	0.3415	0.3415	0.3415	40000.0
2012-10-05 09:00:00	NVDA	Stock	0.342	0.345	0.3393	0.3405	66897880.0
2012-10-05 10:00:00	NVDA	Stock	0.3402	0.3442	0.339	0.3412	54049120.0
2012-10-05 11:00:00	NVDA	Stock	0.341	0.3415	0.3402	0.3404	31388640.0
2012-10-05 12:00:00	NVDA	Stock	0.3402	0.3413	0.3395	0.341	35059640.0
2012-10-05 13:00:00	NVDA	Stock	0.3413	0.3415	0.3388	0.339	40455760.0
2012-10-05 14:00:00	NVDA	Stock	0.3393	0.3393	0.3328	0.3328	94099680.0
2012-10-05 15:00:00	NVDA	Stock	0.3329	0.3341	0.3313	0.3322	141595840.0
2012-10-05 16:00:00	NVDA	Stock	0.3325	0.3384	0.3324	0.3329	13330480.0
2012-10-05 17:00:00	NVDA	Stock	0.3405	0.3405	0.333	0.333	248000.0
2012-10-05 08:00:00	AMZN	Stock	13.025	13.0625	12.975	13.0455	183580.0
2012-10-05 09:00:00	AMZN	Stock	13.039	13.095	12.9815	13.0595	10415280.0
2012-10-05 10:00:00	AMZN	Stock	13.0615	13.0855	12.9895	13.005	9834980.0
2012-10-05 11:00:00	AMZN	Stock	13.0095	13.0185	12.9501	12.9602	6403520.0
2012-10-05 12:00:00	AMZN	Stock	12.963	12.9895	12.9375	12.952	5092140.0
2012-10-05 13:00:00	AMZN	Stock	12.952	12.989	12.9482	12.9575	4144160.0
2012-10-05 14:00:00	AMZN	Stock	12.9575	13.002	12.932	12.933	5387760.0
2012-10-05 15:00:00	AMZN	Stock	12.9355	12.957	12.8745	12.92	12271860.0
2012-10-05 16:00:00	AMZN	Stock	12.9255	12.9838	12.9	12.9075	1653280.0
2012-10-05 17:00:00	AMZN	Stock	12.9255	12.9255	12.9075	12.9075	97200.0
2012-10-05 18:00:00	AMZN	Stock	12.905	12.905	12.905	12.905	4000.0
2012-10-05 19:00:00	AMZN	Stock	12.905	12.905	12.905	12.905	12720.0
2012-10-05 05:00:00	META	Stock	21.7	21.7	21.5	21.5	7632.0

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

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