PREVIEW / stock_30min / 2022-07-05

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-07-05.parquet
  size:    2.1 MB
  rows:    105,957
  symbols: 2,373

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-07-05 04:00:00	AAPL	Stock	139.02	140.22	138.38	138.38	26686.0
2022-07-05 04:30:00	AAPL	Stock	138.28	138.47	137.83	138.03	17858.0
2022-07-05 05:00:00	AAPL	Stock	138.15	138.15	137.85	138.0	7273.0
2022-07-05 05:30:00	AAPL	Stock	138.1	138.17	137.85	138.17	8298.0
2022-07-05 06:00:00	AAPL	Stock	138.2	138.43	138.18	138.38	9348.0
2022-07-05 06:30:00	AAPL	Stock	138.28	138.55	138.2	138.45	6990.0
2022-07-05 07:00:00	AAPL	Stock	138.41	138.55	138.2	138.31	70612.0
2022-07-05 07:30:00	AAPL	Stock	138.31	138.39	137.88	137.89	47257.0
2022-07-05 08:00:00	AAPL	Stock	138.43	138.54	137.28	137.4	215620.0
2022-07-05 08:30:00	AAPL	Stock	137.36	137.67	137.2	137.3001	140148.0
2022-07-05 09:00:00	AAPL	Stock	137.27	137.79	137.22	137.77	158847.0
2022-07-05 09:30:00	AAPL	Stock	137.78	138.84	136.93	138.22	8585665.0
2022-07-05 10:00:00	AAPL	Stock	138.21	139.1099	137.8166	138.7	5531078.0
2022-07-05 10:30:00	AAPL	Stock	138.715	139.66	138.38	138.9	3742789.0
2022-07-05 11:00:00	AAPL	Stock	138.88	138.885	138.17	138.39	2934566.0
2022-07-05 11:30:00	AAPL	Stock	138.3646	139.73	138.25	139.331	3666952.0
2022-07-05 12:00:00	AAPL	Stock	139.33	139.99	139.01	139.85	3259329.0
2022-07-05 12:30:00	AAPL	Stock	139.86	140.03	138.94	138.965	2917633.0
2022-07-05 13:00:00	AAPL	Stock	138.97	139.911	138.87	139.84	2744633.0
2022-07-05 13:30:00	AAPL	Stock	139.83	140.179	139.64	140.05	2814632.0
2022-07-05 14:00:00	AAPL	Stock	140.0504	140.685	139.885	140.6	2731951.0
2022-07-05 14:30:00	AAPL	Stock	140.605	141.44	140.6	140.92	3904684.0
2022-07-05 15:00:00	AAPL	Stock	140.92	141.42	140.55	141.23	4023095.0
2022-07-05 15:30:00	AAPL	Stock	141.23	141.61	141.05	141.59	6564833.0
2022-07-05 16:00:00	AAPL	Stock	141.59	141.69	141.4	141.52	8086832.0
2022-07-05 16:30:00	AAPL	Stock	141.51	141.64	141.42	141.51	27470.0
2022-07-05 17:00:00	AAPL	Stock	141.58	141.58	141.45	141.5	21661.0
2022-07-05 17:30:00	AAPL	Stock	141.53	141.6	141.49	141.55	18977.0
2022-07-05 18:00:00	AAPL	Stock	141.58	141.78	141.55	141.61	13886.0
2022-07-05 18:30:00	AAPL	Stock	141.69	141.71	141.6	141.61	9531.0
2022-07-05 19:00:00	AAPL	Stock	141.61	141.66	141.58	141.59	11660.0
2022-07-05 19:30:00	AAPL	Stock	141.59	141.59	141.32	141.37	28507.0
2022-07-05 04:00:00	MSFT	Stock	260.04	260.39	258.38	258.38	2454.0
2022-07-05 04:30:00	MSFT	Stock	258.06	258.14	257.74	257.74	459.0
2022-07-05 05:00:00	MSFT	Stock	257.5	257.5	257.27	257.27	650.0
2022-07-05 05:30:00	MSFT	Stock	258.0	258.0	257.5	257.5	300.0
2022-07-05 06:00:00	MSFT	Stock	258.29	258.29	258.28	258.29	2000.0
2022-07-05 06:30:00	MSFT	Stock	258.0	258.73	258.0	258.55	500.0
2022-07-05 07:00:00	MSFT	Stock	258.59	258.72	257.66	257.67	6612.0
2022-07-05 07:30:00	MSFT	Stock	257.65	257.8	257.01	257.03	6655.0
2022-07-05 08:00:00	MSFT	Stock	258.48	258.932	256.12	256.6001	35806.0
2022-07-05 08:30:00	MSFT	Stock	256.65	257.0	255.58	255.58	42163.0
2022-07-05 09:00:00	MSFT	Stock	255.98	256.79	255.6	256.03	19099.0
2022-07-05 09:30:00	MSFT	Stock	256.16	256.8755	254.74	256.19	2013622.0
2022-07-05 10:00:00	MSFT	Stock	256.09	257.78	255.56	256.86	1147740.0
2022-07-05 10:30:00	MSFT	Stock	256.81	258.78	256.41	257.23	786667.0
2022-07-05 11:00:00	MSFT	Stock	257.21	257.21	255.95	256.4	488996.0
2022-07-05 11:30:00	MSFT	Stock	256.41	258.1	256.19	257.39	700705.0
2022-07-05 12:00:00	MSFT	Stock	257.38	258.45	256.56	258.25	756665.0
2022-07-05 12:30:00	MSFT	Stock	258.2801	258.55	257.49	257.575	525649.0

> showing 50 of 105,957 rows — these rows as CSV

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