PREVIEW / stock_1hour / 2018-08-02

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-08-02.parquet
  size:    1.1 MB
  rows:    49,567
  symbols: 2,788

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-08-02 04:00:00	AAPL	Stock	49.975	50.1375	49.975	50.0375	65436.0
2018-08-02 05:00:00	AAPL	Stock	50.075	50.075	49.9275	49.9975	89240.0
2018-08-02 06:00:00	AAPL	Stock	49.975	50.03	49.9225	49.9925	185036.0
2018-08-02 07:00:00	AAPL	Stock	49.9975	50.1475	49.9925	50.125	541300.0
2018-08-02 08:00:00	AAPL	Stock	50.075	50.375	50.015	50.1575	790224.0
2018-08-02 09:00:00	AAPL	Stock	50.17	50.8925	50.0625	50.825	29909320.0
2018-08-02 10:00:00	AAPL	Stock	50.825	51.645	50.715	51.4775	50163276.0
2018-08-02 11:00:00	AAPL	Stock	51.4775	51.7625	51.2775	51.6675	38250044.0
2018-08-02 12:00:00	AAPL	Stock	51.6725	51.7475	51.5262	51.607	22827352.0
2018-08-02 13:00:00	AAPL	Stock	51.6085	51.9925	51.605	51.9775	23459552.0
2018-08-02 14:00:00	AAPL	Stock	51.9775	52.095	51.8975	51.935	22556684.0
2018-08-02 15:00:00	AAPL	Stock	51.935	52.0	51.835	51.845	23947196.0
2018-08-02 16:00:00	AAPL	Stock	51.85	51.88	51.835	51.8625	9360800.0
2018-08-02 17:00:00	AAPL	Stock	51.8725	51.885	51.7875	51.8175	141504.0
2018-08-02 18:00:00	AAPL	Stock	51.8075	51.8425	51.7875	51.815	115820.0
2018-08-02 19:00:00	AAPL	Stock	51.8175	51.8225	51.7725	51.7725	132688.0
2018-08-02 04:00:00	MSFT	Stock	105.95	105.95	105.95	105.95	1390.0
2018-08-02 05:00:00	MSFT	Stock	105.65	105.65	105.1	105.1	2677.0
2018-08-02 06:00:00	MSFT	Stock	105.28	105.28	105.13	105.27	1802.0
2018-08-02 07:00:00	MSFT	Stock	105.5	105.64	105.23	105.32	17715.0
2018-08-02 08:00:00	MSFT	Stock	105.51	106.28	105.23	105.39	41666.0
2018-08-02 09:00:00	MSFT	Stock	105.36	105.92	104.84	105.78	3030413.0
2018-08-02 10:00:00	MSFT	Stock	105.775	106.51	105.77	105.98	3258137.0
2018-08-02 11:00:00	MSFT	Stock	105.99	107.24	105.91	107.03	2926950.0
2018-08-02 12:00:00	MSFT	Stock	107.03	107.68	106.8	107.458	2343529.0
2018-08-02 13:00:00	MSFT	Stock	107.46	108.09	107.46	107.98	2479863.0
2018-08-02 14:00:00	MSFT	Stock	107.98	108.05	107.347	107.465	1801082.0
2018-08-02 15:00:00	MSFT	Stock	107.47	107.9	107.35	107.56	4017289.0
2018-08-02 16:00:00	MSFT	Stock	107.56	107.75	107.46	107.75	3511177.0
2018-08-02 17:00:00	MSFT	Stock	107.65	107.72	107.5	107.57	4334.0
2018-08-02 18:00:00	MSFT	Stock	107.72	107.72	107.66	107.66	7077.0
2018-08-02 19:00:00	MSFT	Stock	107.67	107.67	107.51	107.6	3578.0
2018-08-02 06:00:00	NVDA	Stock	6.075	6.075	6.0515	6.0515	44760.0
2018-08-02 07:00:00	NVDA	Stock	6.0708	6.0825	6.0655	6.0813	165840.0
2018-08-02 08:00:00	NVDA	Stock	6.0631	6.115	6.0625	6.097	870480.0
2018-08-02 09:00:00	NVDA	Stock	6.0943	6.1482	6.0303	6.1297	39818000.0
2018-08-02 10:00:00	NVDA	Stock	6.1292	6.199	6.1285	6.1705	43880760.0
2018-08-02 11:00:00	NVDA	Stock	6.1702	6.2063	6.147	6.191	28738800.0
2018-08-02 12:00:00	NVDA	Stock	6.189	6.2375	6.179	6.233	22458240.0
2018-08-02 13:00:00	NVDA	Stock	6.2328	6.2662	6.2328	6.2438	27593960.0
2018-08-02 14:00:00	NVDA	Stock	6.2448	6.2518	6.2255	6.236	22796280.0
2018-08-02 15:00:00	NVDA	Stock	6.2358	6.2695	6.227	6.2655	43388000.0
2018-08-02 16:00:00	NVDA	Stock	6.2655	6.2712	6.1965	6.267	2172600.0
2018-08-02 17:00:00	NVDA	Stock	6.2712	6.2812	6.2655	6.2708	504600.0
2018-08-02 18:00:00	NVDA	Stock	6.275	6.2875	6.2712	6.2875	207920.0
2018-08-02 19:00:00	NVDA	Stock	6.2865	6.2925	6.2825	6.2875	329000.0
2018-08-02 04:00:00	AMZN	Stock	89.95	89.95	89.6	89.6	8000.0
2018-08-02 05:00:00	AMZN	Stock	89.48	89.48	89.2965	89.2965	6280.0
2018-08-02 07:00:00	AMZN	Stock	89.287	89.4	89.287	89.4	56960.0
2018-08-02 08:00:00	AMZN	Stock	89.3	90.05	89.3	89.3885	146500.0

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

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