PREVIEW / stock_1hour / 2015-06-16

all stock 1-hour files

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

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-06-16 04:00:00	AAPL	Stock	31.505	31.595	31.4925	31.53	95972.0
2015-06-16 05:00:00	AAPL	Stock	31.53	31.5675	31.51	31.525	88240.0
2015-06-16 06:00:00	AAPL	Stock	31.5425	31.57	31.525	31.5675	36720.0
2015-06-16 07:00:00	AAPL	Stock	31.575	31.625	31.5725	31.605	209260.0
2015-06-16 08:00:00	AAPL	Stock	31.6175	31.8	31.57	31.785	915664.0
2015-06-16 09:00:00	AAPL	Stock	31.775	31.87	31.625	31.7025	25489740.0
2015-06-16 10:00:00	AAPL	Stock	31.7025	31.73	31.5925	31.7075	20892504.0
2015-06-16 11:00:00	AAPL	Stock	31.705	31.82	31.705	31.7775	14562228.0
2015-06-16 12:00:00	AAPL	Stock	31.7775	31.8675	31.7725	31.85	10998012.0
2015-06-16 13:00:00	AAPL	Stock	31.8475	31.9075	31.8138	31.9	10089336.0
2015-06-16 14:00:00	AAPL	Stock	31.9	31.9625	31.885	31.9238	11506760.0
2015-06-16 15:00:00	AAPL	Stock	31.925	31.93	31.845	31.8975	15895468.0
2015-06-16 16:00:00	AAPL	Stock	31.9	31.9	31.8025	31.9	6915832.0
2015-06-16 17:00:00	AAPL	Stock	31.9	31.905	31.885	31.9	67308.0
2015-06-16 18:00:00	AAPL	Stock	31.9018	31.9075	31.8825	31.9	84888.0
2015-06-16 19:00:00	AAPL	Stock	31.9	31.9	31.8825	31.892	46856.0
2015-06-16 04:00:00	MSFT	Stock	45.38	45.38	45.16	45.16	300.0
2015-06-16 08:00:00	MSFT	Stock	45.417	45.417	45.37	45.39	1300.0
2015-06-16 09:00:00	MSFT	Stock	45.39	45.83	45.3	45.79	4463663.0
2015-06-16 10:00:00	MSFT	Stock	45.785	45.89	45.56	45.7	3750336.0
2015-06-16 11:00:00	MSFT	Stock	45.7	45.88	45.65	45.74	2052974.0
2015-06-16 12:00:00	MSFT	Stock	45.745	46.19	45.72	46.115	2643823.0
2015-06-16 13:00:00	MSFT	Stock	46.115	46.23	46.01	46.151	1878766.0
2015-06-16 14:00:00	MSFT	Stock	46.16	46.24	46.01	46.07	2219367.0
2015-06-16 15:00:00	MSFT	Stock	46.07	46.09	45.79	45.82	5858733.0
2015-06-16 16:00:00	MSFT	Stock	45.83	45.9	45.775	45.89	2955575.0
2015-06-16 17:00:00	MSFT	Stock	45.83	45.83	45.83	45.83	26600.0
2015-06-16 18:00:00	MSFT	Stock	45.83	45.83	45.83	45.83	2895.0
2015-06-16 19:00:00	MSFT	Stock	45.887	45.887	45.887	45.887	200.0
2015-06-16 09:00:00	NVDA	Stock	0.5258	0.529	0.5205	0.5272	37688240.0
2015-06-16 10:00:00	NVDA	Stock	0.5272	0.5296	0.5266	0.5282	31625720.0
2015-06-16 11:00:00	NVDA	Stock	0.5282	0.5302	0.5278	0.5302	17071520.0
2015-06-16 12:00:00	NVDA	Stock	0.5302	0.5332	0.5298	0.5332	22948400.0
2015-06-16 13:00:00	NVDA	Stock	0.5331	0.5335	0.531	0.5315	19840040.0
2015-06-16 14:00:00	NVDA	Stock	0.5318	0.5329	0.5312	0.5327	11914680.0
2015-06-16 15:00:00	NVDA	Stock	0.5327	0.534	0.5322	0.5331	56977160.0
2015-06-16 16:00:00	NVDA	Stock	0.5332	0.5332	0.5332	0.5332	35584560.0
2015-06-16 04:00:00	AMZN	Stock	21.1625	21.1625	21.112	21.112	37780.0
2015-06-16 06:00:00	AMZN	Stock	21.11	21.11	21.11	21.11	5000.0
2015-06-16 08:00:00	AMZN	Stock	21.126	21.15	21.126	21.15	22000.0
2015-06-16 09:00:00	AMZN	Stock	21.1475	21.2775	21.1335	21.1825	4693000.0
2015-06-16 10:00:00	AMZN	Stock	21.2035	21.319	21.1918	21.241	17253720.0
2015-06-16 11:00:00	AMZN	Stock	21.249	21.3245	21.233	21.2816	3627140.0
2015-06-16 12:00:00	AMZN	Stock	21.269	21.2715	21.225	21.246	2806400.0
2015-06-16 13:00:00	AMZN	Stock	21.2405	21.3015	21.228	21.2925	1926860.0
2015-06-16 14:00:00	AMZN	Stock	21.297	21.384	21.297	21.38	4294180.0
2015-06-16 15:00:00	AMZN	Stock	21.3725	21.3985	21.354	21.363	6467080.0
2015-06-16 16:00:00	AMZN	Stock	21.363	21.363	21.3625	21.3625	134960.0
2015-06-16 17:00:00	AMZN	Stock	21.363	21.375	21.3625	21.375	8000.0
2015-06-16 19:00:00	AMZN	Stock	21.385	21.385	21.375	21.375	6900.0

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

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