PREVIEW / stock_1hour / 2016-12-09

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-12-09.parquet
  size:    1.1 MB
  rows:    48,758
  symbols: 3,167

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-09 04:00:00	AAPL	Stock	28.0	28.0	27.9125	27.9125	6800.0
2016-12-09 05:00:00	AAPL	Stock	27.905	27.95	27.905	27.95	1200.0
2016-12-09 06:00:00	AAPL	Stock	27.9375	27.9375	27.9375	27.9375	1248.0
2016-12-09 07:00:00	AAPL	Stock	27.995	28.0225	27.99	28.0075	48428.0
2016-12-09 08:00:00	AAPL	Stock	28.025	28.1	27.975	28.0875	106080.0
2016-12-09 09:00:00	AAPL	Stock	28.0875	28.3775	28.0775	28.3575	20377772.0
2016-12-09 10:00:00	AAPL	Stock	28.3575	28.675	28.29	28.52	31640348.0
2016-12-09 11:00:00	AAPL	Stock	28.5225	28.6375	28.5125	28.56	16505504.0
2016-12-09 12:00:00	AAPL	Stock	28.565	28.575	28.445	28.45	9349176.0
2016-12-09 13:00:00	AAPL	Stock	28.4525	28.5325	28.3975	28.5228	8564972.0
2016-12-09 14:00:00	AAPL	Stock	28.5225	28.5375	28.4675	28.5132	8129924.0
2016-12-09 15:00:00	AAPL	Stock	28.515	28.575	28.445	28.49	21579224.0
2016-12-09 16:00:00	AAPL	Stock	28.46	28.4875	28.4575	28.47	8646940.0
2016-12-09 17:00:00	AAPL	Stock	28.475	28.4925	28.47	28.4775	218652.0
2016-12-09 18:00:00	AAPL	Stock	28.485	28.4875	28.4475	28.4725	47416.0
2016-12-09 19:00:00	AAPL	Stock	28.4625	28.4725	28.4475	28.4475	39900.0
2016-12-09 06:00:00	MSFT	Stock	61.04	61.04	61.04	61.04	500.0
2016-12-09 07:00:00	MSFT	Stock	60.91	60.91	60.85	60.85	10920.0
2016-12-09 08:00:00	MSFT	Stock	60.85	61.15	60.85	61.02	23380.0
2016-12-09 09:00:00	MSFT	Stock	61.02	61.62	61.02	61.43	2741777.0
2016-12-09 10:00:00	MSFT	Stock	61.43	61.8	61.31	61.68	3079081.0
2016-12-09 11:00:00	MSFT	Stock	61.68	61.845	61.59	61.78	3396725.0
2016-12-09 12:00:00	MSFT	Stock	61.79	61.87	61.72	61.8	2078284.0
2016-12-09 13:00:00	MSFT	Stock	61.8	61.93	61.8	61.93	1922313.0
2016-12-09 14:00:00	MSFT	Stock	61.93	61.93	61.79	61.86	1969569.0
2016-12-09 15:00:00	MSFT	Stock	61.87	61.99	61.83	61.98	5119509.0
2016-12-09 16:00:00	MSFT	Stock	61.97	62.04	61.92	62.04	5653920.0
2016-12-09 17:00:00	MSFT	Stock	62.05	62.05	61.97	61.97	35922.0
2016-12-09 18:00:00	MSFT	Stock	62.04	62.04	62.0	62.0	1170.0
2016-12-09 19:00:00	MSFT	Stock	62.04	62.04	62.03	62.03	668.0
2016-12-09 06:00:00	NVDA	Stock	2.337	2.3462	2.337	2.3462	15920.0
2016-12-09 07:00:00	NVDA	Stock	2.345	2.3462	2.345	2.3462	26760.0
2016-12-09 08:00:00	NVDA	Stock	2.3462	2.3585	2.3462	2.3475	211200.0
2016-12-09 09:00:00	NVDA	Stock	2.3488	2.3568	2.3048	2.3051	43606280.0
2016-12-09 10:00:00	NVDA	Stock	2.3051	2.3125	2.2678	2.2935	109448960.0
2016-12-09 11:00:00	NVDA	Stock	2.2934	2.297	2.2728	2.281	48210120.0
2016-12-09 12:00:00	NVDA	Stock	2.281	2.2985	2.2768	2.2968	33864360.0
2016-12-09 13:00:00	NVDA	Stock	2.296	2.3085	2.2915	2.3042	39766760.0
2016-12-09 14:00:00	NVDA	Stock	2.3045	2.305	2.2892	2.296	26337200.0
2016-12-09 15:00:00	NVDA	Stock	2.2965	2.297	2.2875	2.2955	58758680.0
2016-12-09 16:00:00	NVDA	Stock	2.2955	2.2968	2.289	2.295	1551760.0
2016-12-09 17:00:00	NVDA	Stock	2.2948	2.295	2.2915	2.2915	85520.0
2016-12-09 18:00:00	NVDA	Stock	2.2915	2.2915	2.2915	2.2915	8000.0
2016-12-09 19:00:00	NVDA	Stock	2.2948	2.2962	2.2925	2.2955	68600.0
2016-12-09 04:00:00	AMZN	Stock	38.3935	38.3935	38.3935	38.3935	2000.0
2016-12-09 06:00:00	AMZN	Stock	38.4495	38.4495	38.4495	38.4495	2000.0
2016-12-09 07:00:00	AMZN	Stock	38.434	38.4895	38.434	38.45	18560.0
2016-12-09 08:00:00	AMZN	Stock	38.4475	38.485	38.4475	38.4835	71560.0
2016-12-09 09:00:00	AMZN	Stock	38.484	38.55	38.338	38.4592	7386420.0
2016-12-09 10:00:00	AMZN	Stock	38.4608	38.48	38.2875	38.288	8006840.0

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

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