PREVIEW / stock_1hour / 2019-07-25

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-07-25.parquet
  size:    1.1 MB
  rows:    49,715
  symbols: 2,552

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-07-25 04:00:00	AAPL	Stock	52.15	52.21	52.15	52.1925	6700.0
2019-07-25 05:00:00	AAPL	Stock	52.175	52.175	52.1575	52.1675	13964.0
2019-07-25 06:00:00	AAPL	Stock	52.175	52.175	52.03	52.0875	7608.0
2019-07-25 07:00:00	AAPL	Stock	52.0875	52.25	52.0875	52.24	68332.0
2019-07-25 08:00:00	AAPL	Stock	52.125	52.3325	52.0375	52.2575	263176.0
2019-07-25 09:00:00	AAPL	Stock	52.27	52.31	51.9325	52.0825	8189376.0
2019-07-25 10:00:00	AAPL	Stock	52.0875	52.2225	52.0168	52.134	6497952.0
2019-07-25 11:00:00	AAPL	Stock	52.1275	52.1725	51.9725	52.0865	4521736.0
2019-07-25 12:00:00	AAPL	Stock	52.0888	52.09	51.83	51.88	4855900.0
2019-07-25 13:00:00	AAPL	Stock	51.875	51.9035	51.78	51.82	4091124.0
2019-07-25 14:00:00	AAPL	Stock	51.815	51.958	51.7925	51.805	3605220.0
2019-07-25 15:00:00	AAPL	Stock	51.8025	51.84	51.6825	51.7625	8637104.0
2019-07-25 16:00:00	AAPL	Stock	51.755	51.84	51.675	51.75	5643764.0
2019-07-25 17:00:00	AAPL	Stock	51.755	51.78	51.725	51.775	130488.0
2019-07-25 18:00:00	AAPL	Stock	51.775	51.815	51.7575	51.78	23556.0
2019-07-25 19:00:00	AAPL	Stock	51.8225	51.835	51.79	51.7925	46260.0
2019-07-25 04:00:00	MSFT	Stock	140.99	141.0	140.91	141.0	1400.0
2019-07-25 05:00:00	MSFT	Stock	141.1	141.11	141.04	141.04	450.0
2019-07-25 06:00:00	MSFT	Stock	141.09	141.09	140.49	140.6	3133.0
2019-07-25 07:00:00	MSFT	Stock	140.6	141.0	140.46	140.96	20888.0
2019-07-25 08:00:00	MSFT	Stock	140.61	140.98	140.55	140.87	26583.0
2019-07-25 09:00:00	MSFT	Stock	140.88	140.89	139.322	139.752	2782184.0
2019-07-25 10:00:00	MSFT	Stock	139.76	140.595	139.67	140.44	2529338.0
2019-07-25 11:00:00	MSFT	Stock	140.43	140.61	140.11	140.33	1535811.0
2019-07-25 12:00:00	MSFT	Stock	140.33	140.49	139.538	139.81	1905331.0
2019-07-25 13:00:00	MSFT	Stock	139.82	140.28	139.71	139.98	1173975.0
2019-07-25 14:00:00	MSFT	Stock	139.99	140.46	139.99	140.21	1147080.0
2019-07-25 15:00:00	MSFT	Stock	140.2	140.41	139.96	140.19	2649061.0
2019-07-25 16:00:00	MSFT	Stock	140.19	140.28	139.8	139.97	2170274.0
2019-07-25 17:00:00	MSFT	Stock	139.97	140.16	139.82	140.16	21955.0
2019-07-25 18:00:00	MSFT	Stock	140.16	140.17	139.9	140.16	18029.0
2019-07-25 19:00:00	MSFT	Stock	140.16	140.19	140.0	140.18	15280.0
2019-07-25 05:00:00	NVDA	Stock	4.4188	4.425	4.4188	4.425	23000.0
2019-07-25 06:00:00	NVDA	Stock	4.425	4.4258	4.425	4.4258	16000.0
2019-07-25 07:00:00	NVDA	Stock	4.4188	4.4425	4.414	4.435	322840.0
2019-07-25 08:00:00	NVDA	Stock	4.4375	4.4502	4.4126	4.428	1012520.0
2019-07-25 09:00:00	NVDA	Stock	4.4302	4.4375	4.3557	4.3748	71026680.0
2019-07-25 10:00:00	NVDA	Stock	4.374	4.3905	4.3575	4.3748	57579240.0
2019-07-25 11:00:00	NVDA	Stock	4.374	4.3862	4.351	4.3642	43948440.0
2019-07-25 12:00:00	NVDA	Stock	4.3645	4.3682	4.3475	4.3559	32473160.0
2019-07-25 13:00:00	NVDA	Stock	4.3542	4.3572	4.3345	4.3345	24956000.0
2019-07-25 14:00:00	NVDA	Stock	4.3355	4.3475	4.318	4.3192	31756320.0
2019-07-25 15:00:00	NVDA	Stock	4.3188	4.3388	4.311	4.333	45888960.0
2019-07-25 16:00:00	NVDA	Stock	4.3345	4.3788	4.325	4.3625	34952000.0
2019-07-25 17:00:00	NVDA	Stock	4.3625	4.3775	4.3625	4.3775	669000.0
2019-07-25 18:00:00	NVDA	Stock	4.3775	4.3775	4.3675	4.3675	382400.0
2019-07-25 19:00:00	NVDA	Stock	4.37	4.375	4.3625	4.365	180400.0
2019-07-25 04:00:00	AMZN	Stock	100.09	100.09	100.09	100.09	4000.0
2019-07-25 05:00:00	AMZN	Stock	100.104	100.104	100.104	100.104	2000.0
2019-07-25 07:00:00	AMZN	Stock	100.2	100.35	100.2	100.35	33520.0

> showing 50 of 49,715 rows — these rows as CSV

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