PREVIEW / stock_1hour / 2021-08-25

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-08-25.parquet
  size:    1.4 MB
  rows:    64,428
  symbols: 2,765

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
2021-08-25 04:00:00	AAPL	Stock	149.72	150.19	149.69	150.19	24160.0
2021-08-25 05:00:00	AAPL	Stock	150.06	150.16	149.98	150.16	6955.0
2021-08-25 06:00:00	AAPL	Stock	150.05	150.24	149.99	150.15	30574.0
2021-08-25 07:00:00	AAPL	Stock	150.08	150.14	149.65	149.82	127781.0
2021-08-25 08:00:00	AAPL	Stock	149.8999	150.13	149.246	149.99	243680.0
2021-08-25 09:00:00	AAPL	Stock	149.98	150.32	149.15	149.3282	8289863.0
2021-08-25 10:00:00	AAPL	Stock	149.33	149.42	148.12	148.4	10619569.0
2021-08-25 11:00:00	AAPL	Stock	148.4	148.715	148.17	148.25	5616948.0
2021-08-25 12:00:00	AAPL	Stock	148.2501	148.44	148.06	148.3401	4743616.0
2021-08-25 13:00:00	AAPL	Stock	148.34	148.375	147.8	147.86	5165022.0
2021-08-25 14:00:00	AAPL	Stock	147.855	148.37	147.82	148.27	5584616.0
2021-08-25 15:00:00	AAPL	Stock	148.26	148.75	148.215	148.37	7279569.0
2021-08-25 16:00:00	AAPL	Stock	148.37	148.45	148.3	148.3765	5003591.0
2021-08-25 17:00:00	AAPL	Stock	148.36	148.38	148.32	148.3399	31649.0
2021-08-25 18:00:00	AAPL	Stock	148.34	148.35	148.3	148.33	7294.0
2021-08-25 19:00:00	AAPL	Stock	148.34	148.36	148.3	148.3	18487.0
2021-08-25 04:00:00	MSFT	Stock	303.09	303.09	303.09	303.09	200.0
2021-08-25 05:00:00	MSFT	Stock	303.19	303.35	303.18	303.3	1255.0
2021-08-25 06:00:00	MSFT	Stock	303.38	303.38	303.2	303.2	17489.0
2021-08-25 07:00:00	MSFT	Stock	303.4	303.4	302.65	303.25	50779.0
2021-08-25 08:00:00	MSFT	Stock	303.3454	303.91	302.94	303.84	49832.0
2021-08-25 09:00:00	MSFT	Stock	303.92	304.65	301.12	302.035	2628198.0
2021-08-25 10:00:00	MSFT	Stock	302.04	302.37	301.31	302.09	1874052.0
2021-08-25 11:00:00	MSFT	Stock	302.0823	302.55	301.33	301.3409	1387655.0
2021-08-25 12:00:00	MSFT	Stock	301.35	301.55	301.11	301.505	896454.0
2021-08-25 13:00:00	MSFT	Stock	301.51	301.54	300.77	301.02	1147981.0
2021-08-25 14:00:00	MSFT	Stock	301.02	301.64	300.42	301.29	1512711.0
2021-08-25 15:00:00	MSFT	Stock	301.285	302.49	301.27	302.0	2034649.0
2021-08-25 16:00:00	MSFT	Stock	302.01	302.23	301.26	302.15	2385949.0
2021-08-25 17:00:00	MSFT	Stock	302.1	302.3449	302.08	302.3449	6917.0
2021-08-25 18:00:00	MSFT	Stock	302.1501	302.29	302.15	302.28	2434.0
2021-08-25 19:00:00	MSFT	Stock	302.29	302.29	302.1	302.18	2709.0
2021-08-25 04:00:00	NVDA	Stock	21.83	21.83	21.673	21.747	92320.0
2021-08-25 05:00:00	NVDA	Stock	21.748	21.749	21.738	21.74	15150.0
2021-08-25 06:00:00	NVDA	Stock	21.781	21.781	21.749	21.749	41790.0
2021-08-25 07:00:00	NVDA	Stock	21.732	21.75	21.611	21.62	307180.0
2021-08-25 08:00:00	NVDA	Stock	21.71	21.775	21.611	21.7	576190.0
2021-08-25 09:00:00	NVDA	Stock	21.705	22.457	21.6957	22.442	68290500.0
2021-08-25 10:00:00	NVDA	Stock	22.4443	22.47	22.2	22.305	65702650.0
2021-08-25 11:00:00	NVDA	Stock	22.307	22.443	22.286	22.3275	38266930.0
2021-08-25 12:00:00	NVDA	Stock	22.3282	22.368	22.234	22.3601	22348390.0
2021-08-25 13:00:00	NVDA	Stock	22.3587	22.367	22.2715	22.3024	19455040.0
2021-08-25 14:00:00	NVDA	Stock	22.301	22.339	22.203	22.285	21846460.0
2021-08-25 15:00:00	NVDA	Stock	22.284	22.298	22.199	22.208	30885740.0
2021-08-25 16:00:00	NVDA	Stock	22.213	22.213	22.114	22.167	13127820.0
2021-08-25 17:00:00	NVDA	Stock	22.175	22.245	22.145	22.222	338060.0
2021-08-25 18:00:00	NVDA	Stock	22.196	22.228	22.17	22.2	270420.0
2021-08-25 19:00:00	NVDA	Stock	22.186	22.219	22.17	22.193	131540.0
2021-08-25 04:00:00	AMZN	Stock	165.8	165.8	165.8	165.8	2000.0
2021-08-25 07:00:00	AMZN	Stock	165.5525	165.6	165.2055	165.2055	17560.0

> showing 50 of 64,428 rows — these rows as CSV

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