PREVIEW / stock_1hour / 2019-03-12

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-03-12.parquet
  size:    1.1 MB
  rows:    49,648
  symbols: 2,645

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-03-12 04:00:00	AAPL	Stock	45.0	45.0	44.9075	44.9125	31516.0
2019-03-12 05:00:00	AAPL	Stock	44.955	44.955	44.9425	44.9425	12912.0
2019-03-12 06:00:00	AAPL	Stock	44.8875	44.8875	44.85	44.85	28472.0
2019-03-12 07:00:00	AAPL	Stock	44.855	44.915	44.7575	44.845	100856.0
2019-03-12 08:00:00	AAPL	Stock	44.9002	45.02	44.7625	44.9825	530680.0
2019-03-12 09:00:00	AAPL	Stock	44.98	45.2992	44.8425	45.21	20105116.0
2019-03-12 10:00:00	AAPL	Stock	45.21	45.6675	45.1605	45.6	21648396.0
2019-03-12 11:00:00	AAPL	Stock	45.5985	45.625	45.3475	45.4475	18267732.0
2019-03-12 12:00:00	AAPL	Stock	45.45	45.46	45.1538	45.1875	10634356.0
2019-03-12 13:00:00	AAPL	Stock	45.1862	45.3455	45.17	45.295	7489988.0
2019-03-12 14:00:00	AAPL	Stock	45.2962	45.315	45.1525	45.2318	7711680.0
2019-03-12 15:00:00	AAPL	Stock	45.2325	45.25	45.0525	45.235	14078260.0
2019-03-12 16:00:00	AAPL	Stock	45.2275	45.25	45.18	45.2475	16555892.0
2019-03-12 17:00:00	AAPL	Stock	45.25	45.2575	45.1925	45.2415	45320.0
2019-03-12 18:00:00	AAPL	Stock	45.25	45.325	45.2025	45.27	121008.0
2019-03-12 19:00:00	AAPL	Stock	45.285	45.285	45.2075	45.2475	48308.0
2019-03-12 04:00:00	MSFT	Stock	113.19	113.19	113.0	113.0	3200.0
2019-03-12 05:00:00	MSFT	Stock	113.09	113.4	113.09	113.4	2029.0
2019-03-12 06:00:00	MSFT	Stock	113.07	113.07	112.83	112.87	2968.0
2019-03-12 07:00:00	MSFT	Stock	112.96	113.0	112.75	112.9	14162.0
2019-03-12 08:00:00	MSFT	Stock	113.0	113.3	112.81	113.15	13670.0
2019-03-12 09:00:00	MSFT	Stock	113.15	113.189	112.65	112.993	2120243.0
2019-03-12 10:00:00	MSFT	Stock	113.0	113.885	112.805	113.82	3845846.0
2019-03-12 11:00:00	MSFT	Stock	113.8	113.97	113.455	113.955	2948492.0
2019-03-12 12:00:00	MSFT	Stock	113.96	113.99	113.69	113.952	2011962.0
2019-03-12 13:00:00	MSFT	Stock	113.95	113.97	113.63	113.71	1576963.0
2019-03-12 14:00:00	MSFT	Stock	113.71	113.75	113.461	113.73	1873479.0
2019-03-12 15:00:00	MSFT	Stock	113.735	113.76	113.33	113.64	4266637.0
2019-03-12 16:00:00	MSFT	Stock	113.62	113.73	113.55	113.73	4262631.0
2019-03-12 17:00:00	MSFT	Stock	113.7	113.7	113.66	113.7	2450.0
2019-03-12 18:00:00	MSFT	Stock	113.65	113.72	113.6	113.6	688.0
2019-03-12 19:00:00	MSFT	Stock	113.62	113.65	113.55	113.55	1525.0
2019-03-12 04:00:00	NVDA	Stock	4.0625	4.0625	4.05	4.05	38560.0
2019-03-12 05:00:00	NVDA	Stock	4.051	4.051	4.051	4.051	8000.0
2019-03-12 06:00:00	NVDA	Stock	4.0525	4.0528	4.041	4.0417	98760.0
2019-03-12 07:00:00	NVDA	Stock	4.052	4.06	4.0362	4.0502	843160.0
2019-03-12 08:00:00	NVDA	Stock	4.0574	4.0625	4.0375	4.0462	2942960.0
2019-03-12 09:00:00	NVDA	Stock	4.0462	4.0875	3.9798	4.0414	106563800.0
2019-03-12 10:00:00	NVDA	Stock	4.0422	4.075	4.0362	4.0635	94164120.0
2019-03-12 11:00:00	NVDA	Stock	4.063	4.0888	4.026	4.0835	85457400.0
2019-03-12 12:00:00	NVDA	Stock	4.0834	4.0968	4.0653	4.0938	65690280.0
2019-03-12 13:00:00	NVDA	Stock	4.0938	4.1026	4.0737	4.0992	41520960.0
2019-03-12 14:00:00	NVDA	Stock	4.1	4.1098	4.081	4.0922	45125360.0
2019-03-12 15:00:00	NVDA	Stock	4.0927	4.0932	4.0528	4.0628	73291200.0
2019-03-12 16:00:00	NVDA	Stock	4.063	4.0675	4.063	4.0653	17452320.0
2019-03-12 17:00:00	NVDA	Stock	4.07	4.0998	4.064	4.0998	2023440.0
2019-03-12 18:00:00	NVDA	Stock	4.0993	4.0993	4.0775	4.0808	647760.0
2019-03-12 19:00:00	NVDA	Stock	4.0812	4.0812	4.0688	4.0763	487560.0
2019-03-12 04:00:00	AMZN	Stock	83.747	83.75	83.747	83.75	4000.0
2019-03-12 05:00:00	AMZN	Stock	83.7495	83.7495	83.7495	83.7495	2000.0

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

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