PREVIEW / stock_1hour / 2019-05-30

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-05-30.parquet
  size:    1.1 MB
  rows:    49,158
  symbols: 2,601

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
2019-05-30 04:00:00	AAPL	Stock	44.465	44.5	44.4625	44.4625	3200.0
2019-05-30 05:00:00	AAPL	Stock	44.52	44.52	44.52	44.52	400.0
2019-05-30 06:00:00	AAPL	Stock	44.5625	44.575	44.4025	44.4625	35080.0
2019-05-30 07:00:00	AAPL	Stock	44.4925	44.5175	44.42	44.42	75152.0
2019-05-30 08:00:00	AAPL	Stock	44.495	44.62	44.37	44.5625	277964.0
2019-05-30 09:00:00	AAPL	Stock	44.5525	44.8075	44.41	44.6768	14006124.0
2019-05-30 10:00:00	AAPL	Stock	44.675	44.7125	44.4475	44.5325	11512488.0
2019-05-30 11:00:00	AAPL	Stock	44.5325	44.55	44.3775	44.4425	7617648.0
2019-05-30 12:00:00	AAPL	Stock	44.4425	44.475	44.285	44.42	7507152.0
2019-05-30 13:00:00	AAPL	Stock	44.42	44.4462	44.295	44.4075	5446076.0
2019-05-30 14:00:00	AAPL	Stock	44.4075	44.4475	44.1675	44.37	7340148.0
2019-05-30 15:00:00	AAPL	Stock	44.37	44.6175	44.1825	44.5625	13649456.0
2019-05-30 16:00:00	AAPL	Stock	44.575	44.595	44.55	44.5625	3641388.0
2019-05-30 17:00:00	AAPL	Stock	44.5625	44.5625	44.475	44.475	39188.0
2019-05-30 18:00:00	AAPL	Stock	44.505	44.54	44.5025	44.525	24416.0
2019-05-30 19:00:00	AAPL	Stock	44.5225	44.5225	44.1	44.2	81596.0
2019-05-30 04:00:00	MSFT	Stock	125.32	125.65	125.32	125.65	200.0
2019-05-30 05:00:00	MSFT	Stock	125.6	125.6	125.6	125.6	100.0
2019-05-30 06:00:00	MSFT	Stock	125.4	125.4	125.4	125.4	398.0
2019-05-30 07:00:00	MSFT	Stock	125.25	125.36	125.21	125.3	7512.0
2019-05-30 08:00:00	MSFT	Stock	125.37	125.5	125.07	125.484	16071.0
2019-05-30 09:00:00	MSFT	Stock	125.32	125.74	125.02	125.35	1501775.0
2019-05-30 10:00:00	MSFT	Stock	125.34	125.48	125.02	125.16	1943324.0
2019-05-30 11:00:00	MSFT	Stock	125.15	125.43	124.96	125.25	1440844.0
2019-05-30 12:00:00	MSFT	Stock	125.26	125.65	125.103	125.47	1180445.0
2019-05-30 13:00:00	MSFT	Stock	125.47	125.57	124.89	125.155	2034985.0
2019-05-30 14:00:00	MSFT	Stock	125.15	125.39	124.78	125.38	2248356.0
2019-05-30 15:00:00	MSFT	Stock	125.37	125.76	124.93	125.73	3052679.0
2019-05-30 16:00:00	MSFT	Stock	125.73	125.8	125.54	125.73	1541744.0
2019-05-30 17:00:00	MSFT	Stock	125.7	125.72	125.53	125.7	2230.0
2019-05-30 18:00:00	MSFT	Stock	125.66	125.75	125.66	125.75	1846.0
2019-05-30 19:00:00	MSFT	Stock	125.76	125.76	124.55	124.55	21872.0
2019-05-30 04:00:00	NVDA	Stock	3.5292	3.53	3.5255	3.5255	24680.0
2019-05-30 05:00:00	NVDA	Stock	3.525	3.5308	3.525	3.5308	12880.0
2019-05-30 06:00:00	NVDA	Stock	3.5292	3.5298	3.5125	3.516	32240.0
2019-05-30 07:00:00	NVDA	Stock	3.5175	3.5175	3.5	3.5062	511560.0
2019-05-30 08:00:00	NVDA	Stock	3.5175	3.5175	3.5	3.5115	1212480.0
2019-05-30 09:00:00	NVDA	Stock	3.5122	3.5438	3.5025	3.5252	53637440.0
2019-05-30 10:00:00	NVDA	Stock	3.525	3.54	3.5002	3.5062	58048880.0
2019-05-30 11:00:00	NVDA	Stock	3.5052	3.515	3.4925	3.5058	34810440.0
2019-05-30 12:00:00	NVDA	Stock	3.5058	3.509	3.4896	3.4995	40870480.0
2019-05-30 13:00:00	NVDA	Stock	3.5	3.5035	3.4663	3.4708	36864520.0
2019-05-30 14:00:00	NVDA	Stock	3.4706	3.4762	3.4392	3.461	44172760.0
2019-05-30 15:00:00	NVDA	Stock	3.4608	3.484	3.448	3.4778	68169880.0
2019-05-30 16:00:00	NVDA	Stock	3.4758	3.4838	3.4725	3.4838	6040160.0
2019-05-30 17:00:00	NVDA	Stock	3.4812	3.4812	3.4728	3.4728	205600.0
2019-05-30 18:00:00	NVDA	Stock	3.4785	3.485	3.4768	3.4788	392920.0
2019-05-30 19:00:00	NVDA	Stock	3.4798	3.4798	3.4405	3.4405	647800.0
2019-05-30 05:00:00	AMZN	Stock	91.342	91.342	91.342	91.342	2000.0
2019-05-30 07:00:00	AMZN	Stock	91.1145	91.25	91.1145	91.25	15960.0

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

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