PREVIEW / stock_30min / 2023-08-09

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-08-09.parquet
  size:    2.1 MB
  rows:    100,313
  symbols: 1,514

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-09 04:00:00	AAPL	Stock	180.77	181.4	180.75	181.4	20249.0
2023-08-09 04:30:00	AAPL	Stock	181.39	181.47	181.23	181.41	8582.0
2023-08-09 05:00:00	AAPL	Stock	181.44	181.44	181.23	181.38	9581.0
2023-08-09 05:30:00	AAPL	Stock	181.36	181.36	181.2	181.21	2197.0
2023-08-09 06:00:00	AAPL	Stock	181.26	181.29	181.1	181.27	5167.0
2023-08-09 06:30:00	AAPL	Stock	181.27	181.28	181.02	181.02	12763.0
2023-08-09 07:00:00	AAPL	Stock	181.0	181.05	180.56	180.76	39588.0
2023-08-09 07:30:00	AAPL	Stock	180.76	181.1	180.76	181.06	25995.0
2023-08-09 08:00:00	AAPL	Stock	181.0	181.1	180.52	180.73	167883.0
2023-08-09 08:30:00	AAPL	Stock	180.75	180.9	180.53	180.76	75909.0
2023-08-09 09:00:00	AAPL	Stock	180.79	180.98	180.58	180.87	107316.0
2023-08-09 09:30:00	AAPL	Stock	180.83	180.93	178.14	178.66	6805289.0
2023-08-09 10:00:00	AAPL	Stock	178.66	179.13	178.42	178.6915	3463081.0
2023-08-09 10:30:00	AAPL	Stock	178.69	178.835	177.6	177.815	4293952.0
2023-08-09 11:00:00	AAPL	Stock	177.82	178.2	177.01	177.48	3852080.0
2023-08-09 11:30:00	AAPL	Stock	177.47	177.57	177.24	177.42	2444603.0
2023-08-09 12:00:00	AAPL	Stock	177.42	178.11	177.37	178.005	3151282.0
2023-08-09 12:30:00	AAPL	Stock	178.0	178.48	177.99	178.19	2454372.0
2023-08-09 13:00:00	AAPL	Stock	178.195	178.77	178.1402	178.66	1846492.0
2023-08-09 13:30:00	AAPL	Stock	178.659	178.79	178.553	178.6732	1308497.0
2023-08-09 14:00:00	AAPL	Stock	178.67	179.36	178.61	179.295	2203197.0
2023-08-09 14:30:00	AAPL	Stock	179.295	179.59	179.12	179.16	2620856.0
2023-08-09 15:00:00	AAPL	Stock	179.16	179.3	178.7891	179.03	2415567.0
2023-08-09 15:30:00	AAPL	Stock	179.03	179.09	177.99	178.2	5421993.0
2023-08-09 16:00:00	AAPL	Stock	178.2	178.32	178.108	178.22	5656304.0
2023-08-09 16:30:00	AAPL	Stock	178.23	178.56	178.19	178.56	115588.0
2023-08-09 17:00:00	AAPL	Stock	178.54	178.65	178.25	178.27	72227.0
2023-08-09 17:30:00	AAPL	Stock	178.26	178.34	178.2	178.3	20870.0
2023-08-09 18:00:00	AAPL	Stock	178.35	178.63	178.35	178.55	34222.0
2023-08-09 18:30:00	AAPL	Stock	178.4949	178.58	178.43	178.55	12681.0
2023-08-09 19:00:00	AAPL	Stock	178.55	178.55	178.36	178.39	12786.0
2023-08-09 19:30:00	AAPL	Stock	178.42	178.49	178.37	178.43	37194.0
2023-08-09 04:00:00	MSFT	Stock	326.8	327.32	326.8	327.32	3732.0
2023-08-09 04:30:00	MSFT	Stock	327.43	327.59	327.41	327.59	636.0
2023-08-09 05:00:00	MSFT	Stock	327.53	327.68	327.37	327.55	1367.0
2023-08-09 05:30:00	MSFT	Stock	327.56	327.56	327.3	327.3	562.0
2023-08-09 06:00:00	MSFT	Stock	326.84	326.84	326.68	326.68	226.0
2023-08-09 06:30:00	MSFT	Stock	326.7	326.7	326.03	326.39	664.0
2023-08-09 07:00:00	MSFT	Stock	326.48	326.5	326.0	326.0	4355.0
2023-08-09 07:30:00	MSFT	Stock	326.0	326.87	326.0	326.8	3847.0
2023-08-09 08:00:00	MSFT	Stock	326.25	327.59	325.9	326.4	16443.0
2023-08-09 08:30:00	MSFT	Stock	326.6	327.0	326.55	326.6101	15941.0
2023-08-09 09:00:00	MSFT	Stock	326.8	326.8	326.26	326.47	9410.0
2023-08-09 09:30:00	MSFT	Stock	326.47	327.11	324.46	324.7689	1222903.0
2023-08-09 10:00:00	MSFT	Stock	324.78	325.545	324.08	324.23	772030.0
2023-08-09 10:30:00	MSFT	Stock	324.2	324.7	322.92	322.94	771486.0
2023-08-09 11:00:00	MSFT	Stock	322.94	323.66	321.0499	322.02	1353266.0
2023-08-09 11:30:00	MSFT	Stock	322.0	322.775	321.52	322.45	880242.0
2023-08-09 12:00:00	MSFT	Stock	322.43	323.87	322.41	323.14	683679.0
2023-08-09 12:30:00	MSFT	Stock	323.12	323.9	323.09	323.195	540047.0

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

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