PREVIEW / stock_1hour / 2018-12-11

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-12-11.parquet
  size:    1.1 MB
  rows:    49,817
  symbols: 2,730

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-12-11 04:00:00	AAPL	Stock	42.375	42.6425	42.2875	42.6425	13384.0
2018-12-11 05:00:00	AAPL	Stock	42.6425	42.85	42.6425	42.845	35284.0
2018-12-11 06:00:00	AAPL	Stock	42.7575	42.895	42.75	42.78	91560.0
2018-12-11 07:00:00	AAPL	Stock	42.84	42.95	42.7775	42.8025	321536.0
2018-12-11 08:00:00	AAPL	Stock	42.8962	42.995	42.4	42.935	1077216.0
2018-12-11 09:00:00	AAPL	Stock	42.9275	42.9675	42.03	42.0375	25202156.0
2018-12-11 10:00:00	AAPL	Stock	42.0475	42.4625	41.935	42.1243	30347080.0
2018-12-11 11:00:00	AAPL	Stock	42.12	42.5875	42.0375	42.5575	19652736.0
2018-12-11 12:00:00	AAPL	Stock	42.555	42.555	42.0925	42.1	14352780.0
2018-12-11 13:00:00	AAPL	Stock	42.0975	42.26	41.8425	41.8975	12822420.0
2018-12-11 14:00:00	AAPL	Stock	41.895	42.2675	41.75	42.1175	18954188.0
2018-12-11 15:00:00	AAPL	Stock	42.1275	42.4725	41.9925	42.1575	21699060.0
2018-12-11 16:00:00	AAPL	Stock	42.1575	42.1875	42.015	42.06	17712420.0
2018-12-11 17:00:00	AAPL	Stock	42.05	42.085	41.8875	42.0475	94008.0
2018-12-11 18:00:00	AAPL	Stock	42.0475	42.22	42.0475	42.1725	121160.0
2018-12-11 19:00:00	AAPL	Stock	42.15	42.43	42.0975	42.43	110880.0
2018-12-11 04:00:00	MSFT	Stock	107.39	107.7	107.39	107.7	800.0
2018-12-11 05:00:00	MSFT	Stock	108.07	108.11	108.07	108.11	400.0
2018-12-11 06:00:00	MSFT	Stock	108.09	108.8	108.02	108.8	4031.0
2018-12-11 07:00:00	MSFT	Stock	108.8	109.0	108.69	108.71	36679.0
2018-12-11 08:00:00	MSFT	Stock	109.05	109.69	108.55	109.45	112737.0
2018-12-11 09:00:00	MSFT	Stock	109.41	110.922	109.1	110.731	6124173.0
2018-12-11 10:00:00	MSFT	Stock	110.74	110.95	109.53	109.825	7369746.0
2018-12-11 11:00:00	MSFT	Stock	109.83	109.91	108.831	109.48	4461421.0
2018-12-11 12:00:00	MSFT	Stock	109.48	109.48	108.17	108.55	3930391.0
2018-12-11 13:00:00	MSFT	Stock	108.546	108.68	107.44	107.57	3156898.0
2018-12-11 14:00:00	MSFT	Stock	107.58	109.2	107.5	108.84	3832362.0
2018-12-11 15:00:00	MSFT	Stock	108.85	109.55	108.46	108.6	6244151.0
2018-12-11 16:00:00	MSFT	Stock	108.59	108.74	108.11	108.16	3213776.0
2018-12-11 17:00:00	MSFT	Stock	108.26	108.26	108.01	108.1	8979.0
2018-12-11 18:00:00	MSFT	Stock	108.29	108.95	108.29	108.6	7862.0
2018-12-11 19:00:00	MSFT	Stock	108.55	109.5	108.36	109.44	19917.0
2018-12-11 05:00:00	NVDA	Stock	3.8125	3.8472	3.8125	3.8472	72600.0
2018-12-11 06:00:00	NVDA	Stock	3.85	3.85	3.8475	3.85	135920.0
2018-12-11 07:00:00	NVDA	Stock	3.8625	3.8695	3.8488	3.859	1228800.0
2018-12-11 08:00:00	NVDA	Stock	3.8611	3.8962	3.8498	3.8962	2993560.0
2018-12-11 09:00:00	NVDA	Stock	3.8935	3.9035	3.7562	3.7665	117401080.0
2018-12-11 10:00:00	NVDA	Stock	3.7672	3.8215	3.7508	3.7895	115233560.0
2018-12-11 11:00:00	NVDA	Stock	3.7872	3.79	3.7432	3.7532	61106040.0
2018-12-11 12:00:00	NVDA	Stock	3.7531	3.7548	3.7182	3.7358	55580800.0
2018-12-11 13:00:00	NVDA	Stock	3.7338	3.743	3.68	3.6867	51571200.0
2018-12-11 14:00:00	NVDA	Stock	3.686	3.8663	3.625	3.7042	128498080.0
2018-12-11 15:00:00	NVDA	Stock	3.7053	3.7305	3.684	3.7053	98595840.0
2018-12-11 16:00:00	NVDA	Stock	3.7048	3.7125	3.6958	3.7006	18171960.0
2018-12-11 17:00:00	NVDA	Stock	3.6968	3.7005	3.6912	3.7005	401960.0
2018-12-11 18:00:00	NVDA	Stock	3.7025	3.7225	3.6992	3.7105	454720.0
2018-12-11 19:00:00	NVDA	Stock	3.7215	3.731	3.7002	3.725	601200.0
2018-12-11 05:00:00	AMZN	Stock	82.3435	82.6	82.3435	82.6	29320.0
2018-12-11 06:00:00	AMZN	Stock	82.717	83.2735	82.717	83.2215	43200.0
2018-12-11 07:00:00	AMZN	Stock	83.2	83.95	83.2	83.6395	446300.0

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

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