PREVIEW / stock_1hour / 2018-10-31

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-10-31.parquet
  size:    1.1 MB
  rows:    51,220
  symbols: 2,789

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-10-31 04:00:00	AAPL	Stock	54.0	54.1875	53.975	54.1725	20436.0
2018-10-31 05:00:00	AAPL	Stock	54.1625	54.1725	54.0075	54.0375	33912.0
2018-10-31 06:00:00	AAPL	Stock	53.9775	53.995	53.8375	53.9275	92984.0
2018-10-31 07:00:00	AAPL	Stock	53.975	53.9825	53.6	53.7875	893680.0
2018-10-31 08:00:00	AAPL	Stock	53.9245	54.07	53.625	54.005	919744.0
2018-10-31 09:00:00	AAPL	Stock	54.0325	54.5225	54.0125	54.4238	17103260.0
2018-10-31 10:00:00	AAPL	Stock	54.425	54.8	54.37	54.5675	18070028.0
2018-10-31 11:00:00	AAPL	Stock	54.5725	54.9775	54.4825	54.6365	15177040.0
2018-10-31 12:00:00	AAPL	Stock	54.64	54.9875	54.4625	54.926	10939328.0
2018-10-31 13:00:00	AAPL	Stock	54.93	55.1125	54.7525	54.8925	13359880.0
2018-10-31 14:00:00	AAPL	Stock	54.9	55.11	54.7925	54.97	10885816.0
2018-10-31 15:00:00	AAPL	Stock	54.9625	55.0675	54.6725	54.6975	23900992.0
2018-10-31 16:00:00	AAPL	Stock	54.69	54.8225	54.6375	54.695	19444416.0
2018-10-31 17:00:00	AAPL	Stock	54.7	54.715	54.5	54.5875	1415532.0
2018-10-31 18:00:00	AAPL	Stock	54.6175	54.75	54.53	54.75	916668.0
2018-10-31 19:00:00	AAPL	Stock	54.75	54.8	54.725	54.7925	170940.0
2018-10-31 04:00:00	MSFT	Stock	104.0	105.1	104.0	105.1	6515.0
2018-10-31 05:00:00	MSFT	Stock	104.94	104.94	104.7	104.71	7600.0
2018-10-31 06:00:00	MSFT	Stock	104.61	104.75	104.41	104.55	37770.0
2018-10-31 07:00:00	MSFT	Stock	104.34	104.81	104.1	104.6	68264.0
2018-10-31 08:00:00	MSFT	Stock	104.53	105.18	104.2	105.1	121787.0
2018-10-31 09:00:00	MSFT	Stock	105.1	107.35	105.01	106.93	7687339.0
2018-10-31 10:00:00	MSFT	Stock	106.93	108.107	106.79	107.145	7354434.0
2018-10-31 11:00:00	MSFT	Stock	107.17	107.87	106.42	106.8	4860398.0
2018-10-31 12:00:00	MSFT	Stock	106.8	107.75	106.3	107.46	3557831.0
2018-10-31 13:00:00	MSFT	Stock	107.47	108.14	107.39	107.565	2859493.0
2018-10-31 14:00:00	MSFT	Stock	107.57	107.89	107.33	107.82	3144900.0
2018-10-31 15:00:00	MSFT	Stock	107.82	108.01	106.75	106.79	8668780.0
2018-10-31 16:00:00	MSFT	Stock	106.81	106.86	106.44	106.81	6193461.0
2018-10-31 17:00:00	MSFT	Stock	106.75	106.81	106.61	106.75	412685.0
2018-10-31 18:00:00	MSFT	Stock	106.75	106.9	106.61	106.81	14359.0
2018-10-31 19:00:00	MSFT	Stock	106.89	106.94	106.81	106.89	3337.0
2018-10-31 04:00:00	NVDA	Stock	5.15	5.1738	5.15	5.1732	131200.0
2018-10-31 05:00:00	NVDA	Stock	5.1732	5.18	5.1625	5.1625	233560.0
2018-10-31 06:00:00	NVDA	Stock	5.15	5.1638	5.134	5.1638	88720.0
2018-10-31 07:00:00	NVDA	Stock	5.1502	5.2552	5.15	5.225	3100040.0
2018-10-31 08:00:00	NVDA	Stock	5.1898	5.2483	5.155	5.2435	4834160.0
2018-10-31 09:00:00	NVDA	Stock	5.2462	5.301	5.1233	5.2135	136845880.0
2018-10-31 10:00:00	NVDA	Stock	5.2145	5.3148	5.2093	5.2303	140709960.0
2018-10-31 11:00:00	NVDA	Stock	5.2328	5.248	5.1445	5.17	79140760.0
2018-10-31 12:00:00	NVDA	Stock	5.17	5.2005	5.1002	5.1858	61344720.0
2018-10-31 13:00:00	NVDA	Stock	5.188	5.265	5.1812	5.2208	51863160.0
2018-10-31 14:00:00	NVDA	Stock	5.2213	5.2655	5.2102	5.2584	48056040.0
2018-10-31 15:00:00	NVDA	Stock	5.2586	5.3095	5.251	5.272	119537320.0
2018-10-31 16:00:00	NVDA	Stock	5.2714	5.276	5.2525	5.2708	31085360.0
2018-10-31 17:00:00	NVDA	Stock	5.2628	5.2688	5.2563	5.2625	351000.0
2018-10-31 18:00:00	NVDA	Stock	5.2668	5.2818	5.2625	5.2812	170720.0
2018-10-31 19:00:00	NVDA	Stock	5.2855	5.3095	5.28	5.3038	245760.0
2018-10-31 04:00:00	AMZN	Stock	78.3	78.3	77.88	78.06	62840.0
2018-10-31 05:00:00	AMZN	Stock	78.2	78.2	78.0	78.0	23380.0

> showing 50 of 51,220 rows — these rows as CSV

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