PREVIEW / stock_1hour / 2012-06-19

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-06-19.parquet
  size:    959 KB
  rows:    45,338
  symbols: 3,538

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-06-19 04:00:00	AAPL	Stock	20.8575	20.875	20.8571	20.875	38500.0
2012-06-19 05:00:00	AAPL	Stock	20.85	20.9286	20.85	20.9286	51800.0
2012-06-19 06:00:00	AAPL	Stock	20.9286	20.9286	20.9107	20.9107	7700.0
2012-06-19 07:00:00	AAPL	Stock	20.9193	20.98	20.8682	20.8821	1575084.0
2012-06-19 08:00:00	AAPL	Stock	20.8929	20.9639	20.8036	20.85	4272716.0
2012-06-19 09:00:00	AAPL	Stock	20.8393	21.0532	20.825	20.9543	82035436.0
2012-06-19 10:00:00	AAPL	Stock	20.9581	20.9764	20.8636	20.9354	69182652.0
2012-06-19 11:00:00	AAPL	Stock	20.9334	21.0257	20.8929	20.9893	40121368.0
2012-06-19 12:00:00	AAPL	Stock	20.9883	21.0107	20.9682	20.9936	17927812.0
2012-06-19 13:00:00	AAPL	Stock	20.99	21.0714	20.9739	21.0296	37102436.0
2012-06-19 14:00:00	AAPL	Stock	21.0325	21.0589	20.9219	20.9978	46550784.0
2012-06-19 15:00:00	AAPL	Stock	20.9971	21.0425	20.9489	20.9764	52950128.0
2012-06-19 16:00:00	AAPL	Stock	20.9789	20.9869	20.9643	20.9668	7501732.0
2012-06-19 17:00:00	AAPL	Stock	20.9796	20.9796	20.9586	20.9643	214928.0
2012-06-19 18:00:00	AAPL	Stock	20.9625	20.9714	20.9607	20.9714	117824.0
2012-06-19 19:00:00	AAPL	Stock	20.9721	20.9721	20.9468	20.9554	250768.0
2012-06-19 04:00:00	MSFT	Stock	30.0	30.0	30.0	30.0	1400.0
2012-06-19 06:00:00	MSFT	Stock	30.03	30.03	30.03	30.03	200.0
2012-06-19 07:00:00	MSFT	Stock	30.03	30.14	30.03	30.1	40036.0
2012-06-19 08:00:00	MSFT	Stock	30.13	30.13	29.9	30.02	151298.0
2012-06-19 09:00:00	MSFT	Stock	30.0	30.8	30.0	30.768	15136716.0
2012-06-19 10:00:00	MSFT	Stock	30.765	31.06	30.74	31.04	17089548.0
2012-06-19 11:00:00	MSFT	Stock	31.04	31.11	30.92	30.98	9098064.0
2012-06-19 12:00:00	MSFT	Stock	30.975	31.03	30.85	30.945	6150164.0
2012-06-19 13:00:00	MSFT	Stock	30.94	31.01	30.89	30.93	5879231.0
2012-06-19 14:00:00	MSFT	Stock	30.92	30.94	30.68	30.74	6920637.0
2012-06-19 15:00:00	MSFT	Stock	30.74	30.81	30.64	30.69	10632381.0
2012-06-19 16:00:00	MSFT	Stock	30.665	30.946	30.522	30.69	3301033.0
2012-06-19 17:00:00	MSFT	Stock	30.865	30.865	30.68	30.68	179087.0
2012-06-19 18:00:00	MSFT	Stock	30.69	30.7	30.69	30.69	3776.0
2012-06-19 19:00:00	MSFT	Stock	30.69	30.7	30.68	30.7	10312.0
2012-06-19 05:00:00	NVDA	Stock	0.3135	0.3138	0.3135	0.3138	28000.0
2012-06-19 07:00:00	NVDA	Stock	0.3163	0.3175	0.3163	0.3175	152200.0
2012-06-19 08:00:00	NVDA	Stock	0.3133	0.318	0.3133	0.3153	515600.0
2012-06-19 09:00:00	NVDA	Stock	0.3175	0.3273	0.3165	0.3273	168137080.0
2012-06-19 10:00:00	NVDA	Stock	0.3272	0.3308	0.3255	0.3303	168866760.0
2012-06-19 11:00:00	NVDA	Stock	0.3302	0.3333	0.3295	0.3322	134029040.0
2012-06-19 12:00:00	NVDA	Stock	0.3324	0.3328	0.33	0.3314	54475560.0
2012-06-19 13:00:00	NVDA	Stock	0.3314	0.3358	0.331	0.3345	112143560.0
2012-06-19 14:00:00	NVDA	Stock	0.3342	0.3345	0.3308	0.333	112574160.0
2012-06-19 15:00:00	NVDA	Stock	0.333	0.333	0.3303	0.331	146083120.0
2012-06-19 16:00:00	NVDA	Stock	0.3313	0.3334	0.33	0.3307	5403760.0
2012-06-19 17:00:00	NVDA	Stock	0.3308	0.3313	0.3308	0.331	198000.0
2012-06-19 18:00:00	NVDA	Stock	0.3313	0.3313	0.3313	0.3313	8000.0
2012-06-19 19:00:00	NVDA	Stock	0.3313	0.3325	0.3313	0.3313	80000.0
2012-06-19 07:00:00	AMZN	Stock	11.194	11.1995	11.14	11.15	36000.0
2012-06-19 08:00:00	AMZN	Stock	11.1405	11.1405	11.1	11.115	134900.0
2012-06-19 09:00:00	AMZN	Stock	11.13	11.224	11.083	11.1485	11202620.0
2012-06-19 10:00:00	AMZN	Stock	11.1485	11.212	11.145	11.1925	9154420.0
2012-06-19 11:00:00	AMZN	Stock	11.1935	11.245	11.167	11.2335	5992980.0

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

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