PREVIEW / stock_1hour / 2015-08-03

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-08-03.parquet
  size:    1.0 MB
  rows:    48,435
  symbols: 3,466

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-08-03 04:00:00	AAPL	Stock	30.3475	30.3725	30.305	30.3075	57836.0
2015-08-03 05:00:00	AAPL	Stock	30.305	30.3075	30.25	30.305	14000.0
2015-08-03 06:00:00	AAPL	Stock	30.305	30.3625	30.295	30.3625	54688.0
2015-08-03 07:00:00	AAPL	Stock	30.3625	30.4225	30.35	30.41	112764.0
2015-08-03 08:00:00	AAPL	Stock	30.4	30.415	30.35	30.365	461124.0
2015-08-03 09:00:00	AAPL	Stock	30.3575	30.6425	30.2625	30.4425	30022732.0
2015-08-03 10:00:00	AAPL	Stock	30.4475	30.5	30.1325	30.1625	29862496.0
2015-08-03 11:00:00	AAPL	Stock	30.1625	30.295	30.0825	30.1225	19673288.0
2015-08-03 12:00:00	AAPL	Stock	30.125	30.1375	29.38	29.5	55954144.0
2015-08-03 13:00:00	AAPL	Stock	29.502	29.71	29.4025	29.6825	47738784.0
2015-08-03 14:00:00	AAPL	Stock	29.6825	29.7025	29.5825	29.685	25404808.0
2015-08-03 15:00:00	AAPL	Stock	29.6825	29.7175	29.465	29.6125	44721804.0
2015-08-03 16:00:00	AAPL	Stock	29.61	30.3125	29.5675	29.6	7133060.0
2015-08-03 17:00:00	AAPL	Stock	29.6	29.605	29.3875	29.4	678040.0
2015-08-03 18:00:00	AAPL	Stock	29.4125	29.4975	29.4008	29.46	296880.0
2015-08-03 19:00:00	AAPL	Stock	29.4525	29.4625	29.425	29.44	165892.0
2015-08-03 04:00:00	MSFT	Stock	46.76	46.77	46.76	46.77	350.0
2015-08-03 06:00:00	MSFT	Stock	46.71	46.71	46.71	46.71	250.0
2015-08-03 08:00:00	MSFT	Stock	46.71	46.8	46.7	46.8	6858.0
2015-08-03 09:00:00	MSFT	Stock	46.7	47.0	46.45	46.83	2579580.0
2015-08-03 10:00:00	MSFT	Stock	46.83	46.83	46.525	46.635	3730256.0
2015-08-03 11:00:00	MSFT	Stock	46.634	46.99	46.61	46.94	3490335.0
2015-08-03 12:00:00	MSFT	Stock	46.95	46.98	46.61	46.685	2943794.0
2015-08-03 13:00:00	MSFT	Stock	46.68	46.7	46.51	46.543	3432116.0
2015-08-03 14:00:00	MSFT	Stock	46.54	46.67	46.47	46.57	2225949.0
2015-08-03 15:00:00	MSFT	Stock	46.57	46.82	46.49	46.81	3493362.0
2015-08-03 16:00:00	MSFT	Stock	46.81	46.81	46.726	46.75	1139804.0
2015-08-03 17:00:00	MSFT	Stock	46.72	46.75	46.713	46.713	600.0
2015-08-03 18:00:00	MSFT	Stock	46.71	46.71	46.71	46.71	230.0
2015-08-03 08:00:00	NVDA	Stock	0.5058	0.5058	0.5058	0.5058	8000.0
2015-08-03 09:00:00	NVDA	Stock	0.5028	0.5105	0.4988	0.5006	40252560.0
2015-08-03 10:00:00	NVDA	Stock	0.5005	0.5039	0.4963	0.5024	55421480.0
2015-08-03 11:00:00	NVDA	Stock	0.5025	0.5053	0.501	0.5018	43381760.0
2015-08-03 12:00:00	NVDA	Stock	0.5018	0.504	0.5018	0.5038	49509440.0
2015-08-03 13:00:00	NVDA	Stock	0.5038	0.5055	0.5025	0.5053	50791720.0
2015-08-03 14:00:00	NVDA	Stock	0.505	0.5068	0.504	0.5065	36035040.0
2015-08-03 15:00:00	NVDA	Stock	0.5066	0.5078	0.5053	0.5072	93762680.0
2015-08-03 16:00:00	NVDA	Stock	0.5068	0.5075	0.5068	0.5072	16180360.0
2015-08-03 04:00:00	AMZN	Stock	26.796	26.796	26.795	26.795	7000.0
2015-08-03 05:00:00	AMZN	Stock	26.8055	26.807	26.8055	26.807	4000.0
2015-08-03 06:00:00	AMZN	Stock	26.869	26.879	26.869	26.879	10200.0
2015-08-03 07:00:00	AMZN	Stock	26.899	26.9	26.875	26.875	30680.0
2015-08-03 08:00:00	AMZN	Stock	26.915	26.915	26.851	26.8945	48540.0
2015-08-03 09:00:00	AMZN	Stock	26.895	27.022	26.7885	27.011	8596820.0
2015-08-03 10:00:00	AMZN	Stock	27.001	27.013	26.6885	26.811	9075300.0
2015-08-03 11:00:00	AMZN	Stock	26.8125	26.926	26.7505	26.8725	7325160.0
2015-08-03 12:00:00	AMZN	Stock	26.878	26.8825	26.5355	26.5793	7456520.0
2015-08-03 13:00:00	AMZN	Stock	26.5785	26.6495	26.468	26.6495	8045200.0
2015-08-03 14:00:00	AMZN	Stock	26.636	26.7345	26.6065	26.648	4230940.0
2015-08-03 15:00:00	AMZN	Stock	26.6665	26.7755	26.6085	26.751	8590680.0

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

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