PREVIEW / stock_1hour / 2015-10-30

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-10-30.parquet
  size:    1.0 MB
  rows:    48,129
  symbols: 3,427

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-10-30 04:00:00	AAPL	Stock	30.235	30.25	30.2	30.2175	19208.0
2015-10-30 05:00:00	AAPL	Stock	30.22	30.22	30.175	30.175	18040.0
2015-10-30 06:00:00	AAPL	Stock	30.175	30.175	30.1	30.1475	25856.0
2015-10-30 07:00:00	AAPL	Stock	30.13	30.19	30.1225	30.19	48324.0
2015-10-30 08:00:00	AAPL	Stock	30.145	30.3375	30.11	30.3175	1160676.0
2015-10-30 09:00:00	AAPL	Stock	30.3175	30.325	30.115	30.2325	29097556.0
2015-10-30 10:00:00	AAPL	Stock	30.2312	30.2825	30.1	30.1425	30158876.0
2015-10-30 11:00:00	AAPL	Stock	30.145	30.1525	29.975	30.0838	25618172.0
2015-10-30 12:00:00	AAPL	Stock	30.0825	30.195	30.0175	30.1675	16452312.0
2015-10-30 13:00:00	AAPL	Stock	30.1662	30.1725	30.0688	30.1012	14580368.0
2015-10-30 14:00:00	AAPL	Stock	30.1012	30.1212	29.895	29.905	19599556.0
2015-10-30 15:00:00	AAPL	Stock	29.9048	30.025	29.8625	29.8762	33300516.0
2015-10-30 16:00:00	AAPL	Stock	29.875	29.9375	29.765	29.825	15597088.0
2015-10-30 17:00:00	AAPL	Stock	29.8225	29.865	29.8075	29.835	104184.0
2015-10-30 18:00:00	AAPL	Stock	29.835	29.8375	29.8	29.82	71472.0
2015-10-30 19:00:00	AAPL	Stock	29.83	29.835	29.81	29.82	95448.0
2015-10-30 04:00:00	MSFT	Stock	53.6	53.6	53.55	53.55	1380.0
2015-10-30 07:00:00	MSFT	Stock	53.47	53.47	53.47	53.47	100.0
2015-10-30 08:00:00	MSFT	Stock	53.47	53.5	53.4	53.42	5067.0
2015-10-30 09:00:00	MSFT	Stock	53.4	53.59	53.15	53.59	2619788.0
2015-10-30 10:00:00	MSFT	Stock	53.58	53.945	53.55	53.85	4695597.0
2015-10-30 11:00:00	MSFT	Stock	53.86	53.99	53.75	53.88	4712605.0
2015-10-30 12:00:00	MSFT	Stock	53.88	53.89	53.47	53.5	4972935.0
2015-10-30 13:00:00	MSFT	Stock	53.5	53.53	53.32	53.38	3291431.0
2015-10-30 14:00:00	MSFT	Stock	53.375	53.42	52.91	52.93	5373973.0
2015-10-30 15:00:00	MSFT	Stock	52.93	53.12	52.62	52.64	12992862.0
2015-10-30 16:00:00	MSFT	Stock	52.64	53.25	52.64	52.75	5661307.0
2015-10-30 17:00:00	MSFT	Stock	52.74	52.76	52.74	52.75	2121.0
2015-10-30 18:00:00	MSFT	Stock	52.76	52.8	52.72	52.73	1288.0
2015-10-30 19:00:00	MSFT	Stock	52.73	52.75	52.71	52.71	4333.0
2015-10-30 05:00:00	NVDA	Stock	0.7058	0.7058	0.7058	0.7058	8000.0
2015-10-30 08:00:00	NVDA	Stock	0.6968	0.6968	0.6968	0.6968	29000.0
2015-10-30 09:00:00	NVDA	Stock	0.6992	0.71	0.6942	0.71	53302920.0
2015-10-30 10:00:00	NVDA	Stock	0.7103	0.7143	0.7055	0.7058	53730240.0
2015-10-30 11:00:00	NVDA	Stock	0.7058	0.7088	0.7054	0.708	20574120.0
2015-10-30 12:00:00	NVDA	Stock	0.708	0.71	0.7078	0.7088	21820960.0
2015-10-30 13:00:00	NVDA	Stock	0.7085	0.71	0.7074	0.7091	17863920.0
2015-10-30 14:00:00	NVDA	Stock	0.709	0.7098	0.7058	0.706	24771120.0
2015-10-30 15:00:00	NVDA	Stock	0.706	0.711	0.705	0.7093	65287680.0
2015-10-30 16:00:00	NVDA	Stock	0.7093	0.7093	0.7093	0.7093	20164560.0
2015-10-30 05:00:00	AMZN	Stock	31.4345	31.4345	31.4345	31.4345	2000.0
2015-10-30 06:00:00	AMZN	Stock	31.3275	31.3275	31.2445	31.249	52100.0
2015-10-30 07:00:00	AMZN	Stock	31.246	31.3215	31.246	31.3	218860.0
2015-10-30 08:00:00	AMZN	Stock	31.249	31.3685	31.249	31.35	298920.0
2015-10-30 09:00:00	AMZN	Stock	31.3545	31.4945	31.0	31.4945	12655920.0
2015-10-30 10:00:00	AMZN	Stock	31.4785	31.536	31.363	31.402	12178200.0
2015-10-30 11:00:00	AMZN	Stock	31.4185	31.4744	31.3825	31.4105	8540600.0
2015-10-30 12:00:00	AMZN	Stock	31.407	31.494	31.332	31.484	7394380.0
2015-10-30 13:00:00	AMZN	Stock	31.489	31.499	31.4215	31.4715	5698300.0
2015-10-30 14:00:00	AMZN	Stock	31.4673	31.4855	31.358	31.3759	8579240.0

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

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