PREVIEW / stock_1hour / 2021-08-12

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-08-12.parquet
  size:    1.4 MB
  rows:    64,640
  symbols: 2,813

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-12 04:00:00	AAPL	Stock	145.61	145.84	145.5	145.84	4538.0
2021-08-12 05:00:00	AAPL	Stock	145.75	145.82	145.75	145.76	2533.0
2021-08-12 06:00:00	AAPL	Stock	145.74	145.92	145.72	145.91	2465.0
2021-08-12 07:00:00	AAPL	Stock	145.9	146.1	145.85	146.04	44360.0
2021-08-12 08:00:00	AAPL	Stock	146.0495	146.1	145.496	145.6	194762.0
2021-08-12 09:00:00	AAPL	Stock	145.61	147.43	145.57	147.06	10753128.0
2021-08-12 10:00:00	AAPL	Stock	147.07	148.25	146.58	148.17	13044972.0
2021-08-12 11:00:00	AAPL	Stock	148.17	148.53	148.02	148.0398	8005718.0
2021-08-12 12:00:00	AAPL	Stock	148.0399	148.44	147.7	148.3003	6015798.0
2021-08-12 13:00:00	AAPL	Stock	148.3	148.45	148.065	148.335	4567862.0
2021-08-12 14:00:00	AAPL	Stock	148.3397	148.85	148.22	148.705	5863442.0
2021-08-12 15:00:00	AAPL	Stock	148.71	149.05	148.57	148.885	10319693.0
2021-08-12 16:00:00	AAPL	Stock	148.89	149.02	148.88	148.99	6154994.0
2021-08-12 17:00:00	AAPL	Stock	148.99	149.02	148.86	148.94	52448.0
2021-08-12 18:00:00	AAPL	Stock	148.9399	148.95	148.82	148.9001	33777.0
2021-08-12 19:00:00	AAPL	Stock	148.91	148.98	148.89	148.98	49182.0
2021-08-12 04:00:00	MSFT	Stock	286.38	286.38	286.32	286.32	400.0
2021-08-12 05:00:00	MSFT	Stock	286.22	286.41	286.22	286.41	770.0
2021-08-12 06:00:00	MSFT	Stock	286.47	286.85	286.47	286.85	1541.0
2021-08-12 07:00:00	MSFT	Stock	286.86	287.2	286.86	287.2	3626.0
2021-08-12 08:00:00	MSFT	Stock	286.86	287.2	286.2	286.42	23594.0
2021-08-12 09:00:00	MSFT	Stock	286.35	288.08	286.2	287.68	1307352.0
2021-08-12 10:00:00	MSFT	Stock	287.67	289.74	286.95	289.52	1877907.0
2021-08-12 11:00:00	MSFT	Stock	289.5	289.6	289.0442	289.0442	1061197.0
2021-08-12 12:00:00	MSFT	Stock	289.04	289.15	288.73	288.94	736772.0
2021-08-12 13:00:00	MSFT	Stock	288.945	289.6	288.785	289.46	831355.0
2021-08-12 14:00:00	MSFT	Stock	289.47	289.83	289.4226	289.72	871146.0
2021-08-12 15:00:00	MSFT	Stock	289.72	289.97	289.445	289.65	1811911.0
2021-08-12 16:00:00	MSFT	Stock	289.81	289.81	289.53	289.73	2996606.0
2021-08-12 17:00:00	MSFT	Stock	289.76	289.8	289.66	289.7889	10177.0
2021-08-12 18:00:00	MSFT	Stock	289.66	289.77	289.65	289.72	5927.0
2021-08-12 19:00:00	MSFT	Stock	289.69	289.71	289.68	289.71	1646.0
2021-08-12 04:00:00	NVDA	Stock	19.7	19.7	19.534	19.63	18930.0
2021-08-12 05:00:00	NVDA	Stock	19.65	19.73	19.65	19.73	21530.0
2021-08-12 06:00:00	NVDA	Stock	19.75	19.859	19.739	19.859	63230.0
2021-08-12 07:00:00	NVDA	Stock	19.801	19.849	19.75	19.809	319800.0
2021-08-12 08:00:00	NVDA	Stock	19.76	19.874	19.661	19.725	799470.0
2021-08-12 09:00:00	NVDA	Stock	19.722	19.885	19.675	19.7424	18327150.0
2021-08-12 10:00:00	NVDA	Stock	19.736	19.898	19.62	19.851	21395950.0
2021-08-12 11:00:00	NVDA	Stock	19.849	20.029	19.788	19.969	19424630.0
2021-08-12 12:00:00	NVDA	Stock	19.971	19.971	19.818	19.9105	13818970.0
2021-08-12 13:00:00	NVDA	Stock	19.912	19.959	19.855	19.914	9215910.0
2021-08-12 14:00:00	NVDA	Stock	19.916	19.995	19.908	19.9838	7882360.0
2021-08-12 15:00:00	NVDA	Stock	19.985	20.015	19.873	19.902	15602660.0
2021-08-12 16:00:00	NVDA	Stock	19.905	19.92	19.86	19.89	10002610.0
2021-08-12 17:00:00	NVDA	Stock	19.8905	19.905	19.87	19.897	125370.0
2021-08-12 18:00:00	NVDA	Stock	19.887	19.894	19.88	19.88	48430.0
2021-08-12 19:00:00	NVDA	Stock	19.893	19.915	19.88	19.91	106370.0
2021-08-12 04:00:00	AMZN	Stock	164.7055	164.9555	164.7055	164.9555	4120.0
2021-08-12 05:00:00	AMZN	Stock	165.0	165.0	165.0	165.0	2000.0

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

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