PREVIEW / stock_1hour / 2018-11-06

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-11-06.parquet
  size:    1.1 MB
  rows:    49,074
  symbols: 2,751

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-11-06 04:00:00	AAPL	Stock	50.4725	50.4725	50.11	50.11	3364.0
2018-11-06 05:00:00	AAPL	Stock	50.15	50.25	50.065	50.2475	17588.0
2018-11-06 06:00:00	AAPL	Stock	50.16	50.21	50.0625	50.14	27932.0
2018-11-06 07:00:00	AAPL	Stock	50.16	50.35	50.0525	50.35	252444.0
2018-11-06 08:00:00	AAPL	Stock	50.1775	50.35	50.0525	50.325	477644.0
2018-11-06 09:00:00	AAPL	Stock	50.3325	51.18	50.305	51.0625	25260980.0
2018-11-06 10:00:00	AAPL	Stock	51.0625	51.1225	50.6775	50.7325	19892564.0
2018-11-06 11:00:00	AAPL	Stock	50.7375	50.9625	50.605	50.89	13203284.0
2018-11-06 12:00:00	AAPL	Stock	50.8875	50.9525	50.6875	50.74	7442280.0
2018-11-06 13:00:00	AAPL	Stock	50.7425	50.84	50.705	50.73	6171776.0
2018-11-06 14:00:00	AAPL	Stock	50.7275	50.745	50.4225	50.559	11379628.0
2018-11-06 15:00:00	AAPL	Stock	50.56	51.015	50.4625	50.945	15906948.0
2018-11-06 16:00:00	AAPL	Stock	50.945	51.0528	50.9425	51.01	9454296.0
2018-11-06 17:00:00	AAPL	Stock	51.0025	51.025	50.99	51.0225	93808.0
2018-11-06 18:00:00	AAPL	Stock	51.0075	51.02	50.9325	50.9875	154888.0
2018-11-06 19:00:00	AAPL	Stock	50.9625	51.0625	50.8125	50.95	160332.0
2018-11-06 05:00:00	MSFT	Stock	107.0	107.2	107.0	107.2	2620.0
2018-11-06 06:00:00	MSFT	Stock	107.04	107.3	107.04	107.3	346.0
2018-11-06 07:00:00	MSFT	Stock	107.45	107.45	107.1	107.28	3216.0
2018-11-06 08:00:00	MSFT	Stock	107.4	107.51	107.15	107.15	49953.0
2018-11-06 09:00:00	MSFT	Stock	107.3	108.84	107.23	108.4	3056573.0
2018-11-06 10:00:00	MSFT	Stock	108.39	108.5	107.13	107.19	3974573.0
2018-11-06 11:00:00	MSFT	Stock	107.19	107.619	106.89	107.31	2516608.0
2018-11-06 12:00:00	MSFT	Stock	107.31	107.875	107.19	107.755	1967289.0
2018-11-06 13:00:00	MSFT	Stock	107.74	107.78	107.13	107.13	1331815.0
2018-11-06 14:00:00	MSFT	Stock	107.13	107.17	106.28	107.004	2509845.0
2018-11-06 15:00:00	MSFT	Stock	107.0	107.8	106.861	107.71	3638634.0
2018-11-06 16:00:00	MSFT	Stock	107.72	108.0	107.56	107.9	2848517.0
2018-11-06 17:00:00	MSFT	Stock	107.98	108.08	107.82	108.08	11874.0
2018-11-06 18:00:00	MSFT	Stock	107.86	107.98	107.8	107.8	1984.0
2018-11-06 19:00:00	MSFT	Stock	107.98	108.05	107.56	107.8	4697.0
2018-11-06 05:00:00	NVDA	Stock	5.25	5.2542	5.25	5.2542	19400.0
2018-11-06 07:00:00	NVDA	Stock	5.275	5.2825	5.25	5.2825	166520.0
2018-11-06 08:00:00	NVDA	Stock	5.2965	5.2965	5.2378	5.2742	638760.0
2018-11-06 09:00:00	NVDA	Stock	5.2645	5.3712	5.2375	5.3358	49918120.0
2018-11-06 10:00:00	NVDA	Stock	5.336	5.37	5.2972	5.3098	52445560.0
2018-11-06 11:00:00	NVDA	Stock	5.3098	5.3432	5.2848	5.3135	29355760.0
2018-11-06 12:00:00	NVDA	Stock	5.3185	5.3455	5.3042	5.316	20299680.0
2018-11-06 13:00:00	NVDA	Stock	5.316	5.3273	5.3013	5.3048	17342560.0
2018-11-06 14:00:00	NVDA	Stock	5.3048	5.309	5.2445	5.2722	25404360.0
2018-11-06 15:00:00	NVDA	Stock	5.272	5.3055	5.26	5.2765	51475680.0
2018-11-06 16:00:00	NVDA	Stock	5.2765	5.2925	5.2765	5.2875	22335680.0
2018-11-06 17:00:00	NVDA	Stock	5.2908	5.2908	5.28	5.2888	472520.0
2018-11-06 18:00:00	NVDA	Stock	5.2815	5.288	5.2765	5.2788	161000.0
2018-11-06 19:00:00	NVDA	Stock	5.2765	5.2908	5.275	5.2872	215080.0
2018-11-06 04:00:00	AMZN	Stock	81.45	81.45	81.258	81.258	8120.0
2018-11-06 05:00:00	AMZN	Stock	81.1	81.1	81.0465	81.0465	15760.0
2018-11-06 06:00:00	AMZN	Stock	81.05	81.119	81.05	81.119	6780.0
2018-11-06 08:00:00	AMZN	Stock	80.8	80.95	80.8	80.85	295760.0
2018-11-06 09:00:00	AMZN	Stock	80.8935	83.25	80.7275	82.9194	16785140.0

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

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