PREVIEW / stock_1hour / 2013-10-16

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-10-16.parquet
  size:    1.0 MB
  rows:    48,188
  symbols: 3,558

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-10-16 04:00:00	AAPL	Stock	17.7514	17.8611	17.7211	17.7404	315448.0
2013-10-16 05:00:00	AAPL	Stock	17.75	17.7843	17.7325	17.7325	344932.0
2013-10-16 06:00:00	AAPL	Stock	17.75	17.7979	17.7236	17.7979	432936.0
2013-10-16 07:00:00	AAPL	Stock	17.7989	17.9286	17.7914	17.8868	2151324.0
2013-10-16 08:00:00	AAPL	Stock	17.8829	17.9318	17.75	17.9011	3069528.0
2013-10-16 09:00:00	AAPL	Stock	17.905	17.9475	17.8296	17.8371	61663364.0
2013-10-16 10:00:00	AAPL	Stock	17.8371	17.9068	17.8336	17.8689	45825836.0
2013-10-16 11:00:00	AAPL	Stock	17.8728	17.8929	17.8486	17.8839	22840244.0
2013-10-16 12:00:00	AAPL	Stock	17.885	17.9286	17.8714	17.9146	27753824.0
2013-10-16 13:00:00	AAPL	Stock	17.9139	17.9286	17.8782	17.8782	22067640.0
2013-10-16 14:00:00	AAPL	Stock	17.8782	17.9125	17.8754	17.8984	21023212.0
2013-10-16 15:00:00	AAPL	Stock	17.8979	17.915	17.8775	17.8957	30066148.0
2013-10-16 16:00:00	AAPL	Stock	17.8971	17.9066	17.7854	17.8571	9111368.0
2013-10-16 17:00:00	AAPL	Stock	17.8561	17.8969	17.8518	17.8969	658168.0
2013-10-16 18:00:00	AAPL	Stock	17.8661	17.8971	17.8625	17.8782	173600.0
2013-10-16 19:00:00	AAPL	Stock	17.8779	17.895	17.875	17.8911	604044.0
2013-10-16 05:00:00	MSFT	Stock	34.34	34.34	34.33	34.33	649.0
2013-10-16 06:00:00	MSFT	Stock	34.47	34.47	34.36	34.36	320.0
2013-10-16 07:00:00	MSFT	Stock	34.46	34.5	34.46	34.5	3249.0
2013-10-16 08:00:00	MSFT	Stock	34.55	34.67	34.49	34.67	7345.0
2013-10-16 09:00:00	MSFT	Stock	34.62	34.86	34.56	34.757	6176864.0
2013-10-16 10:00:00	MSFT	Stock	34.755	34.81	34.57	34.79	7656349.0
2013-10-16 11:00:00	MSFT	Stock	34.78	34.895	34.76	34.823	4217869.0
2013-10-16 12:00:00	MSFT	Stock	34.825	34.875	34.755	34.803	3252795.0
2013-10-16 13:00:00	MSFT	Stock	34.805	34.82	34.68	34.69	2695684.0
2013-10-16 14:00:00	MSFT	Stock	34.69	34.73	34.655	34.68	2452987.0
2013-10-16 15:00:00	MSFT	Stock	34.68	34.7	34.62	34.65	5432543.0
2013-10-16 16:00:00	MSFT	Stock	34.64	34.778	34.4	34.689	2625090.0
2013-10-16 17:00:00	MSFT	Stock	34.43	34.632	34.42	34.632	143706.0
2013-10-16 18:00:00	MSFT	Stock	34.896	34.896	34.5	34.54	7965.0
2013-10-16 19:00:00	MSFT	Stock	34.54	34.54	34.51	34.51	1700.0
2013-10-16 09:00:00	NVDA	Stock	0.3875	0.3915	0.387	0.3908	20128400.0
2013-10-16 10:00:00	NVDA	Stock	0.3908	0.3914	0.3882	0.3894	40566320.0
2013-10-16 11:00:00	NVDA	Stock	0.3894	0.3906	0.3891	0.3905	33235560.0
2013-10-16 12:00:00	NVDA	Stock	0.3905	0.3908	0.3893	0.3905	17551480.0
2013-10-16 13:00:00	NVDA	Stock	0.3905	0.3905	0.3895	0.3895	12860600.0
2013-10-16 14:00:00	NVDA	Stock	0.3898	0.39	0.3893	0.3898	19171680.0
2013-10-16 15:00:00	NVDA	Stock	0.3896	0.3902	0.3893	0.3902	41352560.0
2013-10-16 16:00:00	NVDA	Stock	0.39	0.3901	0.3847	0.39	17214080.0
2013-10-16 17:00:00	NVDA	Stock	0.3898	0.3898	0.3898	0.3898	400400.0
2013-10-16 18:00:00	NVDA	Stock	0.3894	0.3894	0.3894	0.3894	978360.0
2013-10-16 04:00:00	AMZN	Stock	15.335	15.3625	15.335	15.3625	8000.0
2013-10-16 07:00:00	AMZN	Stock	15.3625	15.3995	15.3625	15.3995	7360.0
2013-10-16 08:00:00	AMZN	Stock	15.3805	15.4515	15.3785	15.4205	109340.0
2013-10-16 09:00:00	AMZN	Stock	15.425	15.4325	15.2777	15.418	7443240.0
2013-10-16 10:00:00	AMZN	Stock	15.4155	15.5	15.3725	15.497	11706360.0
2013-10-16 11:00:00	AMZN	Stock	15.4895	15.5	15.4276	15.4605	4034620.0
2013-10-16 12:00:00	AMZN	Stock	15.4615	15.515	15.458	15.485	5818420.0
2013-10-16 13:00:00	AMZN	Stock	15.4875	15.505	15.4657	15.4825	2311760.0
2013-10-16 14:00:00	AMZN	Stock	15.4815	15.5	15.465	15.494	2886420.0

> showing 50 of 48,188 rows — these rows as CSV

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