PREVIEW / stock_1hour / 2016-10-07

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-10-07.parquet
  size:    1.0 MB
  rows:    47,219
  symbols: 3,186

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-10-07 06:00:00	AAPL	Stock	28.4525	28.4525	28.385	28.445	4200.0
2016-10-07 07:00:00	AAPL	Stock	28.46	28.4725	28.4475	28.4625	45080.0
2016-10-07 08:00:00	AAPL	Stock	28.4625	28.565	28.4	28.5575	477488.0
2016-10-07 09:00:00	AAPL	Stock	28.5575	28.64	28.455	28.5325	19393040.0
2016-10-07 10:00:00	AAPL	Stock	28.535	28.595	28.485	28.49	13395992.0
2016-10-07 11:00:00	AAPL	Stock	28.49	28.575	28.3775	28.4288	13830128.0
2016-10-07 12:00:00	AAPL	Stock	28.4275	28.4875	28.415	28.4875	8324256.0
2016-10-07 13:00:00	AAPL	Stock	28.485	28.565	28.4575	28.5475	10164440.0
2016-10-07 14:00:00	AAPL	Stock	28.5475	28.575	28.5275	28.5425	7392276.0
2016-10-07 15:00:00	AAPL	Stock	28.5425	28.562	28.5025	28.5075	12354676.0
2016-10-07 16:00:00	AAPL	Stock	28.515	28.5315	28.5	28.5075	6208648.0
2016-10-07 17:00:00	AAPL	Stock	28.5025	28.5125	28.5025	28.5125	5804.0
2016-10-07 18:00:00	AAPL	Stock	28.5	28.5	28.4925	28.4925	11516.0
2016-10-07 19:00:00	AAPL	Stock	28.4875	28.4875	28.4675	28.4825	43920.0
2016-10-07 08:00:00	MSFT	Stock	57.7	57.7	57.7	57.7	1000.0
2016-10-07 09:00:00	MSFT	Stock	57.82	57.95	57.545	57.7	2915117.0
2016-10-07 10:00:00	MSFT	Stock	57.7	57.97	57.67	57.74	2371779.0
2016-10-07 11:00:00	MSFT	Stock	57.74	57.86	57.42	57.505	2115484.0
2016-10-07 12:00:00	MSFT	Stock	57.505	57.63	57.455	57.565	1589342.0
2016-10-07 13:00:00	MSFT	Stock	57.57	57.86	57.515	57.825	2072536.0
2016-10-07 14:00:00	MSFT	Stock	57.826	57.98	57.77	57.96	1884069.0
2016-10-07 15:00:00	MSFT	Stock	57.95	57.97	57.75	57.79	4329081.0
2016-10-07 16:00:00	MSFT	Stock	57.8	57.85	57.728	57.76	1945821.0
2016-10-07 17:00:00	MSFT	Stock	57.72	57.78	57.72	57.78	1300.0
2016-10-07 19:00:00	MSFT	Stock	57.8	57.8	57.8	57.8	200.0
2016-10-07 06:00:00	NVDA	Stock	1.6875	1.6875	1.6875	1.6875	16000.0
2016-10-07 08:00:00	NVDA	Stock	1.6863	1.6935	1.685	1.6935	39680.0
2016-10-07 09:00:00	NVDA	Stock	1.6898	1.6962	1.6788	1.689	56639360.0
2016-10-07 10:00:00	NVDA	Stock	1.6892	1.6992	1.6792	1.68	37003400.0
2016-10-07 11:00:00	NVDA	Stock	1.6798	1.6843	1.6665	1.6692	32349960.0
2016-10-07 12:00:00	NVDA	Stock	1.669	1.6735	1.6665	1.6685	24220040.0
2016-10-07 13:00:00	NVDA	Stock	1.6685	1.6775	1.6685	1.6738	29023160.0
2016-10-07 14:00:00	NVDA	Stock	1.6738	1.6751	1.6706	1.6739	24191480.0
2016-10-07 15:00:00	NVDA	Stock	1.6739	1.675	1.67	1.671	47513680.0
2016-10-07 16:00:00	NVDA	Stock	1.6712	1.674	1.67	1.67	12236800.0
2016-10-07 17:00:00	NVDA	Stock	1.67	1.674	1.67	1.67	319400.0
2016-10-07 18:00:00	NVDA	Stock	1.67	1.6703	1.67	1.67	48000.0
2016-10-07 19:00:00	NVDA	Stock	1.67	1.6703	1.67	1.6703	32000.0
2016-10-07 04:00:00	AMZN	Stock	42.075	42.075	42.075	42.075	4000.0
2016-10-07 06:00:00	AMZN	Stock	42.1	42.1	42.05	42.05	8980.0
2016-10-07 07:00:00	AMZN	Stock	42.1145	42.15	42.1145	42.15	8000.0
2016-10-07 08:00:00	AMZN	Stock	42.125	42.232	42.1055	42.201	244120.0
2016-10-07 09:00:00	AMZN	Stock	42.2225	42.2975	41.9965	42.0235	8291940.0
2016-10-07 10:00:00	AMZN	Stock	42.0085	42.154	41.97	42.086	5427820.0
2016-10-07 11:00:00	AMZN	Stock	42.087	42.1625	41.8725	41.955	6093000.0
2016-10-07 12:00:00	AMZN	Stock	41.95	41.9973	41.89	41.9865	2834540.0
2016-10-07 13:00:00	AMZN	Stock	41.9928	42.1105	41.946	42.05	3867780.0
2016-10-07 14:00:00	AMZN	Stock	42.0436	42.125	42.024	42.0912	3700480.0
2016-10-07 15:00:00	AMZN	Stock	42.0995	42.1065	41.9325	41.9705	10253000.0
2016-10-07 16:00:00	AMZN	Stock	41.9715	41.9715	41.933	41.9505	2275900.0

> showing 50 of 47,219 rows — these rows as CSV

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