PREVIEW / stock_1hour / 2018-09-24

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-09-24.parquet
  size:    1.1 MB
  rows:    49,982
  symbols: 2,792

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-09-24 04:00:00	AAPL	Stock	54.4125	54.4125	54.175	54.175	5588.0
2018-09-24 05:00:00	AAPL	Stock	54.15	54.175	54.15	54.15	5092.0
2018-09-24 06:00:00	AAPL	Stock	54.2075	54.2075	54.1875	54.2075	8520.0
2018-09-24 07:00:00	AAPL	Stock	54.1825	54.295	54.115	54.215	155228.0
2018-09-24 08:00:00	AAPL	Stock	54.2175	54.335	54.1275	54.2525	415912.0
2018-09-24 09:00:00	AAPL	Stock	54.255	54.7075	54.14	54.4825	14479324.0
2018-09-24 10:00:00	AAPL	Stock	54.4825	54.7	54.295	54.6975	14516852.0
2018-09-24 11:00:00	AAPL	Stock	54.6925	55.05	54.625	55.025	13705708.0
2018-09-24 12:00:00	AAPL	Stock	55.0275	55.08	54.9	54.9475	8900560.0
2018-09-24 13:00:00	AAPL	Stock	54.9525	55.0725	54.915	55.065	5501592.0
2018-09-24 14:00:00	AAPL	Stock	55.065	55.08	54.9425	55.0075	5501812.0
2018-09-24 15:00:00	AAPL	Stock	55.0075	55.315	54.98	55.1975	15919680.0
2018-09-24 16:00:00	AAPL	Stock	55.1975	55.25	55.1975	55.25	13887472.0
2018-09-24 17:00:00	AAPL	Stock	55.2325	55.2375	55.21	55.215	43640.0
2018-09-24 18:00:00	AAPL	Stock	55.2375	55.2425	55.225	55.2275	10684.0
2018-09-24 19:00:00	AAPL	Stock	55.2475	55.2875	55.23	55.285	55696.0
2018-09-24 05:00:00	MSFT	Stock	113.83	113.83	113.83	113.83	300.0
2018-09-24 07:00:00	MSFT	Stock	113.88	113.88	113.71	113.75	2220.0
2018-09-24 08:00:00	MSFT	Stock	113.88	113.88	113.61	113.71	8861.0
2018-09-24 09:00:00	MSFT	Stock	113.76	113.78	112.218	113.65	3734200.0
2018-09-24 10:00:00	MSFT	Stock	113.66	114.13	113.54	113.85	3471111.0
2018-09-24 11:00:00	MSFT	Stock	113.85	114.57	113.73	114.485	2356996.0
2018-09-24 12:00:00	MSFT	Stock	114.49	114.54	114.031	114.15	1699393.0
2018-09-24 13:00:00	MSFT	Stock	114.16	114.695	114.117	114.61	1866935.0
2018-09-24 14:00:00	MSFT	Stock	114.609	114.67	114.44	114.49	1287531.0
2018-09-24 15:00:00	MSFT	Stock	114.48	114.9	114.434	114.67	4155598.0
2018-09-24 16:00:00	MSFT	Stock	114.67	114.87	114.61	114.8	3862296.0
2018-09-24 17:00:00	MSFT	Stock	114.78	114.8	114.64	114.65	7120.0
2018-09-24 18:00:00	MSFT	Stock	114.7	114.8	114.7	114.8	2526.0
2018-09-24 19:00:00	MSFT	Stock	114.8	114.88	114.71	114.8	5249.0
2018-09-24 04:00:00	NVDA	Stock	6.5688	6.5688	6.5502	6.56	41640.0
2018-09-24 05:00:00	NVDA	Stock	6.5502	6.5502	6.5502	6.5502	6840.0
2018-09-24 06:00:00	NVDA	Stock	6.545	6.5575	6.545	6.5575	32000.0
2018-09-24 07:00:00	NVDA	Stock	6.547	6.56	6.5438	6.55	206480.0
2018-09-24 08:00:00	NVDA	Stock	6.55	6.5845	6.5388	6.5625	805640.0
2018-09-24 09:00:00	NVDA	Stock	6.5624	6.5972	6.467	6.5772	46429720.0
2018-09-24 10:00:00	NVDA	Stock	6.5778	6.6375	6.5746	6.6068	45741320.0
2018-09-24 11:00:00	NVDA	Stock	6.6102	6.6308	6.561	6.6255	32284240.0
2018-09-24 12:00:00	NVDA	Stock	6.6265	6.6332	6.5955	6.6051	16650120.0
2018-09-24 13:00:00	NVDA	Stock	6.6075	6.6342	6.5938	6.6335	13345240.0
2018-09-24 14:00:00	NVDA	Stock	6.6325	6.6368	6.6045	6.6075	17068360.0
2018-09-24 15:00:00	NVDA	Stock	6.6085	6.646	6.6065	6.6428	35654960.0
2018-09-24 16:00:00	NVDA	Stock	6.6425	6.6498	6.6342	6.6425	23743880.0
2018-09-24 17:00:00	NVDA	Stock	6.6498	6.6498	6.6382	6.6463	95440.0
2018-09-24 18:00:00	NVDA	Stock	6.6438	6.6618	6.6438	6.66	172560.0
2018-09-24 19:00:00	NVDA	Stock	6.6552	6.6615	6.6552	6.66	60400.0
2018-09-24 04:00:00	AMZN	Stock	95.537	95.537	95.225	95.263	24940.0
2018-09-24 05:00:00	AMZN	Stock	95.25	95.3745	95.25	95.3745	8040.0
2018-09-24 06:00:00	AMZN	Stock	95.375	95.375	95.301	95.301	15600.0
2018-09-24 07:00:00	AMZN	Stock	95.377	95.377	94.907	94.9605	330540.0

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

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