PREVIEW / stock_1hour / 2018-04-18

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-04-18.parquet
  size:    1.1 MB
  rows:    49,656
  symbols: 2,855

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-04-18 04:00:00	AAPL	Stock	44.685	44.685	44.595	44.595	1200.0
2018-04-18 05:00:00	AAPL	Stock	44.625	44.625	44.54	44.54	3600.0
2018-04-18 06:00:00	AAPL	Stock	44.5425	44.625	44.5375	44.625	8860.0
2018-04-18 07:00:00	AAPL	Stock	44.6	44.685	44.6	44.62	60180.0
2018-04-18 08:00:00	AAPL	Stock	44.625	44.6875	44.53	44.55	134428.0
2018-04-18 09:00:00	AAPL	Stock	44.565	44.705	44.3975	44.4238	11541612.0
2018-04-18 10:00:00	AAPL	Stock	44.425	44.4325	44.22	44.4225	13463984.0
2018-04-18 11:00:00	AAPL	Stock	44.4212	44.5325	44.41	44.4875	8756340.0
2018-04-18 12:00:00	AAPL	Stock	44.4862	44.5825	44.43	44.475	5679944.0
2018-04-18 13:00:00	AAPL	Stock	44.475	44.5775	44.4675	44.4815	5710244.0
2018-04-18 14:00:00	AAPL	Stock	44.485	44.66	44.445	44.5765	7833976.0
2018-04-18 15:00:00	AAPL	Stock	44.5788	44.685	44.44	44.46	11471280.0
2018-04-18 16:00:00	AAPL	Stock	44.46	44.638	44.4475	44.4975	9577500.0
2018-04-18 17:00:00	AAPL	Stock	44.4775	44.5525	44.475	44.515	51908.0
2018-04-18 18:00:00	AAPL	Stock	44.5125	44.52	44.495	44.495	16152.0
2018-04-18 19:00:00	AAPL	Stock	44.5125	44.55	44.5	44.55	20832.0
2018-04-18 04:00:00	MSFT	Stock	96.39	96.39	96.39	96.39	100.0
2018-04-18 05:00:00	MSFT	Stock	96.34	96.34	96.34	96.34	768.0
2018-04-18 06:00:00	MSFT	Stock	96.34	96.39	96.34	96.39	2211.0
2018-04-18 07:00:00	MSFT	Stock	96.4	96.52	96.37	96.5	3110.0
2018-04-18 08:00:00	MSFT	Stock	96.59	96.59	96.35	96.49	18081.0
2018-04-18 09:00:00	MSFT	Stock	96.483	96.68	95.88	96.06	2417130.0
2018-04-18 10:00:00	MSFT	Stock	96.06	96.23	95.52	96.09	3779965.0
2018-04-18 11:00:00	MSFT	Stock	96.1	96.29	95.98	96.175	2172194.0
2018-04-18 12:00:00	MSFT	Stock	96.18	96.68	96.18	96.546	2744909.0
2018-04-18 13:00:00	MSFT	Stock	96.545	96.59	96.255	96.3	1312753.0
2018-04-18 14:00:00	MSFT	Stock	96.3	96.65	96.18	96.42	1975784.0
2018-04-18 15:00:00	MSFT	Stock	96.42	96.72	96.34	96.45	3148993.0
2018-04-18 16:00:00	MSFT	Stock	96.44	96.48	96.39	96.44	1820228.0
2018-04-18 17:00:00	MSFT	Stock	96.47	96.57	96.44	96.56	12082.0
2018-04-18 18:00:00	MSFT	Stock	96.55	96.56	96.49	96.49	1205.0
2018-04-18 19:00:00	MSFT	Stock	96.57	96.69	96.57	96.69	4373.0
2018-04-18 04:00:00	NVDA	Stock	5.9498	5.95	5.945	5.95	18640.0
2018-04-18 07:00:00	NVDA	Stock	5.9462	5.96	5.9068	5.9078	1075280.0
2018-04-18 08:00:00	NVDA	Stock	5.9468	5.9513	5.8813	5.885	1795920.0
2018-04-18 09:00:00	NVDA	Stock	5.8852	5.9135	5.8192	5.9095	87092640.0
2018-04-18 10:00:00	NVDA	Stock	5.91	5.9238	5.8575	5.9119	67687480.0
2018-04-18 11:00:00	NVDA	Stock	5.9118	5.947	5.9092	5.9303	41779520.0
2018-04-18 12:00:00	NVDA	Stock	5.9312	5.9812	5.931	5.9575	46339320.0
2018-04-18 13:00:00	NVDA	Stock	5.9578	5.9645	5.9268	5.932	18767240.0
2018-04-18 14:00:00	NVDA	Stock	5.9343	5.96	5.9258	5.9392	25911360.0
2018-04-18 15:00:00	NVDA	Stock	5.9398	5.9545	5.8953	5.909	68750240.0
2018-04-18 16:00:00	NVDA	Stock	5.9092	5.9122	5.9048	5.9118	7324880.0
2018-04-18 17:00:00	NVDA	Stock	5.9118	5.9343	5.9075	5.9252	278320.0
2018-04-18 18:00:00	NVDA	Stock	5.9248	5.9248	5.917	5.917	85800.0
2018-04-18 19:00:00	NVDA	Stock	5.92	5.95	5.92	5.925	477400.0
2018-04-18 04:00:00	AMZN	Stock	75.55	75.975	75.55	75.9	10000.0
2018-04-18 05:00:00	AMZN	Stock	75.9	75.9	75.7	75.7	11000.0
2018-04-18 06:00:00	AMZN	Stock	75.456	75.6	75.456	75.55	72100.0
2018-04-18 07:00:00	AMZN	Stock	75.5175	75.9715	75.5175	75.893	525580.0

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

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