PREVIEW / stock_1hour / 2018-09-13

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-09-13.parquet
  size:    1.1 MB
  rows:    49,570
  symbols: 2,795

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-13 04:00:00	AAPL	Stock	55.425	55.5	55.375	55.4975	28192.0
2018-09-13 05:00:00	AAPL	Stock	55.4625	55.5	55.25	55.325	126052.0
2018-09-13 06:00:00	AAPL	Stock	55.375	55.625	55.375	55.6175	62672.0
2018-09-13 07:00:00	AAPL	Stock	55.5975	55.735	55.575	55.6925	287820.0
2018-09-13 08:00:00	AAPL	Stock	55.707	55.91	55.5675	55.85	1094300.0
2018-09-13 09:00:00	AAPL	Stock	55.8425	56.3225	55.2675	55.97	22594756.0
2018-09-13 10:00:00	AAPL	Stock	55.97	56.5475	55.95	56.475	27680432.0
2018-09-13 11:00:00	AAPL	Stock	56.4775	56.955	56.4	56.89	21024644.0
2018-09-13 12:00:00	AAPL	Stock	56.892	57.0875	56.7025	56.7525	15104540.0
2018-09-13 13:00:00	AAPL	Stock	56.7525	56.8362	56.4	56.5822	12690292.0
2018-09-13 14:00:00	AAPL	Stock	56.58	56.7275	56.3	56.445	11742116.0
2018-09-13 15:00:00	AAPL	Stock	56.4475	56.61	56.2625	56.6	16576004.0
2018-09-13 16:00:00	AAPL	Stock	56.6575	56.735	56.5975	56.6725	13430392.0
2018-09-13 17:00:00	AAPL	Stock	56.6525	56.69	56.625	56.665	59920.0
2018-09-13 18:00:00	AAPL	Stock	56.6375	56.8	56.6375	56.7525	142844.0
2018-09-13 19:00:00	AAPL	Stock	56.7725	56.7725	56.7025	56.7375	83832.0
2018-09-13 04:00:00	MSFT	Stock	111.8	111.8	111.8	111.8	200.0
2018-09-13 05:00:00	MSFT	Stock	112.0	112.17	112.0	112.01	1197.0
2018-09-13 06:00:00	MSFT	Stock	112.2	112.2	112.2	112.2	5642.0
2018-09-13 07:00:00	MSFT	Stock	112.11	112.3	112.0	112.01	13599.0
2018-09-13 08:00:00	MSFT	Stock	112.3	112.35	112.03	112.18	21231.0
2018-09-13 09:00:00	MSFT	Stock	112.17	113.725	112.08	113.03	4121075.0
2018-09-13 10:00:00	MSFT	Stock	113.04	113.5	112.49	112.905	3849453.0
2018-09-13 11:00:00	MSFT	Stock	112.91	113.2	112.65	112.915	2781982.0
2018-09-13 12:00:00	MSFT	Stock	112.915	113.06	112.68	112.7	1485320.0
2018-09-13 13:00:00	MSFT	Stock	112.705	112.92	112.61	112.722	1139006.0
2018-09-13 14:00:00	MSFT	Stock	112.73	112.846	112.46	112.7	1549389.0
2018-09-13 15:00:00	MSFT	Stock	112.705	112.94	112.435	112.91	3654002.0
2018-09-13 16:00:00	MSFT	Stock	112.91	112.95	112.5	112.83	4473899.0
2018-09-13 17:00:00	MSFT	Stock	112.82	112.88	112.82	112.88	2483.0
2018-09-13 18:00:00	MSFT	Stock	112.86	112.95	112.81	112.95	938.0
2018-09-13 19:00:00	MSFT	Stock	112.85	112.85	112.85	112.85	170.0
2018-09-13 07:00:00	NVDA	Stock	6.6828	6.7412	6.6775	6.7395	256080.0
2018-09-13 08:00:00	NVDA	Stock	6.725	6.77	6.709	6.7582	1214920.0
2018-09-13 09:00:00	NVDA	Stock	6.7582	6.8354	6.7582	6.8271	44533360.0
2018-09-13 10:00:00	NVDA	Stock	6.8273	6.8562	6.754	6.7938	58215120.0
2018-09-13 11:00:00	NVDA	Stock	6.7932	6.875	6.7845	6.8644	42907360.0
2018-09-13 12:00:00	NVDA	Stock	6.8658	6.8738	6.8428	6.8542	25710640.0
2018-09-13 13:00:00	NVDA	Stock	6.852	6.8562	6.7968	6.8045	23605120.0
2018-09-13 14:00:00	NVDA	Stock	6.8072	6.8266	6.766	6.8052	24384360.0
2018-09-13 15:00:00	NVDA	Stock	6.8055	6.806	6.7683	6.7835	35270120.0
2018-09-13 16:00:00	NVDA	Stock	6.7835	6.7835	6.7745	6.776	3679680.0
2018-09-13 17:00:00	NVDA	Stock	6.7812	6.7835	6.7812	6.7825	111040.0
2018-09-13 18:00:00	NVDA	Stock	6.7832	6.7875	6.78	6.7875	141960.0
2018-09-13 19:00:00	NVDA	Stock	6.7918	6.7918	6.7875	6.7875	462680.0
2018-09-13 04:00:00	AMZN	Stock	99.85	99.875	99.847	99.847	14420.0
2018-09-13 05:00:00	AMZN	Stock	99.75	99.75	99.75	99.75	4140.0
2018-09-13 06:00:00	AMZN	Stock	99.75	99.75	99.75	99.75	2000.0
2018-09-13 07:00:00	AMZN	Stock	99.763	99.8665	99.763	99.825	118480.0
2018-09-13 08:00:00	AMZN	Stock	99.8457	99.9145	99.705	99.846	261620.0

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

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