PREVIEW / stock_1hour / 2015-07-06

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-07-06.parquet
  size:    1.1 MB
  rows:    49,194
  symbols: 3,488

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-06 04:00:00	AAPL	Stock	31.25	31.36	31.25	31.3525	117780.0
2015-07-06 05:00:00	AAPL	Stock	31.355	31.425	31.3425	31.425	48424.0
2015-07-06 06:00:00	AAPL	Stock	31.425	31.4275	31.375	31.375	79256.0
2015-07-06 07:00:00	AAPL	Stock	31.375	31.4	31.3125	31.3125	253672.0
2015-07-06 08:00:00	AAPL	Stock	31.325	31.4275	31.2875	31.335	1119752.0
2015-07-06 09:00:00	AAPL	Stock	31.3425	31.4825	31.205	31.42	23401296.0
2015-07-06 10:00:00	AAPL	Stock	31.42	31.5575	31.375	31.5	18548204.0
2015-07-06 11:00:00	AAPL	Stock	31.5	31.5138	31.4	31.4375	11469404.0
2015-07-06 12:00:00	AAPL	Stock	31.4375	31.4675	31.395	31.4672	7397212.0
2015-07-06 13:00:00	AAPL	Stock	31.4675	31.4825	31.3525	31.38	11054564.0
2015-07-06 14:00:00	AAPL	Stock	31.3812	31.415	31.3422	31.3712	10230048.0
2015-07-06 15:00:00	AAPL	Stock	31.37	31.5	31.3625	31.4975	16669972.0
2015-07-06 16:00:00	AAPL	Stock	31.5	31.5475	31.495	31.5382	4423068.0
2015-07-06 17:00:00	AAPL	Stock	31.54	31.575	31.5375	31.5375	104292.0
2015-07-06 18:00:00	AAPL	Stock	31.54	31.595	31.5375	31.5875	110672.0
2015-07-06 19:00:00	AAPL	Stock	31.5875	31.6	31.55	31.5875	50124.0
2015-07-06 07:00:00	MSFT	Stock	44.1	44.1	44.03	44.03	300.0
2015-07-06 08:00:00	MSFT	Stock	44.1	44.18	44.03	44.09	7211.0
2015-07-06 09:00:00	MSFT	Stock	44.09	44.245	43.93	44.11	3430148.0
2015-07-06 10:00:00	MSFT	Stock	44.11	44.47	44.09	44.29	3772923.0
2015-07-06 11:00:00	MSFT	Stock	44.29	44.35	44.12	44.265	2662988.0
2015-07-06 12:00:00	MSFT	Stock	44.26	44.425	44.21	44.42	1924807.0
2015-07-06 13:00:00	MSFT	Stock	44.42	44.48	44.23	44.364	2545017.0
2015-07-06 14:00:00	MSFT	Stock	44.36	44.45	44.14	44.18	2724706.0
2015-07-06 15:00:00	MSFT	Stock	44.175	44.42	44.14	44.4	3627289.0
2015-07-06 16:00:00	MSFT	Stock	44.41	44.523	44.39	44.523	1330250.0
2015-07-06 17:00:00	MSFT	Stock	44.52	44.52	44.52	44.52	2300.0
2015-07-06 18:00:00	MSFT	Stock	44.5	44.5	44.45	44.45	200.0
2015-07-06 19:00:00	MSFT	Stock	44.52	44.55	44.51	44.55	732.0
2015-07-06 08:00:00	NVDA	Stock	0.5062	0.5062	0.5062	0.5062	6000.0
2015-07-06 09:00:00	NVDA	Stock	0.5075	0.5128	0.5053	0.5115	27589160.0
2015-07-06 10:00:00	NVDA	Stock	0.5118	0.5133	0.5095	0.5105	32813200.0
2015-07-06 11:00:00	NVDA	Stock	0.5108	0.511	0.5062	0.508	17523240.0
2015-07-06 12:00:00	NVDA	Stock	0.5078	0.5082	0.5048	0.5053	15541640.0
2015-07-06 13:00:00	NVDA	Stock	0.5053	0.5055	0.5015	0.5018	17623000.0
2015-07-06 14:00:00	NVDA	Stock	0.5018	0.5026	0.5004	0.5005	20035640.0
2015-07-06 15:00:00	NVDA	Stock	0.5005	0.505	0.5005	0.5043	55190920.0
2015-07-06 16:00:00	NVDA	Stock	0.5043	0.5048	0.5043	0.5043	1615720.0
2015-07-06 17:00:00	NVDA	Stock	0.5043	0.5043	0.5043	0.5043	28000.0
2015-07-06 19:00:00	NVDA	Stock	0.5043	0.5043	0.5043	0.5043	8000.0
2015-07-06 06:00:00	AMZN	Stock	21.815	21.815	21.815	21.815	10000.0
2015-07-06 07:00:00	AMZN	Stock	21.7875	21.7875	21.762	21.762	22000.0
2015-07-06 08:00:00	AMZN	Stock	21.755	21.779	21.7445	21.754	80000.0
2015-07-06 09:00:00	AMZN	Stock	21.7615	21.9165	21.7455	21.8385	5589640.0
2015-07-06 10:00:00	AMZN	Stock	21.8353	21.9865	21.782	21.938	6503160.0
2015-07-06 11:00:00	AMZN	Stock	21.941	21.9559	21.767	21.788	4705140.0
2015-07-06 12:00:00	AMZN	Stock	21.795	21.804	21.725	21.7815	4099300.0
2015-07-06 13:00:00	AMZN	Stock	21.781	21.784	21.676	21.7295	3519700.0
2015-07-06 14:00:00	AMZN	Stock	21.7295	21.76	21.677	21.695	3105920.0
2015-07-06 15:00:00	AMZN	Stock	21.691	21.8143	21.6805	21.802	5841420.0

> showing 50 of 49,194 rows — these rows as CSV

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