PREVIEW / stock_1hour / 2012-08-20

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-08-20.parquet
  size:    911 KB
  rows:    43,116
  symbols: 3,459

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-20 04:00:00	AAPL	Stock	23.2682	23.3393	23.2682	23.2857	83272.0
2012-08-20 05:00:00	AAPL	Stock	23.3214	23.3482	23.3036	23.3304	110656.0
2012-08-20 06:00:00	AAPL	Stock	23.3304	23.3304	23.2714	23.2857	95060.0
2012-08-20 07:00:00	AAPL	Stock	23.2732	23.2861	23.1604	23.1846	1094352.0
2012-08-20 08:00:00	AAPL	Stock	23.1857	23.2857	23.175	23.2429	3171700.0
2012-08-20 09:00:00	AAPL	Stock	23.2446	23.3929	23.2086	23.325	91325584.0
2012-08-20 10:00:00	AAPL	Stock	23.325	23.5536	23.3214	23.5471	122642380.0
2012-08-20 11:00:00	AAPL	Stock	23.5467	23.7407	23.5271	23.7193	95941188.0
2012-08-20 12:00:00	AAPL	Stock	23.7189	23.7411	23.5257	23.6321	106749888.0
2012-08-20 13:00:00	AAPL	Stock	23.6296	23.6857	23.5896	23.6706	48745508.0
2012-08-20 14:00:00	AAPL	Stock	23.6729	23.7032	23.63	23.6665	35966756.0
2012-08-20 15:00:00	AAPL	Stock	23.6679	23.7554	23.6361	23.7496	81776940.0
2012-08-20 16:00:00	AAPL	Stock	23.7554	23.7932	23.3519	23.7579	12618200.0
2012-08-20 17:00:00	AAPL	Stock	23.7589	23.775	23.7554	23.77	592676.0
2012-08-20 18:00:00	AAPL	Stock	23.7696	23.8054	23.7679	23.7993	860552.0
2012-08-20 19:00:00	AAPL	Stock	23.7946	23.8036	23.7793	23.8036	281932.0
2012-08-20 08:00:00	MSFT	Stock	30.86	30.97	30.85	30.85	7720.0
2012-08-20 09:00:00	MSFT	Stock	30.88	30.9	30.58	30.64	3327880.0
2012-08-20 10:00:00	MSFT	Stock	30.64	30.725	30.63	30.7	4636581.0
2012-08-20 11:00:00	MSFT	Stock	30.7	30.74	30.65	30.726	2867996.0
2012-08-20 12:00:00	MSFT	Stock	30.72	30.82	30.72	30.76	2111065.0
2012-08-20 13:00:00	MSFT	Stock	30.76	30.77	30.65	30.68	1989001.0
2012-08-20 14:00:00	MSFT	Stock	30.672	30.76	30.665	30.74	2705815.0
2012-08-20 15:00:00	MSFT	Stock	30.745	30.79	30.67	30.74	4294870.0
2012-08-20 16:00:00	MSFT	Stock	30.73	30.84	30.667	30.76	1259036.0
2012-08-20 17:00:00	MSFT	Stock	30.79	30.8	30.76	30.8	2749.0
2012-08-20 18:00:00	MSFT	Stock	30.77	30.77	30.77	30.77	100.0
2012-08-20 19:00:00	MSFT	Stock	30.8	30.81	30.78	30.8	1344.0
2012-08-20 07:00:00	NVDA	Stock	0.365	0.365	0.365	0.365	4000.0
2012-08-20 08:00:00	NVDA	Stock	0.3652	0.3652	0.3652	0.3652	100000.0
2012-08-20 09:00:00	NVDA	Stock	0.364	0.3665	0.3632	0.3638	44377520.0
2012-08-20 10:00:00	NVDA	Stock	0.3638	0.3645	0.3608	0.3628	53158880.0
2012-08-20 11:00:00	NVDA	Stock	0.3629	0.3638	0.3609	0.3638	45841040.0
2012-08-20 12:00:00	NVDA	Stock	0.3638	0.3652	0.3635	0.3652	30125200.0
2012-08-20 13:00:00	NVDA	Stock	0.365	0.3664	0.3642	0.3648	23461960.0
2012-08-20 14:00:00	NVDA	Stock	0.3645	0.3665	0.3642	0.3662	19112280.0
2012-08-20 15:00:00	NVDA	Stock	0.3662	0.3668	0.3648	0.3662	62921560.0
2012-08-20 16:00:00	NVDA	Stock	0.366	0.3663	0.3641	0.3663	33493920.0
2012-08-20 17:00:00	NVDA	Stock	0.3665	0.3665	0.3662	0.3665	78000.0
2012-08-20 18:00:00	NVDA	Stock	0.3665	0.3678	0.3665	0.3665	262000.0
2012-08-20 07:00:00	AMZN	Stock	12.075	12.0755	12.075	12.0755	7000.0
2012-08-20 08:00:00	AMZN	Stock	12.071	12.0825	12.055	12.0825	42200.0
2012-08-20 09:00:00	AMZN	Stock	12.084	12.084	11.9629	11.9644	7130440.0
2012-08-20 10:00:00	AMZN	Stock	11.9635	11.967	11.91	11.9655	7448760.0
2012-08-20 11:00:00	AMZN	Stock	11.966	11.966	11.93	11.951	5192420.0
2012-08-20 12:00:00	AMZN	Stock	11.9529	11.994	11.9475	11.959	2966900.0
2012-08-20 13:00:00	AMZN	Stock	11.959	11.9645	11.916	11.931	2720940.0
2012-08-20 14:00:00	AMZN	Stock	11.9325	11.9825	11.9285	11.98	3340020.0
2012-08-20 15:00:00	AMZN	Stock	11.98	12.025	11.9725	12.017	6438320.0
2012-08-20 16:00:00	AMZN	Stock	12.0175	12.0585	11.9449	12.0099	2063840.0

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

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