PREVIEW / stock_1hour / 2014-06-25

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-06-25.parquet
  size:    1.0 MB
  rows:    48,481
  symbols: 3,564

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
2014-06-25 04:00:00	AAPL	Stock	22.6025	22.6025	22.53	22.535	19872.0
2014-06-25 05:00:00	AAPL	Stock	22.535	22.555	22.51	22.545	34236.0
2014-06-25 06:00:00	AAPL	Stock	22.555	22.5575	22.5125	22.525	70484.0
2014-06-25 07:00:00	AAPL	Stock	22.53	22.59	22.53	22.58	57648.0
2014-06-25 08:00:00	AAPL	Stock	22.5825	22.625	22.555	22.5825	589948.0
2014-06-25 09:00:00	AAPL	Stock	22.575	22.675	22.4125	22.635	30758196.0
2014-06-25 10:00:00	AAPL	Stock	22.635	22.6375	22.42	22.5197	26404108.0
2014-06-25 11:00:00	AAPL	Stock	22.52	22.645	22.5	22.5748	19048884.0
2014-06-25 12:00:00	AAPL	Stock	22.575	22.61	22.5325	22.585	9370924.0
2014-06-25 13:00:00	AAPL	Stock	22.5875	22.6325	22.5625	22.569	9870508.0
2014-06-25 14:00:00	AAPL	Stock	22.57	22.5825	22.505	22.5475	10866864.0
2014-06-25 15:00:00	AAPL	Stock	22.545	22.6225	22.5425	22.59	16497128.0
2014-06-25 16:00:00	AAPL	Stock	22.59	22.605	22.5215	22.59	10461136.0
2014-06-25 17:00:00	AAPL	Stock	22.575	22.59	22.57	22.5875	304672.0
2014-06-25 18:00:00	AAPL	Stock	22.575	22.59	22.575	22.575	47216.0
2014-06-25 19:00:00	AAPL	Stock	22.5825	22.5875	22.5775	22.5875	50912.0
2014-06-25 07:00:00	MSFT	Stock	41.51	41.69	41.51	41.69	900.0
2014-06-25 08:00:00	MSFT	Stock	41.69	41.69	41.67	41.67	323.0
2014-06-25 09:00:00	MSFT	Stock	41.66	41.99	41.46	41.571	1873047.0
2014-06-25 10:00:00	MSFT	Stock	41.58	41.88	41.51	41.81	2380285.0
2014-06-25 11:00:00	MSFT	Stock	41.81	41.845	41.64	41.69	1855110.0
2014-06-25 12:00:00	MSFT	Stock	41.69	41.75	41.66	41.74	1128539.0
2014-06-25 13:00:00	MSFT	Stock	41.735	41.91	41.73	41.89	1426632.0
2014-06-25 14:00:00	MSFT	Stock	41.88	41.94	41.86	41.91	1526626.0
2014-06-25 15:00:00	MSFT	Stock	41.91	42.05	41.89	42.02	5460285.0
2014-06-25 16:00:00	MSFT	Stock	42.01	42.04	41.693	42.03	3269387.0
2014-06-25 17:00:00	MSFT	Stock	42.03	42.03	41.85	41.85	82471.0
2014-06-25 18:00:00	MSFT	Stock	42.03	42.03	41.97	41.97	7878.0
2014-06-25 19:00:00	MSFT	Stock	41.98	41.98	41.88	41.92	2100.0
2014-06-25 07:00:00	NVDA	Stock	0.461	0.461	0.4508	0.4518	104000.0
2014-06-25 08:00:00	NVDA	Stock	0.4605	0.4608	0.4605	0.4605	48000.0
2014-06-25 09:00:00	NVDA	Stock	0.4605	0.4619	0.4593	0.4605	26005400.0
2014-06-25 10:00:00	NVDA	Stock	0.4603	0.4636	0.4575	0.4603	43659520.0
2014-06-25 11:00:00	NVDA	Stock	0.4603	0.4615	0.46	0.4613	25471040.0
2014-06-25 12:00:00	NVDA	Stock	0.4615	0.4624	0.461	0.4621	20256880.0
2014-06-25 13:00:00	NVDA	Stock	0.4622	0.4638	0.462	0.4635	20911720.0
2014-06-25 14:00:00	NVDA	Stock	0.4635	0.465	0.4631	0.4639	20565720.0
2014-06-25 15:00:00	NVDA	Stock	0.4639	0.4655	0.4638	0.465	39701200.0
2014-06-25 16:00:00	NVDA	Stock	0.4652	0.4652	0.4613	0.4652	13112640.0
2014-06-25 17:00:00	NVDA	Stock	0.4652	0.4652	0.4652	0.4652	363320.0
2014-06-25 04:00:00	AMZN	Stock	16.2015	16.2015	16.2015	16.2015	2000.0
2014-06-25 07:00:00	AMZN	Stock	16.225	16.225	16.225	16.225	2000.0
2014-06-25 08:00:00	AMZN	Stock	16.2245	16.2245	16.172	16.175	35480.0
2014-06-25 09:00:00	AMZN	Stock	16.1775	16.2355	16.087	16.1145	7973960.0
2014-06-25 10:00:00	AMZN	Stock	16.1205	16.2635	16.116	16.2515	8180780.0
2014-06-25 11:00:00	AMZN	Stock	16.251	16.289	16.208	16.2665	6042720.0
2014-06-25 12:00:00	AMZN	Stock	16.2577	16.2905	16.231	16.2442	2661820.0
2014-06-25 13:00:00	AMZN	Stock	16.25	16.367	16.25	16.3505	4328120.0
2014-06-25 14:00:00	AMZN	Stock	16.35	16.3845	16.313	16.325	3479520.0
2014-06-25 15:00:00	AMZN	Stock	16.329	16.4075	16.309	16.37	7386100.0

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

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