PREVIEW / stock_1hour / 2018-11-23

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-11-23.parquet
  size:    746 KB
  rows:    32,021
  symbols: 2,622

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-11-23 04:00:00	AAPL	Stock	43.9725	43.9725	43.875	43.925	22540.0
2018-11-23 05:00:00	AAPL	Stock	43.925	43.925	43.675	43.7775	9340.0
2018-11-23 06:00:00	AAPL	Stock	43.75	43.825	43.7375	43.7875	6252.0
2018-11-23 07:00:00	AAPL	Stock	43.8225	43.9875	43.7875	43.9875	105416.0
2018-11-23 08:00:00	AAPL	Stock	43.93	44.0	43.6225	43.725	506652.0
2018-11-23 09:00:00	AAPL	Stock	43.7425	44.1488	43.5	43.9175	18447372.0
2018-11-23 10:00:00	AAPL	Stock	43.9025	43.965	43.425	43.5525	19332000.0
2018-11-23 11:00:00	AAPL	Stock	43.55	43.573	43.175	43.2125	15792756.0
2018-11-23 12:00:00	AAPL	Stock	43.2075	43.3298	43.025	43.0725	21434888.0
2018-11-23 13:00:00	AAPL	Stock	43.0725	43.075	42.9625	43.0075	6182964.0
2018-11-23 14:00:00	AAPL	Stock	43.025	43.0725	42.9998	43.0175	140156.0
2018-11-23 15:00:00	AAPL	Stock	43.0025	43.0725	42.975	42.9925	101152.0
2018-11-23 16:00:00	AAPL	Stock	42.9875	43.0425	42.975	43.0025	60132.0
2018-11-23 04:00:00	MSFT	Stock	103.0	103.0	102.57	102.57	2506.0
2018-11-23 05:00:00	MSFT	Stock	102.65	102.65	102.26	102.26	3782.0
2018-11-23 06:00:00	MSFT	Stock	102.6	102.6	102.3	102.3	300.0
2018-11-23 07:00:00	MSFT	Stock	102.4	102.7	102.3	102.7	17176.0
2018-11-23 08:00:00	MSFT	Stock	102.332	102.6	101.65	101.99	44235.0
2018-11-23 09:00:00	MSFT	Stock	102.1	103.77	101.748	103.56	2573754.0
2018-11-23 10:00:00	MSFT	Stock	103.56	103.81	102.99	103.35	2581747.0
2018-11-23 11:00:00	MSFT	Stock	103.355	103.45	102.805	102.84	2111003.0
2018-11-23 12:00:00	MSFT	Stock	102.83	103.26	102.73	103.07	2913812.0
2018-11-23 13:00:00	MSFT	Stock	103.07	103.07	102.85	102.87	1975032.0
2018-11-23 14:00:00	MSFT	Stock	102.86	103.07	102.86	102.86	151046.0
2018-11-23 15:00:00	MSFT	Stock	102.86	103.0	102.81	102.867	3869.0
2018-11-23 16:00:00	MSFT	Stock	102.98	102.98	102.9	102.9	945.0
2018-11-23 04:00:00	NVDA	Stock	3.615	3.615	3.575	3.575	169800.0
2018-11-23 05:00:00	NVDA	Stock	3.575	3.575	3.575	3.575	4000.0
2018-11-23 06:00:00	NVDA	Stock	3.5625	3.5625	3.5625	3.5625	8000.0
2018-11-23 07:00:00	NVDA	Stock	3.55	3.597	3.55	3.5945	475080.0
2018-11-23 08:00:00	NVDA	Stock	3.585	3.5992	3.545	3.5675	1893280.0
2018-11-23 09:00:00	NVDA	Stock	3.5732	3.7398	3.56	3.6962	130137400.0
2018-11-23 10:00:00	NVDA	Stock	3.695	3.7102	3.6638	3.665	104818000.0
2018-11-23 11:00:00	NVDA	Stock	3.6651	3.6748	3.6362	3.6386	66258920.0
2018-11-23 12:00:00	NVDA	Stock	3.6378	3.656	3.624	3.625	61114560.0
2018-11-23 13:00:00	NVDA	Stock	3.625	3.6325	3.6225	3.6233	15472760.0
2018-11-23 14:00:00	NVDA	Stock	3.6233	3.6302	3.6233	3.6302	106440.0
2018-11-23 15:00:00	NVDA	Stock	3.6272	3.6298	3.6267	3.629	146320.0
2018-11-23 16:00:00	NVDA	Stock	3.6263	3.63	3.6263	3.6263	36000.0
2018-11-23 04:00:00	AMZN	Stock	75.6245	75.6245	75.5	75.5335	12140.0
2018-11-23 05:00:00	AMZN	Stock	75.4	75.4	75.4	75.4	2000.0
2018-11-23 07:00:00	AMZN	Stock	75.3675	75.75	75.175	75.75	142360.0
2018-11-23 08:00:00	AMZN	Stock	75.255	76.02	75.2	75.6	501680.0
2018-11-23 09:00:00	AMZN	Stock	75.7	76.81	75.65	76.4293	13065540.0
2018-11-23 10:00:00	AMZN	Stock	76.4515	76.5215	75.5995	75.805	11411240.0
2018-11-23 11:00:00	AMZN	Stock	75.785	76.1591	75.545	75.61	6583500.0
2018-11-23 12:00:00	AMZN	Stock	75.58	75.8	75.0905	75.0982	7125380.0
2018-11-23 13:00:00	AMZN	Stock	75.098	75.1845	75.098	75.1115	2897520.0
2018-11-23 14:00:00	AMZN	Stock	75.125	75.25	75.103	75.25	61560.0
2018-11-23 15:00:00	AMZN	Stock	75.275	75.275	75.103	75.103	9340.0

> showing 50 of 32,021 rows — these rows as CSV

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