PREVIEW / stock_30min / 2021-08-05

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-08-05.parquet
  size:    2.2 MB
  rows:    110,140
  symbols: 2,823

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-05 04:00:00	AAPL	Stock	146.9	146.92	146.79	146.92	6495.0
2021-08-05 04:30:00	AAPL	Stock	146.93	146.93	146.8	146.83	4470.0
2021-08-05 05:00:00	AAPL	Stock	146.83	146.93	146.82	146.93	1102.0
2021-08-05 05:30:00	AAPL	Stock	146.95	147.06	146.95	147.06	2980.0
2021-08-05 06:00:00	AAPL	Stock	147.0	147.08	147.0	147.08	2085.0
2021-08-05 06:30:00	AAPL	Stock	147.02	147.02	146.98	147.01	667.0
2021-08-05 07:00:00	AAPL	Stock	147.03	147.19	147.01	147.16	18402.0
2021-08-05 07:30:00	AAPL	Stock	147.19	147.25	147.15	147.22	18405.0
2021-08-05 08:00:00	AAPL	Stock	147.0699	147.25	147.02	147.23	84551.0
2021-08-05 08:30:00	AAPL	Stock	147.23	147.4	147.13	147.1901	63174.0
2021-08-05 09:00:00	AAPL	Stock	147.19	147.24	146.84	146.98	119485.0
2021-08-05 09:30:00	AAPL	Stock	146.99	147.18	146.17	147.055	8192297.0
2021-08-05 10:00:00	AAPL	Stock	147.06	147.43	146.7906	147.36	4425894.0
2021-08-05 10:30:00	AAPL	Stock	147.3624	147.585	147.1602	147.49	2980900.0
2021-08-05 11:00:00	AAPL	Stock	147.4899	147.84	147.3	147.4701	2935408.0
2021-08-05 11:30:00	AAPL	Stock	147.48	147.63	147.3454	147.46	1982751.0
2021-08-05 12:00:00	AAPL	Stock	147.465	147.545	147.24	147.285	1871722.0
2021-08-05 12:30:00	AAPL	Stock	147.291	147.4	147.17	147.2576	1484908.0
2021-08-05 13:00:00	AAPL	Stock	147.25	147.265	147.11	147.2276	1263669.0
2021-08-05 13:30:00	AAPL	Stock	147.23	147.38	147.15	147.353	1235058.0
2021-08-05 14:00:00	AAPL	Stock	147.36	147.46	147.2201	147.225	1582930.0
2021-08-05 14:30:00	AAPL	Stock	147.22	147.26	147.0419	147.0545	1899405.0
2021-08-05 15:00:00	AAPL	Stock	147.055	147.19	146.8299	146.85	2158941.0
2021-08-05 15:30:00	AAPL	Stock	146.8403	147.11	146.73	147.06	4442100.0
2021-08-05 16:00:00	AAPL	Stock	147.06	147.1	146.92	147.0	3371953.0
2021-08-05 16:30:00	AAPL	Stock	146.97	147.01	146.92	146.96	19908.0
2021-08-05 17:00:00	AAPL	Stock	146.95	147.06	146.92	146.92	27149.0
2021-08-05 17:30:00	AAPL	Stock	146.94	146.98	146.92	146.94	8640.0
2021-08-05 18:00:00	AAPL	Stock	146.93	146.96	146.92	146.94	4120.0
2021-08-05 18:30:00	AAPL	Stock	146.97	146.97	146.9001	146.91	16260.0
2021-08-05 19:00:00	AAPL	Stock	146.92	146.94	146.86	146.88	8568.0
2021-08-05 19:30:00	AAPL	Stock	146.91	146.96	146.88	146.9	19611.0
2021-08-05 04:00:00	MSFT	Stock	287.14	287.14	286.5	286.5	330.0
2021-08-05 04:30:00	MSFT	Stock	286.5	286.5	286.5	286.5	103.0
2021-08-05 05:00:00	MSFT	Stock	286.15	286.51	286.15	286.51	638.0
2021-08-05 05:30:00	MSFT	Stock	286.51	286.51	286.42	286.42	407.0
2021-08-05 06:00:00	MSFT	Stock	286.75	286.95	286.75	286.86	370.0
2021-08-05 06:30:00	MSFT	Stock	287.0	287.0	287.0	287.0	100.0
2021-08-05 07:00:00	MSFT	Stock	287.0	287.0	286.66	287.0	3716.0
2021-08-05 07:30:00	MSFT	Stock	286.95	287.25	286.9	287.15	4265.0
2021-08-05 08:00:00	MSFT	Stock	286.955	287.2001	286.68	286.85	6740.0
2021-08-05 08:30:00	MSFT	Stock	286.7	286.8	286.6001	286.73	7619.0
2021-08-05 09:00:00	MSFT	Stock	286.79	287.36	286.6	286.73	8247.0
2021-08-05 09:30:00	MSFT	Stock	286.87	287.8299	286.1	287.7239	1347965.0
2021-08-05 10:00:00	MSFT	Stock	287.7	288.28	287.57	288.2	1012059.0
2021-08-05 10:30:00	MSFT	Stock	288.22	288.61	287.87	288.4465	662384.0
2021-08-05 11:00:00	MSFT	Stock	288.4584	288.82	288.0	288.14	742418.0
2021-08-05 11:30:00	MSFT	Stock	288.16	288.43	288.02	288.2	546738.0
2021-08-05 12:00:00	MSFT	Stock	288.21	288.29	287.95	288.265	449351.0
2021-08-05 12:30:00	MSFT	Stock	288.25	288.49	288.07	288.12	395219.0

> showing 50 of 110,140 rows — these rows as CSV

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