PREVIEW / stock_1hour / 2012-08-02

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-08-02.parquet
  size:    920 KB
  rows:    43,661
  symbols: 3,454

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-08-02 04:00:00	AAPL	Stock	21.7071	21.7143	21.7	21.7143	15400.0
2012-08-02 05:00:00	AAPL	Stock	21.7321	21.75	21.7321	21.75	24360.0
2012-08-02 06:00:00	AAPL	Stock	21.7429	21.75	21.7429	21.75	31528.0
2012-08-02 07:00:00	AAPL	Stock	21.7321	21.7846	21.7075	21.7732	552804.0
2012-08-02 08:00:00	AAPL	Stock	21.7679	21.8071	21.5357	21.5625	4340448.0
2012-08-02 09:00:00	AAPL	Stock	21.5532	21.6946	21.4375	21.6829	58862132.0
2012-08-02 10:00:00	AAPL	Stock	21.6829	21.8104	21.6	21.7054	70764512.0
2012-08-02 11:00:00	AAPL	Stock	21.6982	21.7286	21.5471	21.5821	44665824.0
2012-08-02 12:00:00	AAPL	Stock	21.5814	21.6231	21.5214	21.6069	30168068.0
2012-08-02 13:00:00	AAPL	Stock	21.6029	21.6257	21.565	21.5786	16478336.0
2012-08-02 14:00:00	AAPL	Stock	21.5744	21.6764	21.5546	21.6571	26495308.0
2012-08-02 15:00:00	AAPL	Stock	21.6582	21.75	21.6511	21.7054	52115168.0
2012-08-02 16:00:00	AAPL	Stock	21.7068	21.7329	21.64	21.7329	5468596.0
2012-08-02 17:00:00	AAPL	Stock	21.7264	21.7271	21.715	21.7196	63840.0
2012-08-02 18:00:00	AAPL	Stock	21.7193	21.7193	21.7125	21.7143	28028.0
2012-08-02 19:00:00	AAPL	Stock	21.7179	21.7214	21.7071	21.7139	74480.0
2012-08-02 08:00:00	MSFT	Stock	29.57	29.59	29.25	29.26	8950.0
2012-08-02 09:00:00	MSFT	Stock	29.24	29.41	29.03	29.34	5012291.0
2012-08-02 10:00:00	MSFT	Stock	29.33	29.525	29.23	29.25	6923087.0
2012-08-02 11:00:00	MSFT	Stock	29.25	29.32	29.04	29.105	6818491.0
2012-08-02 12:00:00	MSFT	Stock	29.105	29.13	28.97	29.11	3899102.0
2012-08-02 13:00:00	MSFT	Stock	29.115	29.14	28.99	29.0	3618922.0
2012-08-02 14:00:00	MSFT	Stock	29.005	29.18	28.98	29.05	4106709.0
2012-08-02 15:00:00	MSFT	Stock	29.055	29.25	29.05	29.16	7441312.0
2012-08-02 16:00:00	MSFT	Stock	29.19	29.21	29.085	29.085	1586392.0
2012-08-02 17:00:00	MSFT	Stock	29.16	29.19	29.05	29.19	5980.0
2012-08-02 18:00:00	MSFT	Stock	29.11	29.16	29.11	29.16	1790.0
2012-08-02 19:00:00	MSFT	Stock	29.19	29.19	29.18	29.18	1640.0
2012-08-02 08:00:00	NVDA	Stock	0.34	0.34	0.332	0.332	50040.0
2012-08-02 09:00:00	NVDA	Stock	0.3348	0.3362	0.3275	0.336	33333640.0
2012-08-02 10:00:00	NVDA	Stock	0.336	0.341	0.3353	0.3384	107692600.0
2012-08-02 11:00:00	NVDA	Stock	0.3385	0.3393	0.3342	0.3353	67449520.0
2012-08-02 12:00:00	NVDA	Stock	0.335	0.3362	0.3333	0.3345	21193800.0
2012-08-02 13:00:00	NVDA	Stock	0.3345	0.335	0.3325	0.3325	19745920.0
2012-08-02 14:00:00	NVDA	Stock	0.3328	0.3345	0.3313	0.3335	31038480.0
2012-08-02 15:00:00	NVDA	Stock	0.3338	0.3368	0.3338	0.3358	76953040.0
2012-08-02 16:00:00	NVDA	Stock	0.336	0.3361	0.3359	0.336	10085680.0
2012-08-02 08:00:00	AMZN	Stock	11.661	11.678	11.533	11.545	254360.0
2012-08-02 09:00:00	AMZN	Stock	11.543	11.65	11.466	11.65	8368220.0
2012-08-02 10:00:00	AMZN	Stock	11.648	11.717	11.585	11.62	12826980.0
2012-08-02 11:00:00	AMZN	Stock	11.613	11.628	11.4385	11.4835	9079620.0
2012-08-02 12:00:00	AMZN	Stock	11.4835	11.538	11.433	11.4772	6956640.0
2012-08-02 13:00:00	AMZN	Stock	11.4755	11.4955	11.45	11.4695	4523160.0
2012-08-02 14:00:00	AMZN	Stock	11.469	11.566	11.467	11.5505	7756680.0
2012-08-02 15:00:00	AMZN	Stock	11.548	11.564	11.5165	11.54	9588840.0
2012-08-02 16:00:00	AMZN	Stock	11.5405	11.5645	11.5375	11.5395	1339600.0
2012-08-02 17:00:00	AMZN	Stock	11.5315	11.5315	11.5265	11.5265	9800.0
2012-08-02 18:00:00	AMZN	Stock	11.525	11.525	11.525	11.525	6000.0
2012-08-02 04:00:00	META	Stock	22.1	22.1	20.93	20.93	200.0
2012-08-02 05:00:00	META	Stock	21.09	21.09	21.09	21.09	800.0

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

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