PREVIEW / stock_1hour / 2013-06-06

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-06-06.parquet
  size:    1008 KB
  rows:    47,264
  symbols: 3,483

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-06-06 05:00:00	AAPL	Stock	15.9418	15.9418	15.9393	15.9393	7000.0
2013-06-06 06:00:00	AAPL	Stock	15.9571	15.9757	15.9568	15.9757	36400.0
2013-06-06 07:00:00	AAPL	Stock	15.9836	15.9911	15.9432	15.9739	307776.0
2013-06-06 08:00:00	AAPL	Stock	15.9696	15.9696	15.8929	15.9375	1641528.0
2013-06-06 09:00:00	AAPL	Stock	15.9389	15.9643	15.7429	15.8028	62541612.0
2013-06-06 10:00:00	AAPL	Stock	15.8036	15.8125	15.6122	15.6864	79278668.0
2013-06-06 11:00:00	AAPL	Stock	15.6864	15.6925	15.6154	15.6154	47152476.0
2013-06-06 12:00:00	AAPL	Stock	15.6182	15.6371	15.5018	15.5429	59851820.0
2013-06-06 13:00:00	AAPL	Stock	15.5446	15.6893	15.5364	15.6532	45567480.0
2013-06-06 14:00:00	AAPL	Stock	15.6496	15.6975	15.5864	15.6454	33510400.0
2013-06-06 15:00:00	AAPL	Stock	15.641	15.6857	15.6046	15.6593	53132968.0
2013-06-06 16:00:00	AAPL	Stock	15.6591	15.7182	15.6414	15.6675	30224768.0
2013-06-06 17:00:00	AAPL	Stock	15.6625	15.6786	15.6593	15.6714	459116.0
2013-06-06 18:00:00	AAPL	Stock	15.6714	15.675	15.6646	15.665	61712.0
2013-06-06 19:00:00	AAPL	Stock	15.6714	15.6764	15.6661	15.6661	90832.0
2013-06-06 04:00:00	MSFT	Stock	34.75	34.75	34.75	34.75	500.0
2013-06-06 07:00:00	MSFT	Stock	34.78	34.9	34.78	34.9	2600.0
2013-06-06 08:00:00	MSFT	Stock	34.82	34.9	34.78	34.8	9166.0
2013-06-06 09:00:00	MSFT	Stock	34.82	35.11	34.79	35.01	4230294.0
2013-06-06 10:00:00	MSFT	Stock	35.005	35.08	34.825	34.86	5198212.0
2013-06-06 11:00:00	MSFT	Stock	34.86	34.92	34.82	34.83	4753110.0
2013-06-06 12:00:00	MSFT	Stock	34.83	34.85	34.53	34.6	3925837.0
2013-06-06 13:00:00	MSFT	Stock	34.6	34.675	34.49	34.518	3732695.0
2013-06-06 14:00:00	MSFT	Stock	34.515	34.8	34.51	34.795	4876860.0
2013-06-06 15:00:00	MSFT	Stock	34.795	34.95	34.7	34.95	7024874.0
2013-06-06 16:00:00	MSFT	Stock	34.95	34.98	34.76	34.965	3474775.0
2013-06-06 17:00:00	MSFT	Stock	34.78	34.96	34.78	34.95	1700.0
2013-06-06 18:00:00	MSFT	Stock	34.95	34.95	34.63	34.94	3711.0
2013-06-06 19:00:00	MSFT	Stock	34.93	34.93	34.9	34.9	5675.0
2013-06-06 09:00:00	NVDA	Stock	0.3542	0.3585	0.3538	0.3578	24342400.0
2013-06-06 10:00:00	NVDA	Stock	0.358	0.359	0.3562	0.358	41685400.0
2013-06-06 11:00:00	NVDA	Stock	0.3579	0.3584	0.3538	0.354	28461000.0
2013-06-06 12:00:00	NVDA	Stock	0.3541	0.3562	0.3538	0.3541	34196440.0
2013-06-06 13:00:00	NVDA	Stock	0.3542	0.3568	0.3538	0.3555	30663600.0
2013-06-06 14:00:00	NVDA	Stock	0.3555	0.3578	0.3553	0.3561	40803920.0
2013-06-06 15:00:00	NVDA	Stock	0.3562	0.3572	0.3553	0.3562	81333480.0
2013-06-06 16:00:00	NVDA	Stock	0.3565	0.3568	0.3562	0.3563	53972080.0
2013-06-06 17:00:00	NVDA	Stock	0.354	0.354	0.354	0.354	80000.0
2013-06-06 18:00:00	NVDA	Stock	0.3562	0.3562	0.3562	0.3562	5347320.0
2013-06-06 08:00:00	AMZN	Stock	13.425	13.4495	13.3485	13.369	215360.0
2013-06-06 09:00:00	AMZN	Stock	13.3945	13.525	13.2615	13.3315	10617680.0
2013-06-06 10:00:00	AMZN	Stock	13.3306	13.3795	13.268	13.346	5591740.0
2013-06-06 11:00:00	AMZN	Stock	13.3495	13.415	13.3115	13.357	5722240.0
2013-06-06 12:00:00	AMZN	Stock	13.35	13.359	13.216	13.225	8752200.0
2013-06-06 13:00:00	AMZN	Stock	13.225	13.305	13.2105	13.291	6184620.0
2013-06-06 14:00:00	AMZN	Stock	13.2855	13.382	13.2636	13.345	3177600.0
2013-06-06 15:00:00	AMZN	Stock	13.3395	13.394	13.3375	13.3915	6746080.0
2013-06-06 16:00:00	AMZN	Stock	13.3915	13.4215	13.339	13.3942	2263560.0
2013-06-06 17:00:00	AMZN	Stock	13.3585	13.3835	13.3238	13.3835	64000.0
2013-06-06 18:00:00	AMZN	Stock	13.3915	13.3915	13.3915	13.3915	145960.0

> showing 50 of 47,264 rows — these rows as CSV

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