PREVIEW / stock_30min / 2023-01-19

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-01-19.parquet
  size:    2.1 MB
  rows:    102,159
  symbols: 1,911

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
2023-01-19 04:00:00	AAPL	Stock	134.52	134.9	134.49	134.49	21294.0
2023-01-19 04:30:00	AAPL	Stock	134.55	134.55	134.31	134.4	12236.0
2023-01-19 05:00:00	AAPL	Stock	134.45	134.53	134.3	134.32	8172.0
2023-01-19 05:30:00	AAPL	Stock	134.31	134.36	134.22	134.31	10840.0
2023-01-19 06:00:00	AAPL	Stock	134.29	134.3	133.63	133.63	38755.0
2023-01-19 06:30:00	AAPL	Stock	133.65	133.8	133.63	133.79	11414.0
2023-01-19 07:00:00	AAPL	Stock	133.78	133.89	133.42	133.67	47549.0
2023-01-19 07:30:00	AAPL	Stock	133.7	133.75	133.38	133.52	35258.0
2023-01-19 08:00:00	AAPL	Stock	133.69	134.872	133.38	133.7	149936.0
2023-01-19 08:30:00	AAPL	Stock	133.73	133.9	133.22	133.82	152793.0
2023-01-19 09:00:00	AAPL	Stock	133.82	134.09	133.65	134.04	124758.0
2023-01-19 09:30:00	AAPL	Stock	134.09	135.325	133.86	135.06	6867717.0
2023-01-19 10:00:00	AAPL	Stock	135.05	135.0686	134.1714	134.47	4155158.0
2023-01-19 10:30:00	AAPL	Stock	134.477	134.68	133.77	134.0999	3267519.0
2023-01-19 11:00:00	AAPL	Stock	134.11	135.39	134.05	134.49	4514410.0
2023-01-19 11:30:00	AAPL	Stock	134.48	134.68	134.19	134.4	2509724.0
2023-01-19 12:00:00	AAPL	Stock	134.39	134.83	134.35	134.4409	2170519.0
2023-01-19 12:30:00	AAPL	Stock	134.4418	134.65	134.27	134.598	1624905.0
2023-01-19 13:00:00	AAPL	Stock	134.6	135.11	134.5873	134.75	2358664.0
2023-01-19 13:30:00	AAPL	Stock	134.76	135.55	134.76	135.28	2632190.0
2023-01-19 14:00:00	AAPL	Stock	135.27	136.05	135.06	135.885	2696933.0
2023-01-19 14:30:00	AAPL	Stock	135.88	136.25	135.67	135.925	2914472.0
2023-01-19 15:00:00	AAPL	Stock	135.94	136.05	135.51	135.7097	2748050.0
2023-01-19 15:30:00	AAPL	Stock	135.71	135.83	135.1	135.2822	5204233.0
2023-01-19 16:00:00	AAPL	Stock	135.27	136.0	135.26	135.65	6753109.0
2023-01-19 16:30:00	AAPL	Stock	135.56	135.79	135.27	135.72	32313.0
2023-01-19 17:00:00	AAPL	Stock	135.73	135.74	135.51	135.7	13798.0
2023-01-19 17:30:00	AAPL	Stock	135.6501	135.72	135.64	135.72	9296.0
2023-01-19 18:00:00	AAPL	Stock	135.78	135.86	135.42	135.62	22129.0
2023-01-19 18:30:00	AAPL	Stock	135.61	135.61	135.5	135.55	9667.0
2023-01-19 19:00:00	AAPL	Stock	135.56	135.56	135.16	135.3801	38119.0
2023-01-19 19:30:00	AAPL	Stock	135.45	135.55	135.35	135.55	14936.0
2023-01-19 04:00:00	MSFT	Stock	235.33	235.66	235.22	235.23	7603.0
2023-01-19 04:30:00	MSFT	Stock	235.39	235.4	234.94	234.99	7345.0
2023-01-19 05:00:00	MSFT	Stock	235.1	235.21	234.5	234.5	6274.0
2023-01-19 05:30:00	MSFT	Stock	234.41	234.47	233.82	234.47	5438.0
2023-01-19 06:00:00	MSFT	Stock	234.44	234.44	234.07	234.21	4100.0
2023-01-19 06:30:00	MSFT	Stock	234.15	234.19	233.8	234.15	8410.0
2023-01-19 07:00:00	MSFT	Stock	234.28	234.4	233.88	234.4	8044.0
2023-01-19 07:30:00	MSFT	Stock	234.25	234.62	233.88	234.05	15406.0
2023-01-19 08:00:00	MSFT	Stock	234.3	235.221	233.88	234.37	28175.0
2023-01-19 08:30:00	MSFT	Stock	234.04	234.44	233.32	234.32	22297.0
2023-01-19 09:00:00	MSFT	Stock	234.36	234.4	233.62	233.9	17951.0
2023-01-19 09:30:00	MSFT	Stock	233.78	235.52	231.94	232.8901	2906403.0
2023-01-19 10:00:00	MSFT	Stock	232.88	233.38	232.11	232.9134	1411265.0
2023-01-19 10:30:00	MSFT	Stock	232.9	232.97	230.83	231.1066	1546308.0
2023-01-19 11:00:00	MSFT	Stock	231.1	232.08	230.86	231.03	1340086.0
2023-01-19 11:30:00	MSFT	Stock	231.01	231.53	230.68	231.03	1049490.0
2023-01-19 12:00:00	MSFT	Stock	231.04	231.83	230.93	231.02	759222.0
2023-01-19 12:30:00	MSFT	Stock	231.02	231.67	230.93	231.6214	519390.0

> showing 50 of 102,159 rows — these rows as CSV

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