PREVIEW / stock_1hour / 2019-10-16

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-10-16.parquet
  size:    1.1 MB
  rows:    49,359
  symbols: 2,517

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
2019-10-16 04:00:00	AAPL	Stock	58.75	58.75	58.6325	58.675	14184.0
2019-10-16 05:00:00	AAPL	Stock	58.655	58.6625	58.565	58.565	28016.0
2019-10-16 06:00:00	AAPL	Stock	58.65	58.6625	58.6	58.6	13508.0
2019-10-16 07:00:00	AAPL	Stock	58.625	58.7125	58.61	58.66	78012.0
2019-10-16 08:00:00	AAPL	Stock	58.625	58.785	58.625	58.6725	230368.0
2019-10-16 09:00:00	AAPL	Stock	58.6875	58.81	58.3	58.64	12897688.0
2019-10-16 10:00:00	AAPL	Stock	58.6325	58.665	58.4	58.615	11203800.0
2019-10-16 11:00:00	AAPL	Stock	58.61	58.6842	58.4425	58.59	7260820.0
2019-10-16 12:00:00	AAPL	Stock	58.5925	58.6225	58.3988	58.425	5594352.0
2019-10-16 13:00:00	AAPL	Stock	58.426	58.515	58.405	58.4275	4651932.0
2019-10-16 14:00:00	AAPL	Stock	58.425	58.5375	58.4125	58.4962	4189792.0
2019-10-16 15:00:00	AAPL	Stock	58.4975	58.645	58.4275	58.5975	8986392.0
2019-10-16 16:00:00	AAPL	Stock	58.5975	58.7	58.5875	58.6625	6768192.0
2019-10-16 17:00:00	AAPL	Stock	58.6625	58.7	58.6625	58.6825	25564.0
2019-10-16 18:00:00	AAPL	Stock	58.695	58.6975	58.61	58.61	65188.0
2019-10-16 19:00:00	AAPL	Stock	58.6475	58.6475	58.5625	58.5875	70376.0
2019-10-16 05:00:00	MSFT	Stock	141.36	141.36	141.36	141.36	100.0
2019-10-16 06:00:00	MSFT	Stock	141.29	141.3	141.29	141.3	1539.0
2019-10-16 07:00:00	MSFT	Stock	141.28	141.36	141.23	141.34	3345.0
2019-10-16 08:00:00	MSFT	Stock	141.3	141.5	141.0	141.01	19048.0
2019-10-16 09:00:00	MSFT	Stock	141.1	141.208	139.53	139.695	3352759.0
2019-10-16 10:00:00	MSFT	Stock	139.67	140.69	139.59	140.51	3183345.0
2019-10-16 11:00:00	MSFT	Stock	140.5	140.64	139.86	139.97	2142572.0
2019-10-16 12:00:00	MSFT	Stock	139.96	140.16	139.77	139.92	1302921.0
2019-10-16 13:00:00	MSFT	Stock	139.92	140.14	139.79	139.88	1517509.0
2019-10-16 14:00:00	MSFT	Stock	139.88	140.4	139.82	140.29	1281636.0
2019-10-16 15:00:00	MSFT	Stock	140.295	140.51	140.11	140.48	2559850.0
2019-10-16 16:00:00	MSFT	Stock	140.41	140.59	140.36	140.463	2860772.0
2019-10-16 17:00:00	MSFT	Stock	140.54	140.55	140.47	140.5	4463.0
2019-10-16 18:00:00	MSFT	Stock	140.5	140.55	140.37	140.37	8356.0
2019-10-16 19:00:00	MSFT	Stock	140.35	140.54	140.35	140.35	5568.0
2019-10-16 04:00:00	NVDA	Stock	4.9	4.9	4.885	4.885	37760.0
2019-10-16 05:00:00	NVDA	Stock	4.8813	4.8813	4.8813	4.8813	12120.0
2019-10-16 06:00:00	NVDA	Stock	4.8852	4.8852	4.8852	4.8852	16000.0
2019-10-16 07:00:00	NVDA	Stock	4.895	4.8988	4.8888	4.8925	166880.0
2019-10-16 08:00:00	NVDA	Stock	4.8938	4.9092	4.8703	4.88	1268960.0
2019-10-16 09:00:00	NVDA	Stock	4.8825	4.959	4.853	4.9275	81278680.0
2019-10-16 10:00:00	NVDA	Stock	4.9275	4.9805	4.9035	4.9534	82344200.0
2019-10-16 11:00:00	NVDA	Stock	4.9515	4.9618	4.915	4.9263	43203880.0
2019-10-16 12:00:00	NVDA	Stock	4.9265	4.9358	4.8808	4.882	36589760.0
2019-10-16 13:00:00	NVDA	Stock	4.8832	4.8945	4.8752	4.8763	32751280.0
2019-10-16 14:00:00	NVDA	Stock	4.8772	4.8912	4.866	4.8672	33874160.0
2019-10-16 15:00:00	NVDA	Stock	4.8678	4.8681	4.8438	4.8553	56971880.0
2019-10-16 16:00:00	NVDA	Stock	4.8553	4.863	4.855	4.8612	21701600.0
2019-10-16 17:00:00	NVDA	Stock	4.8625	4.865	4.8603	4.8633	439560.0
2019-10-16 18:00:00	NVDA	Stock	4.8633	4.865	4.8528	4.8528	272080.0
2019-10-16 19:00:00	NVDA	Stock	4.8538	4.8548	4.8455	4.8538	336200.0
2019-10-16 05:00:00	AMZN	Stock	88.2	88.2	88.2	88.2	2000.0
2019-10-16 06:00:00	AMZN	Stock	88.3	88.3	88.3	88.3	4520.0
2019-10-16 07:00:00	AMZN	Stock	88.45	88.575	88.4375	88.4485	111600.0

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

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