PREVIEW / stock_1hour / 2017-03-30

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-03-30.parquet
  size:    1.0 MB
  rows:    48,213
  symbols: 3,095

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-30 04:00:00	AAPL	Stock	36.1125	36.1125	36.05	36.05	40968.0
2017-03-30 05:00:00	AAPL	Stock	36.075	36.1175	36.075	36.1175	8992.0
2017-03-30 06:00:00	AAPL	Stock	36.095	36.1125	36.075	36.075	22384.0
2017-03-30 07:00:00	AAPL	Stock	36.075	36.0975	36.05	36.09	63664.0
2017-03-30 08:00:00	AAPL	Stock	36.07	36.0925	35.875	36.08	214616.0
2017-03-30 09:00:00	AAPL	Stock	36.075	36.125	35.97	36.02	13808644.0
2017-03-30 10:00:00	AAPL	Stock	36.02	36.1	36.0025	36.0425	11828808.0
2017-03-30 11:00:00	AAPL	Stock	36.0425	36.06	35.9375	35.9425	8095324.0
2017-03-30 12:00:00	AAPL	Stock	35.9405	35.97	35.875	35.9332	8828720.0
2017-03-30 13:00:00	AAPL	Stock	35.9325	36.035	35.9175	36.0	7833408.0
2017-03-30 14:00:00	AAPL	Stock	36.0025	36.0075	35.9175	35.945	5902180.0
2017-03-30 15:00:00	AAPL	Stock	35.9457	36.0	35.93	35.98	9122244.0
2017-03-30 16:00:00	AAPL	Stock	35.9825	35.9875	35.9475	35.965	10319156.0
2017-03-30 17:00:00	AAPL	Stock	35.965	35.975	35.955	35.975	9464.0
2017-03-30 18:00:00	AAPL	Stock	35.9725	35.9775	35.9625	35.9775	14772.0
2017-03-30 19:00:00	AAPL	Stock	35.955	35.975	35.9425	35.9425	15984.0
2017-03-30 08:00:00	MSFT	Stock	65.54	65.54	65.4	65.5	2052.0
2017-03-30 09:00:00	MSFT	Stock	65.5	65.8	65.33	65.75	1898456.0
2017-03-30 10:00:00	MSFT	Stock	65.74	65.98	65.73	65.92	2510104.0
2017-03-30 11:00:00	MSFT	Stock	65.92	65.94	65.76	65.79	1553379.0
2017-03-30 12:00:00	MSFT	Stock	65.79	65.87	65.61	65.665	1243408.0
2017-03-30 13:00:00	MSFT	Stock	65.665	65.81	65.65	65.725	1048089.0
2017-03-30 14:00:00	MSFT	Stock	65.73	65.83	65.665	65.69	1785128.0
2017-03-30 15:00:00	MSFT	Stock	65.69	65.79	65.61	65.71	2828317.0
2017-03-30 16:00:00	MSFT	Stock	65.71	65.772	65.71	65.76	1213807.0
2017-03-30 17:00:00	MSFT	Stock	65.71	65.71	65.64	65.64	350.0
2017-03-30 18:00:00	MSFT	Stock	65.71	65.71	65.71	65.71	3681.0
2017-03-30 19:00:00	MSFT	Stock	65.71	65.71	65.71	65.71	2400.0
2017-03-30 06:00:00	NVDA	Stock	2.6863	2.6863	2.6863	2.6863	4000.0
2017-03-30 07:00:00	NVDA	Stock	2.6832	2.6832	2.681	2.681	21480.0
2017-03-30 08:00:00	NVDA	Stock	2.6832	2.6835	2.678	2.6835	241360.0
2017-03-30 09:00:00	NVDA	Stock	2.685	2.7165	2.6825	2.7152	70118920.0
2017-03-30 10:00:00	NVDA	Stock	2.7141	2.7343	2.7133	2.7232	112040560.0
2017-03-30 11:00:00	NVDA	Stock	2.7235	2.7278	2.715	2.717	45635120.0
2017-03-30 12:00:00	NVDA	Stock	2.7178	2.7265	2.7155	2.725	32716440.0
2017-03-30 13:00:00	NVDA	Stock	2.725	2.75	2.7235	2.742	79271720.0
2017-03-30 14:00:00	NVDA	Stock	2.7423	2.7483	2.7325	2.7348	66687640.0
2017-03-30 15:00:00	NVDA	Stock	2.7349	2.74	2.7282	2.7352	68413160.0
2017-03-30 16:00:00	NVDA	Stock	2.735	2.7388	2.7328	2.735	12836480.0
2017-03-30 17:00:00	NVDA	Stock	2.7355	2.7442	2.735	2.7442	719240.0
2017-03-30 18:00:00	NVDA	Stock	2.7425	2.7435	2.7375	2.7413	176320.0
2017-03-30 19:00:00	NVDA	Stock	2.7418	2.7418	2.7395	2.74	316880.0
2017-03-30 06:00:00	AMZN	Stock	43.7445	43.7445	43.7445	43.7445	4000.0
2017-03-30 07:00:00	AMZN	Stock	43.725	43.744	43.708	43.74	29640.0
2017-03-30 08:00:00	AMZN	Stock	43.725	43.775	43.716	43.769	269520.0
2017-03-30 09:00:00	AMZN	Stock	43.77	43.853	43.606	43.7765	11484780.0
2017-03-30 10:00:00	AMZN	Stock	43.778	43.8086	43.61	43.6865	7892400.0
2017-03-30 11:00:00	AMZN	Stock	43.689	43.743	43.583	43.586	5706340.0
2017-03-30 12:00:00	AMZN	Stock	43.586	43.7413	43.5835	43.7145	5226840.0
2017-03-30 13:00:00	AMZN	Stock	43.707	43.809	43.703	43.7176	5358320.0

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

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