PREVIEW / stock_1hour / 2018-04-04

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-04-04.parquet
  size:    1.1 MB
  rows:    49,380
  symbols: 2,869

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-04-04 04:00:00	AAPL	Stock	41.4375	41.4375	41.1125	41.2	54244.0
2018-04-04 05:00:00	AAPL	Stock	41.105	41.225	41.0675	41.1575	38592.0
2018-04-04 06:00:00	AAPL	Stock	41.105	41.105	40.8975	41.0725	48596.0
2018-04-04 07:00:00	AAPL	Stock	41.1	41.385	41.0625	41.3625	370708.0
2018-04-04 08:00:00	AAPL	Stock	41.175	41.475	41.025	41.3775	739648.0
2018-04-04 09:00:00	AAPL	Stock	41.375	41.73	41.19	41.6	15868456.0
2018-04-04 10:00:00	AAPL	Stock	41.6025	42.0225	41.4075	42.0175	16595028.0
2018-04-04 11:00:00	AAPL	Stock	42.0182	42.4475	41.8525	42.355	17788644.0
2018-04-04 12:00:00	AAPL	Stock	42.35	42.6325	42.3188	42.3975	13147580.0
2018-04-04 13:00:00	AAPL	Stock	42.4025	42.43	42.1175	42.355	9240940.0
2018-04-04 14:00:00	AAPL	Stock	42.365	42.75	42.3375	42.7325	12645576.0
2018-04-04 15:00:00	AAPL	Stock	42.73	43.0025	42.6675	42.895	25010868.0
2018-04-04 16:00:00	AAPL	Stock	42.9025	42.9025	42.0975	42.875	9426340.0
2018-04-04 17:00:00	AAPL	Stock	42.8875	42.945	42.865	42.9	64644.0
2018-04-04 18:00:00	AAPL	Stock	42.9	42.9475	42.9	42.9425	21388.0
2018-04-04 19:00:00	AAPL	Stock	42.95	43.0	42.95	42.995	29096.0
2018-04-04 04:00:00	MSFT	Stock	88.65	88.65	87.91	88.55	22974.0
2018-04-04 05:00:00	MSFT	Stock	88.12	88.3	88.12	88.24	13044.0
2018-04-04 06:00:00	MSFT	Stock	88.16	88.16	87.7	87.91	7603.0
2018-04-04 07:00:00	MSFT	Stock	88.0	88.49	88.0	88.16	31225.0
2018-04-04 08:00:00	MSFT	Stock	87.96	88.4	87.96	88.29	63911.0
2018-04-04 09:00:00	MSFT	Stock	88.28	88.87	87.73	88.835	3800897.0
2018-04-04 10:00:00	MSFT	Stock	88.83	89.305	88.27	89.23	4137256.0
2018-04-04 11:00:00	MSFT	Stock	89.22	89.9	88.84	89.78	3074339.0
2018-04-04 12:00:00	MSFT	Stock	89.79	90.54	89.6	90.3	2951919.0
2018-04-04 13:00:00	MSFT	Stock	90.31	90.37	89.68	90.295	2488234.0
2018-04-04 14:00:00	MSFT	Stock	90.3	91.69	90.22	91.56	4310806.0
2018-04-04 15:00:00	MSFT	Stock	91.55	92.76	91.4	92.27	8085132.0
2018-04-04 16:00:00	MSFT	Stock	92.27	92.4	92.08	92.11	3910691.0
2018-04-04 17:00:00	MSFT	Stock	92.1	92.35	92.1	92.23	33990.0
2018-04-04 18:00:00	MSFT	Stock	92.27	92.4	92.22	92.35	9219.0
2018-04-04 19:00:00	MSFT	Stock	92.46	92.55	92.33	92.5	8952.0
2018-04-04 04:00:00	NVDA	Stock	5.4868	5.4925	5.4375	5.4375	338000.0
2018-04-04 05:00:00	NVDA	Stock	5.4498	5.4498	5.3888	5.4	427040.0
2018-04-04 06:00:00	NVDA	Stock	5.3915	5.4165	5.3313	5.4062	478920.0
2018-04-04 07:00:00	NVDA	Stock	5.3968	5.4738	5.3968	5.4425	5271320.0
2018-04-04 08:00:00	NVDA	Stock	5.4531	5.4698	5.3893	5.4275	8139320.0
2018-04-04 09:00:00	NVDA	Stock	5.4333	5.4888	5.35	5.4218	162364400.0
2018-04-04 10:00:00	NVDA	Stock	5.4215	5.4978	5.3868	5.4936	139729080.0
2018-04-04 11:00:00	NVDA	Stock	5.4936	5.5862	5.4483	5.5547	117171280.0
2018-04-04 12:00:00	NVDA	Stock	5.555	5.5875	5.5208	5.54	71905840.0
2018-04-04 13:00:00	NVDA	Stock	5.541	5.5443	5.4632	5.5326	65908280.0
2018-04-04 14:00:00	NVDA	Stock	5.5345	5.5925	5.5242	5.5878	76123920.0
2018-04-04 15:00:00	NVDA	Stock	5.587	5.6665	5.5685	5.6545	110676840.0
2018-04-04 16:00:00	NVDA	Stock	5.656	5.6638	5.6378	5.653	4035720.0
2018-04-04 17:00:00	NVDA	Stock	5.6538	5.6675	5.65	5.6663	574160.0
2018-04-04 18:00:00	NVDA	Stock	5.662	5.675	5.6553	5.675	535160.0
2018-04-04 19:00:00	NVDA	Stock	5.6745	5.6812	5.6625	5.681	657920.0
2018-04-04 04:00:00	AMZN	Stock	68.1	68.1	67.3125	67.6	51960.0
2018-04-04 05:00:00	AMZN	Stock	67.5	67.9125	67.5	67.8795	42400.0

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

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