PREVIEW / stock_1hour / 2017-03-23

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-03-23.parquet
  size:    1.0 MB
  rows:    47,822
  symbols: 3,061

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
2017-03-23 04:00:00	AAPL	Stock	35.32	35.32	35.2825	35.3	4268.0
2017-03-23 07:00:00	AAPL	Stock	35.3475	35.37	35.325	35.34	36756.0
2017-03-23 08:00:00	AAPL	Stock	35.35	35.3875	35.325	35.335	222104.0
2017-03-23 09:00:00	AAPL	Stock	35.33	35.37	35.155	35.19	11352624.0
2017-03-23 10:00:00	AAPL	Stock	35.1905	35.325	35.1525	35.2825	9967576.0
2017-03-23 11:00:00	AAPL	Stock	35.285	35.3475	35.26	35.33	7290720.0
2017-03-23 12:00:00	AAPL	Stock	35.33	35.396	35.26	35.295	6816480.0
2017-03-23 13:00:00	AAPL	Stock	35.2975	35.3	35.1725	35.21	9197548.0
2017-03-23 14:00:00	AAPL	Stock	35.2075	35.335	35.2	35.2825	7750964.0
2017-03-23 15:00:00	AAPL	Stock	35.2825	35.285	35.155	35.23	15888096.0
2017-03-23 16:00:00	AAPL	Stock	35.23	35.2325	35.1925	35.21	5858168.0
2017-03-23 17:00:00	AAPL	Stock	35.21	35.21	35.1875	35.1975	15884.0
2017-03-23 18:00:00	AAPL	Stock	35.1975	35.2475	35.1975	35.24	60440.0
2017-03-23 19:00:00	AAPL	Stock	35.24	35.26	35.2325	35.25	31536.0
2017-03-23 04:00:00	MSFT	Stock	65.02	65.02	65.02	65.02	100.0
2017-03-23 06:00:00	MSFT	Stock	65.03	65.05	65.03	65.05	1500.0
2017-03-23 07:00:00	MSFT	Stock	65.1	65.1	65.1	65.1	100.0
2017-03-23 08:00:00	MSFT	Stock	65.1	65.1	65.0	65.0	2508.0
2017-03-23 09:00:00	MSFT	Stock	65.01	65.235	64.82	65.06	2048926.0
2017-03-23 10:00:00	MSFT	Stock	65.07	65.095	64.77	64.91	2181661.0
2017-03-23 11:00:00	MSFT	Stock	64.91	65.15	64.85	65.12	1696511.0
2017-03-23 12:00:00	MSFT	Stock	65.11	65.195	65.0	65.09	1702842.0
2017-03-23 13:00:00	MSFT	Stock	65.1	65.12	64.861	64.97	1803610.0
2017-03-23 14:00:00	MSFT	Stock	64.96	65.1	64.95	65.005	1294274.0
2017-03-23 15:00:00	MSFT	Stock	65.01	65.02	64.765	64.87	4572494.0
2017-03-23 16:00:00	MSFT	Stock	64.87	64.93	64.87	64.87	2518329.0
2017-03-23 18:00:00	MSFT	Stock	64.92	64.92	64.87	64.87	2100.0
2017-03-23 05:00:00	NVDA	Stock	2.7025	2.7025	2.7025	2.7025	7640.0
2017-03-23 06:00:00	NVDA	Stock	2.7068	2.7072	2.7025	2.7072	49320.0
2017-03-23 07:00:00	NVDA	Stock	2.7072	2.721	2.7072	2.709	159880.0
2017-03-23 08:00:00	NVDA	Stock	2.7072	2.72	2.7025	2.705	1259080.0
2017-03-23 09:00:00	NVDA	Stock	2.704	2.7103	2.673	2.6778	102563360.0
2017-03-23 10:00:00	NVDA	Stock	2.677	2.7139	2.6675	2.6928	117274680.0
2017-03-23 11:00:00	NVDA	Stock	2.6926	2.7042	2.6863	2.7015	60544600.0
2017-03-23 12:00:00	NVDA	Stock	2.7012	2.7028	2.6852	2.694	37891320.0
2017-03-23 13:00:00	NVDA	Stock	2.6945	2.6945	2.6762	2.6792	41957200.0
2017-03-23 14:00:00	NVDA	Stock	2.679	2.6978	2.6778	2.69	33319640.0
2017-03-23 15:00:00	NVDA	Stock	2.6903	2.6908	2.6698	2.6775	70831680.0
2017-03-23 16:00:00	NVDA	Stock	2.6773	2.688	2.6745	2.6863	31657080.0
2017-03-23 17:00:00	NVDA	Stock	2.687	2.687	2.683	2.687	682920.0
2017-03-23 18:00:00	NVDA	Stock	2.6875	2.692	2.6875	2.691	617600.0
2017-03-23 19:00:00	NVDA	Stock	2.6905	2.692	2.6888	2.6888	174400.0
2017-03-23 06:00:00	AMZN	Stock	42.4055	42.4055	42.4055	42.4055	2000.0
2017-03-23 07:00:00	AMZN	Stock	42.415	42.4485	42.415	42.4485	6660.0
2017-03-23 08:00:00	AMZN	Stock	42.425	42.4985	42.415	42.4425	67300.0
2017-03-23 09:00:00	AMZN	Stock	42.3995	42.4385	42.24	42.3442	4594060.0
2017-03-23 10:00:00	AMZN	Stock	42.349	42.486	42.2455	42.459	5831060.0
2017-03-23 11:00:00	AMZN	Stock	42.4675	42.5445	42.433	42.507	4300860.0
2017-03-23 12:00:00	AMZN	Stock	42.5058	42.5225	42.4605	42.51	2539480.0
2017-03-23 13:00:00	AMZN	Stock	42.5105	42.5171	42.361	42.4115	3008240.0

> showing 50 of 47,822 rows — these rows as CSV

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