PREVIEW / stock_1hour / 2018-11-21

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-11-21.parquet
  size:    1.1 MB
  rows:    48,386
  symbols: 2,716

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-11-21 04:00:00	AAPL	Stock	44.5125	44.725	44.5125	44.66	68388.0
2018-11-21 05:00:00	AAPL	Stock	44.6075	44.7	44.575	44.6375	25812.0
2018-11-21 06:00:00	AAPL	Stock	44.5575	44.7325	44.0725	44.075	144692.0
2018-11-21 07:00:00	AAPL	Stock	44.1225	44.88	44.1225	44.775	798864.0
2018-11-21 08:00:00	AAPL	Stock	44.4238	44.91	44.2488	44.695	1423716.0
2018-11-21 09:00:00	AAPL	Stock	44.7025	45.0675	44.3075	44.56	22265836.0
2018-11-21 10:00:00	AAPL	Stock	44.562	44.7475	44.2675	44.58	21323928.0
2018-11-21 11:00:00	AAPL	Stock	44.575	44.815	44.39	44.4375	13935100.0
2018-11-21 12:00:00	AAPL	Stock	44.44	44.5625	44.2875	44.5525	8446332.0
2018-11-21 13:00:00	AAPL	Stock	44.5575	44.595	44.4175	44.5925	7472844.0
2018-11-21 14:00:00	AAPL	Stock	44.59	44.5925	44.4525	44.4708	5520460.0
2018-11-21 15:00:00	AAPL	Stock	44.4725	44.5125	44.1375	44.19	16821468.0
2018-11-21 16:00:00	AAPL	Stock	44.195	44.225	44.1425	44.1575	11684796.0
2018-11-21 17:00:00	AAPL	Stock	44.1625	44.195	44.155	44.1675	43060.0
2018-11-21 18:00:00	AAPL	Stock	44.1875	44.2375	44.1875	44.2125	26180.0
2018-11-21 19:00:00	AAPL	Stock	44.225	44.2475	44.2	44.245	37452.0
2018-11-21 04:00:00	MSFT	Stock	102.8	103.2	102.6	102.6	5424.0
2018-11-21 05:00:00	MSFT	Stock	103.0	103.0	102.6	102.7	725.0
2018-11-21 06:00:00	MSFT	Stock	102.45	102.84	102.45	102.51	4755.0
2018-11-21 07:00:00	MSFT	Stock	102.61	104.17	102.55	103.1	40228.0
2018-11-21 08:00:00	MSFT	Stock	103.1	103.5	102.6	103.1	82060.0
2018-11-21 09:00:00	MSFT	Stock	103.19	103.723	102.24	102.99	4498302.0
2018-11-21 10:00:00	MSFT	Stock	103.0	103.59	102.81	103.275	4442783.0
2018-11-21 11:00:00	MSFT	Stock	103.28	104.18	103.07	103.93	4002307.0
2018-11-21 12:00:00	MSFT	Stock	103.94	104.43	103.78	104.385	2462798.0
2018-11-21 13:00:00	MSFT	Stock	104.39	104.417	103.88	104.07	1559313.0
2018-11-21 14:00:00	MSFT	Stock	104.06	104.14	103.74	103.82	1502290.0
2018-11-21 15:00:00	MSFT	Stock	103.83	104.125	103.07	103.08	4345643.0
2018-11-21 16:00:00	MSFT	Stock	103.12	103.39	103.0	103.13	2793626.0
2018-11-21 17:00:00	MSFT	Stock	103.19	103.19	103.1	103.13	769.0
2018-11-21 18:00:00	MSFT	Stock	103.1	103.1	103.04	103.07	2640.0
2018-11-21 19:00:00	MSFT	Stock	103.14	103.23	103.13	103.2	4545.0
2018-11-21 04:00:00	NVDA	Stock	3.8	3.8425	3.8	3.8175	392720.0
2018-11-21 05:00:00	NVDA	Stock	3.8175	3.8312	3.8125	3.8248	230760.0
2018-11-21 06:00:00	NVDA	Stock	3.8275	3.8425	3.8125	3.825	116400.0
2018-11-21 07:00:00	NVDA	Stock	3.821	3.91	3.821	3.8775	7129280.0
2018-11-21 08:00:00	NVDA	Stock	3.8792	3.912	3.8312	3.8688	7342000.0
2018-11-21 09:00:00	NVDA	Stock	3.8688	3.8912	3.713	3.752	201181320.0
2018-11-21 10:00:00	NVDA	Stock	3.752	3.7788	3.6208	3.6348	225637720.0
2018-11-21 11:00:00	NVDA	Stock	3.6352	3.6928	3.6138	3.6355	131918360.0
2018-11-21 12:00:00	NVDA	Stock	3.6362	3.6412	3.5903	3.6258	118826320.0
2018-11-21 13:00:00	NVDA	Stock	3.6252	3.6388	3.5965	3.6365	70994920.0
2018-11-21 14:00:00	NVDA	Stock	3.6375	3.6382	3.6008	3.609	62472120.0
2018-11-21 15:00:00	NVDA	Stock	3.6083	3.63	3.6055	3.6178	108546800.0
2018-11-21 16:00:00	NVDA	Stock	3.6178	3.6248	3.6092	3.622	22424200.0
2018-11-21 17:00:00	NVDA	Stock	3.6225	3.6235	3.618	3.6205	334680.0
2018-11-21 18:00:00	NVDA	Stock	3.6225	3.6298	3.6225	3.6298	238840.0
2018-11-21 19:00:00	NVDA	Stock	3.628	3.635	3.6275	3.635	351560.0
2018-11-21 04:00:00	AMZN	Stock	75.75	75.753	75.654	75.753	12360.0
2018-11-21 06:00:00	AMZN	Stock	75.875	75.875	75.875	75.875	3280.0

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

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