PREVIEW / stock_1hour / 2018-01-23

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-01-23.parquet
  size:    1.1 MB
  rows:    49,566
  symbols: 2,894

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
2018-01-23 04:00:00	AAPL	Stock	44.45	44.5	44.4475	44.475	34184.0
2018-01-23 05:00:00	AAPL	Stock	44.4325	44.475	44.4125	44.4125	12744.0
2018-01-23 06:00:00	AAPL	Stock	44.47	44.475	44.315	44.3875	44792.0
2018-01-23 07:00:00	AAPL	Stock	44.35	44.495	44.35	44.44	108620.0
2018-01-23 08:00:00	AAPL	Stock	44.4375	44.4875	44.345	44.365	395556.0
2018-01-23 09:00:00	AAPL	Stock	44.38	44.635	44.2075	44.495	16498620.0
2018-01-23 10:00:00	AAPL	Stock	44.4975	44.6875	44.4375	44.6475	16045264.0
2018-01-23 11:00:00	AAPL	Stock	44.6475	44.755	44.62	44.625	10749320.0
2018-01-23 12:00:00	AAPL	Stock	44.625	44.745	44.6175	44.704	5773492.0
2018-01-23 13:00:00	AAPL	Stock	44.7038	44.8428	44.6825	44.83	7024628.0
2018-01-23 14:00:00	AAPL	Stock	44.837	44.86	44.255	44.2625	27694988.0
2018-01-23 15:00:00	AAPL	Stock	44.265	44.4375	44.205	44.24	22549324.0
2018-01-23 16:00:00	AAPL	Stock	44.2425	44.2675	44.125	44.175	10221088.0
2018-01-23 17:00:00	AAPL	Stock	44.1725	44.1925	44.145	44.175	75100.0
2018-01-23 18:00:00	AAPL	Stock	44.18	44.2475	44.18	44.2075	67980.0
2018-01-23 19:00:00	AAPL	Stock	44.225	44.3	44.225	44.3	75860.0
2018-01-23 04:00:00	MSFT	Stock	91.94	91.94	91.94	91.94	119.0
2018-01-23 05:00:00	MSFT	Stock	91.94	92.0	91.9	92.0	5310.0
2018-01-23 06:00:00	MSFT	Stock	91.9	91.9	91.81	91.81	4466.0
2018-01-23 07:00:00	MSFT	Stock	91.98	92.09	91.9	92.0	10403.0
2018-01-23 08:00:00	MSFT	Stock	92.0	92.05	91.67	91.67	36503.0
2018-01-23 09:00:00	MSFT	Stock	91.65	92.3	91.64	91.83	3281260.0
2018-01-23 10:00:00	MSFT	Stock	91.83	92.07	91.54	92.0	2912032.0
2018-01-23 11:00:00	MSFT	Stock	92.0	92.07	91.79	91.81	2159890.0
2018-01-23 12:00:00	MSFT	Stock	91.816	91.865	91.575	91.64	1774615.0
2018-01-23 13:00:00	MSFT	Stock	91.64	91.99	91.63	91.96	1314404.0
2018-01-23 14:00:00	MSFT	Stock	91.96	91.993	91.67	91.98	1620209.0
2018-01-23 15:00:00	MSFT	Stock	91.98	92.15	91.83	91.89	4020259.0
2018-01-23 16:00:00	MSFT	Stock	91.9	92.1	91.9	92.0	3526642.0
2018-01-23 17:00:00	MSFT	Stock	92.04	92.05	91.95	91.96	1126.0
2018-01-23 18:00:00	MSFT	Stock	92.05	92.05	91.91	92.04	1142.0
2018-01-23 19:00:00	MSFT	Stock	92.0	92.09	92.0	92.08	3892.0
2018-01-23 04:00:00	NVDA	Stock	5.8835	5.8835	5.8752	5.8813	20080.0
2018-01-23 05:00:00	NVDA	Stock	5.8813	5.8813	5.8813	5.8813	6920.0
2018-01-23 06:00:00	NVDA	Stock	5.8778	5.88	5.85	5.8623	138840.0
2018-01-23 07:00:00	NVDA	Stock	5.8623	5.8968	5.8623	5.8968	833720.0
2018-01-23 08:00:00	NVDA	Stock	5.8715	5.9188	5.8708	5.9	2706760.0
2018-01-23 09:00:00	NVDA	Stock	5.8992	5.9438	5.8775	5.9135	83246880.0
2018-01-23 10:00:00	NVDA	Stock	5.9158	5.9782	5.9025	5.9635	102142400.0
2018-01-23 11:00:00	NVDA	Stock	5.9638	5.9915	5.9626	5.9729	52191600.0
2018-01-23 12:00:00	NVDA	Stock	5.9727	5.9958	5.9663	5.9722	35199600.0
2018-01-23 13:00:00	NVDA	Stock	5.9728	5.9815	5.9668	5.9737	23648960.0
2018-01-23 14:00:00	NVDA	Stock	5.972	5.9755	5.9335	5.9547	40956280.0
2018-01-23 15:00:00	NVDA	Stock	5.955	5.9868	5.95	5.9735	58309160.0
2018-01-23 16:00:00	NVDA	Stock	5.9728	5.9728	5.9295	5.9728	15055920.0
2018-01-23 17:00:00	NVDA	Stock	5.957	5.96	5.95	5.955	412880.0
2018-01-23 18:00:00	NVDA	Stock	5.9548	5.955	5.95	5.95	599400.0
2018-01-23 19:00:00	NVDA	Stock	5.9563	5.9583	5.95	5.951	259240.0
2018-01-23 04:00:00	AMZN	Stock	66.95	66.95	66.95	66.95	2140.0
2018-01-23 05:00:00	AMZN	Stock	66.995	67.0	66.9	66.9	41360.0

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

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