PREVIEW / stock_30min / 2022-08-19

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-08-19.parquet
  size:    2.1 MB
  rows:    105,740
  symbols: 2,205

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
2022-08-19 04:00:00	AAPL	Stock	173.6	173.6	172.62	172.67	33999.0
2022-08-19 04:30:00	AAPL	Stock	172.64	172.79	172.4	172.69	20522.0
2022-08-19 05:00:00	AAPL	Stock	172.66	172.85	172.62	172.64	4964.0
2022-08-19 05:30:00	AAPL	Stock	172.66	172.85	172.57	172.6	21023.0
2022-08-19 06:00:00	AAPL	Stock	172.59	172.68	172.43	172.6	7875.0
2022-08-19 06:30:00	AAPL	Stock	172.6	172.6	172.2	172.45	13030.0
2022-08-19 07:00:00	AAPL	Stock	172.55	172.78	172.35	172.6	69804.0
2022-08-19 07:30:00	AAPL	Stock	172.6	172.67	172.42	172.59	62763.0
2022-08-19 08:00:00	AAPL	Stock	172.6	173.85	172.35	172.59	412097.0
2022-08-19 08:30:00	AAPL	Stock	172.62	172.78	172.45	172.63	98293.0
2022-08-19 09:00:00	AAPL	Stock	172.63	173.59	172.56	173.2	559454.0
2022-08-19 09:30:00	AAPL	Stock	173.03	173.74	172.55	172.77	11780263.0
2022-08-19 10:00:00	AAPL	Stock	172.77	173.09	171.88	172.17	5857554.0
2022-08-19 10:30:00	AAPL	Stock	172.18	172.38	171.73	171.83	4110666.0
2022-08-19 11:00:00	AAPL	Stock	171.835	172.16	171.64	172.005	3588211.0
2022-08-19 11:30:00	AAPL	Stock	172.01	172.448	171.86	172.17	2948589.0
2022-08-19 12:00:00	AAPL	Stock	172.16	172.35	171.86	172.16	2165507.0
2022-08-19 12:30:00	AAPL	Stock	172.16	172.94	172.06	172.74	2870080.0
2022-08-19 13:00:00	AAPL	Stock	172.74	173.03	172.015	172.02	2605959.0
2022-08-19 13:30:00	AAPL	Stock	172.02	172.27	171.74	172.18	2230034.0
2022-08-19 14:00:00	AAPL	Stock	172.18	172.27	171.81	171.95	1940822.0
2022-08-19 14:30:00	AAPL	Stock	171.96	172.2	171.76	171.8401	1950576.0
2022-08-19 15:00:00	AAPL	Stock	171.85	171.95	171.38	171.73	3554516.0
2022-08-19 15:30:00	AAPL	Stock	171.73	171.86	171.3101	171.52	6253786.0
2022-08-19 16:00:00	AAPL	Stock	171.52	171.7	171.3	171.3	7818168.0
2022-08-19 16:30:00	AAPL	Stock	171.31	171.52	171.23	171.28	230510.0
2022-08-19 17:00:00	AAPL	Stock	171.27	171.28	171.09	171.1	32785.0
2022-08-19 17:30:00	AAPL	Stock	171.09	171.15	171.04	171.05	28567.0
2022-08-19 18:00:00	AAPL	Stock	171.08	171.08	170.82	170.9	56472.0
2022-08-19 18:30:00	AAPL	Stock	170.9	170.9	170.75	170.76	24017.0
2022-08-19 19:00:00	AAPL	Stock	170.76	170.79	170.71	170.74	15482.0
2022-08-19 19:30:00	AAPL	Stock	170.72	170.8	170.7	170.75	31762.0
2022-08-19 04:00:00	MSFT	Stock	289.09	289.09	287.31	287.31	13515.0
2022-08-19 04:30:00	MSFT	Stock	287.31	287.6	287.31	287.54	513.0
2022-08-19 05:00:00	MSFT	Stock	287.81	287.81	287.71	287.71	866.0
2022-08-19 05:30:00	MSFT	Stock	288.0	288.16	288.0	288.16	401.0
2022-08-19 06:00:00	MSFT	Stock	287.5	287.5	287.2	287.31	831.0
2022-08-19 06:30:00	MSFT	Stock	287.2	287.2	286.62	286.62	1325.0
2022-08-19 07:00:00	MSFT	Stock	287.3	288.56	287.15	287.2	14662.0
2022-08-19 07:30:00	MSFT	Stock	287.18	287.26	286.76	287.25	5913.0
2022-08-19 08:00:00	MSFT	Stock	287.559	289.445	286.8	286.9	31318.0
2022-08-19 08:30:00	MSFT	Stock	286.9007	287.39	286.9007	287.0	3899.0
2022-08-19 09:00:00	MSFT	Stock	287.1	289.32	286.88	288.91	113612.0
2022-08-19 09:30:00	MSFT	Stock	288.9	289.25	286.32	286.56	2920450.0
2022-08-19 10:00:00	MSFT	Stock	286.585	287.55	286.35	287.21	848326.0
2022-08-19 10:30:00	MSFT	Stock	287.21	287.65	286.27	286.27	761818.0
2022-08-19 11:00:00	MSFT	Stock	286.275	286.7199	285.92	286.36	662191.0
2022-08-19 11:30:00	MSFT	Stock	286.37	287.21	286.11	286.4777	522069.0
2022-08-19 12:00:00	MSFT	Stock	286.445	286.9	286.26	286.43	431055.0
2022-08-19 12:30:00	MSFT	Stock	286.44	287.12	286.36	286.73	569092.0

> showing 50 of 105,740 rows — these rows as CSV

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