PREVIEW / stock_1hour / 2016-12-15

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-12-15.parquet
  size:    1.1 MB
  rows:    49,241
  symbols: 3,170

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
2016-12-15 04:00:00	AAPL	Stock	28.755	28.755	28.7525	28.7525	800.0
2016-12-15 05:00:00	AAPL	Stock	28.75	28.75	28.6875	28.725	7308.0
2016-12-15 06:00:00	AAPL	Stock	28.7075	28.74	28.67	28.675	27608.0
2016-12-15 07:00:00	AAPL	Stock	28.7	28.725	28.6725	28.7175	76404.0
2016-12-15 08:00:00	AAPL	Stock	28.68	28.7975	28.68	28.7775	254756.0
2016-12-15 09:00:00	AAPL	Stock	28.7875	29.1825	28.7725	29.1175	24302420.0
2016-12-15 10:00:00	AAPL	Stock	29.12	29.125	28.955	29.0275	16325128.0
2016-12-15 11:00:00	AAPL	Stock	29.0275	29.12	28.9838	29.0125	12788352.0
2016-12-15 12:00:00	AAPL	Stock	29.0125	29.0635	28.96	29.0375	10453856.0
2016-12-15 13:00:00	AAPL	Stock	29.0375	29.0875	28.8525	28.9088	12763120.0
2016-12-15 14:00:00	AAPL	Stock	28.9075	28.99	28.865	28.9485	8931708.0
2016-12-15 15:00:00	AAPL	Stock	28.9488	29.02	28.93	28.955	15673728.0
2016-12-15 16:00:00	AAPL	Stock	28.9525	29.0	28.8875	28.95	16199548.0
2016-12-15 17:00:00	AAPL	Stock	28.95	28.955	28.935	28.95	46228.0
2016-12-15 18:00:00	AAPL	Stock	28.955	28.9575	28.9525	28.9575	21384.0
2016-12-15 19:00:00	AAPL	Stock	28.975	29.0	28.97	28.975	53248.0
2016-12-15 05:00:00	MSFT	Stock	62.85	62.85	62.75	62.75	2459.0
2016-12-15 06:00:00	MSFT	Stock	62.84	62.9	62.75	62.85	3100.0
2016-12-15 07:00:00	MSFT	Stock	62.85	62.85	62.85	62.85	4400.0
2016-12-15 08:00:00	MSFT	Stock	62.85	62.85	62.7	62.82	3527.0
2016-12-15 09:00:00	MSFT	Stock	62.85	63.15	62.54	62.83	3107591.0
2016-12-15 10:00:00	MSFT	Stock	62.83	62.88	62.66	62.695	3288028.0
2016-12-15 11:00:00	MSFT	Stock	62.69	63.154	62.68	62.99	2745868.0
2016-12-15 12:00:00	MSFT	Stock	62.99	63.03	62.86	62.935	2067258.0
2016-12-15 13:00:00	MSFT	Stock	62.94	63.08	62.3	62.445	3333316.0
2016-12-15 14:00:00	MSFT	Stock	62.45	62.64	62.38	62.49	3193968.0
2016-12-15 15:00:00	MSFT	Stock	62.495	62.75	62.405	62.57	5274994.0
2016-12-15 16:00:00	MSFT	Stock	62.58	62.62	62.52	62.62	2931511.0
2016-12-15 17:00:00	MSFT	Stock	62.72	62.72	62.72	62.72	5000.0
2016-12-15 19:00:00	MSFT	Stock	62.7	62.7	62.59	62.59	1200.0
2016-12-15 05:00:00	NVDA	Stock	2.4178	2.4178	2.4178	2.4178	4000.0
2016-12-15 06:00:00	NVDA	Stock	2.4388	2.4388	2.4338	2.4338	44000.0
2016-12-15 07:00:00	NVDA	Stock	2.4388	2.4412	2.433	2.433	169160.0
2016-12-15 08:00:00	NVDA	Stock	2.4388	2.439	2.4062	2.43	1579400.0
2016-12-15 09:00:00	NVDA	Stock	2.4313	2.4845	2.415	2.476	154684920.0
2016-12-15 10:00:00	NVDA	Stock	2.475	2.4948	2.4532	2.4695	162523720.0
2016-12-15 11:00:00	NVDA	Stock	2.4708	2.4865	2.4692	2.481	78253920.0
2016-12-15 12:00:00	NVDA	Stock	2.481	2.4985	2.4802	2.4908	73634840.0
2016-12-15 13:00:00	NVDA	Stock	2.491	2.492	2.4565	2.463	61818000.0
2016-12-15 14:00:00	NVDA	Stock	2.4635	2.4755	2.4576	2.4662	56743000.0
2016-12-15 15:00:00	NVDA	Stock	2.4663	2.4723	2.4538	2.468	92202640.0
2016-12-15 16:00:00	NVDA	Stock	2.4678	2.4728	2.4678	2.472	32598560.0
2016-12-15 17:00:00	NVDA	Stock	2.472	2.4725	2.472	2.472	120880.0
2016-12-15 18:00:00	NVDA	Stock	2.4692	2.472	2.469	2.472	110280.0
2016-12-15 19:00:00	NVDA	Stock	2.4695	2.4725	2.4695	2.4725	114400.0
2016-12-15 06:00:00	AMZN	Stock	38.4705	38.4795	38.4	38.4	32960.0
2016-12-15 07:00:00	AMZN	Stock	38.437	38.445	38.437	38.4425	14200.0
2016-12-15 08:00:00	AMZN	Stock	38.445	38.467	38.3525	38.465	377780.0
2016-12-15 09:00:00	AMZN	Stock	38.445	38.46	38.134	38.1972	13054320.0
2016-12-15 10:00:00	AMZN	Stock	38.208	38.397	38.083	38.2435	13438380.0

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

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