PREVIEW / stock_30min / 2023-05-23

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-05-23.parquet
  size:    2.1 MB
  rows:    101,499
  symbols: 1,652

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-05-23 04:00:00	AAPL	Stock	174.55	174.56	174.1	174.12	6766.0
2023-05-23 04:30:00	AAPL	Stock	174.12	174.21	174.12	174.2	2593.0
2023-05-23 05:00:00	AAPL	Stock	174.18	174.21	174.02	174.11	3165.0
2023-05-23 05:30:00	AAPL	Stock	174.07	174.07	173.8	173.91	8377.0
2023-05-23 06:00:00	AAPL	Stock	173.91	174.01	173.91	173.91	2063.0
2023-05-23 06:30:00	AAPL	Stock	173.95	174.01	173.89	173.96	6452.0
2023-05-23 07:00:00	AAPL	Stock	173.99	174.2	173.86	173.97	25515.0
2023-05-23 07:30:00	AAPL	Stock	173.96	173.97	173.5	173.5	39918.0
2023-05-23 08:00:00	AAPL	Stock	174.19	174.51	173.4	173.42	89764.0
2023-05-23 08:30:00	AAPL	Stock	173.45	173.48	173.17	173.23	94237.0
2023-05-23 09:00:00	AAPL	Stock	173.21	174.2	172.69	173.12	230682.0
2023-05-23 09:30:00	AAPL	Stock	173.13	173.3794	172.55	172.938	5262840.0
2023-05-23 10:00:00	AAPL	Stock	172.94	173.19	172.78	172.85	2276051.0
2023-05-23 10:30:00	AAPL	Stock	172.85	173.16	172.685	172.9135	2214438.0
2023-05-23 11:00:00	AAPL	Stock	172.91	173.18	172.83	173.015	1524821.0
2023-05-23 11:30:00	AAPL	Stock	173.02	173.04	172.52	172.725	1841366.0
2023-05-23 12:00:00	AAPL	Stock	172.73	172.8105	172.54	172.6	1314395.0
2023-05-23 12:30:00	AAPL	Stock	172.59	172.6486	171.77	171.9401	2772009.0
2023-05-23 13:00:00	AAPL	Stock	171.95	172.48	171.91	172.075	1499995.0
2023-05-23 13:30:00	AAPL	Stock	172.07	172.3398	171.86	172.16	1451735.0
2023-05-23 14:00:00	AAPL	Stock	172.1703	172.3	171.5	171.655	2355027.0
2023-05-23 14:30:00	AAPL	Stock	171.655	171.94	171.58	171.82	1610102.0
2023-05-23 15:00:00	AAPL	Stock	171.83	171.88	171.275	171.6195	2332833.0
2023-05-23 15:30:00	AAPL	Stock	171.62	172.02	171.49	171.55	5992023.0
2023-05-23 16:00:00	AAPL	Stock	171.55	171.76	171.35	171.47	5479915.0
2023-05-23 16:30:00	AAPL	Stock	171.47	171.57	171.43	171.54	146099.0
2023-05-23 17:00:00	AAPL	Stock	171.52	171.64	171.48	171.5	16090.0
2023-05-23 17:30:00	AAPL	Stock	171.46	171.48	171.45	171.46	6906.0
2023-05-23 18:00:00	AAPL	Stock	171.47	171.7	171.47	171.6529	68114.0
2023-05-23 18:30:00	AAPL	Stock	171.66	171.8	171.66	171.73	8290.0
2023-05-23 19:00:00	AAPL	Stock	171.74	171.8	171.67	171.7	6458.0
2023-05-23 19:30:00	AAPL	Stock	171.77	171.9	171.67	171.76	15441.0
2023-05-23 04:00:00	MSFT	Stock	321.8	323.29	321.8	322.91	21510.0
2023-05-23 04:30:00	MSFT	Stock	322.86	322.92	322.55	322.75	2288.0
2023-05-23 05:00:00	MSFT	Stock	322.69	322.7	322.1	322.25	2712.0
2023-05-23 05:30:00	MSFT	Stock	322.25	322.5	321.8	322.0	2869.0
2023-05-23 06:00:00	MSFT	Stock	322.12	322.35	322.07	322.35	5932.0
2023-05-23 06:30:00	MSFT	Stock	322.3	322.35	322.1	322.35	1655.0
2023-05-23 07:00:00	MSFT	Stock	322.35	322.35	321.83	322.25	8854.0
2023-05-23 07:30:00	MSFT	Stock	322.17	322.34	320.9	321.0	20371.0
2023-05-23 08:00:00	MSFT	Stock	322.3495	322.35	320.8	321.9	42232.0
2023-05-23 08:30:00	MSFT	Stock	321.87	322.0	321.0701	321.13	30917.0
2023-05-23 09:00:00	MSFT	Stock	321.14	321.3	319.8	320.1	96418.0
2023-05-23 09:30:00	MSFT	Stock	320.03	322.72	320.01	320.74	2917338.0
2023-05-23 10:00:00	MSFT	Stock	320.75	321.19	319.97	320.005	1568133.0
2023-05-23 10:30:00	MSFT	Stock	319.99	320.1363	318.58	318.8525	1284554.0
2023-05-23 11:00:00	MSFT	Stock	318.86	319.64	318.31	318.9799	1512463.0
2023-05-23 11:30:00	MSFT	Stock	318.98	319.29	318.58	318.9249	1076340.0
2023-05-23 12:00:00	MSFT	Stock	318.95	319.0	317.66	318.085	938033.0
2023-05-23 12:30:00	MSFT	Stock	318.08	318.38	317.0	317.34	1032753.0

> showing 50 of 101,499 rows — these rows as CSV

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