PREVIEW / stock_1hour / 2018-11-05

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-11-05.parquet
  size:    1.1 MB
  rows:    50,226
  symbols: 2,761

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-05 04:00:00	AAPL	Stock	51.625	51.625	51.425	51.4625	46472.0
2018-11-05 05:00:00	AAPL	Stock	51.5775	51.615	51.425	51.55	63232.0
2018-11-05 06:00:00	AAPL	Stock	51.5375	51.575	51.2875	51.355	107796.0
2018-11-05 07:00:00	AAPL	Stock	51.32	51.535	50.905	50.905	1223940.0
2018-11-05 08:00:00	AAPL	Stock	51.04	51.4375	50.875	51.0075	1461452.0
2018-11-05 09:00:00	AAPL	Stock	51.0275	51.11	50.207	50.2578	45538176.0
2018-11-05 10:00:00	AAPL	Stock	50.26	50.3625	49.5425	50.337	69199396.0
2018-11-05 11:00:00	AAPL	Stock	50.3362	50.4725	50.095	50.3912	24229648.0
2018-11-05 12:00:00	AAPL	Stock	50.3915	50.4225	49.89	50.045	19573348.0
2018-11-05 13:00:00	AAPL	Stock	50.0425	50.2375	49.895	50.2098	13189384.0
2018-11-05 14:00:00	AAPL	Stock	50.2088	50.445	50.1625	50.231	14063552.0
2018-11-05 15:00:00	AAPL	Stock	50.2325	50.4725	50.2075	50.3975	21630952.0
2018-11-05 16:00:00	AAPL	Stock	50.3925	50.4375	50.335	50.4	14082184.0
2018-11-05 17:00:00	AAPL	Stock	50.4	50.47	50.3875	50.45	144048.0
2018-11-05 18:00:00	AAPL	Stock	50.4375	50.485	50.425	50.4275	150788.0
2018-11-05 19:00:00	AAPL	Stock	50.4275	50.5	50.41	50.5	76884.0
2018-11-05 05:00:00	MSFT	Stock	106.14	106.14	106.13	106.13	928.0
2018-11-05 06:00:00	MSFT	Stock	106.5	106.5	106.5	106.5	1506.0
2018-11-05 07:00:00	MSFT	Stock	106.51	106.7	106.0	106.0	7619.0
2018-11-05 08:00:00	MSFT	Stock	106.57	106.68	105.9	106.15	18078.0
2018-11-05 09:00:00	MSFT	Stock	106.17	106.69	105.9	106.28	4358349.0
2018-11-05 10:00:00	MSFT	Stock	106.29	107.02	105.98	106.975	4997973.0
2018-11-05 11:00:00	MSFT	Stock	106.97	106.975	106.23	106.57	2828726.0
2018-11-05 12:00:00	MSFT	Stock	106.57	106.97	106.36	106.92	2074084.0
2018-11-05 13:00:00	MSFT	Stock	106.92	107.16	106.67	106.97	1835494.0
2018-11-05 14:00:00	MSFT	Stock	106.96	107.74	106.85	107.54	2369707.0
2018-11-05 15:00:00	MSFT	Stock	107.55	107.74	106.99	107.49	4452488.0
2018-11-05 16:00:00	MSFT	Stock	107.49	107.67	107.25	107.65	2319292.0
2018-11-05 17:00:00	MSFT	Stock	107.61	107.65	107.562	107.65	3318.0
2018-11-05 18:00:00	MSFT	Stock	107.73	107.75	107.51	107.74	8179.0
2018-11-05 19:00:00	MSFT	Stock	107.72	108.0	107.7	108.0	2042.0
2018-11-05 04:00:00	NVDA	Stock	5.4	5.4	5.3403	5.3403	28680.0
2018-11-05 05:00:00	NVDA	Stock	5.3728	5.3728	5.3728	5.3728	8000.0
2018-11-05 06:00:00	NVDA	Stock	5.375	5.397	5.375	5.397	8000.0
2018-11-05 07:00:00	NVDA	Stock	5.4	5.4125	5.32	5.32	554560.0
2018-11-05 08:00:00	NVDA	Stock	5.375	5.4125	5.3125	5.3668	937520.0
2018-11-05 09:00:00	NVDA	Stock	5.3635	5.3832	5.2055	5.2398	53045000.0
2018-11-05 10:00:00	NVDA	Stock	5.2368	5.25	5.145	5.2098	83928600.0
2018-11-05 11:00:00	NVDA	Stock	5.2078	5.2353	5.132	5.173	43018040.0
2018-11-05 12:00:00	NVDA	Stock	5.1726	5.1843	5.1393	5.1797	24795680.0
2018-11-05 13:00:00	NVDA	Stock	5.1805	5.2225	5.1693	5.2099	21248240.0
2018-11-05 14:00:00	NVDA	Stock	5.2096	5.3048	5.1978	5.2908	39467320.0
2018-11-05 15:00:00	NVDA	Stock	5.2902	5.3085	5.2688	5.2943	48765840.0
2018-11-05 16:00:00	NVDA	Stock	5.2943	5.3153	5.2925	5.3053	10047480.0
2018-11-05 17:00:00	NVDA	Stock	5.3	5.3	5.2888	5.2888	97280.0
2018-11-05 18:00:00	NVDA	Stock	5.295	5.302	5.2943	5.3	93840.0
2018-11-05 19:00:00	NVDA	Stock	5.3025	5.325	5.3025	5.3125	241440.0
2018-11-05 04:00:00	AMZN	Stock	83.19	83.19	83.19	83.19	2140.0
2018-11-05 05:00:00	AMZN	Stock	83.65	83.65	83.575	83.575	6740.0
2018-11-05 06:00:00	AMZN	Stock	83.575	83.7	83.575	83.7	4000.0

> showing 50 of 50,226 rows — these rows as CSV

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