PREVIEW / stock_1hour / 2019-09-25

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-09-25.parquet
  size:    1.1 MB
  rows:    50,191
  symbols: 2,529

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-09-25 04:00:00	AAPL	Stock	54.28	54.28	54.175	54.175	20604.0
2019-09-25 05:00:00	AAPL	Stock	54.1375	54.1875	54.075	54.15	8080.0
2019-09-25 06:00:00	AAPL	Stock	54.225	54.3	54.225	54.3	28496.0
2019-09-25 07:00:00	AAPL	Stock	54.2825	54.4125	54.25	54.325	148740.0
2019-09-25 08:00:00	AAPL	Stock	54.4125	54.675	54.255	54.675	328180.0
2019-09-25 09:00:00	AAPL	Stock	54.6975	54.92	54.4388	54.5025	10380088.0
2019-09-25 10:00:00	AAPL	Stock	54.5	55.015	54.285	54.875	15173088.0
2019-09-25 11:00:00	AAPL	Stock	54.875	55.1375	54.83	55.0675	8967016.0
2019-09-25 12:00:00	AAPL	Stock	55.0625	55.2325	54.985	55.0425	6011164.0
2019-09-25 13:00:00	AAPL	Stock	55.04	55.1325	54.9602	55.1275	4656024.0
2019-09-25 14:00:00	AAPL	Stock	55.13	55.225	55.0	55.1375	5785100.0
2019-09-25 15:00:00	AAPL	Stock	55.1375	55.375	55.105	55.2475	11780440.0
2019-09-25 16:00:00	AAPL	Stock	55.2575	55.305	55.205	55.24	8257560.0
2019-09-25 17:00:00	AAPL	Stock	55.2575	55.2575	55.2125	55.24	72736.0
2019-09-25 18:00:00	AAPL	Stock	55.2275	55.29	55.2275	55.25	32300.0
2019-09-25 19:00:00	AAPL	Stock	55.2325	55.2425	55.1625	55.225	71900.0
2019-09-25 04:00:00	MSFT	Stock	137.17	137.38	136.8	136.8	700.0
2019-09-25 05:00:00	MSFT	Stock	136.73	136.83	136.62	136.83	550.0
2019-09-25 06:00:00	MSFT	Stock	136.97	136.97	136.97	136.97	100.0
2019-09-25 07:00:00	MSFT	Stock	137.23	137.23	136.88	136.95	5297.0
2019-09-25 08:00:00	MSFT	Stock	136.883	137.5	136.883	137.5	23438.0
2019-09-25 09:00:00	MSFT	Stock	137.42	137.7	136.27	136.68	2067349.0
2019-09-25 10:00:00	MSFT	Stock	136.7	137.73	136.03	137.37	2767453.0
2019-09-25 11:00:00	MSFT	Stock	137.37	138.06	137.35	137.765	1697482.0
2019-09-25 12:00:00	MSFT	Stock	137.765	138.23	137.76	138.0	1635889.0
2019-09-25 13:00:00	MSFT	Stock	138.0	138.365	137.94	138.21	1040266.0
2019-09-25 14:00:00	MSFT	Stock	138.215	139.13	138.175	139.06	1789462.0
2019-09-25 15:00:00	MSFT	Stock	139.06	139.958	139.02	139.36	3458888.0
2019-09-25 16:00:00	MSFT	Stock	139.36	139.41	139.216	139.23	3149739.0
2019-09-25 17:00:00	MSFT	Stock	139.36	139.36	139.2	139.2	43622.0
2019-09-25 18:00:00	MSFT	Stock	139.27	139.3	139.21	139.23	4862.0
2019-09-25 19:00:00	MSFT	Stock	139.23	139.24	139.08	139.09	11199.0
2019-09-25 04:00:00	NVDA	Stock	4.3	4.3	4.3	4.3	20000.0
2019-09-25 05:00:00	NVDA	Stock	4.2895	4.2895	4.2533	4.2735	98680.0
2019-09-25 06:00:00	NVDA	Stock	4.2972	4.2972	4.2588	4.265	46400.0
2019-09-25 07:00:00	NVDA	Stock	4.28	4.2888	4.275	4.2803	188400.0
2019-09-25 08:00:00	NVDA	Stock	4.2752	4.3112	4.275	4.3112	597440.0
2019-09-25 09:00:00	NVDA	Stock	4.3125	4.367	4.2818	4.2947	30592480.0
2019-09-25 10:00:00	NVDA	Stock	4.2962	4.3645	4.2678	4.3625	35132000.0
2019-09-25 11:00:00	NVDA	Stock	4.3645	4.402	4.3645	4.3817	39304880.0
2019-09-25 12:00:00	NVDA	Stock	4.3827	4.4105	4.382	4.39	21198080.0
2019-09-25 13:00:00	NVDA	Stock	4.3908	4.438	4.3873	4.4328	26580120.0
2019-09-25 14:00:00	NVDA	Stock	4.4322	4.4635	4.4298	4.4563	34421000.0
2019-09-25 15:00:00	NVDA	Stock	4.4563	4.4755	4.4528	4.4568	51877040.0
2019-09-25 16:00:00	NVDA	Stock	4.4558	4.4648	4.4553	4.4636	17116680.0
2019-09-25 17:00:00	NVDA	Stock	4.4558	4.46	4.4558	4.457	1021880.0
2019-09-25 18:00:00	NVDA	Stock	4.4615	4.464	4.4575	4.4622	36000.0
2019-09-25 19:00:00	NVDA	Stock	4.4645	4.4645	4.4562	4.4588	290320.0
2019-09-25 04:00:00	AMZN	Stock	86.6535	86.7445	86.6535	86.6585	13140.0
2019-09-25 05:00:00	AMZN	Stock	86.6	86.6555	86.6	86.6555	13320.0

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

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