PREVIEW / stock_1hour / 2018-06-14

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-06-14.parquet
  size:    1.1 MB
  rows:    49,278
  symbols: 2,828

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-06-14 04:00:00	AAPL	Stock	47.6575	47.6575	47.6575	47.6575	2800.0
2018-06-14 05:00:00	AAPL	Stock	47.66	47.725	47.6225	47.6225	12924.0
2018-06-14 06:00:00	AAPL	Stock	47.5875	47.6275	47.585	47.625	9800.0
2018-06-14 07:00:00	AAPL	Stock	47.625	47.785	47.61	47.785	67672.0
2018-06-14 08:00:00	AAPL	Stock	47.6775	47.855	47.62	47.7925	338200.0
2018-06-14 09:00:00	AAPL	Stock	47.8	47.8925	47.555	47.6575	12255012.0
2018-06-14 10:00:00	AAPL	Stock	47.655	47.8825	47.6325	47.6347	11500144.0
2018-06-14 11:00:00	AAPL	Stock	47.6325	47.86	47.5902	47.7775	7430944.0
2018-06-14 12:00:00	AAPL	Stock	47.7758	47.8125	47.655	47.6912	6944812.0
2018-06-14 13:00:00	AAPL	Stock	47.6925	47.835	47.6725	47.7375	5855132.0
2018-06-14 14:00:00	AAPL	Stock	47.74	47.7825	47.64	47.65	4859512.0
2018-06-14 15:00:00	AAPL	Stock	47.6525	47.7925	47.625	47.7025	14388712.0
2018-06-14 16:00:00	AAPL	Stock	47.7	47.7375	47.6975	47.7025	9977712.0
2018-06-14 17:00:00	AAPL	Stock	47.705	47.73	47.68	47.7	44668.0
2018-06-14 18:00:00	AAPL	Stock	47.675	47.7025	47.625	47.69	13536.0
2018-06-14 19:00:00	AAPL	Stock	47.7	47.7	47.6275	47.65	39476.0
2018-06-14 04:00:00	MSFT	Stock	100.78	100.85	100.78	100.85	400.0
2018-06-14 05:00:00	MSFT	Stock	100.85	100.85	100.85	100.85	121.0
2018-06-14 07:00:00	MSFT	Stock	100.9	101.0	100.9	101.0	8583.0
2018-06-14 08:00:00	MSFT	Stock	100.95	101.17	100.75	101.15	19281.0
2018-06-14 09:00:00	MSFT	Stock	101.15	101.69	101.0	101.11	3466191.0
2018-06-14 10:00:00	MSFT	Stock	101.1	102.03	101.095	101.43	4047407.0
2018-06-14 11:00:00	MSFT	Stock	101.434	101.89	101.235	101.68	2034710.0
2018-06-14 12:00:00	MSFT	Stock	101.685	101.75	101.3	101.32	1360774.0
2018-06-14 13:00:00	MSFT	Stock	101.315	101.76	101.28	101.514	1463050.0
2018-06-14 14:00:00	MSFT	Stock	101.51	101.57	101.13	101.15	1490533.0
2018-06-14 15:00:00	MSFT	Stock	101.15	101.51	101.14	101.42	4416347.0
2018-06-14 16:00:00	MSFT	Stock	101.42	101.665	101.37	101.43	3648409.0
2018-06-14 17:00:00	MSFT	Stock	101.49	101.49	101.39	101.49	2415.0
2018-06-14 18:00:00	MSFT	Stock	101.39	101.53	101.39	101.42	1935.0
2018-06-14 19:00:00	MSFT	Stock	101.53	101.53	101.37	101.5	1736.0
2018-06-14 04:00:00	NVDA	Stock	6.55	6.5625	6.55	6.5625	22880.0
2018-06-14 07:00:00	NVDA	Stock	6.5418	6.5888	6.535	6.5875	336200.0
2018-06-14 08:00:00	NVDA	Stock	6.5888	6.5933	6.535	6.5905	805760.0
2018-06-14 09:00:00	NVDA	Stock	6.5905	6.675	6.5873	6.6543	70591400.0
2018-06-14 10:00:00	NVDA	Stock	6.6537	6.7138	6.6537	6.6705	86192560.0
2018-06-14 11:00:00	NVDA	Stock	6.6707	6.707	6.6588	6.699	39042400.0
2018-06-14 12:00:00	NVDA	Stock	6.699	6.711	6.6912	6.6985	32900800.0
2018-06-14 13:00:00	NVDA	Stock	6.6978	6.73	6.6933	6.7162	30374840.0
2018-06-14 14:00:00	NVDA	Stock	6.7168	6.7226	6.6358	6.647	43780880.0
2018-06-14 15:00:00	NVDA	Stock	6.646	6.6832	6.6412	6.6725	63809600.0
2018-06-14 16:00:00	NVDA	Stock	6.6728	6.6944	6.6588	6.6715	9892520.0
2018-06-14 17:00:00	NVDA	Stock	6.6742	6.6812	6.6712	6.68	392120.0
2018-06-14 18:00:00	NVDA	Stock	6.675	6.6822	6.675	6.68	291440.0
2018-06-14 19:00:00	NVDA	Stock	6.6818	6.6838	6.6762	6.6838	256440.0
2018-06-14 04:00:00	AMZN	Stock	85.2	85.2	85.2	85.2	4000.0
2018-06-14 07:00:00	AMZN	Stock	85.3495	85.45	85.305	85.45	53980.0
2018-06-14 08:00:00	AMZN	Stock	85.4375	85.5675	85.3475	85.525	342980.0
2018-06-14 09:00:00	AMZN	Stock	85.55	85.8775	85.4435	85.6495	10207540.0
2018-06-14 10:00:00	AMZN	Stock	85.6495	85.9135	85.6275	85.6695	8513940.0

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

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