PREVIEW / stock_1hour / 2019-10-02

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-10-02.parquet
  size:    1.1 MB
  rows:    50,078
  symbols: 2,503

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-10-02 04:00:00	AAPL	Stock	55.9375	55.9375	55.7325	55.75	89448.0
2019-10-02 05:00:00	AAPL	Stock	55.75	55.825	55.625	55.6525	132100.0
2019-10-02 06:00:00	AAPL	Stock	55.65	55.775	55.625	55.6875	49324.0
2019-10-02 07:00:00	AAPL	Stock	55.69	55.7875	55.6325	55.7875	218112.0
2019-10-02 08:00:00	AAPL	Stock	55.715	55.8375	55.6325	55.67	348356.0
2019-10-02 09:00:00	AAPL	Stock	55.6632	55.895	55.1825	55.3275	17969444.0
2019-10-02 10:00:00	AAPL	Stock	55.325	55.365	54.84	54.9475	22384476.0
2019-10-02 11:00:00	AAPL	Stock	54.9425	55.14	54.7175	54.8025	12788088.0
2019-10-02 12:00:00	AAPL	Stock	54.8	54.8132	54.4825	54.6108	9978380.0
2019-10-02 13:00:00	AAPL	Stock	54.61	54.8725	54.57	54.675	11011384.0
2019-10-02 14:00:00	AAPL	Stock	54.6762	54.9402	54.6325	54.8125	10866764.0
2019-10-02 15:00:00	AAPL	Stock	54.8125	54.9875	54.71	54.74	18299232.0
2019-10-02 16:00:00	AAPL	Stock	54.74	54.956	54.5125	54.625	9708304.0
2019-10-02 17:00:00	AAPL	Stock	54.6125	54.625	54.5825	54.625	104396.0
2019-10-02 18:00:00	AAPL	Stock	54.6125	54.6675	54.565	54.6575	89288.0
2019-10-02 19:00:00	AAPL	Stock	54.625	54.7525	54.625	54.625	93132.0
2019-10-02 04:00:00	MSFT	Stock	136.65	136.65	136.13	136.13	3578.0
2019-10-02 05:00:00	MSFT	Stock	136.06	136.18	135.8	135.8	1603.0
2019-10-02 06:00:00	MSFT	Stock	135.97	135.97	135.97	135.97	250.0
2019-10-02 07:00:00	MSFT	Stock	136.08	136.3	136.0	136.26	18191.0
2019-10-02 08:00:00	MSFT	Stock	136.25	136.46	136.05	136.175	54489.0
2019-10-02 09:00:00	MSFT	Stock	136.082	136.37	134.87	135.14	3274228.0
2019-10-02 10:00:00	MSFT	Stock	135.13	135.18	133.63	134.07	5196205.0
2019-10-02 11:00:00	MSFT	Stock	134.06	134.43	133.89	134.288	3153376.0
2019-10-02 12:00:00	MSFT	Stock	134.28	134.37	133.58	133.78	2067826.0
2019-10-02 13:00:00	MSFT	Stock	133.78	134.28	133.644	133.97	1699353.0
2019-10-02 14:00:00	MSFT	Stock	133.96	134.915	133.83	134.76	2239365.0
2019-10-02 15:00:00	MSFT	Stock	134.775	135.282	134.54	134.63	4284447.0
2019-10-02 16:00:00	MSFT	Stock	134.65	134.71	134.25	134.44	4335452.0
2019-10-02 17:00:00	MSFT	Stock	134.41	134.45	134.37	134.38	8027.0
2019-10-02 18:00:00	MSFT	Stock	134.44	134.75	134.42	134.75	8735.0
2019-10-02 19:00:00	MSFT	Stock	134.65	134.84	134.6	134.65	14547.0
2019-10-02 04:00:00	NVDA	Stock	4.3225	4.3225	4.3015	4.3015	30400.0
2019-10-02 05:00:00	NVDA	Stock	4.3025	4.3025	4.3	4.3	12600.0
2019-10-02 06:00:00	NVDA	Stock	4.3	4.3	4.3	4.3	102800.0
2019-10-02 07:00:00	NVDA	Stock	4.3	4.3255	4.3	4.3225	791080.0
2019-10-02 08:00:00	NVDA	Stock	4.305	4.3368	4.3004	4.3125	1224240.0
2019-10-02 09:00:00	NVDA	Stock	4.3112	4.3305	4.2725	4.299	45623000.0
2019-10-02 10:00:00	NVDA	Stock	4.2968	4.34	4.2685	4.2898	41913560.0
2019-10-02 11:00:00	NVDA	Stock	4.29	4.3048	4.2533	4.2812	34805800.0
2019-10-02 12:00:00	NVDA	Stock	4.2818	4.2828	4.2565	4.27	28163400.0
2019-10-02 13:00:00	NVDA	Stock	4.2705	4.289	4.2653	4.2685	20172520.0
2019-10-02 14:00:00	NVDA	Stock	4.2678	4.316	4.2625	4.3068	29174320.0
2019-10-02 15:00:00	NVDA	Stock	4.3077	4.3312	4.2947	4.328	54419960.0
2019-10-02 16:00:00	NVDA	Stock	4.326	4.331	4.3035	4.3125	5833160.0
2019-10-02 17:00:00	NVDA	Stock	4.313	4.3225	4.313	4.3222	893920.0
2019-10-02 18:00:00	NVDA	Stock	4.32	4.3225	4.3153	4.3162	90920.0
2019-10-02 19:00:00	NVDA	Stock	4.322	4.33	4.3212	4.3212	175160.0
2019-10-02 05:00:00	AMZN	Stock	86.05	86.05	86.05	86.05	2000.0
2019-10-02 06:00:00	AMZN	Stock	86.1	86.1	86.1	86.1	6760.0

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

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