PREVIEW / stock_1hour / 2018-11-19

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-11-19.parquet
  size:    1.1 MB
  rows:    49,832
  symbols: 2,764

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-11-19 04:00:00	AAPL	Stock	48.6775	48.7	47.8575	47.9	62056.0
2018-11-19 05:00:00	AAPL	Stock	47.9	47.9	47.62	47.62	33288.0
2018-11-19 06:00:00	AAPL	Stock	47.68	47.685	47.35	47.4425	134544.0
2018-11-19 07:00:00	AAPL	Stock	47.47	47.8	47.375	47.595	670396.0
2018-11-19 08:00:00	AAPL	Stock	47.595	47.7775	47.375	47.4275	1368868.0
2018-11-19 09:00:00	AAPL	Stock	47.45	47.675	46.965	47.0455	24641900.0
2018-11-19 10:00:00	AAPL	Stock	47.035	47.08	46.725	46.99	22783256.0
2018-11-19 11:00:00	AAPL	Stock	46.9875	47.05	46.4075	46.561	18959756.0
2018-11-19 12:00:00	AAPL	Stock	46.5625	46.765	46.42	46.5425	13930920.0
2018-11-19 13:00:00	AAPL	Stock	46.5425	46.745	46.4275	46.5065	11241536.0
2018-11-19 14:00:00	AAPL	Stock	46.51	46.705	46.3775	46.6382	11136592.0
2018-11-19 15:00:00	AAPL	Stock	46.6325	46.7725	46.2475	46.4625	24570996.0
2018-11-19 16:00:00	AAPL	Stock	46.465	46.5375	46.4425	46.5	16008824.0
2018-11-19 17:00:00	AAPL	Stock	46.4625	46.475	46.1725	46.3375	190788.0
2018-11-19 18:00:00	AAPL	Stock	46.3125	46.465	46.1275	46.2625	218640.0
2018-11-19 19:00:00	AAPL	Stock	46.275	46.275	46.1575	46.225	132444.0
2018-11-19 04:00:00	MSFT	Stock	108.33	108.33	108.33	108.33	145.0
2018-11-19 07:00:00	MSFT	Stock	108.23	108.59	108.04	108.3	16150.0
2018-11-19 08:00:00	MSFT	Stock	108.25	108.59	107.9	107.9	24343.0
2018-11-19 09:00:00	MSFT	Stock	107.97	108.56	106.83	107.14	2485471.0
2018-11-19 10:00:00	MSFT	Stock	107.14	107.202	104.79	105.815	6591476.0
2018-11-19 11:00:00	MSFT	Stock	105.81	105.94	104.51	104.88	4883153.0
2018-11-19 12:00:00	MSFT	Stock	104.85	104.98	104.08	104.26	4714265.0
2018-11-19 13:00:00	MSFT	Stock	104.265	104.6	103.55	104.09	4440805.0
2018-11-19 14:00:00	MSFT	Stock	104.085	104.57	103.69	104.46	4084567.0
2018-11-19 15:00:00	MSFT	Stock	104.465	105.09	104.19	104.62	6184238.0
2018-11-19 16:00:00	MSFT	Stock	104.63	104.93	104.5	104.81	4097905.0
2018-11-19 17:00:00	MSFT	Stock	104.87	104.87	104.63	104.65	16257.0
2018-11-19 18:00:00	MSFT	Stock	104.7	104.85	104.45	104.83	38901.0
2018-11-19 19:00:00	MSFT	Stock	104.77	104.78	104.57	104.65	13534.0
2018-11-19 04:00:00	NVDA	Stock	4.1425	4.1425	4.1155	4.1235	92280.0
2018-11-19 05:00:00	NVDA	Stock	4.125	4.125	4.1083	4.1083	59760.0
2018-11-19 06:00:00	NVDA	Stock	4.1083	4.1083	4.085	4.0875	275000.0
2018-11-19 07:00:00	NVDA	Stock	4.0888	4.0888	4.033	4.0475	1715440.0
2018-11-19 08:00:00	NVDA	Stock	4.0688	4.0875	4.0328	4.0435	4256680.0
2018-11-19 09:00:00	NVDA	Stock	4.0435	4.072	3.8272	3.8392	288984280.0
2018-11-19 10:00:00	NVDA	Stock	3.8385	3.8925	3.7658	3.884	351447240.0
2018-11-19 11:00:00	NVDA	Stock	3.8842	3.903	3.845	3.8689	152472680.0
2018-11-19 12:00:00	NVDA	Stock	3.8688	3.8822	3.798	3.7981	127329280.0
2018-11-19 13:00:00	NVDA	Stock	3.7982	3.7992	3.7125	3.7138	206598680.0
2018-11-19 14:00:00	NVDA	Stock	3.7153	3.752	3.7005	3.732	158932080.0
2018-11-19 15:00:00	NVDA	Stock	3.7328	3.75	3.6158	3.6175	274823240.0
2018-11-19 16:00:00	NVDA	Stock	3.6175	3.6405	3.6142	3.6172	9529440.0
2018-11-19 17:00:00	NVDA	Stock	3.6155	3.6214	3.595	3.5988	1697520.0
2018-11-19 18:00:00	NVDA	Stock	3.5972	3.6175	3.573	3.5775	1687280.0
2018-11-19 19:00:00	NVDA	Stock	3.575	3.59	3.5675	3.5688	1293320.0
2018-11-19 04:00:00	AMZN	Stock	79.9045	79.9045	79.9045	79.9045	6860.0
2018-11-19 05:00:00	AMZN	Stock	80.0	80.0	79.9	79.9	35140.0
2018-11-19 07:00:00	AMZN	Stock	79.5685	79.75	79.45	79.65	135260.0
2018-11-19 08:00:00	AMZN	Stock	79.525	79.8231	79.2555	79.355	233740.0

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

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