PREVIEW / stock_1hour / 2019-10-10

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-10-10.parquet
  size:    1.1 MB
  rows:    48,969
  symbols: 2,522

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-10-10 04:00:00	AAPL	Stock	56.6725	57.0375	56.5525	56.93	64452.0
2019-10-10 05:00:00	AAPL	Stock	56.915	56.95	56.8075	56.875	41712.0
2019-10-10 06:00:00	AAPL	Stock	56.9375	57.075	56.9375	57.025	91112.0
2019-10-10 07:00:00	AAPL	Stock	56.97	57.05	56.705	56.825	286044.0
2019-10-10 08:00:00	AAPL	Stock	56.9125	57.0	56.6175	56.9325	436820.0
2019-10-10 09:00:00	AAPL	Stock	56.94	57.55	56.825	57.4655	17932652.0
2019-10-10 10:00:00	AAPL	Stock	57.465	57.5475	57.2375	57.5338	16729300.0
2019-10-10 11:00:00	AAPL	Stock	57.535	57.61	57.47	57.5175	11770436.0
2019-10-10 12:00:00	AAPL	Stock	57.5175	57.575	57.3125	57.475	9977644.0
2019-10-10 13:00:00	AAPL	Stock	57.4725	57.48	57.2755	57.435	6516040.0
2019-10-10 14:00:00	AAPL	Stock	57.4362	57.4775	57.075	57.4425	10638572.0
2019-10-10 15:00:00	AAPL	Stock	57.4425	57.575	57.43	57.5225	15661812.0
2019-10-10 16:00:00	AAPL	Stock	57.5225	57.725	57.4005	57.6875	5266684.0
2019-10-10 17:00:00	AAPL	Stock	57.705	57.7475	56.7575	57.71	184504.0
2019-10-10 18:00:00	AAPL	Stock	57.71	57.77	57.6375	57.745	233392.0
2019-10-10 19:00:00	AAPL	Stock	57.75	57.8125	57.69	57.8125	160588.0
2019-10-10 04:00:00	MSFT	Stock	137.88	138.4	137.75	138.3	7089.0
2019-10-10 05:00:00	MSFT	Stock	138.33	138.33	138.0	138.0	2048.0
2019-10-10 06:00:00	MSFT	Stock	138.23	138.49	138.22	138.25	11447.0
2019-10-10 07:00:00	MSFT	Stock	138.24	138.34	137.88	138.05	26068.0
2019-10-10 08:00:00	MSFT	Stock	138.1	138.4	138.0	138.34	25200.0
2019-10-10 09:00:00	MSFT	Stock	138.26	139.39	138.1	139.33	2365011.0
2019-10-10 10:00:00	MSFT	Stock	139.34	139.4	138.6	139.285	2341097.0
2019-10-10 11:00:00	MSFT	Stock	139.29	139.665	139.22	139.62	1981267.0
2019-10-10 12:00:00	MSFT	Stock	139.615	139.67	138.82	139.2	1146135.0
2019-10-10 13:00:00	MSFT	Stock	139.19	139.24	138.75	139.095	1072445.0
2019-10-10 14:00:00	MSFT	Stock	139.09	139.115	138.29	138.925	1418009.0
2019-10-10 15:00:00	MSFT	Stock	138.925	139.37	138.819	139.1	2496728.0
2019-10-10 16:00:00	MSFT	Stock	139.1	139.77	139.1	139.69	2077906.0
2019-10-10 17:00:00	MSFT	Stock	139.7	139.727	139.1	139.46	18028.0
2019-10-10 18:00:00	MSFT	Stock	139.5	139.7	139.27	139.42	8726.0
2019-10-10 19:00:00	MSFT	Stock	139.43	139.56	139.25	139.55	9445.0
2019-10-10 04:00:00	NVDA	Stock	4.509	4.5175	4.509	4.5153	12000.0
2019-10-10 05:00:00	NVDA	Stock	4.504	4.504	4.504	4.504	4000.0
2019-10-10 06:00:00	NVDA	Stock	4.5178	4.5178	4.5088	4.5088	57560.0
2019-10-10 07:00:00	NVDA	Stock	4.504	4.504	4.4975	4.4975	145960.0
2019-10-10 08:00:00	NVDA	Stock	4.4938	4.5075	4.4938	4.5075	631320.0
2019-10-10 09:00:00	NVDA	Stock	4.5005	4.5965	4.4938	4.5908	34932200.0
2019-10-10 10:00:00	NVDA	Stock	4.5893	4.6092	4.5632	4.6042	43631440.0
2019-10-10 11:00:00	NVDA	Stock	4.6048	4.627	4.6015	4.6095	31316840.0
2019-10-10 12:00:00	NVDA	Stock	4.609	4.619	4.5658	4.58	38201480.0
2019-10-10 13:00:00	NVDA	Stock	4.5806	4.5812	4.5392	4.568	35215240.0
2019-10-10 14:00:00	NVDA	Stock	4.5678	4.5779	4.5345	4.5771	21996320.0
2019-10-10 15:00:00	NVDA	Stock	4.577	4.5948	4.5678	4.5752	39392360.0
2019-10-10 16:00:00	NVDA	Stock	4.575	4.6	4.5737	4.6	13216280.0
2019-10-10 17:00:00	NVDA	Stock	4.6	4.6083	4.597	4.6	1035480.0
2019-10-10 18:00:00	NVDA	Stock	4.605	4.605	4.5938	4.6	407560.0
2019-10-10 19:00:00	NVDA	Stock	4.6	4.606	4.595	4.606	406800.0
2019-10-10 06:00:00	AMZN	Stock	86.3615	86.3615	86.3615	86.3615	2000.0
2019-10-10 07:00:00	AMZN	Stock	86.163	86.163	85.999	86.05	41960.0

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

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