PREVIEW / stock_1hour / 2019-03-08

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-03-08.parquet
  size:    1.1 MB
  rows:    50,401
  symbols: 2,647

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-08 04:00:00	AAPL	Stock	42.9725	42.9725	42.81	42.875	18476.0
2019-03-08 05:00:00	AAPL	Stock	42.92	42.9375	42.825	42.88	89012.0
2019-03-08 06:00:00	AAPL	Stock	42.8775	42.9325	42.8425	42.8425	20692.0
2019-03-08 07:00:00	AAPL	Stock	42.8825	42.9125	42.8125	42.815	166104.0
2019-03-08 08:00:00	AAPL	Stock	42.85	43.125	42.5825	42.595	922168.0
2019-03-08 09:00:00	AAPL	Stock	42.5925	42.8675	42.375	42.795	14984820.0
2019-03-08 10:00:00	AAPL	Stock	42.7925	42.9925	42.6702	42.8975	13504604.0
2019-03-08 11:00:00	AAPL	Stock	42.8925	43.0675	42.8725	42.92	8904900.0
2019-03-08 12:00:00	AAPL	Stock	42.9225	42.9475	42.8125	42.835	5866780.0
2019-03-08 13:00:00	AAPL	Stock	42.835	42.9525	42.8075	42.9512	5432552.0
2019-03-08 14:00:00	AAPL	Stock	42.9525	43.1875	42.91	43.125	8041832.0
2019-03-08 15:00:00	AAPL	Stock	43.12	43.2675	42.995	43.23	14997532.0
2019-03-08 16:00:00	AAPL	Stock	43.2275	43.3625	43.22	43.29	14594948.0
2019-03-08 17:00:00	AAPL	Stock	43.275	43.295	43.2625	43.275	34680.0
2019-03-08 18:00:00	AAPL	Stock	43.275	43.275	43.25	43.25	16604.0
2019-03-08 19:00:00	AAPL	Stock	43.275	43.2975	43.2525	43.2525	11808.0
2019-03-08 04:00:00	MSFT	Stock	109.75	109.9	109.75	109.85	2718.0
2019-03-08 05:00:00	MSFT	Stock	109.48	109.48	109.26	109.32	3305.0
2019-03-08 06:00:00	MSFT	Stock	109.5	109.7	109.5	109.64	3087.0
2019-03-08 07:00:00	MSFT	Stock	109.64	109.71	109.56	109.62	7152.0
2019-03-08 08:00:00	MSFT	Stock	109.55	110.39	109.2	109.31	213069.0
2019-03-08 09:00:00	MSFT	Stock	109.26	109.62	108.8	109.2	3473335.0
2019-03-08 10:00:00	MSFT	Stock	109.205	109.765	109.02	109.41	3178451.0
2019-03-08 11:00:00	MSFT	Stock	109.41	109.88	109.36	109.61	1875772.0
2019-03-08 12:00:00	MSFT	Stock	109.62	109.7	109.24	109.43	1987227.0
2019-03-08 13:00:00	MSFT	Stock	109.42	109.84	109.375	109.68	1273199.0
2019-03-08 14:00:00	MSFT	Stock	109.68	110.38	109.56	110.2	1520865.0
2019-03-08 15:00:00	MSFT	Stock	110.2	110.71	109.92	110.52	3682889.0
2019-03-08 16:00:00	MSFT	Stock	110.52	110.8	110.51	110.69	3225198.0
2019-03-08 17:00:00	MSFT	Stock	110.72	110.72	110.55	110.56	11066.0
2019-03-08 18:00:00	MSFT	Stock	110.61	110.68	110.61	110.63	696.0
2019-03-08 19:00:00	MSFT	Stock	110.68	110.72	110.66	110.72	6410.0
2019-03-08 04:00:00	NVDA	Stock	3.707	3.707	3.6868	3.6868	24640.0
2019-03-08 05:00:00	NVDA	Stock	3.6768	3.6868	3.6752	3.6868	20800.0
2019-03-08 06:00:00	NVDA	Stock	3.6882	3.6882	3.6765	3.6765	8000.0
2019-03-08 07:00:00	NVDA	Stock	3.6865	3.6878	3.67	3.67	554600.0
2019-03-08 08:00:00	NVDA	Stock	3.6856	3.7315	3.6415	3.6485	3439880.0
2019-03-08 09:00:00	NVDA	Stock	3.6475	3.7242	3.62	3.709	79031640.0
2019-03-08 10:00:00	NVDA	Stock	3.709	3.7333	3.6942	3.7175	56348640.0
2019-03-08 11:00:00	NVDA	Stock	3.717	3.7298	3.7005	3.7078	36167200.0
2019-03-08 12:00:00	NVDA	Stock	3.7078	3.7275	3.706	3.7134	25472280.0
2019-03-08 13:00:00	NVDA	Stock	3.7134	3.7375	3.7125	3.7284	26385760.0
2019-03-08 14:00:00	NVDA	Stock	3.7288	3.768	3.7212	3.7598	40891240.0
2019-03-08 15:00:00	NVDA	Stock	3.759	3.7768	3.748	3.7668	75817360.0
2019-03-08 16:00:00	NVDA	Stock	3.766	3.7788	3.755	3.7693	4015600.0
2019-03-08 17:00:00	NVDA	Stock	3.77	3.7788	3.77	3.7763	311840.0
2019-03-08 18:00:00	NVDA	Stock	3.775	3.7763	3.7725	3.775	240400.0
2019-03-08 19:00:00	NVDA	Stock	3.775	3.777	3.7688	3.775	152760.0
2019-03-08 04:00:00	AMZN	Stock	80.9	80.9	80.8175	80.8175	6000.0
2019-03-08 05:00:00	AMZN	Stock	80.7495	80.787	80.7495	80.787	4000.0

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

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