PREVIEW / stock_1hour / 2019-01-18

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-01-18.parquet
  size:    1.1 MB
  rows:    49,837
  symbols: 2,699

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
2019-01-18 04:00:00	AAPL	Stock	39.125	39.23	39.125	39.195	16680.0
2019-01-18 05:00:00	AAPL	Stock	39.2	39.2	39.0025	39.0325	24336.0
2019-01-18 06:00:00	AAPL	Stock	39.075	39.1675	39.075	39.1675	8064.0
2019-01-18 07:00:00	AAPL	Stock	39.175	39.24	39.1325	39.155	182504.0
2019-01-18 08:00:00	AAPL	Stock	39.2382	39.29	39.125	39.255	583780.0
2019-01-18 09:00:00	AAPL	Stock	39.255	39.4925	39.055	39.135	26369160.0
2019-01-18 10:00:00	AAPL	Stock	39.135	39.47	39.055	39.2525	17763348.0
2019-01-18 11:00:00	AAPL	Stock	39.2528	39.3625	39.185	39.325	9965120.0
2019-01-18 12:00:00	AAPL	Stock	39.325	39.4075	39.2125	39.3608	11362740.0
2019-01-18 13:00:00	AAPL	Stock	39.365	39.4025	39.0375	39.3575	8489460.0
2019-01-18 14:00:00	AAPL	Stock	39.355	39.3675	39.07	39.1725	10363912.0
2019-01-18 15:00:00	AAPL	Stock	39.1738	39.2175	38.9952	39.205	17829796.0
2019-01-18 16:00:00	AAPL	Stock	39.22	39.22	39.0935	39.1625	13932756.0
2019-01-18 17:00:00	AAPL	Stock	39.15	39.205	39.1192	39.15	553200.0
2019-01-18 18:00:00	AAPL	Stock	39.1625	39.205	39.115	39.14	146088.0
2019-01-18 19:00:00	AAPL	Stock	39.15	39.1725	39.1125	39.14	30088.0
2019-01-18 04:00:00	MSFT	Stock	106.59	106.78	106.59	106.78	1200.0
2019-01-18 05:00:00	MSFT	Stock	106.77	106.78	106.4	106.5	9576.0
2019-01-18 06:00:00	MSFT	Stock	106.5	106.77	106.5	106.72	4325.0
2019-01-18 07:00:00	MSFT	Stock	106.85	107.07	106.85	106.85	32694.0
2019-01-18 08:00:00	MSFT	Stock	106.98	106.99	106.8	106.82	31841.0
2019-01-18 09:00:00	MSFT	Stock	106.94	107.8	106.19	106.375	9308332.0
2019-01-18 10:00:00	MSFT	Stock	106.38	107.12	105.91	106.965	5335632.0
2019-01-18 11:00:00	MSFT	Stock	106.97	107.59	106.9	107.36	3208469.0
2019-01-18 12:00:00	MSFT	Stock	107.37	107.89	107.28	107.885	2895173.0
2019-01-18 13:00:00	MSFT	Stock	107.89	107.9	107.434	107.545	2200369.0
2019-01-18 14:00:00	MSFT	Stock	107.545	107.545	106.96	107.375	2156449.0
2019-01-18 15:00:00	MSFT	Stock	107.38	107.79	107.24	107.71	4482573.0
2019-01-18 16:00:00	MSFT	Stock	107.73	107.88	107.51	107.88	4941190.0
2019-01-18 17:00:00	MSFT	Stock	107.88	107.88	107.71	107.76	2894.0
2019-01-18 18:00:00	MSFT	Stock	107.71	107.85	107.71	107.85	79492.0
2019-01-18 19:00:00	MSFT	Stock	107.82	107.91	107.79	107.86	3569.0
2019-01-18 04:00:00	NVDA	Stock	3.8282	3.8282	3.8282	3.8282	4000.0
2019-01-18 05:00:00	NVDA	Stock	3.8185	3.825	3.8185	3.825	65200.0
2019-01-18 06:00:00	NVDA	Stock	3.8128	3.8238	3.8093	3.8238	14000.0
2019-01-18 07:00:00	NVDA	Stock	3.83	3.8428	3.814	3.8252	1289280.0
2019-01-18 08:00:00	NVDA	Stock	3.835	3.8425	3.82	3.8413	1785600.0
2019-01-18 09:00:00	NVDA	Stock	3.836	3.8508	3.7912	3.838	85660840.0
2019-01-18 10:00:00	NVDA	Stock	3.8365	3.9275	3.8181	3.9267	135267400.0
2019-01-18 11:00:00	NVDA	Stock	3.9272	3.9482	3.9163	3.9422	94857480.0
2019-01-18 12:00:00	NVDA	Stock	3.9428	3.9495	3.9158	3.925	55672000.0
2019-01-18 13:00:00	NVDA	Stock	3.9255	3.9265	3.9038	3.924	42682600.0
2019-01-18 14:00:00	NVDA	Stock	3.9243	3.927	3.8699	3.894	64453840.0
2019-01-18 15:00:00	NVDA	Stock	3.8939	3.9292	3.8826	3.9232	83954360.0
2019-01-18 16:00:00	NVDA	Stock	3.9232	3.925	3.9138	3.9188	11363240.0
2019-01-18 17:00:00	NVDA	Stock	3.9188	3.9288	3.915	3.918	1210240.0
2019-01-18 18:00:00	NVDA	Stock	3.9245	3.9288	3.9232	3.9238	267520.0
2019-01-18 19:00:00	NVDA	Stock	3.9232	3.93	3.9208	3.925	127720.0
2019-01-18 04:00:00	AMZN	Stock	85.1	85.1	85.1	85.1	2000.0
2019-01-18 05:00:00	AMZN	Stock	85.185	85.185	84.95	84.95	14780.0

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

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