PREVIEW / stock_1hour / 2018-07-17

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-07-17.parquet
  size:    1.1 MB
  rows:    48,825
  symbols: 2,822

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-07-17 04:00:00	AAPL	Stock	47.475	47.5	47.475	47.5	816.0
2018-07-17 06:00:00	AAPL	Stock	47.5	47.5	47.4	47.4	45508.0
2018-07-17 07:00:00	AAPL	Stock	47.425	47.595	47.425	47.5875	94564.0
2018-07-17 08:00:00	AAPL	Stock	47.595	47.595	47.425	47.4775	159192.0
2018-07-17 09:00:00	AAPL	Stock	47.4625	47.7275	47.3	47.4675	8044916.0
2018-07-17 10:00:00	AAPL	Stock	47.4725	47.695	47.4058	47.68	6678212.0
2018-07-17 11:00:00	AAPL	Stock	47.6775	47.76	47.6025	47.695	5996328.0
2018-07-17 12:00:00	AAPL	Stock	47.6962	47.8725	47.6525	47.7625	7064160.0
2018-07-17 13:00:00	AAPL	Stock	47.7625	47.8775	47.7625	47.85	3691912.0
2018-07-17 14:00:00	AAPL	Stock	47.85	47.8775	47.7725	47.805	3237640.0
2018-07-17 15:00:00	AAPL	Stock	47.8025	47.9675	47.7925	47.8675	9920496.0
2018-07-17 16:00:00	AAPL	Stock	47.8675	47.8925	47.8625	47.8875	9438640.0
2018-07-17 17:00:00	AAPL	Stock	47.8875	47.8875	47.8675	47.8675	18180.0
2018-07-17 18:00:00	AAPL	Stock	47.8925	47.9375	47.87	47.925	24356.0
2018-07-17 19:00:00	AAPL	Stock	47.9075	47.9325	47.9	47.9325	7820.0
2018-07-17 04:00:00	MSFT	Stock	104.72	104.72	104.5	104.5	598.0
2018-07-17 05:00:00	MSFT	Stock	104.55	104.78	104.55	104.69	1338.0
2018-07-17 06:00:00	MSFT	Stock	104.54	104.54	104.48	104.48	1600.0
2018-07-17 07:00:00	MSFT	Stock	104.5	104.77	104.5	104.68	4470.0
2018-07-17 08:00:00	MSFT	Stock	104.5	105.3	104.5	105.15	52619.0
2018-07-17 09:00:00	MSFT	Stock	105.15	105.26	104.32	104.88	3190006.0
2018-07-17 10:00:00	MSFT	Stock	104.89	105.21	104.885	105.085	3066311.0
2018-07-17 11:00:00	MSFT	Stock	105.09	105.41	105.01	105.41	2481628.0
2018-07-17 12:00:00	MSFT	Stock	105.405	105.957	105.205	105.94	2344364.0
2018-07-17 13:00:00	MSFT	Stock	105.946	106.32	105.9	106.202	1795728.0
2018-07-17 14:00:00	MSFT	Stock	106.205	106.4	106.01	106.265	2056446.0
2018-07-17 15:00:00	MSFT	Stock	106.26	106.5	105.91	105.95	5272655.0
2018-07-17 16:00:00	MSFT	Stock	105.95	106.14	105.81	105.95	2984871.0
2018-07-17 17:00:00	MSFT	Stock	106.07	106.07	105.92	105.95	5637.0
2018-07-17 18:00:00	MSFT	Stock	105.99	106.1	105.99	106.1	10451.0
2018-07-17 19:00:00	MSFT	Stock	106.1	106.18	106.1	106.18	11106.0
2018-07-17 04:00:00	NVDA	Stock	6.1798	6.1925	6.1798	6.1925	15760.0
2018-07-17 05:00:00	NVDA	Stock	6.175	6.175	6.175	6.175	11800.0
2018-07-17 06:00:00	NVDA	Stock	6.1718	6.1718	6.1408	6.142	47520.0
2018-07-17 07:00:00	NVDA	Stock	6.14	6.1825	6.14	6.1825	197960.0
2018-07-17 08:00:00	NVDA	Stock	6.1495	6.1938	6.1495	6.1672	347400.0
2018-07-17 09:00:00	NVDA	Stock	6.1663	6.2098	6.1295	6.1998	48927600.0
2018-07-17 10:00:00	NVDA	Stock	6.1998	6.275	6.1829	6.2598	68621120.0
2018-07-17 11:00:00	NVDA	Stock	6.2593	6.3	6.2593	6.2972	35492200.0
2018-07-17 12:00:00	NVDA	Stock	6.2971	6.3095	6.2795	6.2926	27832720.0
2018-07-17 13:00:00	NVDA	Stock	6.2945	6.3135	6.2918	6.3062	19643080.0
2018-07-17 14:00:00	NVDA	Stock	6.3072	6.345	6.3048	6.3313	58469960.0
2018-07-17 15:00:00	NVDA	Stock	6.3303	6.3575	6.3154	6.342	64537360.0
2018-07-17 16:00:00	NVDA	Stock	6.3422	6.3465	6.3362	6.3413	2784280.0
2018-07-17 17:00:00	NVDA	Stock	6.3325	6.345	6.3325	6.3445	62000.0
2018-07-17 18:00:00	NVDA	Stock	6.345	6.3725	6.345	6.3725	751400.0
2018-07-17 19:00:00	NVDA	Stock	6.3725	6.3725	6.3655	6.3663	204880.0
2018-07-17 04:00:00	AMZN	Stock	90.6	90.6	90.6	90.6	4100.0
2018-07-17 05:00:00	AMZN	Stock	90.595	90.64	90.595	90.6235	10800.0
2018-07-17 06:00:00	AMZN	Stock	90.56	90.573	90.3245	90.3245	73020.0

> showing 50 of 48,825 rows — these rows as CSV

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