PREVIEW / stock_1hour / 2019-12-20

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-12-20.parquet
  size:    1.2 MB
  rows:    50,843
  symbols: 2,494

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-20 04:00:00	AAPL	Stock	70.025	70.025	70.0	70.0	3008.0
2019-12-20 05:00:00	AAPL	Stock	70.0825	70.12	70.0825	70.12	3008.0
2019-12-20 06:00:00	AAPL	Stock	70.115	70.1675	70.075	70.075	12644.0
2019-12-20 07:00:00	AAPL	Stock	70.075	70.25	70.0325	70.2475	111600.0
2019-12-20 08:00:00	AAPL	Stock	70.07	70.3	70.04	70.2525	344264.0
2019-12-20 09:00:00	AAPL	Stock	70.2625	70.885	70.2	70.2475	39308148.0
2019-12-20 10:00:00	AAPL	Stock	70.2488	70.4575	70.1625	70.3475	10355112.0
2019-12-20 11:00:00	AAPL	Stock	70.3475	70.4825	70.21	70.26	11147032.0
2019-12-20 12:00:00	AAPL	Stock	70.2575	70.2925	70.17	70.2212	7026948.0
2019-12-20 13:00:00	AAPL	Stock	70.2212	70.2725	70.1862	70.1875	4206468.0
2019-12-20 14:00:00	AAPL	Stock	70.1875	70.1922	70.0375	70.1175	7603324.0
2019-12-20 15:00:00	AAPL	Stock	70.1138	70.1225	69.64	69.82	20884524.0
2019-12-20 16:00:00	AAPL	Stock	69.86	69.905	69.75	69.8525	81245324.0
2019-12-20 17:00:00	AAPL	Stock	69.83	69.8535	69.755	69.825	98284.0
2019-12-20 18:00:00	AAPL	Stock	69.85	69.88	69.775	69.8025	70868.0
2019-12-20 19:00:00	AAPL	Stock	69.8275	69.875	69.8125	69.875	61680.0
2019-12-20 04:00:00	MSFT	Stock	155.8	155.8	155.5	155.5	300.0
2019-12-20 05:00:00	MSFT	Stock	155.7	155.7	155.67	155.67	500.0
2019-12-20 06:00:00	MSFT	Stock	155.67	155.85	155.67	155.8	4392.0
2019-12-20 07:00:00	MSFT	Stock	155.8	155.91	155.8	155.91	2974.0
2019-12-20 08:00:00	MSFT	Stock	155.87	156.2	155.75	156.03	50940.0
2019-12-20 09:00:00	MSFT	Stock	156.1	158.49	156.0	156.43	14058543.0
2019-12-20 10:00:00	MSFT	Stock	156.43	157.13	156.41	156.78	2323677.0
2019-12-20 11:00:00	MSFT	Stock	156.78	157.24	156.69	157.08	1859140.0
2019-12-20 12:00:00	MSFT	Stock	157.07	157.47	156.99	157.175	1538299.0
2019-12-20 13:00:00	MSFT	Stock	157.17	157.21	156.963	157.142	1221333.0
2019-12-20 14:00:00	MSFT	Stock	157.145	157.44	156.99	157.35	1270270.0
2019-12-20 15:00:00	MSFT	Stock	157.35	157.53	157.05	157.39	3968303.0
2019-12-20 16:00:00	MSFT	Stock	157.41	157.6	157.175	157.5	14736239.0
2019-12-20 17:00:00	MSFT	Stock	157.5	157.54	157.5	157.5	6076.0
2019-12-20 18:00:00	MSFT	Stock	157.51	157.54	157.51	157.54	1606.0
2019-12-20 19:00:00	MSFT	Stock	157.53	157.6	157.53	157.58	6598.0
2019-12-20 04:00:00	NVDA	Stock	5.908	5.915	5.908	5.915	25360.0
2019-12-20 05:00:00	NVDA	Stock	5.917	5.917	5.91	5.91	55120.0
2019-12-20 06:00:00	NVDA	Stock	5.925	5.927	5.9125	5.927	134320.0
2019-12-20 07:00:00	NVDA	Stock	5.9275	5.9492	5.915	5.9488	780680.0
2019-12-20 08:00:00	NVDA	Stock	5.9263	5.9748	5.9075	5.9688	3019960.0
2019-12-20 09:00:00	NVDA	Stock	5.9685	5.989	5.9339	5.9695	109260560.0
2019-12-20 10:00:00	NVDA	Stock	5.9688	6.0098	5.9553	6.0025	81464600.0
2019-12-20 11:00:00	NVDA	Stock	6.0037	6.0072	5.9708	5.9804	39927880.0
2019-12-20 12:00:00	NVDA	Stock	5.9806	5.9842	5.954	5.9698	31535360.0
2019-12-20 13:00:00	NVDA	Stock	5.9696	6.0065	5.9631	5.9998	29957000.0
2019-12-20 14:00:00	NVDA	Stock	5.9981	6.0013	5.976	5.9834	26768560.0
2019-12-20 15:00:00	NVDA	Stock	5.9842	5.9878	5.9513	5.9848	69878360.0
2019-12-20 16:00:00	NVDA	Stock	5.9842	5.985	5.9695	5.98	56285520.0
2019-12-20 17:00:00	NVDA	Stock	5.98	5.9825	5.978	5.9788	160440.0
2019-12-20 18:00:00	NVDA	Stock	5.9825	5.9825	5.9818	5.9825	78680.0
2019-12-20 19:00:00	NVDA	Stock	5.9825	5.9875	5.9765	5.9875	207760.0
2019-12-20 07:00:00	AMZN	Stock	89.6	89.637	89.6	89.637	14360.0
2019-12-20 08:00:00	AMZN	Stock	89.5995	89.794	89.5995	89.794	66860.0

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

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