PREVIEW / stock_30min / 2023-09-14

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-09-14.parquet
  size:    2.0 MB
  rows:    97,790
  symbols: 1,424

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-09-14 04:00:00	AAPL	Stock	174.58	174.78	174.22	174.51	14037.0
2023-09-14 04:30:00	AAPL	Stock	174.55	174.9	174.55	174.7	5386.0
2023-09-14 05:00:00	AAPL	Stock	174.7	174.85	174.65	174.73	1807.0
2023-09-14 05:30:00	AAPL	Stock	174.8	174.8	174.69	174.72	4818.0
2023-09-14 06:00:00	AAPL	Stock	174.74	175.02	174.72	175.02	7593.0
2023-09-14 06:30:00	AAPL	Stock	174.96	175.19	174.96	175.0	13161.0
2023-09-14 07:00:00	AAPL	Stock	174.97	175.02	174.65	174.65	152404.0
2023-09-14 07:30:00	AAPL	Stock	174.64	174.78	174.4	174.55	31974.0
2023-09-14 08:00:00	AAPL	Stock	174.88	175.14	174.38	174.72	261186.0
2023-09-14 08:30:00	AAPL	Stock	174.71	174.74	174.1	174.44	208599.0
2023-09-14 09:00:00	AAPL	Stock	174.41	174.88	174.0	174.01	314445.0
2023-09-14 09:30:00	AAPL	Stock	174.0	175.63	173.58	175.37	8200168.0
2023-09-14 10:00:00	AAPL	Stock	175.4	175.46	174.31	174.81	4062141.0
2023-09-14 10:30:00	AAPL	Stock	174.81	175.57	174.81	175.22	4073879.0
2023-09-14 11:00:00	AAPL	Stock	175.225	175.76	175.21	175.39	2873038.0
2023-09-14 11:30:00	AAPL	Stock	175.39	175.56	174.83	175.5	2333821.0
2023-09-14 12:00:00	AAPL	Stock	175.5	176.0	175.27	175.52	2418966.0
2023-09-14 12:30:00	AAPL	Stock	175.51	175.97	175.02	175.87	2539380.0
2023-09-14 13:00:00	AAPL	Stock	175.8759	175.93	175.46	175.7946	1721076.0
2023-09-14 13:30:00	AAPL	Stock	175.8	176.04	175.71	175.745	1992054.0
2023-09-14 14:00:00	AAPL	Stock	175.74	175.9	175.3	175.37	2096737.0
2023-09-14 14:30:00	AAPL	Stock	175.365	175.8	175.31	175.725	1956965.0
2023-09-14 15:00:00	AAPL	Stock	175.73	176.1	175.64	175.67	2375263.0
2023-09-14 15:30:00	AAPL	Stock	175.67	175.86	175.56	175.73	4586220.0
2023-09-14 16:00:00	AAPL	Stock	175.72	175.79	175.54	175.78	6813874.0
2023-09-14 16:30:00	AAPL	Stock	175.77	175.88	175.61	175.61	120660.0
2023-09-14 17:00:00	AAPL	Stock	175.66	175.66	175.47	175.65	47050.0
2023-09-14 17:30:00	AAPL	Stock	175.7125	175.7125	175.62	175.65	18966.0
2023-09-14 18:00:00	AAPL	Stock	175.65	175.78	175.61	175.71	18763.0
2023-09-14 18:30:00	AAPL	Stock	175.7499	175.81	175.68	175.8	20283.0
2023-09-14 19:00:00	AAPL	Stock	175.77	175.89	175.7	175.86	12799.0
2023-09-14 19:30:00	AAPL	Stock	175.84	175.93	175.8	175.86	12462.0
2023-09-14 04:00:00	MSFT	Stock	336.92	336.92	336.5	336.65	3145.0
2023-09-14 04:30:00	MSFT	Stock	336.41	336.41	336.41	336.41	200.0
2023-09-14 05:00:00	MSFT	Stock	336.62	336.79	336.62	336.79	350.0
2023-09-14 06:00:00	MSFT	Stock	336.58	337.56	336.58	337.56	2589.0
2023-09-14 06:30:00	MSFT	Stock	337.55	337.9	337.55	337.76	2529.0
2023-09-14 07:00:00	MSFT	Stock	337.65	338.51	337.5	337.53	11628.0
2023-09-14 07:30:00	MSFT	Stock	337.83	338.28	337.74	338.28	15066.0
2023-09-14 08:00:00	MSFT	Stock	338.1908	338.55	336.75	338.1	34285.0
2023-09-14 08:30:00	MSFT	Stock	338.3	338.5	336.85	338.15	51525.0
2023-09-14 09:00:00	MSFT	Stock	337.75	339.6	337.75	339.25	81420.0
2023-09-14 09:30:00	MSFT	Stock	339.0	340.4699	336.57	337.74	2255992.0
2023-09-14 10:00:00	MSFT	Stock	337.755	337.94	336.62	337.8255	740008.0
2023-09-14 10:30:00	MSFT	Stock	337.89	340.03	337.74	339.84	912855.0
2023-09-14 11:00:00	MSFT	Stock	339.86	340.86	339.6601	339.75	978016.0
2023-09-14 11:30:00	MSFT	Stock	339.73	340.25	338.395	340.19	693928.0
2023-09-14 12:00:00	MSFT	Stock	340.2046	340.71	339.6	339.98	618446.0
2023-09-14 12:30:00	MSFT	Stock	339.975	340.2761	339.428	340.15	509401.0
2023-09-14 13:00:00	MSFT	Stock	340.16	340.16	339.23	339.34	318136.0

> showing 50 of 97,790 rows — these rows as CSV

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