PREVIEW / stock_30min / 2023-01-12

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-01-12.parquet
  size:    2.1 MB
  rows:    104,887
  symbols: 1,923

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-01-12 04:00:00	AAPL	Stock	134.0	134.0	133.32	133.6	17574.0
2023-01-12 04:30:00	AAPL	Stock	133.64	133.88	133.64	133.8	4239.0
2023-01-12 05:00:00	AAPL	Stock	133.75	133.75	133.41	133.62	9564.0
2023-01-12 05:30:00	AAPL	Stock	133.6	133.66	133.58	133.64	3461.0
2023-01-12 06:00:00	AAPL	Stock	133.63	133.65	133.42	133.56	6436.0
2023-01-12 06:30:00	AAPL	Stock	133.65	133.69	133.62	133.64	6185.0
2023-01-12 07:00:00	AAPL	Stock	133.64	133.82	133.5	133.74	29414.0
2023-01-12 07:30:00	AAPL	Stock	133.77	134.16	133.77	134.16	38323.0
2023-01-12 08:00:00	AAPL	Stock	133.6302	134.59	133.3	133.3	245058.0
2023-01-12 08:30:00	AAPL	Stock	133.27	134.61	131.5	134.33	1174529.0
2023-01-12 09:00:00	AAPL	Stock	134.35	134.66	133.2	133.79	477992.0
2023-01-12 09:30:00	AAPL	Stock	133.85	134.26	131.44	132.3	9630095.0
2023-01-12 10:00:00	AAPL	Stock	132.3	133.795	132.15	132.9703	6070571.0
2023-01-12 10:30:00	AAPL	Stock	132.98	133.43	132.37	132.445	4168962.0
2023-01-12 11:00:00	AAPL	Stock	132.45	132.78	131.99	132.415	3059405.0
2023-01-12 11:30:00	AAPL	Stock	132.42	133.1705	132.07	133.08	2738071.0
2023-01-12 12:00:00	AAPL	Stock	133.08	134.085	132.815	134.01	3264373.0
2023-01-12 12:30:00	AAPL	Stock	134.01	134.22	133.71	133.72	2728159.0
2023-01-12 13:00:00	AAPL	Stock	133.715	133.97	132.76	132.81	3003475.0
2023-01-12 13:30:00	AAPL	Stock	132.8	134.19	132.42	134.025	3953390.0
2023-01-12 14:00:00	AAPL	Stock	134.02	134.11	133.14	133.1975	2615311.0
2023-01-12 14:30:00	AAPL	Stock	133.1975	133.5599	133.01	133.3501	2835413.0
2023-01-12 15:00:00	AAPL	Stock	133.355	133.4299	132.83	133.185	2895810.0
2023-01-12 15:30:00	AAPL	Stock	133.19	133.56	132.77	133.385	5053269.0
2023-01-12 16:00:00	AAPL	Stock	133.385	133.45	133.31	133.36	7150374.0
2023-01-12 16:30:00	AAPL	Stock	133.36	133.41	133.1501	133.22	29561.0
2023-01-12 17:00:00	AAPL	Stock	133.2	133.5	133.18	133.25	17499.0
2023-01-12 17:30:00	AAPL	Stock	133.27	133.27	133.2	133.201	8202.0
2023-01-12 18:00:00	AAPL	Stock	133.2	133.27	133.13	133.2	12722.0
2023-01-12 18:30:00	AAPL	Stock	133.2	133.23	133.16	133.2	9848.0
2023-01-12 19:00:00	AAPL	Stock	133.19	133.25	133.16	133.24	13076.0
2023-01-12 19:30:00	AAPL	Stock	133.23	133.23	133.12	133.12	11715.0
2023-01-12 04:00:00	MSFT	Stock	235.78	235.78	235.33	235.73	1821.0
2023-01-12 04:30:00	MSFT	Stock	235.75	235.76	235.56	235.65	1762.0
2023-01-12 05:00:00	MSFT	Stock	235.5	235.55	235.02	235.12	2505.0
2023-01-12 05:30:00	MSFT	Stock	235.26	235.26	235.26	235.26	200.0
2023-01-12 06:00:00	MSFT	Stock	235.32	235.32	235.3	235.3	300.0
2023-01-12 06:30:00	MSFT	Stock	235.25	235.27	235.25	235.27	335.0
2023-01-12 07:00:00	MSFT	Stock	235.37	235.55	235.3	235.45	5862.0
2023-01-12 07:30:00	MSFT	Stock	235.51	235.69	235.15	235.52	10875.0
2023-01-12 08:00:00	MSFT	Stock	235.54	235.98	233.18	233.18	74986.0
2023-01-12 08:30:00	MSFT	Stock	233.18	236.77	231.0	236.7	232655.0
2023-01-12 09:00:00	MSFT	Stock	236.66	236.9	233.58	234.81	101234.0
2023-01-12 09:30:00	MSFT	Stock	234.92	237.28	233.56	234.6736	2576494.0
2023-01-12 10:00:00	MSFT	Stock	234.7	238.92	234.63	238.18	2335005.0
2023-01-12 10:30:00	MSFT	Stock	238.21	239.1386	236.38	237.31	1691477.0
2023-01-12 11:00:00	MSFT	Stock	237.31	238.39	236.72	238.13	1082138.0
2023-01-12 11:30:00	MSFT	Stock	238.165	238.95	237.21	238.77	938526.0
2023-01-12 12:00:00	MSFT	Stock	238.76	239.31	237.9974	239.22	919203.0
2023-01-12 12:30:00	MSFT	Stock	239.24	239.64	238.92	239.27	916796.0

> showing 50 of 104,887 rows — these rows as CSV

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