PREVIEW / stock_30min / 2023-06-09

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-06-09.parquet
  size:    2.0 MB
  rows:    99,565
  symbols: 1,617

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-06-09 04:00:00	AAPL	Stock	180.19	180.25	180.0	180.22	21386.0
2023-06-09 04:30:00	AAPL	Stock	180.22	180.42	180.18	180.4	11013.0
2023-06-09 05:00:00	AAPL	Stock	180.39	180.5	180.3	180.4	21313.0
2023-06-09 05:30:00	AAPL	Stock	180.47	180.47	180.24	180.24	7568.0
2023-06-09 06:00:00	AAPL	Stock	180.25	180.37	180.2	180.37	11830.0
2023-06-09 06:30:00	AAPL	Stock	180.25	180.38	180.13	180.38	8186.0
2023-06-09 07:00:00	AAPL	Stock	180.39	180.5	180.07	180.35	14974.0
2023-06-09 07:30:00	AAPL	Stock	180.42	180.7	180.42	180.55	17483.0
2023-06-09 08:00:00	AAPL	Stock	180.45	180.85	180.05	180.58	87234.0
2023-06-09 08:30:00	AAPL	Stock	180.69	180.8	180.56	180.77	42868.0
2023-06-09 09:00:00	AAPL	Stock	180.77	181.52	180.66	181.52	185726.0
2023-06-09 09:30:00	AAPL	Stock	181.52	182.19	181.24	181.58	5656380.0
2023-06-09 10:00:00	AAPL	Stock	181.59	182.11	181.345	181.92	3606541.0
2023-06-09 10:30:00	AAPL	Stock	181.92	182.1	180.98	181.4	2916918.0
2023-06-09 11:00:00	AAPL	Stock	181.3988	182.07	181.13	181.23	2981695.0
2023-06-09 11:30:00	AAPL	Stock	181.225	181.49	180.86	180.92	2328147.0
2023-06-09 12:00:00	AAPL	Stock	180.9	181.5301	180.63	181.16	2120551.0
2023-06-09 12:30:00	AAPL	Stock	181.17	181.58	180.94	181.39	1436788.0
2023-06-09 13:00:00	AAPL	Stock	181.4099	181.7	181.28	181.66	1214954.0
2023-06-09 13:30:00	AAPL	Stock	181.67	182.03	181.6	182.025	1656392.0
2023-06-09 14:00:00	AAPL	Stock	182.03	182.23	181.83	182.0099	1598535.0
2023-06-09 14:30:00	AAPL	Stock	182.01	182.06	181.755	182.035	1565089.0
2023-06-09 15:00:00	AAPL	Stock	182.0397	182.09	181.31	181.49	2234699.0
2023-06-09 15:30:00	AAPL	Stock	181.48	181.53	180.73	181.05	4676898.0
2023-06-09 16:00:00	AAPL	Stock	181.05	181.1	180.93	181.02	6478331.0
2023-06-09 16:30:00	AAPL	Stock	181.03	181.05	180.8	180.8488	49020.0
2023-06-09 17:00:00	AAPL	Stock	180.87	180.88	180.75	180.85	19507.0
2023-06-09 17:30:00	AAPL	Stock	180.8688	180.87	180.78	180.78	6260.0
2023-06-09 18:00:00	AAPL	Stock	180.7536	180.83	180.75	180.77	4697.0
2023-06-09 18:30:00	AAPL	Stock	180.76	180.85	180.72	180.84	8664.0
2023-06-09 19:00:00	AAPL	Stock	180.78	180.86	180.78	180.7907	2562.0
2023-06-09 19:30:00	AAPL	Stock	180.83	180.85	180.72	180.81	4876.0
2023-06-09 04:00:00	MSFT	Stock	324.11	324.24	323.2	323.57	3278.0
2023-06-09 04:30:00	MSFT	Stock	323.55	323.81	323.55	323.8	2417.0
2023-06-09 05:00:00	MSFT	Stock	323.8	324.1	323.5	323.74	1809.0
2023-06-09 05:30:00	MSFT	Stock	324.22	324.27	323.7	323.7	1639.0
2023-06-09 06:00:00	MSFT	Stock	323.98	324.96	323.98	324.64	4880.0
2023-06-09 06:30:00	MSFT	Stock	324.61	324.88	324.42	324.86	7528.0
2023-06-09 07:00:00	MSFT	Stock	324.6	324.7	324.12	324.3	5954.0
2023-06-09 07:30:00	MSFT	Stock	324.2	324.55	324.16	324.4	3408.0
2023-06-09 08:00:00	MSFT	Stock	324.75	324.8467	323.7351	323.81	23661.0
2023-06-09 08:30:00	MSFT	Stock	323.82	324.94	323.8	324.73	14401.0
2023-06-09 09:00:00	MSFT	Stock	324.62	325.0	324.48	324.92	29376.0
2023-06-09 09:30:00	MSFT	Stock	324.92	329.99	324.41	329.55	2875176.0
2023-06-09 10:00:00	MSFT	Stock	329.58	329.79	328.33	328.63	1293709.0
2023-06-09 10:30:00	MSFT	Stock	328.65	329.2	326.8	327.43	1409814.0
2023-06-09 11:00:00	MSFT	Stock	327.4	328.63	326.08	326.2	860606.0
2023-06-09 11:30:00	MSFT	Stock	326.17	326.9	325.29	325.51	1120369.0
2023-06-09 12:00:00	MSFT	Stock	325.51	326.76	325.02	325.81	713220.0
2023-06-09 12:30:00	MSFT	Stock	325.8201	326.88	325.64	326.81	561110.0

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

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