PREVIEW / stock_1hour / 2018-10-16

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-10-16.parquet
  size:    1.1 MB
  rows:    49,729
  symbols: 2,767

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-16 04:00:00	AAPL	Stock	54.5	54.725	54.5	54.5	16568.0
2018-10-16 05:00:00	AAPL	Stock	54.6	54.6	54.6	54.6	2400.0
2018-10-16 06:00:00	AAPL	Stock	54.5975	54.6875	54.575	54.6725	15020.0
2018-10-16 07:00:00	AAPL	Stock	54.6725	54.6875	54.5	54.6875	225832.0
2018-10-16 08:00:00	AAPL	Stock	54.6	54.825	54.515	54.7875	436436.0
2018-10-16 09:00:00	AAPL	Stock	54.795	54.88	54.45	54.635	14402684.0
2018-10-16 10:00:00	AAPL	Stock	54.6225	54.715	54.1908	54.5735	16468048.0
2018-10-16 11:00:00	AAPL	Stock	54.5725	55.0575	54.4875	55.0375	13278496.0
2018-10-16 12:00:00	AAPL	Stock	55.0375	55.1575	54.8275	55.0125	8883344.0
2018-10-16 13:00:00	AAPL	Stock	55.0188	55.265	54.99	55.155	7438108.0
2018-10-16 14:00:00	AAPL	Stock	55.155	55.4875	55.1325	55.335	9368952.0
2018-10-16 15:00:00	AAPL	Stock	55.335	55.7475	55.27	55.5325	17922480.0
2018-10-16 16:00:00	AAPL	Stock	55.5375	55.8125	55.381	55.7	8708656.0
2018-10-16 17:00:00	AAPL	Stock	55.7448	55.7975	55.5375	55.7975	105508.0
2018-10-16 18:00:00	AAPL	Stock	55.7575	55.785	55.7175	55.75	66972.0
2018-10-16 19:00:00	AAPL	Stock	55.775	55.8	55.7225	55.7875	52820.0
2018-10-16 04:00:00	MSFT	Stock	108.23	108.9	108.23	108.9	3150.0
2018-10-16 05:00:00	MSFT	Stock	108.8	108.8	108.4	108.5	3989.0
2018-10-16 06:00:00	MSFT	Stock	108.6	108.75	108.6	108.61	1380.0
2018-10-16 07:00:00	MSFT	Stock	108.8	108.8	108.51	108.74	5796.0
2018-10-16 08:00:00	MSFT	Stock	108.65	109.2	108.5	109.1	29625.0
2018-10-16 09:00:00	MSFT	Stock	109.1	109.98	108.85	109.78	3553310.0
2018-10-16 10:00:00	MSFT	Stock	109.775	110.04	109.0	109.97	3991307.0
2018-10-16 11:00:00	MSFT	Stock	109.965	110.87	109.77	110.858	3006852.0
2018-10-16 12:00:00	MSFT	Stock	110.855	110.9	110.39	110.605	1962425.0
2018-10-16 13:00:00	MSFT	Stock	110.6	110.79	110.51	110.615	2234186.0
2018-10-16 14:00:00	MSFT	Stock	110.62	110.77	110.34	110.4	2711610.0
2018-10-16 15:00:00	MSFT	Stock	110.415	111.41	110.3	110.89	6206077.0
2018-10-16 16:00:00	MSFT	Stock	111.0	112.0	110.6	111.6	3835681.0
2018-10-16 17:00:00	MSFT	Stock	111.67	111.68	111.0	111.67	125621.0
2018-10-16 18:00:00	MSFT	Stock	111.41	111.75	111.34	111.34	14684.0
2018-10-16 19:00:00	MSFT	Stock	111.52	111.56	111.41	111.52	7666.0
2018-10-16 04:00:00	NVDA	Stock	5.9668	6.0158	5.9668	5.9725	21280.0
2018-10-16 05:00:00	NVDA	Stock	5.9725	5.9725	5.9725	5.9725	4000.0
2018-10-16 07:00:00	NVDA	Stock	5.997	5.9988	5.9442	5.9585	610800.0
2018-10-16 08:00:00	NVDA	Stock	5.9953	5.9953	5.95	5.985	1557320.0
2018-10-16 09:00:00	NVDA	Stock	5.985	6.0173	5.9485	5.9962	54539920.0
2018-10-16 10:00:00	NVDA	Stock	5.9984	6.0415	5.9505	6.0143	68118560.0
2018-10-16 11:00:00	NVDA	Stock	6.0143	6.0665	5.9975	6.0635	48368400.0
2018-10-16 12:00:00	NVDA	Stock	6.0634	6.072	6.0304	6.0518	32279200.0
2018-10-16 13:00:00	NVDA	Stock	6.0532	6.1	6.0487	6.0943	32774000.0
2018-10-16 14:00:00	NVDA	Stock	6.096	6.1198	6.0858	6.0927	36078600.0
2018-10-16 15:00:00	NVDA	Stock	6.0913	6.157	6.0855	6.1398	64214920.0
2018-10-16 16:00:00	NVDA	Stock	6.1458	6.2748	6.1458	6.23	11008480.0
2018-10-16 17:00:00	NVDA	Stock	6.2275	6.2425	6.225	6.2422	630720.0
2018-10-16 18:00:00	NVDA	Stock	6.23	6.245	6.23	6.244	399080.0
2018-10-16 19:00:00	NVDA	Stock	6.2338	6.2643	6.2338	6.2625	640400.0
2018-10-16 04:00:00	AMZN	Stock	88.7	88.7	88.6	88.6	5040.0
2018-10-16 06:00:00	AMZN	Stock	88.5495	88.6	88.5495	88.55	18100.0
2018-10-16 07:00:00	AMZN	Stock	88.725	88.8615	88.6605	88.7485	143280.0

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

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