PREVIEW / stock_1hour / 2017-03-22

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-03-22.parquet
  size:    1.0 MB
  rows:    48,235
  symbols: 3,076

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
2017-03-22 04:00:00	AAPL	Stock	34.8125	34.8125	34.685	34.735	17212.0
2017-03-22 05:00:00	AAPL	Stock	34.6775	34.775	34.6675	34.775	25708.0
2017-03-22 06:00:00	AAPL	Stock	34.76	34.7725	34.715	34.75	40260.0
2017-03-22 07:00:00	AAPL	Stock	34.775	34.875	34.755	34.85	265876.0
2017-03-22 08:00:00	AAPL	Stock	34.85	34.8975	34.73	34.8775	341160.0
2017-03-22 09:00:00	AAPL	Stock	34.895	35.25	34.875	35.1025	18855860.0
2017-03-22 10:00:00	AAPL	Stock	35.11	35.2	34.99	35.1975	17181328.0
2017-03-22 11:00:00	AAPL	Stock	35.197	35.3472	35.1675	35.28	13709120.0
2017-03-22 12:00:00	AAPL	Stock	35.2812	35.3075	35.2025	35.2475	8053548.0
2017-03-22 13:00:00	AAPL	Stock	35.245	35.285	35.1575	35.2175	8078700.0
2017-03-22 14:00:00	AAPL	Stock	35.22	35.305	35.2075	35.295	6591664.0
2017-03-22 15:00:00	AAPL	Stock	35.2942	35.4	35.27	35.3575	14262608.0
2017-03-22 16:00:00	AAPL	Stock	35.355	35.36	35.2188	35.3125	7877912.0
2017-03-22 17:00:00	AAPL	Stock	35.3	35.3125	35.2925	35.3125	64532.0
2017-03-22 18:00:00	AAPL	Stock	35.325	35.35	35.3175	35.3475	31744.0
2017-03-22 19:00:00	AAPL	Stock	35.3475	35.375	35.3425	35.375	38012.0
2017-03-22 04:00:00	MSFT	Stock	64.05	64.05	64.05	64.05	110.0
2017-03-22 07:00:00	MSFT	Stock	64.06	64.1	64.06	64.06	2451.0
2017-03-22 08:00:00	MSFT	Stock	64.06	64.2	64.05	64.1	9967.0
2017-03-22 09:00:00	MSFT	Stock	64.13	64.53	64.06	64.34	2276444.0
2017-03-22 10:00:00	MSFT	Stock	64.35	64.82	64.32	64.82	2696780.0
2017-03-22 11:00:00	MSFT	Stock	64.81	65.07	64.695	64.885	2496541.0
2017-03-22 12:00:00	MSFT	Stock	64.885	64.94	64.815	64.92	1702252.0
2017-03-22 13:00:00	MSFT	Stock	64.92	65.03	64.81	64.89	1646949.0
2017-03-22 14:00:00	MSFT	Stock	64.9	65.098	64.87	65.06	1596728.0
2017-03-22 15:00:00	MSFT	Stock	65.055	65.14	64.97	65.05	3500913.0
2017-03-22 16:00:00	MSFT	Stock	65.03	65.08	64.895	65.0	3064480.0
2017-03-22 17:00:00	MSFT	Stock	64.99	64.99	64.95	64.95	2614.0
2017-03-22 18:00:00	MSFT	Stock	64.99	64.99	64.99	64.99	935.0
2017-03-22 19:00:00	MSFT	Stock	65.03	65.08	65.0	65.0	920.0
2017-03-22 04:00:00	NVDA	Stock	2.6225	2.6225	2.6203	2.6225	44000.0
2017-03-22 06:00:00	NVDA	Stock	2.627	2.627	2.627	2.627	12000.0
2017-03-22 07:00:00	NVDA	Stock	2.6285	2.635	2.6282	2.635	149360.0
2017-03-22 08:00:00	NVDA	Stock	2.6338	2.64	2.6188	2.6343	1116320.0
2017-03-22 09:00:00	NVDA	Stock	2.6355	2.6898	2.6325	2.6585	107165600.0
2017-03-22 10:00:00	NVDA	Stock	2.6585	2.6875	2.6468	2.6775	128777800.0
2017-03-22 11:00:00	NVDA	Stock	2.6778	2.6843	2.6628	2.6762	59556880.0
2017-03-22 12:00:00	NVDA	Stock	2.6758	2.681	2.667	2.6802	40446720.0
2017-03-22 13:00:00	NVDA	Stock	2.6808	2.695	2.6722	2.6925	54136440.0
2017-03-22 14:00:00	NVDA	Stock	2.6925	2.7065	2.6863	2.7032	89024800.0
2017-03-22 15:00:00	NVDA	Stock	2.7032	2.7038	2.6904	2.7018	85517640.0
2017-03-22 16:00:00	NVDA	Stock	2.7018	2.7042	2.695	2.6952	17797040.0
2017-03-22 17:00:00	NVDA	Stock	2.7005	2.7012	2.695	2.7012	375200.0
2017-03-22 18:00:00	NVDA	Stock	2.7018	2.7042	2.7005	2.7042	216680.0
2017-03-22 19:00:00	NVDA	Stock	2.705	2.7088	2.7042	2.7085	235560.0
2017-03-22 04:00:00	AMZN	Stock	41.975	41.975	41.975	41.975	2000.0
2017-03-22 05:00:00	AMZN	Stock	41.9	41.95	41.9	41.95	10000.0
2017-03-22 06:00:00	AMZN	Stock	41.9605	42.0045	41.95	42.0045	37140.0
2017-03-22 07:00:00	AMZN	Stock	42.05	42.05	42.025	42.025	5080.0
2017-03-22 08:00:00	AMZN	Stock	42.003	42.099	42.0	42.025	73680.0

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

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