PREVIEW / stock_1hour / 2018-10-22

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-10-22.parquet
  size:    1.1 MB
  rows:    49,475
  symbols: 2,747

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-10-22 04:00:00	AAPL	Stock	54.75	55.07	54.75	55.005	6868.0
2018-10-22 05:00:00	AAPL	Stock	55.0525	55.055	55.02	55.02	18720.0
2018-10-22 06:00:00	AAPL	Stock	55.0875	55.18	55.0	55.18	30384.0
2018-10-22 07:00:00	AAPL	Stock	55.18	55.365	55.1625	55.25	207532.0
2018-10-22 08:00:00	AAPL	Stock	55.235	55.3625	55.1	55.1	511784.0
2018-10-22 09:00:00	AAPL	Stock	55.1	55.3075	54.7275	54.9628	13448808.0
2018-10-22 10:00:00	AAPL	Stock	54.955	55.83	54.9275	55.6605	18924928.0
2018-10-22 11:00:00	AAPL	Stock	55.6625	55.84	55.39	55.48	12604516.0
2018-10-22 12:00:00	AAPL	Stock	55.48	55.605	55.1975	55.3825	10445992.0
2018-10-22 13:00:00	AAPL	Stock	55.38	55.4925	55.144	55.1475	8185884.0
2018-10-22 14:00:00	AAPL	Stock	55.145	55.355	55.065	55.3	7929624.0
2018-10-22 15:00:00	AAPL	Stock	55.2975	55.57	55.145	55.1475	14192416.0
2018-10-22 16:00:00	AAPL	Stock	55.1475	55.22	55.1175	55.1275	11605076.0
2018-10-22 17:00:00	AAPL	Stock	55.125	55.1625	55.125	55.16	44004.0
2018-10-22 18:00:00	AAPL	Stock	55.15	55.175	55.13	55.175	24456.0
2018-10-22 19:00:00	AAPL	Stock	55.175	55.1825	55.04	55.05	45620.0
2018-10-22 04:00:00	MSFT	Stock	109.1	109.61	108.95	108.95	2499.0
2018-10-22 05:00:00	MSFT	Stock	109.31	109.31	108.74	108.74	2606.0
2018-10-22 06:00:00	MSFT	Stock	109.08	109.15	109.0	109.15	5556.0
2018-10-22 07:00:00	MSFT	Stock	109.03	109.55	109.03	109.5	16701.0
2018-10-22 08:00:00	MSFT	Stock	109.55	109.75	109.1	109.4	36641.0
2018-10-22 09:00:00	MSFT	Stock	109.34	109.648	108.44	108.62	3230045.0
2018-10-22 10:00:00	MSFT	Stock	108.62	110.54	108.24	110.27	4357617.0
2018-10-22 11:00:00	MSFT	Stock	110.27	110.48	109.41	109.66	3201077.0
2018-10-22 12:00:00	MSFT	Stock	109.67	110.01	108.92	109.85	2447715.0
2018-10-22 13:00:00	MSFT	Stock	109.83	110.07	109.4	109.495	1685194.0
2018-10-22 14:00:00	MSFT	Stock	109.5	110.01	109.43	109.831	1588974.0
2018-10-22 15:00:00	MSFT	Stock	109.83	110.35	109.63	109.63	3921935.0
2018-10-22 16:00:00	MSFT	Stock	109.63	109.86	109.63	109.77	3295522.0
2018-10-22 17:00:00	MSFT	Stock	109.73	109.77	109.63	109.65	4742.0
2018-10-22 18:00:00	MSFT	Stock	109.7	109.87	109.63	109.87	2419.0
2018-10-22 19:00:00	MSFT	Stock	109.63	109.9	109.41	109.58	36019.0
2018-10-22 04:00:00	NVDA	Stock	5.7748	5.8482	5.7748	5.8482	52160.0
2018-10-22 05:00:00	NVDA	Stock	5.79	5.795	5.775	5.775	68920.0
2018-10-22 06:00:00	NVDA	Stock	5.7862	5.7862	5.7862	5.7862	50000.0
2018-10-22 07:00:00	NVDA	Stock	5.7875	5.8088	5.77	5.802	541800.0
2018-10-22 08:00:00	NVDA	Stock	5.7812	5.8075	5.7602	5.775	1791440.0
2018-10-22 09:00:00	NVDA	Stock	5.775	5.8125	5.682	5.6852	75560720.0
2018-10-22 10:00:00	NVDA	Stock	5.6852	5.883	5.6768	5.8268	81749880.0
2018-10-22 11:00:00	NVDA	Stock	5.8253	5.8598	5.7645	5.7733	34049720.0
2018-10-22 12:00:00	NVDA	Stock	5.7767	5.8	5.7478	5.7738	28094400.0
2018-10-22 13:00:00	NVDA	Stock	5.7737	5.786	5.7368	5.738	20270400.0
2018-10-22 14:00:00	NVDA	Stock	5.7375	5.7978	5.73	5.7885	25023240.0
2018-10-22 15:00:00	NVDA	Stock	5.7898	5.825	5.7763	5.7785	45896800.0
2018-10-22 16:00:00	NVDA	Stock	5.7805	5.788	5.7678	5.788	3791440.0
2018-10-22 17:00:00	NVDA	Stock	5.7735	5.775	5.7665	5.77	101880.0
2018-10-22 18:00:00	NVDA	Stock	5.7678	5.775	5.765	5.775	345040.0
2018-10-22 19:00:00	NVDA	Stock	5.78	5.7875	5.765	5.765	87840.0
2018-10-22 04:00:00	AMZN	Stock	88.8305	88.9995	88.7845	88.85	43340.0
2018-10-22 05:00:00	AMZN	Stock	88.797	88.797	88.797	88.797	3020.0

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

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