PREVIEW / stock_1hour / 2015-07-17

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-07-17.parquet
  size:    1.0 MB
  rows:    48,838
  symbols: 3,487

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
2015-07-17 04:00:00	AAPL	Stock	32.2875	32.2875	32.1475	32.19	82528.0
2015-07-17 05:00:00	AAPL	Stock	32.2	32.2225	32.19	32.2125	14532.0
2015-07-17 06:00:00	AAPL	Stock	32.2	32.235	32.1875	32.2275	58732.0
2015-07-17 07:00:00	AAPL	Stock	32.2275	32.33	32.225	32.2675	299920.0
2015-07-17 08:00:00	AAPL	Stock	32.2675	32.3125	32.225	32.2675	682332.0
2015-07-17 09:00:00	AAPL	Stock	32.2725	32.2975	32.0925	32.1718	33041128.0
2015-07-17 10:00:00	AAPL	Stock	32.1702	32.3825	32.0775	32.3475	37802252.0
2015-07-17 11:00:00	AAPL	Stock	32.3452	32.36	32.2375	32.255	16869992.0
2015-07-17 12:00:00	AAPL	Stock	32.254	32.2872	32.2	32.2325	10226212.0
2015-07-17 13:00:00	AAPL	Stock	32.2325	32.3525	32.22	32.3175	12073684.0
2015-07-17 14:00:00	AAPL	Stock	32.316	32.375	32.285	32.3718	13241200.0
2015-07-17 15:00:00	AAPL	Stock	32.3725	32.405	32.29	32.405	30831392.0
2015-07-17 16:00:00	AAPL	Stock	32.3985	32.4175	32.1642	32.4025	16698908.0
2015-07-17 17:00:00	AAPL	Stock	32.4125	32.47	32.4078	32.4225	368928.0
2015-07-17 18:00:00	AAPL	Stock	32.425	32.44	32.4158	32.43	128156.0
2015-07-17 19:00:00	AAPL	Stock	32.43	32.45	32.425	32.4425	146108.0
2015-07-17 04:00:00	MSFT	Stock	46.89	46.89	46.4	46.4	4730.0
2015-07-17 05:00:00	MSFT	Stock	46.39	46.51	46.39	46.51	7170.0
2015-07-17 06:00:00	MSFT	Stock	46.47	46.47	46.42	46.42	800.0
2015-07-17 07:00:00	MSFT	Stock	46.45	46.45	46.38	46.38	9189.0
2015-07-17 08:00:00	MSFT	Stock	46.45	46.45	46.32	46.43	13587.0
2015-07-17 09:00:00	MSFT	Stock	46.42	46.63	46.4	46.52	6089837.0
2015-07-17 10:00:00	MSFT	Stock	46.52	46.78	46.5	46.54	4940177.0
2015-07-17 11:00:00	MSFT	Stock	46.54	46.62	46.36	46.445	2443182.0
2015-07-17 12:00:00	MSFT	Stock	46.45	46.555	46.35	46.355	2358108.0
2015-07-17 13:00:00	MSFT	Stock	46.355	46.39	46.26	46.322	2102416.0
2015-07-17 14:00:00	MSFT	Stock	46.32	46.49	46.31	46.45	2168739.0
2015-07-17 15:00:00	MSFT	Stock	46.45	46.64	46.4	46.61	4594549.0
2015-07-17 16:00:00	MSFT	Stock	46.62	46.65	46.57	46.62	3435571.0
2015-07-17 17:00:00	MSFT	Stock	46.647	46.647	46.64	46.64	1250.0
2015-07-17 18:00:00	MSFT	Stock	46.65	46.65	46.64	46.64	1400.0
2015-07-17 19:00:00	MSFT	Stock	46.6	46.6	46.6	46.6	1025.0
2015-07-17 05:00:00	NVDA	Stock	0.5095	0.5095	0.5095	0.5095	12000.0
2015-07-17 07:00:00	NVDA	Stock	0.5085	0.5085	0.5085	0.5085	4000.0
2015-07-17 08:00:00	NVDA	Stock	0.5048	0.5048	0.5048	0.5048	10000.0
2015-07-17 09:00:00	NVDA	Stock	0.503	0.5035	0.4975	0.4986	27526040.0
2015-07-17 10:00:00	NVDA	Stock	0.4985	0.4991	0.4955	0.4976	45887000.0
2015-07-17 11:00:00	NVDA	Stock	0.4976	0.4998	0.4952	0.4995	21599480.0
2015-07-17 12:00:00	NVDA	Stock	0.4994	0.5005	0.498	0.4982	17504760.0
2015-07-17 13:00:00	NVDA	Stock	0.4984	0.4998	0.4982	0.4991	14807320.0
2015-07-17 14:00:00	NVDA	Stock	0.4991	0.5018	0.4978	0.5018	22536600.0
2015-07-17 15:00:00	NVDA	Stock	0.5015	0.5025	0.5013	0.502	42914560.0
2015-07-17 16:00:00	NVDA	Stock	0.5018	0.5018	0.4988	0.5013	2866400.0
2015-07-17 17:00:00	NVDA	Stock	0.5018	0.5062	0.5013	0.5062	84000.0
2015-07-17 18:00:00	NVDA	Stock	0.5075	0.5075	0.5075	0.5075	20000.0
2015-07-17 04:00:00	AMZN	Stock	23.885	23.956	23.885	23.9	11800.0
2015-07-17 05:00:00	AMZN	Stock	23.8605	23.8965	23.8605	23.8965	4100.0
2015-07-17 06:00:00	AMZN	Stock	23.892	23.9325	23.892	23.9	23600.0
2015-07-17 07:00:00	AMZN	Stock	23.9115	23.94	23.9	23.915	176860.0
2015-07-17 08:00:00	AMZN	Stock	23.901	23.96	23.88	23.9245	307680.0

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

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