PREVIEW / stock_30min / 2023-08-10

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-08-10.parquet
  size:    2.1 MB
  rows:    99,894
  symbols: 1,491

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-08-10 04:00:00	AAPL	Stock	179.39	179.39	178.92	179.11	18870.0
2023-08-10 04:30:00	AAPL	Stock	179.2	179.34	179.18	179.25	7300.0
2023-08-10 05:00:00	AAPL	Stock	179.15	179.33	179.11	179.32	4799.0
2023-08-10 05:30:00	AAPL	Stock	179.28	179.34	179.18	179.34	3831.0
2023-08-10 06:00:00	AAPL	Stock	179.34	179.48	179.05	179.19	12162.0
2023-08-10 06:30:00	AAPL	Stock	179.08	179.16	179.05	179.14	1030.0
2023-08-10 07:00:00	AAPL	Stock	179.11	179.24	178.71	178.71	32469.0
2023-08-10 07:30:00	AAPL	Stock	178.7	178.83	178.55	178.76	24679.0
2023-08-10 08:00:00	AAPL	Stock	179.14	179.55	178.5307	179.08	185335.0
2023-08-10 08:30:00	AAPL	Stock	179.08	179.95	178.7	179.67	281706.0
2023-08-10 09:00:00	AAPL	Stock	179.7	179.88	179.2	179.41	162727.0
2023-08-10 09:30:00	AAPL	Stock	179.47	180.58	178.86	180.55	6032264.0
2023-08-10 10:00:00	AAPL	Stock	180.5596	180.75	179.84	180.1	3675135.0
2023-08-10 10:30:00	AAPL	Stock	180.098	180.43	179.12	179.5701	3696320.0
2023-08-10 11:00:00	AAPL	Stock	179.58	179.6	178.69	179.14	3126606.0
2023-08-10 11:30:00	AAPL	Stock	179.14	179.44	178.01	178.355	3014510.0
2023-08-10 12:00:00	AAPL	Stock	178.35	178.5425	177.97	178.38	2296684.0
2023-08-10 12:30:00	AAPL	Stock	178.36	178.9199	177.85	177.97	2234326.0
2023-08-10 13:00:00	AAPL	Stock	177.9637	178.3911	177.8	178.045	2061451.0
2023-08-10 13:30:00	AAPL	Stock	178.04	178.19	177.6	177.68	2088041.0
2023-08-10 14:00:00	AAPL	Stock	177.69	178.6904	177.65	178.2351	2571260.0
2023-08-10 14:30:00	AAPL	Stock	178.24	178.64	177.9034	178.615	2331553.0
2023-08-10 15:00:00	AAPL	Stock	178.62	178.7	178.17	178.22	2136564.0
2023-08-10 15:30:00	AAPL	Stock	178.22	178.27	177.72	178.01	4185557.0
2023-08-10 16:00:00	AAPL	Stock	177.97	177.97	177.8	177.97	3539775.0
2023-08-10 16:30:00	AAPL	Stock	177.97	178.1	177.97	178.06	32947.0
2023-08-10 17:00:00	AAPL	Stock	178.0501	178.0501	178.0	178.009	12990.0
2023-08-10 17:30:00	AAPL	Stock	178.0	178.12	178.0	178.0801	9403.0
2023-08-10 18:00:00	AAPL	Stock	178.14	178.25	178.0925	178.2	20032.0
2023-08-10 18:30:00	AAPL	Stock	178.22	178.29	178.19	178.24	11401.0
2023-08-10 19:00:00	AAPL	Stock	178.24	178.4	178.16	178.4	9237.0
2023-08-10 19:30:00	AAPL	Stock	178.35	178.48	178.35	178.43	14707.0
2023-08-10 04:00:00	MSFT	Stock	322.93	324.69	322.93	324.0	7969.0
2023-08-10 04:30:00	MSFT	Stock	324.29	324.61	324.29	324.61	2118.0
2023-08-10 05:00:00	MSFT	Stock	324.4	324.4	324.4	324.4	200.0
2023-08-10 05:30:00	MSFT	Stock	324.1	324.56	324.1	324.56	1246.0
2023-08-10 06:00:00	MSFT	Stock	324.3	324.7	324.3	324.7	1369.0
2023-08-10 06:30:00	MSFT	Stock	324.7	325.05	324.7	325.05	704.0
2023-08-10 07:00:00	MSFT	Stock	325.0	325.6	325.0	325.15	12950.0
2023-08-10 07:30:00	MSFT	Stock	325.35	325.38	324.78	324.85	8445.0
2023-08-10 08:00:00	MSFT	Stock	325.02	325.94	322.5	325.6	43551.0
2023-08-10 08:30:00	MSFT	Stock	325.85	326.98	324.59	326.5	68801.0
2023-08-10 09:00:00	MSFT	Stock	326.5	327.11	325.12	325.73	60831.0
2023-08-10 09:30:00	MSFT	Stock	325.99	327.28	325.11	327.19	1843845.0
2023-08-10 10:00:00	MSFT	Stock	327.23	328.26	326.04	326.25	1077391.0
2023-08-10 10:30:00	MSFT	Stock	326.23	327.175	324.2	324.76	1191950.0
2023-08-10 11:00:00	MSFT	Stock	324.76	324.9	323.04	324.235	1037871.0
2023-08-10 11:30:00	MSFT	Stock	324.26	325.05	322.08	322.975	1036393.0
2023-08-10 12:00:00	MSFT	Stock	322.95	323.63	322.43	323.25	639947.0
2023-08-10 12:30:00	MSFT	Stock	323.2	324.47	322.63	323.0	531335.0

> showing 50 of 99,894 rows — these rows as CSV

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