PREVIEW / stock_1hour / 2018-03-23

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-03-23.parquet
  size:    1.1 MB
  rows:    49,418
  symbols: 2,873

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-23 04:00:00	AAPL	Stock	42.0275	42.1125	41.75	41.8125	47856.0
2018-03-23 05:00:00	AAPL	Stock	41.8	41.8725	41.675	41.675	32240.0
2018-03-23 06:00:00	AAPL	Stock	41.6325	41.9375	41.6325	41.8775	121216.0
2018-03-23 07:00:00	AAPL	Stock	41.885	42.195	41.885	42.1675	256496.0
2018-03-23 08:00:00	AAPL	Stock	42.1775	42.3675	41.95	42.235	921896.0
2018-03-23 09:00:00	AAPL	Stock	42.2475	42.3725	41.885	42.239	20520580.0
2018-03-23 10:00:00	AAPL	Stock	42.24	42.4175	42.0575	42.405	20338684.0
2018-03-23 11:00:00	AAPL	Stock	42.405	42.435	41.8475	41.864	13842300.0
2018-03-23 12:00:00	AAPL	Stock	41.865	42.1475	41.8475	41.95	10305948.0
2018-03-23 13:00:00	AAPL	Stock	41.9475	42.48	41.9	42.43	11073188.0
2018-03-23 14:00:00	AAPL	Stock	42.4325	42.47	41.7775	41.78	13673564.0
2018-03-23 15:00:00	AAPL	Stock	41.7825	41.92	41.235	41.24	38902448.0
2018-03-23 16:00:00	AAPL	Stock	41.2675	41.375	41.23	41.2475	13007588.0
2018-03-23 17:00:00	AAPL	Stock	41.265	41.2875	41.235	41.2875	144624.0
2018-03-23 18:00:00	AAPL	Stock	41.2625	41.2875	41.255	41.2575	70588.0
2018-03-23 19:00:00	AAPL	Stock	41.275	41.3125	41.26	41.2875	46916.0
2018-03-23 04:00:00	MSFT	Stock	89.1	89.1	88.6	88.83	11248.0
2018-03-23 05:00:00	MSFT	Stock	88.95	88.95	88.51	88.8	5163.0
2018-03-23 06:00:00	MSFT	Stock	88.78	88.8	88.6	88.8	4217.0
2018-03-23 07:00:00	MSFT	Stock	89.0	89.41	88.79	89.3	27212.0
2018-03-23 08:00:00	MSFT	Stock	89.13	89.79	88.8	89.33	75441.0
2018-03-23 09:00:00	MSFT	Stock	89.34	90.46	89.161	90.1	3841388.0
2018-03-23 10:00:00	MSFT	Stock	90.1	90.35	89.47	90.321	4364345.0
2018-03-23 11:00:00	MSFT	Stock	90.32	90.39	88.93	88.99	3652982.0
2018-03-23 12:00:00	MSFT	Stock	88.99	89.565	88.97	89.22	2839755.0
2018-03-23 13:00:00	MSFT	Stock	89.22	90.35	89.06	90.255	3199565.0
2018-03-23 14:00:00	MSFT	Stock	90.26	90.44	88.56	88.64	3711574.0
2018-03-23 15:00:00	MSFT	Stock	88.64	88.97	87.08	87.13	11011669.0
2018-03-23 16:00:00	MSFT	Stock	87.15	87.51	86.93	87.0	6825122.0
2018-03-23 17:00:00	MSFT	Stock	87.0	87.0	86.83	86.95	38031.0
2018-03-23 18:00:00	MSFT	Stock	86.95	86.95	86.9	86.95	7164.0
2018-03-23 19:00:00	MSFT	Stock	86.94	86.95	86.85	86.88	37060.0
2018-03-23 04:00:00	NVDA	Stock	6.0	6.0	5.97	5.975	253640.0
2018-03-23 05:00:00	NVDA	Stock	5.975	5.975	5.9628	5.9693	132840.0
2018-03-23 06:00:00	NVDA	Stock	5.9695	6.0	5.9612	5.9915	301480.0
2018-03-23 07:00:00	NVDA	Stock	6.0002	6.0475	5.9975	6.0475	754920.0
2018-03-23 08:00:00	NVDA	Stock	6.0478	6.0998	5.9958	6.0568	2945840.0
2018-03-23 09:00:00	NVDA	Stock	6.0583	6.0873	5.845	5.906	157227040.0
2018-03-23 10:00:00	NVDA	Stock	5.908	5.978	5.8725	5.965	122585720.0
2018-03-23 11:00:00	NVDA	Stock	5.9653	5.9695	5.8188	5.826	96382960.0
2018-03-23 12:00:00	NVDA	Stock	5.8248	5.897	5.8208	5.8764	66738320.0
2018-03-23 13:00:00	NVDA	Stock	5.8758	5.9945	5.866	5.98	78993040.0
2018-03-23 14:00:00	NVDA	Stock	5.9808	5.9928	5.8525	5.8618	58257440.0
2018-03-23 15:00:00	NVDA	Stock	5.864	5.903	5.813	5.8231	125587000.0
2018-03-23 16:00:00	NVDA	Stock	5.8242	5.8452	5.8175	5.8343	3498120.0
2018-03-23 17:00:00	NVDA	Stock	5.835	5.835	5.815	5.8168	653760.0
2018-03-23 18:00:00	NVDA	Stock	5.8233	5.825	5.8188	5.8212	211280.0
2018-03-23 19:00:00	NVDA	Stock	5.825	5.83	5.825	5.8288	47440.0
2018-03-23 04:00:00	AMZN	Stock	76.43	76.43	75.8985	75.9	45880.0
2018-03-23 05:00:00	AMZN	Stock	76.1	76.1	75.7	75.7	44980.0

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

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