PREVIEW / stock_1hour / 2019-05-23

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-05-23.parquet
  size:    1.1 MB
  rows:    49,980
  symbols: 2,605

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-05-23 04:00:00	AAPL	Stock	44.875	45.035	44.8125	44.8125	112436.0
2019-05-23 05:00:00	AAPL	Stock	44.825	44.9125	44.675	44.725	28812.0
2019-05-23 06:00:00	AAPL	Stock	44.68	44.845	44.5875	44.75	114912.0
2019-05-23 07:00:00	AAPL	Stock	44.75	44.9975	44.75	44.8625	430752.0
2019-05-23 08:00:00	AAPL	Stock	44.85	45.0475	44.75	44.9425	816644.0
2019-05-23 09:00:00	AAPL	Stock	44.9378	45.0642	44.4775	44.4988	27582792.0
2019-05-23 10:00:00	AAPL	Stock	44.5	45.03	44.4525	44.9678	21777204.0
2019-05-23 11:00:00	AAPL	Stock	44.9725	45.135	44.7325	44.74	13126328.0
2019-05-23 12:00:00	AAPL	Stock	44.7475	44.805	44.5725	44.7675	12918792.0
2019-05-23 13:00:00	AAPL	Stock	44.765	44.9692	44.7275	44.83	9250624.0
2019-05-23 14:00:00	AAPL	Stock	44.83	44.9075	44.6925	44.7425	8321904.0
2019-05-23 15:00:00	AAPL	Stock	44.7425	45.0575	44.615	44.9175	17225264.0
2019-05-23 16:00:00	AAPL	Stock	44.915	45.075	44.88	44.96	17346704.0
2019-05-23 17:00:00	AAPL	Stock	44.975	45.0	44.9	44.9575	55900.0
2019-05-23 18:00:00	AAPL	Stock	44.9375	44.9875	44.905	44.905	36484.0
2019-05-23 19:00:00	AAPL	Stock	44.9	44.975	44.88	44.975	59764.0
2019-05-23 04:00:00	MSFT	Stock	126.55	126.94	126.18	126.4	5889.0
2019-05-23 05:00:00	MSFT	Stock	126.39	126.4	125.83	125.91	5246.0
2019-05-23 06:00:00	MSFT	Stock	125.81	126.38	125.81	126.12	2732.0
2019-05-23 07:00:00	MSFT	Stock	126.33	126.5	126.3	126.38	13777.0
2019-05-23 08:00:00	MSFT	Stock	126.32	126.51	126.12	126.36	65763.0
2019-05-23 09:00:00	MSFT	Stock	126.38	126.5	125.53	125.93	2753701.0
2019-05-23 10:00:00	MSFT	Stock	125.93	126.195	125.43	125.91	2428714.0
2019-05-23 11:00:00	MSFT	Stock	125.92	125.93	125.19	125.216	2144900.0
2019-05-23 12:00:00	MSFT	Stock	125.22	125.4	124.74	124.825	2412445.0
2019-05-23 13:00:00	MSFT	Stock	124.82	125.64	124.74	125.485	1964646.0
2019-05-23 14:00:00	MSFT	Stock	125.48	125.63	125.11	125.53	1700957.0
2019-05-23 15:00:00	MSFT	Stock	125.53	126.22	125.34	126.18	4034902.0
2019-05-23 16:00:00	MSFT	Stock	126.18	126.36	125.75	126.25	2776516.0
2019-05-23 17:00:00	MSFT	Stock	126.3	126.3	126.18	126.25	6436.0
2019-05-23 18:00:00	MSFT	Stock	126.24	126.4	126.2	126.3	20869.0
2019-05-23 19:00:00	MSFT	Stock	126.25	126.52	126.25	126.41	15192.0
2019-05-23 04:00:00	NVDA	Stock	3.75	3.75	3.7225	3.7225	42520.0
2019-05-23 05:00:00	NVDA	Stock	3.7225	3.7225	3.7225	3.7225	12000.0
2019-05-23 06:00:00	NVDA	Stock	3.7125	3.72	3.7125	3.72	8000.0
2019-05-23 07:00:00	NVDA	Stock	3.725	3.75	3.725	3.725	568640.0
2019-05-23 08:00:00	NVDA	Stock	3.7333	3.75	3.715	3.7362	1799840.0
2019-05-23 09:00:00	NVDA	Stock	3.7362	3.7425	3.6415	3.6776	86368040.0
2019-05-23 10:00:00	NVDA	Stock	3.677	3.696	3.657	3.6885	58674240.0
2019-05-23 11:00:00	NVDA	Stock	3.6898	3.6949	3.6613	3.6664	43341280.0
2019-05-23 12:00:00	NVDA	Stock	3.6658	3.6708	3.6348	3.6405	56483200.0
2019-05-23 13:00:00	NVDA	Stock	3.6403	3.654	3.6328	3.6408	35643440.0
2019-05-23 14:00:00	NVDA	Stock	3.6398	3.6455	3.6228	3.6388	41687160.0
2019-05-23 15:00:00	NVDA	Stock	3.6385	3.687	3.6295	3.6843	103958720.0
2019-05-23 16:00:00	NVDA	Stock	3.683	3.6865	3.6758	3.683	52190880.0
2019-05-23 17:00:00	NVDA	Stock	3.678	3.683	3.6665	3.6665	1793240.0
2019-05-23 18:00:00	NVDA	Stock	3.6688	3.678	3.6575	3.6575	404440.0
2019-05-23 19:00:00	NVDA	Stock	3.6578	3.6722	3.6578	3.659	416560.0
2019-05-23 04:00:00	AMZN	Stock	91.8205	91.8495	91.746	91.8075	14400.0
2019-05-23 05:00:00	AMZN	Stock	91.81	91.81	91.455	91.455	4840.0

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

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