PREVIEW / stock_1hour / 2020-06-22

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-06-22.parquet
  size:    1.3 MB
  rows:    57,851
  symbols: 2,431

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
2020-06-22 04:00:00	AAPL	Stock	87.6	87.93	87.5	87.8875	23924.0
2020-06-22 05:00:00	AAPL	Stock	88.0325	88.1925	87.9375	87.9625	6640.0
2020-06-22 06:00:00	AAPL	Stock	87.875	88.085	87.75	87.9225	31252.0
2020-06-22 07:00:00	AAPL	Stock	87.815	88.105	87.5625	88.05	316480.0
2020-06-22 08:00:00	AAPL	Stock	87.5625	88.175	87.5525	87.975	462164.0
2020-06-22 09:00:00	AAPL	Stock	87.965	88.7825	87.6775	88.7375	16938604.0
2020-06-22 10:00:00	AAPL	Stock	88.7475	89.0525	88.6275	88.6362	14725460.0
2020-06-22 11:00:00	AAPL	Stock	88.6325	89.0878	88.4675	89.0125	10128992.0
2020-06-22 12:00:00	AAPL	Stock	89.0125	89.3525	89.0112	89.2775	11450596.0
2020-06-22 13:00:00	AAPL	Stock	89.28	89.42	89.1425	89.245	11264048.0
2020-06-22 14:00:00	AAPL	Stock	89.24	89.775	89.105	89.77	15649776.0
2020-06-22 15:00:00	AAPL	Stock	89.7702	89.865	89.31	89.7325	20915196.0
2020-06-22 16:00:00	AAPL	Stock	89.735	90.0825	89.6325	89.9875	8459948.0
2020-06-22 17:00:00	AAPL	Stock	90.0	90.105	89.9525	90.0375	207248.0
2020-06-22 18:00:00	AAPL	Stock	90.005	90.4025	90.005	90.375	283548.0
2020-06-22 19:00:00	AAPL	Stock	90.3725	90.5625	90.295	90.55	172188.0
2020-06-22 04:00:00	MSFT	Stock	195.88	195.88	195.15	195.15	1571.0
2020-06-22 05:00:00	MSFT	Stock	196.4	196.9	196.23	196.23	3643.0
2020-06-22 06:00:00	MSFT	Stock	195.9	196.2	195.51	195.58	9262.0
2020-06-22 07:00:00	MSFT	Stock	195.58	196.3	195.5	196.3	31882.0
2020-06-22 08:00:00	MSFT	Stock	195.78	196.6	195.52	195.83	67057.0
2020-06-22 09:00:00	MSFT	Stock	195.828	196.9	195.23	196.89	3276713.0
2020-06-22 10:00:00	MSFT	Stock	196.9	198.33	196.9	197.87	3487609.0
2020-06-22 11:00:00	MSFT	Stock	197.87	199.2	197.61	199.01	3085657.0
2020-06-22 12:00:00	MSFT	Stock	199.0	199.8	199.0	199.48	3376292.0
2020-06-22 13:00:00	MSFT	Stock	199.53	199.68	198.85	199.54	1886583.0
2020-06-22 14:00:00	MSFT	Stock	199.54	200.17	199.19	199.77	3319007.0
2020-06-22 15:00:00	MSFT	Stock	199.76	200.76	199.12	200.58	4469803.0
2020-06-22 16:00:00	MSFT	Stock	200.58	201.41	200.11	201.12	3946189.0
2020-06-22 17:00:00	MSFT	Stock	201.12	201.5	201.05	201.45	37299.0
2020-06-22 18:00:00	MSFT	Stock	201.26	201.6	201.1	201.6	18008.0
2020-06-22 19:00:00	MSFT	Stock	201.5	202.0	201.5	201.97	39526.0
2020-06-22 04:00:00	NVDA	Stock	9.2313	9.2998	9.2313	9.2998	42240.0
2020-06-22 05:00:00	NVDA	Stock	9.275	9.2972	9.275	9.2972	10000.0
2020-06-22 07:00:00	NVDA	Stock	9.275	9.325	9.2628	9.325	405480.0
2020-06-22 08:00:00	NVDA	Stock	9.2763	9.3308	9.25	9.3025	1035720.0
2020-06-22 09:00:00	NVDA	Stock	9.3088	9.3662	9.2733	9.3662	42598640.0
2020-06-22 10:00:00	NVDA	Stock	9.367	9.4233	9.3418	9.366	50172760.0
2020-06-22 11:00:00	NVDA	Stock	9.3655	9.425	9.3558	9.4108	32551840.0
2020-06-22 12:00:00	NVDA	Stock	9.4118	9.5002	9.4065	9.476	55478600.0
2020-06-22 13:00:00	NVDA	Stock	9.4761	9.5125	9.4463	9.4951	44222560.0
2020-06-22 14:00:00	NVDA	Stock	9.496	9.5125	9.4552	9.5088	41249160.0
2020-06-22 15:00:00	NVDA	Stock	9.5091	9.5295	9.4545	9.525	48645000.0
2020-06-22 16:00:00	NVDA	Stock	9.528	9.5562	9.5188	9.55	21608240.0
2020-06-22 17:00:00	NVDA	Stock	9.5492	9.5525	9.5325	9.546	450280.0
2020-06-22 18:00:00	NVDA	Stock	9.5395	9.5537	9.5395	9.5515	139600.0
2020-06-22 19:00:00	NVDA	Stock	9.5515	9.5672	9.55	9.556	417600.0
2020-06-22 04:00:00	AMZN	Stock	134.4	134.4	134.4	134.4	3960.0
2020-06-22 06:00:00	AMZN	Stock	134.485	134.485	134.485	134.485	6600.0
2020-06-22 07:00:00	AMZN	Stock	134.25	134.425	134.1525	134.425	49760.0

> showing 50 of 57,851 rows — these rows as CSV

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