PREVIEW / stock_1hour / 2018-03-26

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-03-26.parquet
  size:    1.1 MB
  rows:    49,268
  symbols: 2,882

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-03-26 04:00:00	AAPL	Stock	41.7125	42.175	41.7125	42.175	36400.0
2018-03-26 05:00:00	AAPL	Stock	42.105	42.1875	42.105	42.1625	25732.0
2018-03-26 06:00:00	AAPL	Stock	42.165	42.2225	42.07	42.1575	58804.0
2018-03-26 07:00:00	AAPL	Stock	42.1575	42.1875	42.0	42.0125	405004.0
2018-03-26 08:00:00	AAPL	Stock	42.04	42.1875	41.9575	41.975	666884.0
2018-03-26 09:00:00	AAPL	Stock	41.975	42.47	41.91	42.3525	21038540.0
2018-03-26 10:00:00	AAPL	Stock	42.3525	42.43	41.9775	42.0525	17949728.0
2018-03-26 11:00:00	AAPL	Stock	42.055	42.145	41.61	41.9275	15272456.0
2018-03-26 12:00:00	AAPL	Stock	41.9275	42.3025	41.8237	42.1925	9574284.0
2018-03-26 13:00:00	AAPL	Stock	42.1925	42.495	42.1825	42.3725	9277896.0
2018-03-26 14:00:00	AAPL	Stock	42.3775	42.99	42.375	42.8762	15701680.0
2018-03-26 15:00:00	AAPL	Stock	42.8815	43.275	42.86	43.19	23500896.0
2018-03-26 16:00:00	AAPL	Stock	43.1925	43.2725	42.0492	43.15	15901300.0
2018-03-26 17:00:00	AAPL	Stock	43.15	43.2125	43.1425	43.2075	78092.0
2018-03-26 18:00:00	AAPL	Stock	43.2075	43.225	43.2	43.21	17612.0
2018-03-26 19:00:00	AAPL	Stock	43.245	43.25	43.1925	43.25	33892.0
2018-03-26 04:00:00	MSFT	Stock	88.25	89.2	88.25	89.0	18700.0
2018-03-26 05:00:00	MSFT	Stock	88.98	89.6	88.82	89.36	18171.0
2018-03-26 06:00:00	MSFT	Stock	89.37	89.76	89.15	89.74	61597.0
2018-03-26 07:00:00	MSFT	Stock	89.65	90.55	89.55	90.08	110378.0
2018-03-26 08:00:00	MSFT	Stock	89.665	90.75	89.65	90.227	98019.0
2018-03-26 09:00:00	MSFT	Stock	90.1	92.46	90.0	92.21	10297113.0
2018-03-26 10:00:00	MSFT	Stock	92.2	92.72	91.95	92.25	7829762.0
2018-03-26 11:00:00	MSFT	Stock	92.25	92.3	91.39	91.895	5423789.0
2018-03-26 12:00:00	MSFT	Stock	91.9	92.49	91.56	92.39	3870758.0
2018-03-26 13:00:00	MSFT	Stock	92.39	93.24	92.29	92.47	3851454.0
2018-03-26 14:00:00	MSFT	Stock	92.48	93.38	92.37	93.16	4968193.0
2018-03-26 15:00:00	MSFT	Stock	93.16	94.0	93.12	93.77	8037662.0
2018-03-26 16:00:00	MSFT	Stock	93.85	93.97	92.703	93.78	7243181.0
2018-03-26 17:00:00	MSFT	Stock	93.85	93.97	93.85	93.86	13252.0
2018-03-26 18:00:00	MSFT	Stock	93.94	93.95	93.87	93.95	16107.0
2018-03-26 19:00:00	MSFT	Stock	93.97	94.19	93.92	94.19	10640.0
2018-03-26 04:00:00	NVDA	Stock	5.9	5.9672	5.9	5.925	148200.0
2018-03-26 05:00:00	NVDA	Stock	5.9263	5.9675	5.9263	5.9625	131680.0
2018-03-26 06:00:00	NVDA	Stock	5.9625	5.9625	5.934	5.934	192800.0
2018-03-26 07:00:00	NVDA	Stock	5.9338	5.96	5.925	5.939	1164480.0
2018-03-26 08:00:00	NVDA	Stock	5.9561	5.96	5.9268	5.9338	4066680.0
2018-03-26 09:00:00	NVDA	Stock	5.925	6.05	5.92	6.0212	103491440.0
2018-03-26 10:00:00	NVDA	Stock	6.02	6.0371	5.957	5.9901	122451160.0
2018-03-26 11:00:00	NVDA	Stock	5.9879	5.996	5.8975	5.949	82365000.0
2018-03-26 12:00:00	NVDA	Stock	5.9488	5.9693	5.9208	5.9435	38806520.0
2018-03-26 13:00:00	NVDA	Stock	5.9435	6.015	5.935	5.9947	52809320.0
2018-03-26 14:00:00	NVDA	Stock	5.9958	6.0653	5.9875	6.0375	55722240.0
2018-03-26 15:00:00	NVDA	Stock	6.038	6.1133	6.0375	6.1098	77664640.0
2018-03-26 16:00:00	NVDA	Stock	6.107	6.1188	6.1012	6.1075	18170400.0
2018-03-26 17:00:00	NVDA	Stock	6.1032	6.11	6.1028	6.1028	144040.0
2018-03-26 18:00:00	NVDA	Stock	6.107	6.1193	6.1068	6.119	520480.0
2018-03-26 19:00:00	NVDA	Stock	6.1168	6.121	6.1125	6.1198	436040.0
2018-03-26 04:00:00	AMZN	Stock	75.5505	76.5	75.5505	76.4	39740.0
2018-03-26 05:00:00	AMZN	Stock	76.3285	76.55	76.3	76.55	20520.0

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

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