PREVIEW / stock_30min / 2024-10-14

all stock 30-min files

  file:    by_date/stock_30min/2024/2024-10-14.parquet
  size:    2.1 MB
  rows:    99,541
  symbols: 773

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
2024-10-14 04:00:00	AAPL	Stock	228.0	228.4	227.71	228.4	17274.0
2024-10-14 04:30:00	AAPL	Stock	228.19	228.19	227.84	227.85	2695.0
2024-10-14 05:00:00	AAPL	Stock	227.98	228.13	227.98	228.01	1638.0
2024-10-14 05:30:00	AAPL	Stock	227.99	228.4	227.95	228.24	8154.0
2024-10-14 06:00:00	AAPL	Stock	228.04	229.29	228.04	228.92	16119.0
2024-10-14 06:30:00	AAPL	Stock	229.08	229.49	229.0	229.0	17633.0
2024-10-14 07:00:00	AAPL	Stock	229.0	229.2	228.85	228.91	29016.0
2024-10-14 07:30:00	AAPL	Stock	228.92	229.0	228.7	228.8	12470.0
2024-10-14 08:00:00	AAPL	Stock	229.0	229.2	227.12	228.82	57833.0
2024-10-14 08:30:00	AAPL	Stock	228.82	229.01	228.7195	228.79	27715.0
2024-10-14 09:00:00	AAPL	Stock	228.75	229.33	228.56	228.72	66697.0
2024-10-14 09:30:00	AAPL	Stock	228.7	231.31	228.6	230.555	4477618.0
2024-10-14 10:00:00	AAPL	Stock	230.57	230.8	229.93	230.685	1883382.0
2024-10-14 10:30:00	AAPL	Stock	230.685	230.885	229.31	229.48	1435651.0
2024-10-14 11:00:00	AAPL	Stock	229.47	230.03	229.15	229.69	1232187.0
2024-10-14 11:30:00	AAPL	Stock	229.7	230.35	229.43	230.346	746802.0
2024-10-14 12:00:00	AAPL	Stock	230.34	230.5292	229.97	230.2495	712712.0
2024-10-14 12:30:00	AAPL	Stock	230.26	230.61	230.2	230.33	643977.0
2024-10-14 13:00:00	AAPL	Stock	230.355	230.56	230.29	230.43	535764.0
2024-10-14 13:30:00	AAPL	Stock	230.42	230.49	230.16	230.19	499363.0
2024-10-14 14:00:00	AAPL	Stock	230.19	230.5503	230.06	230.46	701948.0
2024-10-14 14:30:00	AAPL	Stock	230.4835	231.2	230.45	231.15	1286915.0
2024-10-14 15:00:00	AAPL	Stock	231.16	231.4468	231.05	231.2226	1364883.0
2024-10-14 15:30:00	AAPL	Stock	231.22	231.73	231.04	231.4	3297130.0
2024-10-14 16:00:00	AAPL	Stock	231.3	231.46	230.98	230.98	6304587.0
2024-10-14 16:30:00	AAPL	Stock	231.03	231.3	230.84	231.19	92676.0
2024-10-14 17:00:00	AAPL	Stock	231.19	231.3	231.0877	231.18	292076.0
2024-10-14 17:30:00	AAPL	Stock	231.176	231.18	231.0962	231.14	4010.0
2024-10-14 18:00:00	AAPL	Stock	231.14	231.247	231.0928	231.2049	6771.0
2024-10-14 18:30:00	AAPL	Stock	231.2	231.25	231.1788	231.2235	5757.0
2024-10-14 19:00:00	AAPL	Stock	231.2235	231.3	231.2	231.3	5474.0
2024-10-14 19:30:00	AAPL	Stock	231.23	231.3	231.2011	231.3	7915.0
2024-10-14 04:00:00	MSFT	Stock	416.34	416.89	416.33	416.81	2777.0
2024-10-14 04:30:00	MSFT	Stock	416.51	416.51	416.35	416.35	200.0
2024-10-14 05:00:00	MSFT	Stock	416.54	416.99	416.54	416.99	996.0
2024-10-14 05:30:00	MSFT	Stock	416.83	416.83	416.7	416.7	374.0
2024-10-14 06:00:00	MSFT	Stock	416.84	417.0	416.84	417.0	1580.0
2024-10-14 06:30:00	MSFT	Stock	417.0	417.0	416.83	416.83	2524.0
2024-10-14 07:00:00	MSFT	Stock	416.9	417.0	416.76	416.92	1829.0
2024-10-14 07:30:00	MSFT	Stock	416.95	417.1	416.95	417.1	2467.0
2024-10-14 08:00:00	MSFT	Stock	416.69	417.5	415.56	417.45	12405.0
2024-10-14 08:30:00	MSFT	Stock	417.48	418.5	417.4245	418.5	8577.0
2024-10-14 09:00:00	MSFT	Stock	418.442	418.827	417.5	417.75	21316.0
2024-10-14 09:30:00	MSFT	Stock	417.68	422.255	417.52	421.71	1447675.0
2024-10-14 10:00:00	MSFT	Stock	421.71	424.04	421.13	423.595	950307.0
2024-10-14 10:30:00	MSFT	Stock	423.59	423.72	419.59	419.8079	904521.0
2024-10-14 11:00:00	MSFT	Stock	419.75	420.34	419.16	419.43	482888.0
2024-10-14 11:30:00	MSFT	Stock	419.2601	420.78	419.01	420.75	418927.0
2024-10-14 12:00:00	MSFT	Stock	420.78	420.78	419.7	419.9827	337072.0
2024-10-14 12:30:00	MSFT	Stock	419.99	420.43	419.84	420.1405	264241.0

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

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