PREVIEW / stock_30min / 2022-05-18

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-05-18.parquet
  size:    2.1 MB
  rows:    107,311
  symbols: 2,415

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-18 04:00:00	AAPL	Stock	148.79	148.85	148.2	148.39	12181.0
2022-05-18 04:30:00	AAPL	Stock	148.24	148.24	148.12	148.18	1329.0
2022-05-18 05:00:00	AAPL	Stock	148.39	148.43	148.28	148.31	4846.0
2022-05-18 05:30:00	AAPL	Stock	148.31	148.64	148.31	148.52	6133.0
2022-05-18 06:00:00	AAPL	Stock	148.7	148.78	148.58	148.76	6748.0
2022-05-18 06:30:00	AAPL	Stock	148.59	148.59	148.01	148.3	24011.0
2022-05-18 07:00:00	AAPL	Stock	148.34	148.39	147.38	147.42	78908.0
2022-05-18 07:30:00	AAPL	Stock	147.43	147.69	147.38	147.55	33799.0
2022-05-18 08:00:00	AAPL	Stock	148.27	149.19	147.4	147.85	325798.0
2022-05-18 08:30:00	AAPL	Stock	147.7999	147.7999	146.75	146.7901	260472.0
2022-05-18 09:00:00	AAPL	Stock	146.87	146.99	146.61	146.8	275771.0
2022-05-18 09:30:00	AAPL	Stock	146.86	147.3601	145.78	145.9026	8557279.0
2022-05-18 10:00:00	AAPL	Stock	145.905	146.6	145.59	145.6	5917151.0
2022-05-18 10:30:00	AAPL	Stock	145.6	145.69	144.8201	145.42	5209866.0
2022-05-18 11:00:00	AAPL	Stock	145.415	145.42	143.37	143.449	6065767.0
2022-05-18 11:30:00	AAPL	Stock	143.435	144.14	142.76	142.76	5625066.0
2022-05-18 12:00:00	AAPL	Stock	142.775	143.05	142.14	142.52	4967408.0
2022-05-18 12:30:00	AAPL	Stock	142.52	143.69	142.3313	143.5501	4828665.0
2022-05-18 13:00:00	AAPL	Stock	143.55	143.564	141.94	142.035	4058686.0
2022-05-18 13:30:00	AAPL	Stock	142.03	142.37	141.36	141.73	5044695.0
2022-05-18 14:00:00	AAPL	Stock	141.72	141.94	141.08	141.17	4639836.0
2022-05-18 14:30:00	AAPL	Stock	141.16	141.33	139.9	140.0917	7325042.0
2022-05-18 15:00:00	AAPL	Stock	140.1017	140.84	140.07	140.56	5880762.0
2022-05-18 15:30:00	AAPL	Stock	140.57	141.2	140.21	140.82	12990570.0
2022-05-18 16:00:00	AAPL	Stock	140.83	141.16	140.18	140.6	12548157.0
2022-05-18 16:30:00	AAPL	Stock	140.57	140.92	140.44	140.88	196412.0
2022-05-18 17:00:00	AAPL	Stock	140.88	140.92	140.65	140.75	53410.0
2022-05-18 17:30:00	AAPL	Stock	140.78	140.95	140.71	140.87	40900.0
2022-05-18 18:00:00	AAPL	Stock	140.83	141.19	140.8	140.84	74560.0
2022-05-18 18:30:00	AAPL	Stock	140.9	141.2	140.85	141.2	49985.0
2022-05-18 19:00:00	AAPL	Stock	141.11	141.12	140.6	140.64	49788.0
2022-05-18 19:30:00	AAPL	Stock	140.64	140.79	140.0	140.2	167935.0
2022-05-18 04:00:00	MSFT	Stock	264.59	265.3	264.59	265.0	15889.0
2022-05-18 04:30:00	MSFT	Stock	264.75	264.75	264.61	264.62	678.0
2022-05-18 05:00:00	MSFT	Stock	265.15	265.15	265.13	265.13	400.0
2022-05-18 05:30:00	MSFT	Stock	265.09	265.42	265.06	265.06	1255.0
2022-05-18 06:00:00	MSFT	Stock	265.5	265.5	265.38	265.49	3047.0
2022-05-18 06:30:00	MSFT	Stock	265.04	265.1	264.93	265.1	1600.0
2022-05-18 07:00:00	MSFT	Stock	265.4	265.4	263.92	264.15	13539.0
2022-05-18 07:30:00	MSFT	Stock	264.2	264.5	264.0	264.06	4485.0
2022-05-18 08:00:00	MSFT	Stock	265.1086	266.06	263.86	264.42	23668.0
2022-05-18 08:30:00	MSFT	Stock	264.45	264.52	263.3	263.411	23511.0
2022-05-18 09:00:00	MSFT	Stock	263.409	263.99	263.0	263.0	42675.0
2022-05-18 09:30:00	MSFT	Stock	263.0	263.6	261.09	261.262	1759602.0
2022-05-18 10:00:00	MSFT	Stock	261.265	262.27	260.57	260.64	1437546.0
2022-05-18 10:30:00	MSFT	Stock	260.6362	260.7199	259.7705	260.3	934398.0
2022-05-18 11:00:00	MSFT	Stock	260.25	260.25	257.21	257.43	955909.0
2022-05-18 11:30:00	MSFT	Stock	257.47	257.86	256.82	256.87	978223.0
2022-05-18 12:00:00	MSFT	Stock	256.88	257.79	256.4	257.15	1037134.0
2022-05-18 12:30:00	MSFT	Stock	257.13	257.96	256.82	257.85	629075.0

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

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