PREVIEW / stock_30min / 2022-05-13

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-05-13.parquet
  size:    2.2 MB
  rows:    107,949
  symbols: 2,480

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-05-13 04:00:00	AAPL	Stock	144.5	145.69	144.5	145.5	60104.0
2022-05-13 04:30:00	AAPL	Stock	145.46	145.46	144.8	144.94	19645.0
2022-05-13 05:00:00	AAPL	Stock	145.02	145.35	145.02	145.06	18128.0
2022-05-13 05:30:00	AAPL	Stock	145.06	145.13	144.7	145.0	21151.0
2022-05-13 06:00:00	AAPL	Stock	144.87	144.95	144.71	144.84	6625.0
2022-05-13 06:30:00	AAPL	Stock	144.91	145.3	144.9	145.06	33901.0
2022-05-13 07:00:00	AAPL	Stock	145.18	145.2	144.56	144.61	139140.0
2022-05-13 07:30:00	AAPL	Stock	144.65	145.71	144.6	145.55	109861.0
2022-05-13 08:00:00	AAPL	Stock	144.8501	145.7788	142.56	145.12	494436.0
2022-05-13 08:30:00	AAPL	Stock	145.12	145.35	144.98	145.0	183540.0
2022-05-13 09:00:00	AAPL	Stock	145.0	145.26	144.45	144.65	363003.0
2022-05-13 09:30:00	AAPL	Stock	144.66	145.26	143.11	144.9844	14028732.0
2022-05-13 10:00:00	AAPL	Stock	144.99	146.39	144.98	146.16	9428179.0
2022-05-13 10:30:00	AAPL	Stock	146.165	146.92	145.62	146.86	6843830.0
2022-05-13 11:00:00	AAPL	Stock	146.87	147.77	146.56	147.6454	7329726.0
2022-05-13 11:30:00	AAPL	Stock	147.65	147.84	146.8	147.0391	4831398.0
2022-05-13 12:00:00	AAPL	Stock	147.06	148.105	146.9	147.415	5044984.0
2022-05-13 12:30:00	AAPL	Stock	147.42	148.06	146.81	147.255	5041485.0
2022-05-13 13:00:00	AAPL	Stock	147.2572	147.48	146.6	146.825	3626356.0
2022-05-13 13:30:00	AAPL	Stock	146.83	147.02	146.0	146.215	4178704.0
2022-05-13 14:00:00	AAPL	Stock	146.2	146.2	144.8	145.49	6358787.0
2022-05-13 14:30:00	AAPL	Stock	145.48	146.93	145.4722	146.86	5452756.0
2022-05-13 15:00:00	AAPL	Stock	146.8784	147.7	146.66	147.67	5525651.0
2022-05-13 15:30:00	AAPL	Stock	147.67	147.81	145.92	147.13	11182938.0
2022-05-13 16:00:00	AAPL	Stock	147.15	147.15	146.69	146.92	9489956.0
2022-05-13 16:30:00	AAPL	Stock	146.93	147.11	146.6421	146.71	227736.0
2022-05-13 17:00:00	AAPL	Stock	146.73	147.08	146.69	147.04	69435.0
2022-05-13 17:30:00	AAPL	Stock	147.06	147.27	147.0405	147.2089	53540.0
2022-05-13 18:00:00	AAPL	Stock	147.2	147.2	147.02	147.06	48539.0
2022-05-13 18:30:00	AAPL	Stock	147.08	147.29	147.0	147.26	40184.0
2022-05-13 19:00:00	AAPL	Stock	147.27	147.3	147.18	147.28	21109.0
2022-05-13 19:30:00	AAPL	Stock	147.28	147.3	147.23	147.28	75715.0
2022-05-13 04:00:00	MSFT	Stock	257.8	260.24	257.8	260.0	7979.0
2022-05-13 04:30:00	MSFT	Stock	260.0	260.08	259.64	259.64	968.0
2022-05-13 05:00:00	MSFT	Stock	259.8	260.19	259.8	260.15	4758.0
2022-05-13 05:30:00	MSFT	Stock	259.51	260.26	259.51	259.61	4507.0
2022-05-13 06:00:00	MSFT	Stock	259.85	260.03	259.52	260.03	6896.0
2022-05-13 06:30:00	MSFT	Stock	260.01	260.15	259.83	260.05	8681.0
2022-05-13 07:00:00	MSFT	Stock	259.9	260.0	259.6	259.75	18014.0
2022-05-13 07:30:00	MSFT	Stock	259.55	260.25	259.5	260.23	51858.0
2022-05-13 08:00:00	MSFT	Stock	259.9999	260.25	259.28	259.5	70247.0
2022-05-13 08:30:00	MSFT	Stock	259.69	259.97	259.5	259.78	31630.0
2022-05-13 09:00:00	MSFT	Stock	259.5	259.9	257.0	257.12	49039.0
2022-05-13 09:30:00	MSFT	Stock	257.35	260.51	255.35	259.45	3412753.0
2022-05-13 10:00:00	MSFT	Stock	259.475	262.09	259.05	261.28	2394103.0
2022-05-13 10:30:00	MSFT	Stock	261.3	261.58	260.27	260.78	1297865.0
2022-05-13 11:00:00	MSFT	Stock	260.77	261.38	259.67	261.2301	1221639.0
2022-05-13 11:30:00	MSFT	Stock	261.23	261.915	260.71	261.31	977297.0
2022-05-13 12:00:00	MSFT	Stock	261.3	262.38	261.11	261.81	981440.0
2022-05-13 12:30:00	MSFT	Stock	261.84	263.04	261.3102	261.5699	1301499.0

> showing 50 of 107,949 rows — these rows as CSV

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