PREVIEW / stock_30min / 2023-04-26

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-04-26.parquet
  size:    2.0 MB
  rows:    100,229
  symbols: 1,706

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-04-26 04:00:00	AAPL	Stock	164.84	164.84	164.18	164.37	14567.0
2023-04-26 04:30:00	AAPL	Stock	164.31	164.58	164.31	164.47	9420.0
2023-04-26 05:00:00	AAPL	Stock	164.43	164.53	164.0	164.08	20624.0
2023-04-26 05:30:00	AAPL	Stock	164.17	164.3	164.08	164.2	9286.0
2023-04-26 06:00:00	AAPL	Stock	164.3	164.4	164.1	164.14	12433.0
2023-04-26 06:30:00	AAPL	Stock	164.12	164.14	163.16	163.27	41856.0
2023-04-26 07:00:00	AAPL	Stock	163.29	163.68	163.19	163.38	55694.0
2023-04-26 07:30:00	AAPL	Stock	163.32	163.58	162.66	162.89	78176.0
2023-04-26 08:00:00	AAPL	Stock	163.4	164.55	162.75	163.32	199210.0
2023-04-26 08:30:00	AAPL	Stock	163.28	164.26	163.05	163.91	231976.0
2023-04-26 09:00:00	AAPL	Stock	163.92	164.09	162.86	163.05	235663.0
2023-04-26 09:30:00	AAPL	Stock	163.04	164.14	162.8	164.0291	5261573.0
2023-04-26 10:00:00	AAPL	Stock	164.02	164.2693	163.265	163.3106	2728482.0
2023-04-26 10:30:00	AAPL	Stock	163.31	164.26	163.27	164.185	2102217.0
2023-04-26 11:00:00	AAPL	Stock	164.19	164.885	164.09	164.62	2358831.0
2023-04-26 11:30:00	AAPL	Stock	164.62	164.94	164.4	164.86	1547593.0
2023-04-26 12:00:00	AAPL	Stock	164.86	165.28	164.8443	165.03	1998632.0
2023-04-26 12:30:00	AAPL	Stock	165.03	165.04	164.1302	164.3008	1312413.0
2023-04-26 13:00:00	AAPL	Stock	164.3071	164.53	164.041	164.18	1495880.0
2023-04-26 13:30:00	AAPL	Stock	164.18	164.19	163.38	163.5181	1702624.0
2023-04-26 14:00:00	AAPL	Stock	163.51	163.87	163.35	163.76	1445890.0
2023-04-26 14:30:00	AAPL	Stock	163.755	163.8	163.38	163.5	1473254.0
2023-04-26 15:00:00	AAPL	Stock	163.51	163.67	163.31	163.63	1651950.0
2023-04-26 15:30:00	AAPL	Stock	163.64	164.19	163.361	163.72	5360814.0
2023-04-26 16:00:00	AAPL	Stock	163.71	164.5	163.65	164.29	5082192.0
2023-04-26 16:30:00	AAPL	Stock	164.28	164.48	163.76	164.18	98855.0
2023-04-26 17:00:00	AAPL	Stock	164.15	164.26	164.02	164.2	28764.0
2023-04-26 17:30:00	AAPL	Stock	164.15	164.2	164.15	164.2	11047.0
2023-04-26 18:00:00	AAPL	Stock	164.2	164.2	164.02	164.02	23488.0
2023-04-26 18:30:00	AAPL	Stock	164.08	164.08	163.9	164.0	14739.0
2023-04-26 19:00:00	AAPL	Stock	164.0	164.0	163.92	163.97	7002.0
2023-04-26 19:30:00	AAPL	Stock	163.96	164.03	163.75	164.03	16601.0
2023-04-26 04:00:00	MSFT	Stock	296.7	297.0	295.27	296.74	130150.0
2023-04-26 04:30:00	MSFT	Stock	296.73	296.85	295.55	296.03	39279.0
2023-04-26 05:00:00	MSFT	Stock	296.18	296.4	295.66	296.0	12898.0
2023-04-26 05:30:00	MSFT	Stock	296.0	297.99	295.85	297.55	97656.0
2023-04-26 06:00:00	MSFT	Stock	297.5	297.64	296.85	296.92	25178.0
2023-04-26 06:30:00	MSFT	Stock	296.91	297.38	296.0	296.62	59935.0
2023-04-26 07:00:00	MSFT	Stock	296.88	297.0	294.28	295.4	217285.0
2023-04-26 07:30:00	MSFT	Stock	295.38	297.33	295.09	296.5	201758.0
2023-04-26 08:00:00	MSFT	Stock	296.81	298.3199	294.22	297.26	394799.0
2023-04-26 08:30:00	MSFT	Stock	297.14	299.1	297.1	298.3	554304.0
2023-04-26 09:00:00	MSFT	Stock	298.2	298.29	295.55	296.56	343846.0
2023-04-26 09:30:00	MSFT	Stock	296.7	297.3	292.73	294.89	10875488.0
2023-04-26 10:00:00	MSFT	Stock	294.85	295.73	293.52	295.32	4777215.0
2023-04-26 10:30:00	MSFT	Stock	295.33	296.41	295.25	296.05	3892123.0
2023-04-26 11:00:00	MSFT	Stock	296.13	297.18	295.46	297.11	2932743.0
2023-04-26 11:30:00	MSFT	Stock	297.1089	298.66	296.74	298.658	3000774.0
2023-04-26 12:00:00	MSFT	Stock	298.6501	299.57	298.1285	299.03	3254579.0
2023-04-26 12:30:00	MSFT	Stock	299.05	299.13	296.74	296.935	2223903.0

> showing 50 of 100,229 rows — these rows as CSV

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