PREVIEW / stock_1hour / 2022-07-15

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-07-15.parquet
  size:    1.3 MB
  rows:    60,409
  symbols: 2,279

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
2022-07-15 04:00:00	AAPL	Stock	148.3	149.04	148.25	148.75	36933.0
2022-07-15 05:00:00	AAPL	Stock	148.75	148.99	148.65	148.7	6754.0
2022-07-15 06:00:00	AAPL	Stock	148.62	148.77	148.55	148.73	3868.0
2022-07-15 07:00:00	AAPL	Stock	148.81	149.09	148.59	148.59	57669.0
2022-07-15 08:00:00	AAPL	Stock	148.86	149.84	148.0	149.6301	530618.0
2022-07-15 09:00:00	AAPL	Stock	149.67	150.86	148.78	149.37	12405711.0
2022-07-15 10:00:00	AAPL	Stock	149.38	150.52	148.84	149.26	10136043.0
2022-07-15 11:00:00	AAPL	Stock	149.25	149.63	148.79	148.791	6003074.0
2022-07-15 12:00:00	AAPL	Stock	148.79	149.058	148.2	148.91	6037032.0
2022-07-15 13:00:00	AAPL	Stock	148.91	149.51	148.81	149.135	4727834.0
2022-07-15 14:00:00	AAPL	Stock	149.1219	149.57	148.86	149.35	4814257.0
2022-07-15 15:00:00	AAPL	Stock	149.3501	150.25	149.05	150.17	12068360.0
2022-07-15 16:00:00	AAPL	Stock	150.13	150.27	149.78	150.02	10106237.0
2022-07-15 17:00:00	AAPL	Stock	150.02	150.05	149.99	150.01	58141.0
2022-07-15 18:00:00	AAPL	Stock	150.01	150.05	149.98	149.99	31419.0
2022-07-15 19:00:00	AAPL	Stock	149.97	150.07	149.97	150.03	22308.0
2022-07-15 04:00:00	MSFT	Stock	254.4	254.4	254.4	254.4	423.0
2022-07-15 05:00:00	MSFT	Stock	255.15	255.15	254.55	254.55	908.0
2022-07-15 06:00:00	MSFT	Stock	254.5	254.73	254.5	254.62	1230.0
2022-07-15 07:00:00	MSFT	Stock	254.99	255.08	253.53	253.53	16342.0
2022-07-15 08:00:00	MSFT	Stock	254.85	256.32	253.09	255.6021	78836.0
2022-07-15 09:00:00	MSFT	Stock	255.6049	258.68	254.24	257.76	3803638.0
2022-07-15 10:00:00	MSFT	Stock	257.88	260.3699	257.87	258.77	3093698.0
2022-07-15 11:00:00	MSFT	Stock	258.81	259.32	257.15	257.2	1625924.0
2022-07-15 12:00:00	MSFT	Stock	257.2249	257.38	255.9	256.17	1406876.0
2022-07-15 13:00:00	MSFT	Stock	256.19	256.62	255.2	255.87	1420332.0
2022-07-15 14:00:00	MSFT	Stock	255.8592	255.955	254.7727	255.545	1515515.0
2022-07-15 15:00:00	MSFT	Stock	255.52	256.91	255.13	256.71	3570092.0
2022-07-15 16:00:00	MSFT	Stock	256.74	256.74	256.33	256.53	4631498.0
2022-07-15 17:00:00	MSFT	Stock	256.67	256.75	256.62	256.71	6167.0
2022-07-15 18:00:00	MSFT	Stock	256.74	256.74	256.69	256.7	1473.0
2022-07-15 19:00:00	MSFT	Stock	256.75	256.89	256.75	256.79	3574.0
2022-07-15 04:00:00	NVDA	Stock	15.5	15.518	15.376	15.499	65260.0
2022-07-15 05:00:00	NVDA	Stock	15.498	15.51	15.473	15.486	25440.0
2022-07-15 06:00:00	NVDA	Stock	15.475	15.494	15.46	15.49	19030.0
2022-07-15 07:00:00	NVDA	Stock	15.499	15.579	15.48	15.5	355560.0
2022-07-15 08:00:00	NVDA	Stock	15.485	15.648	15.4001	15.61	2632270.0
2022-07-15 09:00:00	NVDA	Stock	15.61	15.743	15.445	15.547	62216040.0
2022-07-15 10:00:00	NVDA	Stock	15.567	15.7052	15.4744	15.589	56316650.0
2022-07-15 11:00:00	NVDA	Stock	15.5874	15.67	15.564	15.564	32497190.0
2022-07-15 12:00:00	NVDA	Stock	15.5649	15.5794	15.48	15.564	26051590.0
2022-07-15 13:00:00	NVDA	Stock	15.564	15.639	15.517	15.636	21926270.0
2022-07-15 14:00:00	NVDA	Stock	15.636	15.666	15.57	15.645	22898820.0
2022-07-15 15:00:00	NVDA	Stock	15.646	15.782	15.621	15.762	52052510.0
2022-07-15 16:00:00	NVDA	Stock	15.762	15.765	15.745	15.75	30366090.0
2022-07-15 17:00:00	NVDA	Stock	15.747	15.764	15.7374	15.76	322680.0
2022-07-15 18:00:00	NVDA	Stock	15.756	15.859	15.755	15.828	500020.0
2022-07-15 19:00:00	NVDA	Stock	15.828	15.85	15.817	15.817	276350.0
2022-07-15 04:00:00	AMZN	Stock	111.43	111.47	110.57	111.25	8442.0
2022-07-15 05:00:00	AMZN	Stock	111.26	111.26	110.87	111.0	6814.0

> showing 50 of 60,409 rows — these rows as CSV

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