PREVIEW / stock_1hour / 2014-01-08

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-01-08.parquet
  size:    1.0 MB
  rows:    48,146
  symbols: 3,521

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-01-08 05:00:00	AAPL	Stock	19.2868	19.3361	19.2868	19.3086	16800.0
2014-01-08 06:00:00	AAPL	Stock	19.3011	19.3011	19.2718	19.2814	19600.0
2014-01-08 07:00:00	AAPL	Stock	19.2679	19.3193	19.2675	19.3193	80864.0
2014-01-08 08:00:00	AAPL	Stock	19.3071	19.3204	19.2714	19.2857	1051120.0
2014-01-08 09:00:00	AAPL	Stock	19.2846	19.4442	19.2389	19.4275	51330188.0
2014-01-08 10:00:00	AAPL	Stock	19.4275	19.4843	19.3771	19.3982	40767496.0
2014-01-08 11:00:00	AAPL	Stock	19.4	19.4521	19.3571	19.45	20787844.0
2014-01-08 12:00:00	AAPL	Stock	19.4507	19.4661	19.4107	19.4336	15202712.0
2014-01-08 13:00:00	AAPL	Stock	19.4321	19.4436	19.375	19.4389	14435848.0
2014-01-08 14:00:00	AAPL	Stock	19.4386	19.4639	19.4075	19.412	19507488.0
2014-01-08 15:00:00	AAPL	Stock	19.4128	19.4282	19.3339	19.4061	36708952.0
2014-01-08 16:00:00	AAPL	Stock	19.4093	19.4154	19.3821	19.4154	16342844.0
2014-01-08 17:00:00	AAPL	Stock	19.4107	19.4207	19.4089	19.4136	1967140.0
2014-01-08 18:00:00	AAPL	Stock	19.4093	19.4107	19.4036	19.4064	80976.0
2014-01-08 19:00:00	AAPL	Stock	19.4071	19.4168	19.4057	19.4107	63560.0
2014-01-08 04:00:00	MSFT	Stock	36.1	36.1	36.1	36.1	1700.0
2014-01-08 05:00:00	MSFT	Stock	36.1	36.1	35.97	36.09	5840.0
2014-01-08 06:00:00	MSFT	Stock	36.11	36.29	36.07	36.14	3331.0
2014-01-08 07:00:00	MSFT	Stock	36.14	36.24	36.05	36.14	41637.0
2014-01-08 08:00:00	MSFT	Stock	36.02	36.28	36.02	36.19	504359.0
2014-01-08 09:00:00	MSFT	Stock	36.2	36.2	35.74	35.95	8286785.0
2014-01-08 10:00:00	MSFT	Stock	35.95	36.14	35.91	35.95	7140062.0
2014-01-08 11:00:00	MSFT	Stock	35.954	35.99	35.88	35.94	7100108.0
2014-01-08 12:00:00	MSFT	Stock	35.94	35.95	35.75	35.799	6246098.0
2014-01-08 13:00:00	MSFT	Stock	35.8	35.865	35.76	35.79	4831449.0
2014-01-08 14:00:00	MSFT	Stock	35.79	35.86	35.65	35.66	6833850.0
2014-01-08 15:00:00	MSFT	Stock	35.66	35.8	35.58	35.75	13080155.0
2014-01-08 16:00:00	MSFT	Stock	35.75	35.954	35.67	35.79	3609726.0
2014-01-08 17:00:00	MSFT	Stock	35.78	35.78	35.74	35.74	41065.0
2014-01-08 18:00:00	MSFT	Stock	35.77	35.77	35.74	35.76	1352.0
2014-01-08 19:00:00	MSFT	Stock	35.76	35.8	35.76	35.8	1071.0
2014-01-08 09:00:00	NVDA	Stock	0.4043	0.4082	0.4035	0.4064	35524960.0
2014-01-08 10:00:00	NVDA	Stock	0.4065	0.411	0.4062	0.4084	40010640.0
2014-01-08 11:00:00	NVDA	Stock	0.4085	0.4094	0.408	0.4088	28880600.0
2014-01-08 12:00:00	NVDA	Stock	0.4088	0.4095	0.4082	0.409	19336080.0
2014-01-08 13:00:00	NVDA	Stock	0.409	0.409	0.408	0.4085	17118600.0
2014-01-08 14:00:00	NVDA	Stock	0.4085	0.4088	0.4075	0.408	20260320.0
2014-01-08 15:00:00	NVDA	Stock	0.408	0.4098	0.4065	0.4093	83322000.0
2014-01-08 16:00:00	NVDA	Stock	0.409	0.4093	0.4072	0.4091	45426320.0
2014-01-08 17:00:00	NVDA	Stock	0.409	0.4093	0.409	0.4093	151960.0
2014-01-08 19:00:00	NVDA	Stock	0.409	0.409	0.409	0.409	8000.0
2014-01-08 07:00:00	AMZN	Stock	19.9	19.9415	19.9	19.9415	15540.0
2014-01-08 08:00:00	AMZN	Stock	19.9	19.905	19.875	19.875	10000.0
2014-01-08 09:00:00	AMZN	Stock	19.875	19.942	19.802	19.8615	5604360.0
2014-01-08 10:00:00	AMZN	Stock	19.8555	20.0645	19.8405	20.0162	7836800.0
2014-01-08 11:00:00	AMZN	Stock	20.0185	20.075	19.956	20.0605	5437720.0
2014-01-08 12:00:00	AMZN	Stock	20.071	20.0715	19.9785	20.0115	3030120.0
2014-01-08 13:00:00	AMZN	Stock	20.0055	20.0455	19.9635	20.0205	2711440.0
2014-01-08 14:00:00	AMZN	Stock	20.0125	20.15	19.99	20.0805	7519580.0
2014-01-08 15:00:00	AMZN	Stock	20.0825	20.108	19.9905	20.095	7449220.0

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

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