PREVIEW / stock_1hour / 2019-06-17

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-06-17.parquet
  size:    1.1 MB
  rows:    49,410
  symbols: 2,574

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-06-17 04:00:00	AAPL	Stock	48.375	48.375	48.16	48.2625	3400.0
2019-06-17 05:00:00	AAPL	Stock	48.2925	48.2925	48.25	48.25	5000.0
2019-06-17 06:00:00	AAPL	Stock	48.2	48.25	48.175	48.225	25176.0
2019-06-17 07:00:00	AAPL	Stock	48.225	48.38	48.225	48.38	77900.0
2019-06-17 08:00:00	AAPL	Stock	48.3125	48.37	48.225	48.25	110580.0
2019-06-17 09:00:00	AAPL	Stock	48.25	48.7125	48.0425	48.66	9786024.0
2019-06-17 10:00:00	AAPL	Stock	48.67	48.74	48.5375	48.6625	7722932.0
2019-06-17 11:00:00	AAPL	Stock	48.6575	48.6725	48.51	48.5375	5819568.0
2019-06-17 12:00:00	AAPL	Stock	48.5325	48.5875	48.4775	48.5538	3786168.0
2019-06-17 13:00:00	AAPL	Stock	48.5525	48.66	48.535	48.6488	3511036.0
2019-06-17 14:00:00	AAPL	Stock	48.65	48.6925	48.5425	48.5575	3612540.0
2019-06-17 15:00:00	AAPL	Stock	48.5575	48.6225	48.39	48.4875	9311200.0
2019-06-17 16:00:00	AAPL	Stock	48.4875	48.4975	48.465	48.4975	4814476.0
2019-06-17 17:00:00	AAPL	Stock	48.497	48.5125	48.475	48.5	41308.0
2019-06-17 18:00:00	AAPL	Stock	48.5125	48.57	48.5	48.57	20516.0
2019-06-17 19:00:00	AAPL	Stock	48.55	48.5625	48.5225	48.5225	8036.0
2019-06-17 04:00:00	MSFT	Stock	132.8	132.8	132.8	132.8	820.0
2019-06-17 05:00:00	MSFT	Stock	132.94	132.94	132.85	132.85	200.0
2019-06-17 06:00:00	MSFT	Stock	132.91	132.97	132.65	132.65	3750.0
2019-06-17 07:00:00	MSFT	Stock	132.65	132.9	132.65	132.9	7603.0
2019-06-17 08:00:00	MSFT	Stock	132.79	132.95	132.56	132.6	17508.0
2019-06-17 09:00:00	MSFT	Stock	132.6	133.73	132.5	133.5	1685660.0
2019-06-17 10:00:00	MSFT	Stock	133.5	133.62	132.835	133.04	1888346.0
2019-06-17 11:00:00	MSFT	Stock	133.04	133.19	132.72	132.76	1121881.0
2019-06-17 12:00:00	MSFT	Stock	132.75	133.1	132.65	133.08	908096.0
2019-06-17 13:00:00	MSFT	Stock	133.08	133.31	133.03	133.25	840070.0
2019-06-17 14:00:00	MSFT	Stock	133.24	133.315	132.92	132.935	854019.0
2019-06-17 15:00:00	MSFT	Stock	132.934	133.03	132.58	132.89	2518546.0
2019-06-17 16:00:00	MSFT	Stock	132.85	133.0	132.78	132.87	2524084.0
2019-06-17 17:00:00	MSFT	Stock	132.987	133.03	132.91	133.0	7387.0
2019-06-17 18:00:00	MSFT	Stock	133.1	133.13	133.05	133.12	5837.0
2019-06-17 19:00:00	MSFT	Stock	133.05	133.17	133.0	133.1	5865.0
2019-06-17 04:00:00	NVDA	Stock	3.6155	3.6155	3.6155	3.6155	4000.0
2019-06-17 06:00:00	NVDA	Stock	3.615	3.615	3.6028	3.6038	80280.0
2019-06-17 07:00:00	NVDA	Stock	3.5978	3.6118	3.5962	3.6118	89720.0
2019-06-17 08:00:00	NVDA	Stock	3.6012	3.625	3.595	3.6058	727880.0
2019-06-17 09:00:00	NVDA	Stock	3.6068	3.6418	3.5913	3.6332	38685680.0
2019-06-17 10:00:00	NVDA	Stock	3.6338	3.6582	3.6212	3.651	51223480.0
2019-06-17 11:00:00	NVDA	Stock	3.6512	3.659	3.636	3.6455	29056720.0
2019-06-17 12:00:00	NVDA	Stock	3.6452	3.6525	3.6418	3.6446	21271240.0
2019-06-17 13:00:00	NVDA	Stock	3.6447	3.655	3.644	3.6538	16483400.0
2019-06-17 14:00:00	NVDA	Stock	3.654	3.663	3.647	3.647	26913480.0
2019-06-17 15:00:00	NVDA	Stock	3.647	3.6488	3.6205	3.6255	47013400.0
2019-06-17 16:00:00	NVDA	Stock	3.6258	3.63	3.6203	3.626	12546680.0
2019-06-17 17:00:00	NVDA	Stock	3.6308	3.6308	3.6238	3.6285	297720.0
2019-06-17 18:00:00	NVDA	Stock	3.6295	3.6312	3.6258	3.6312	256680.0
2019-06-17 19:00:00	NVDA	Stock	3.6312	3.633	3.6252	3.6252	231880.0
2019-06-17 04:00:00	AMZN	Stock	93.75	93.75	93.75	93.75	8780.0
2019-06-17 05:00:00	AMZN	Stock	93.808	93.8305	93.808	93.8305	5060.0
2019-06-17 06:00:00	AMZN	Stock	93.776	93.776	93.645	93.645	24860.0

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

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