PREVIEW / stock_30min / 2021-09-27

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-09-27.parquet
  size:    2.2 MB
  rows:    111,002
  symbols: 2,728

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-09-27 04:00:00	AAPL	Stock	147.0	147.28	146.99	147.15	8179.0
2021-09-27 04:30:00	AAPL	Stock	147.1	147.13	146.92	146.99	5282.0
2021-09-27 05:00:00	AAPL	Stock	146.98	147.03	146.87	146.87	10345.0
2021-09-27 05:30:00	AAPL	Stock	146.87	146.87	146.27	146.34	15095.0
2021-09-27 06:00:00	AAPL	Stock	146.3	146.5	146.21	146.35	9753.0
2021-09-27 06:30:00	AAPL	Stock	146.35	146.35	145.75	145.85	35653.0
2021-09-27 07:00:00	AAPL	Stock	145.97	146.2	145.84	145.9	117845.0
2021-09-27 07:30:00	AAPL	Stock	145.93	146.13	145.85	146.05	77100.0
2021-09-27 08:00:00	AAPL	Stock	146.1899	146.25	145.5	145.7	462406.0
2021-09-27 08:30:00	AAPL	Stock	145.75	145.93	145.4	145.72	321905.0
2021-09-27 09:00:00	AAPL	Stock	145.72	145.72	145.2	145.48	438389.0
2021-09-27 09:30:00	AAPL	Stock	145.48	145.96	143.82	144.319	12544814.0
2021-09-27 10:00:00	AAPL	Stock	144.33	145.58	144.21	145.575	6884721.0
2021-09-27 10:30:00	AAPL	Stock	145.57	145.655	145.22	145.255	4432137.0
2021-09-27 11:00:00	AAPL	Stock	145.2537	145.5955	144.91	144.9298	3587403.0
2021-09-27 11:30:00	AAPL	Stock	144.93	145.11	144.53	144.8	4122366.0
2021-09-27 12:00:00	AAPL	Stock	144.79	145.14	144.09	145.09	2873505.0
2021-09-27 12:30:00	AAPL	Stock	145.08	145.21	144.86	145.1	2802419.0
2021-09-27 13:00:00	AAPL	Stock	145.09	145.54	145.035	145.46	2440000.0
2021-09-27 13:30:00	AAPL	Stock	145.46	145.53	145.2	145.515	1989652.0
2021-09-27 14:00:00	AAPL	Stock	145.52	145.73	145.44	145.71	2273193.0
2021-09-27 14:30:00	AAPL	Stock	145.71	145.76	145.4441	145.54	2365638.0
2021-09-27 15:00:00	AAPL	Stock	145.5457	145.77	145.39	145.56	3192327.0
2021-09-27 15:30:00	AAPL	Stock	145.56	145.76	145.2	145.38	6005939.0
2021-09-27 16:00:00	AAPL	Stock	145.4	145.44	145.21	145.26	7521398.0
2021-09-27 16:30:00	AAPL	Stock	145.26	145.37	145.22	145.24	218074.0
2021-09-27 17:00:00	AAPL	Stock	145.27	145.27	145.1	145.13	53153.0
2021-09-27 17:30:00	AAPL	Stock	145.11	145.14	145.0	145.04	56619.0
2021-09-27 18:00:00	AAPL	Stock	145.03	145.1	145.0	145.05	55608.0
2021-09-27 18:30:00	AAPL	Stock	145.08	145.09	144.92	144.96	36725.0
2021-09-27 19:00:00	AAPL	Stock	144.97	145.0	144.94	144.97	7776.0
2021-09-27 19:30:00	AAPL	Stock	144.95	145.05	144.95	145.0	26749.0
2021-09-27 04:00:00	MSFT	Stock	300.0	300.0	299.38	299.38	862.0
2021-09-27 04:30:00	MSFT	Stock	299.35	299.35	299.35	299.35	100.0
2021-09-27 05:00:00	MSFT	Stock	299.5	299.8	299.43	299.43	954.0
2021-09-27 05:30:00	MSFT	Stock	299.3	299.64	298.82	298.82	3512.0
2021-09-27 06:00:00	MSFT	Stock	298.34	298.51	298.28	298.51	437.0
2021-09-27 06:30:00	MSFT	Stock	298.37	298.6	297.31	297.45	5897.0
2021-09-27 07:00:00	MSFT	Stock	297.7	297.86	297.05	297.75	23570.0
2021-09-27 07:30:00	MSFT	Stock	297.75	297.87	297.75	297.75	28125.0
2021-09-27 08:00:00	MSFT	Stock	297.22	300.098	296.84	297.0212	41319.0
2021-09-27 08:30:00	MSFT	Stock	297.01	297.33	296.18	297.11	24433.0
2021-09-27 09:00:00	MSFT	Stock	297.02	297.0854	296.0	296.18	70036.0
2021-09-27 09:30:00	MSFT	Stock	296.18	296.47	293.6	294.28	3062538.0
2021-09-27 10:00:00	MSFT	Stock	294.28	296.0	293.72	295.945	1600145.0
2021-09-27 10:30:00	MSFT	Stock	295.93	296.22	295.21	295.21	866858.0
2021-09-27 11:00:00	MSFT	Stock	295.21	296.09	294.58	294.63	1193928.0
2021-09-27 11:30:00	MSFT	Stock	294.64	294.72	293.23	293.64	1073488.0
2021-09-27 12:00:00	MSFT	Stock	293.62	293.95	293.32	293.77	625348.0
2021-09-27 12:30:00	MSFT	Stock	293.74	293.79	292.9449	293.26	781018.0

> showing 50 of 111,002 rows — these rows as CSV

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