PREVIEW / stock_1hour / 2015-04-07

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-04-07.parquet
  size:    1.0 MB
  rows:    48,273
  symbols: 3,499

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-04-07 04:00:00	AAPL	Stock	31.93	31.93	31.825	31.825	8788.0
2015-04-07 05:00:00	AAPL	Stock	31.85	31.875	31.825	31.855	3200.0
2015-04-07 06:00:00	AAPL	Stock	31.875	31.9425	31.875	31.9425	64816.0
2015-04-07 07:00:00	AAPL	Stock	31.9425	32.03	31.9425	31.985	360352.0
2015-04-07 08:00:00	AAPL	Stock	31.98	32.04	31.9575	32.0102	1003192.0
2015-04-07 09:00:00	AAPL	Stock	32.015	32.0305	31.8	31.8075	28028288.0
2015-04-07 10:00:00	AAPL	Stock	31.8025	31.9075	31.7762	31.7925	21753176.0
2015-04-07 11:00:00	AAPL	Stock	31.79	31.8125	31.725	31.755	14737244.0
2015-04-07 12:00:00	AAPL	Stock	31.7558	31.82	31.695	31.715	10983308.0
2015-04-07 13:00:00	AAPL	Stock	31.715	31.7425	31.6525	31.6775	10067508.0
2015-04-07 14:00:00	AAPL	Stock	31.6762	31.7575	31.665	31.6975	11066436.0
2015-04-07 15:00:00	AAPL	Stock	31.6975	31.7262	31.495	31.5012	24216400.0
2015-04-07 16:00:00	AAPL	Stock	31.5012	31.8375	31.4498	31.465	9319948.0
2015-04-07 17:00:00	AAPL	Stock	31.4725	31.5025	31.4525	31.4875	184624.0
2015-04-07 18:00:00	AAPL	Stock	31.4875	31.4875	31.4125	31.435	220740.0
2015-04-07 19:00:00	AAPL	Stock	31.435	31.46	31.425	31.435	109940.0
2015-04-07 04:00:00	MSFT	Stock	42.0	42.0	41.47	41.53	2200.0
2015-04-07 06:00:00	MSFT	Stock	41.5	41.5	41.38	41.42	12996.0
2015-04-07 07:00:00	MSFT	Stock	41.48	41.57	41.48	41.55	2251.0
2015-04-07 08:00:00	MSFT	Stock	41.519	41.54	41.42	41.43	8493.0
2015-04-07 09:00:00	MSFT	Stock	41.45	41.63	41.31	41.43	3908587.0
2015-04-07 10:00:00	MSFT	Stock	41.44	41.67	41.31	41.58	3830490.0
2015-04-07 11:00:00	MSFT	Stock	41.585	41.82	41.58	41.76	3472502.0
2015-04-07 12:00:00	MSFT	Stock	41.76	41.91	41.76	41.84	2916498.0
2015-04-07 13:00:00	MSFT	Stock	41.835	41.88	41.79	41.79	2416646.0
2015-04-07 14:00:00	MSFT	Stock	41.795	41.88	41.75	41.765	2697501.0
2015-04-07 15:00:00	MSFT	Stock	41.76	41.86	41.52	41.53	6969512.0
2015-04-07 16:00:00	MSFT	Stock	41.53	41.693	41.47	41.48	1525591.0
2015-04-07 17:00:00	MSFT	Stock	41.57	41.57	41.57	41.57	300.0
2015-04-07 19:00:00	MSFT	Stock	41.57	41.57	41.57	41.57	200.0
2015-04-07 08:00:00	NVDA	Stock	0.544	0.544	0.544	0.544	60000.0
2015-04-07 09:00:00	NVDA	Stock	0.5425	0.5468	0.5388	0.5462	48472960.0
2015-04-07 10:00:00	NVDA	Stock	0.5462	0.5525	0.5458	0.5495	71493360.0
2015-04-07 11:00:00	NVDA	Stock	0.5496	0.551	0.5482	0.5495	43854400.0
2015-04-07 12:00:00	NVDA	Stock	0.5495	0.5512	0.549	0.5495	29846920.0
2015-04-07 13:00:00	NVDA	Stock	0.5497	0.5498	0.546	0.5468	17971120.0
2015-04-07 14:00:00	NVDA	Stock	0.5468	0.5482	0.546	0.5463	25916760.0
2015-04-07 15:00:00	NVDA	Stock	0.5462	0.5495	0.5452	0.5465	121149680.0
2015-04-07 16:00:00	NVDA	Stock	0.5465	0.5465	0.5465	0.5465	1214240.0
2015-04-07 17:00:00	NVDA	Stock	0.5472	0.5472	0.5472	0.5472	12000.0
2015-04-07 18:00:00	NVDA	Stock	0.5475	0.5475	0.5475	0.5475	6240.0
2015-04-07 07:00:00	AMZN	Stock	18.863	18.863	18.863	18.863	2000.0
2015-04-07 08:00:00	AMZN	Stock	18.825	18.8625	18.825	18.8625	9400.0
2015-04-07 09:00:00	AMZN	Stock	18.8525	18.9	18.7695	18.803	4491100.0
2015-04-07 10:00:00	AMZN	Stock	18.793	18.9655	18.756	18.8975	7871980.0
2015-04-07 11:00:00	AMZN	Stock	18.8975	18.8975	18.8015	18.8365	3649260.0
2015-04-07 12:00:00	AMZN	Stock	18.8375	18.8615	18.743	18.7884	3191800.0
2015-04-07 13:00:00	AMZN	Stock	18.784	18.8575	18.777	18.8208	3135420.0
2015-04-07 14:00:00	AMZN	Stock	18.82	18.835	18.775	18.7945	3011280.0
2015-04-07 15:00:00	AMZN	Stock	18.8	18.803	18.7015	18.715	9750140.0

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

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