PREVIEW / stock_1hour / 2019-12-05

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-12-05.parquet
  size:    1.1 MB
  rows:    50,260
  symbols: 2,478

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
2019-12-05 04:00:00	AAPL	Stock	65.5525	65.665	65.5075	65.665	38740.0
2019-12-05 05:00:00	AAPL	Stock	65.67	65.825	65.6375	65.8075	42548.0
2019-12-05 06:00:00	AAPL	Stock	65.8	65.995	65.8	65.9275	93780.0
2019-12-05 07:00:00	AAPL	Stock	65.9275	65.975	65.85	65.8875	172828.0
2019-12-05 08:00:00	AAPL	Stock	65.975	65.975	65.735	65.855	439608.0
2019-12-05 09:00:00	AAPL	Stock	65.855	66.1875	65.435	66.08	10389448.0
2019-12-05 10:00:00	AAPL	Stock	66.0725	66.0925	65.6825	65.925	10190496.0
2019-12-05 11:00:00	AAPL	Stock	65.9238	66.115	65.8775	66.0945	6081516.0
2019-12-05 12:00:00	AAPL	Stock	66.09	66.0975	65.94	66.0775	4002324.0
2019-12-05 13:00:00	AAPL	Stock	66.0725	66.3238	66.05	66.2375	5709868.0
2019-12-05 14:00:00	AAPL	Stock	66.2358	66.395	66.0825	66.2475	6530040.0
2019-12-05 15:00:00	AAPL	Stock	66.2525	66.4725	66.2352	66.395	9714412.0
2019-12-05 16:00:00	AAPL	Stock	66.395	66.395	66.3375	66.3575	8548616.0
2019-12-05 17:00:00	AAPL	Stock	66.36	66.415	66.3525	66.4	35988.0
2019-12-05 18:00:00	AAPL	Stock	66.3975	66.4375	66.3975	66.4125	64532.0
2019-12-05 19:00:00	AAPL	Stock	66.425	66.5	66.425	66.5	146404.0
2019-12-05 04:00:00	MSFT	Stock	150.18	150.18	150.08	150.08	898.0
2019-12-05 05:00:00	MSFT	Stock	150.5	150.65	150.5	150.65	5500.0
2019-12-05 06:00:00	MSFT	Stock	150.64	150.82	150.6	150.6	2793.0
2019-12-05 07:00:00	MSFT	Stock	150.52	150.6	150.05	150.35	38062.0
2019-12-05 08:00:00	MSFT	Stock	150.4	150.456	149.85	150.26	177110.0
2019-12-05 09:00:00	MSFT	Stock	150.26	150.32	149.56	150.13	1576832.0
2019-12-05 10:00:00	MSFT	Stock	150.12	150.19	149.59	149.83	2111960.0
2019-12-05 11:00:00	MSFT	Stock	149.83	150.04	149.635	149.86	1577828.0
2019-12-05 12:00:00	MSFT	Stock	149.85	149.99	149.79	149.84	748347.0
2019-12-05 13:00:00	MSFT	Stock	149.83	149.96	149.6	149.83	1070638.0
2019-12-05 14:00:00	MSFT	Stock	149.83	150.16	149.48	149.93	1387929.0
2019-12-05 15:00:00	MSFT	Stock	149.95	150.15	149.815	149.92	1918000.0
2019-12-05 16:00:00	MSFT	Stock	149.93	150.0	149.82	149.93	3833943.0
2019-12-05 17:00:00	MSFT	Stock	149.88	149.977	149.88	149.96	500.0
2019-12-05 18:00:00	MSFT	Stock	149.9	149.95	149.9	149.95	2227.0
2019-12-05 19:00:00	MSFT	Stock	149.98	150.05	149.95	150.05	8790.0
2019-12-05 04:00:00	NVDA	Stock	5.2502	5.257	5.2502	5.2563	35960.0
2019-12-05 05:00:00	NVDA	Stock	5.2625	5.2645	5.2625	5.2645	29240.0
2019-12-05 07:00:00	NVDA	Stock	5.2688	5.2773	5.2625	5.27	223640.0
2019-12-05 08:00:00	NVDA	Stock	5.2773	5.2781	5.2565	5.27	588680.0
2019-12-05 09:00:00	NVDA	Stock	5.2625	5.2733	5.2238	5.2525	24182760.0
2019-12-05 10:00:00	NVDA	Stock	5.2525	5.2528	5.2128	5.2252	30053880.0
2019-12-05 11:00:00	NVDA	Stock	5.225	5.2385	5.2025	5.219	27714680.0
2019-12-05 12:00:00	NVDA	Stock	5.2182	5.2205	5.2	5.2096	13300440.0
2019-12-05 13:00:00	NVDA	Stock	5.208	5.2228	5.201	5.215	12925160.0
2019-12-05 14:00:00	NVDA	Stock	5.215	5.2218	5.1877	5.2063	12119760.0
2019-12-05 15:00:00	NVDA	Stock	5.2063	5.2245	5.204	5.2185	25027440.0
2019-12-05 16:00:00	NVDA	Stock	5.2185	5.2185	5.2028	5.2125	14169320.0
2019-12-05 18:00:00	NVDA	Stock	5.2175	5.225	5.2138	5.221	112600.0
2019-12-05 19:00:00	NVDA	Stock	5.2248	5.2312	5.2225	5.2225	128520.0
2019-12-05 05:00:00	AMZN	Stock	88.375	88.375	88.375	88.375	3860.0
2019-12-05 06:00:00	AMZN	Stock	88.5	88.609	88.5	88.609	14860.0
2019-12-05 07:00:00	AMZN	Stock	88.4005	88.4005	88.055	88.1825	57440.0
2019-12-05 08:00:00	AMZN	Stock	88.4	88.4642	88.1	88.2025	101540.0

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

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