PREVIEW / stock_1hour / 2014-07-23

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-07-23.parquet
  size:    1.0 MB
  rows:    48,376
  symbols: 3,559

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-07-23 04:00:00	AAPL	Stock	23.585	23.625	23.5775	23.6075	17236.0
2014-07-23 05:00:00	AAPL	Stock	23.59	23.6	23.5775	23.6	26480.0
2014-07-23 06:00:00	AAPL	Stock	23.5875	23.5875	23.545	23.5625	76860.0
2014-07-23 07:00:00	AAPL	Stock	23.5625	23.9675	23.53	23.845	1876872.0
2014-07-23 08:00:00	AAPL	Stock	23.8475	23.97	23.53	23.775	5005320.0
2014-07-23 09:00:00	AAPL	Stock	23.775	24.07	23.755	24.0475	64491448.0
2014-07-23 10:00:00	AAPL	Stock	24.0425	24.47	24.0425	24.4175	96561388.0
2014-07-23 11:00:00	AAPL	Stock	24.4152	24.4275	24.3075	24.3425	52259780.0
2014-07-23 12:00:00	AAPL	Stock	24.345	24.42	24.325	24.3875	28155008.0
2014-07-23 13:00:00	AAPL	Stock	24.3873	24.4125	24.2913	24.4055	22900564.0
2014-07-23 14:00:00	AAPL	Stock	24.405	24.42	24.3425	24.3675	17481432.0
2014-07-23 15:00:00	AAPL	Stock	24.3662	24.405	24.2825	24.2975	34585400.0
2014-07-23 16:00:00	AAPL	Stock	24.2975	24.3482	24.2375	24.285	17340040.0
2014-07-23 17:00:00	AAPL	Stock	24.2825	24.2975	24.2525	24.2625	432908.0
2014-07-23 18:00:00	AAPL	Stock	24.2725	24.3	24.2575	24.285	269984.0
2014-07-23 19:00:00	AAPL	Stock	24.2875	24.2925	24.27	24.2925	209272.0
2014-07-23 04:00:00	MSFT	Stock	45.5	45.59	45.07	45.07	5000.0
2014-07-23 05:00:00	MSFT	Stock	45.55	45.55	45.31	45.31	1300.0
2014-07-23 06:00:00	MSFT	Stock	45.35	45.62	45.32	45.43	15572.0
2014-07-23 07:00:00	MSFT	Stock	45.55	45.95	45.55	45.88	257726.0
2014-07-23 08:00:00	MSFT	Stock	45.88	45.9	45.39	45.57	433361.0
2014-07-23 09:00:00	MSFT	Stock	45.56	45.69	44.62	44.74	12433155.0
2014-07-23 10:00:00	MSFT	Stock	44.75	45.43	44.725	45.265	11728490.0
2014-07-23 11:00:00	MSFT	Stock	45.262	45.4	45.14	45.17	6236692.0
2014-07-23 12:00:00	MSFT	Stock	45.18	45.31	44.965	45.09	4387944.0
2014-07-23 13:00:00	MSFT	Stock	45.085	45.09	44.735	44.934	3754219.0
2014-07-23 14:00:00	MSFT	Stock	44.93	45.11	44.77	44.77	3619070.0
2014-07-23 15:00:00	MSFT	Stock	44.77	44.94	44.73	44.88	6203625.0
2014-07-23 16:00:00	MSFT	Stock	44.87	45.042	44.8	44.87	1416591.0
2014-07-23 17:00:00	MSFT	Stock	44.87	44.88	44.8	44.8	29268.0
2014-07-23 18:00:00	MSFT	Stock	44.8	44.86	44.8	44.86	1800.0
2014-07-23 09:00:00	NVDA	Stock	0.462	0.4622	0.454	0.4552	37319760.0
2014-07-23 10:00:00	NVDA	Stock	0.4552	0.4568	0.4545	0.4555	64711680.0
2014-07-23 11:00:00	NVDA	Stock	0.4558	0.4562	0.4542	0.4554	52428840.0
2014-07-23 12:00:00	NVDA	Stock	0.4554	0.4558	0.4525	0.4532	22176400.0
2014-07-23 13:00:00	NVDA	Stock	0.4532	0.455	0.453	0.4548	16400360.0
2014-07-23 14:00:00	NVDA	Stock	0.455	0.455	0.453	0.4538	19490400.0
2014-07-23 15:00:00	NVDA	Stock	0.4538	0.454	0.4515	0.4522	72374920.0
2014-07-23 16:00:00	NVDA	Stock	0.452	0.452	0.4512	0.452	1062040.0
2014-07-23 17:00:00	NVDA	Stock	0.451	0.452	0.451	0.452	938680.0
2014-07-23 18:00:00	NVDA	Stock	0.4508	0.4508	0.4508	0.4508	20000.0
2014-07-23 07:00:00	AMZN	Stock	18.0	18.0	17.9965	18.0	20100.0
2014-07-23 08:00:00	AMZN	Stock	18.0	18.062	17.986	18.0205	94200.0
2014-07-23 09:00:00	AMZN	Stock	18.005	18.0315	17.9025	17.9815	7102440.0
2014-07-23 10:00:00	AMZN	Stock	17.9828	17.9845	17.8475	17.8528	10504040.0
2014-07-23 11:00:00	AMZN	Stock	17.857	17.921	17.833	17.8685	8717140.0
2014-07-23 12:00:00	AMZN	Stock	17.877	17.902	17.831	17.8778	4242220.0
2014-07-23 13:00:00	AMZN	Stock	17.876	17.9453	17.8445	17.9325	4400340.0
2014-07-23 14:00:00	AMZN	Stock	17.93	17.9365	17.8802	17.914	3658180.0
2014-07-23 15:00:00	AMZN	Stock	17.914	17.9225	17.8885	17.9075	8133600.0

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

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