PREVIEW / stock_1hour / 2019-12-18

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-12-18.parquet
  size:    1.2 MB
  rows:    51,115
  symbols: 2,517

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-18 04:00:00	AAPL	Stock	70.0775	70.19	70.0775	70.19	2672.0
2019-12-18 05:00:00	AAPL	Stock	70.1125	70.1125	69.97	70.0925	17788.0
2019-12-18 06:00:00	AAPL	Stock	70.0525	70.0525	70.0	70.05	12140.0
2019-12-18 07:00:00	AAPL	Stock	70.05	70.0825	69.9375	70.0625	79004.0
2019-12-18 08:00:00	AAPL	Stock	70.025	70.1025	69.9025	70.0	187264.0
2019-12-18 09:00:00	AAPL	Stock	70.0	70.12	69.825	69.8542	12008640.0
2019-12-18 10:00:00	AAPL	Stock	69.8525	69.995	69.78	69.9225	11360832.0
2019-12-18 11:00:00	AAPL	Stock	69.92	70.065	69.8825	70.015	10593540.0
2019-12-18 12:00:00	AAPL	Stock	70.0175	70.3125	70.0175	70.255	9385408.0
2019-12-18 13:00:00	AAPL	Stock	70.2575	70.371	70.1925	70.3692	7262896.0
2019-12-18 14:00:00	AAPL	Stock	70.37	70.475	70.3175	70.4625	7459988.0
2019-12-18 15:00:00	AAPL	Stock	70.4638	70.475	69.8775	69.9275	15601900.0
2019-12-18 16:00:00	AAPL	Stock	69.935	70.0875	69.9	69.95	15533640.0
2019-12-18 17:00:00	AAPL	Stock	69.9375	69.9825	69.9375	69.95	65592.0
2019-12-18 18:00:00	AAPL	Stock	69.975	69.9925	69.95	69.9725	34108.0
2019-12-18 19:00:00	AAPL	Stock	69.9525	70.0	69.9525	70.0	35876.0
2019-12-18 04:00:00	MSFT	Stock	154.68	154.94	154.68	154.94	1045.0
2019-12-18 05:00:00	MSFT	Stock	155.04	155.04	154.91	155.0	1854.0
2019-12-18 06:00:00	MSFT	Stock	154.9	154.9	154.9	154.9	100.0
2019-12-18 07:00:00	MSFT	Stock	154.76	154.9	154.75	154.89	3856.0
2019-12-18 08:00:00	MSFT	Stock	154.887	154.89	154.65	154.74	12207.0
2019-12-18 09:00:00	MSFT	Stock	154.74	154.74	154.07	154.57	1892487.0
2019-12-18 10:00:00	MSFT	Stock	154.57	155.2	154.43	155.15	1885615.0
2019-12-18 11:00:00	MSFT	Stock	155.15	155.48	155.045	155.32	2087398.0
2019-12-18 12:00:00	MSFT	Stock	155.316	155.37	155.0	155.01	1075289.0
2019-12-18 13:00:00	MSFT	Stock	155.01	155.12	154.91	154.94	774582.0
2019-12-18 14:00:00	MSFT	Stock	154.948	154.99	154.82	154.901	963755.0
2019-12-18 15:00:00	MSFT	Stock	154.91	154.94	154.36	154.37	3225950.0
2019-12-18 16:00:00	MSFT	Stock	154.37	154.737	154.22	154.4	6913106.0
2019-12-18 17:00:00	MSFT	Stock	154.54	154.54	154.54	154.54	191.0
2019-12-18 18:00:00	MSFT	Stock	154.5	154.55	154.37	154.5	448639.0
2019-12-18 19:00:00	MSFT	Stock	154.47	154.69	154.47	154.5	1216.0
2019-12-18 04:00:00	NVDA	Stock	5.73	5.7362	5.73	5.7362	21880.0
2019-12-18 05:00:00	NVDA	Stock	5.7375	5.7375	5.7375	5.7375	12200.0
2019-12-18 06:00:00	NVDA	Stock	5.725	5.7293	5.725	5.7293	20400.0
2019-12-18 07:00:00	NVDA	Stock	5.7345	5.7475	5.7165	5.7453	493760.0
2019-12-18 08:00:00	NVDA	Stock	5.735	5.7575	5.693	5.75	1772000.0
2019-12-18 09:00:00	NVDA	Stock	5.745	5.7898	5.7338	5.756	65986840.0
2019-12-18 10:00:00	NVDA	Stock	5.7552	5.791	5.738	5.7824	49268720.0
2019-12-18 11:00:00	NVDA	Stock	5.7822	5.7985	5.7595	5.791	42951200.0
2019-12-18 12:00:00	NVDA	Stock	5.7908	5.7916	5.7693	5.7703	28818640.0
2019-12-18 13:00:00	NVDA	Stock	5.7708	5.7848	5.7703	5.7792	18117720.0
2019-12-18 14:00:00	NVDA	Stock	5.7798	5.7888	5.7683	5.7754	18982160.0
2019-12-18 15:00:00	NVDA	Stock	5.776	5.7773	5.7355	5.7355	47326360.0
2019-12-18 16:00:00	NVDA	Stock	5.7378	5.8	5.7353	5.7655	26297680.0
2019-12-18 17:00:00	NVDA	Stock	5.7625	5.775	5.7625	5.77	418680.0
2019-12-18 18:00:00	NVDA	Stock	5.775	5.7835	5.775	5.78	328840.0
2019-12-18 19:00:00	NVDA	Stock	5.7775	5.7788	5.7625	5.7763	410360.0
2019-12-18 04:00:00	AMZN	Stock	89.676	89.677	89.676	89.677	11320.0
2019-12-18 05:00:00	AMZN	Stock	89.735	89.75	89.735	89.75	4100.0

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

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