PREVIEW / stock_30min / 2022-07-21

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-07-21.parquet
  size:    2.0 MB
  rows:    102,684
  symbols: 2,268

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-07-21 04:00:00	AAPL	Stock	152.46	153.01	152.46	152.66	21216.0
2022-07-21 04:30:00	AAPL	Stock	152.63	153.0	152.61	152.99	6035.0
2022-07-21 05:00:00	AAPL	Stock	152.93	153.15	152.89	153.12	6118.0
2022-07-21 05:30:00	AAPL	Stock	153.07	153.27	153.0	153.26	8798.0
2022-07-21 06:00:00	AAPL	Stock	153.33	153.7	153.32	153.51	15864.0
2022-07-21 06:30:00	AAPL	Stock	153.48	153.48	153.25	153.36	6893.0
2022-07-21 07:00:00	AAPL	Stock	153.3	153.49	153.11	153.2	59536.0
2022-07-21 07:30:00	AAPL	Stock	153.29	153.56	153.2	153.48	22426.0
2022-07-21 08:00:00	AAPL	Stock	153.3	154.15	152.38	153.74	299073.0
2022-07-21 08:30:00	AAPL	Stock	153.74	154.51	153.72	154.15	463057.0
2022-07-21 09:00:00	AAPL	Stock	154.2	154.6	153.8	154.5	431671.0
2022-07-21 09:30:00	AAPL	Stock	154.5	154.74	152.965	153.37	7890214.0
2022-07-21 10:00:00	AAPL	Stock	153.39	153.97	151.94	152.38	5186973.0
2022-07-21 10:30:00	AAPL	Stock	152.385	153.3493	152.155	153.26	3231737.0
2022-07-21 11:00:00	AAPL	Stock	153.2582	153.63	152.96	153.5879	2966614.0
2022-07-21 11:30:00	AAPL	Stock	153.6172	154.1	153.48	153.97	2823877.0
2022-07-21 12:00:00	AAPL	Stock	153.995	154.98	153.9	154.9681	3313431.0
2022-07-21 12:30:00	AAPL	Stock	154.97	155.26	154.92	155.15	3308367.0
2022-07-21 13:00:00	AAPL	Stock	155.16	155.4799	154.83	154.94	2963418.0
2022-07-21 13:30:00	AAPL	Stock	154.94	155.24	154.534	155.16	2881923.0
2022-07-21 14:00:00	AAPL	Stock	155.16	155.45	155.05	155.3435	2349745.0
2022-07-21 14:30:00	AAPL	Stock	155.34	155.37	154.9001	155.2601	2201146.0
2022-07-21 15:00:00	AAPL	Stock	155.2686	155.57	154.89	154.97	3172700.0
2022-07-21 15:30:00	AAPL	Stock	154.98	155.38	154.7	155.38	5361196.0
2022-07-21 16:00:00	AAPL	Stock	155.38	155.39	154.75	155.0	5972959.0
2022-07-21 16:30:00	AAPL	Stock	155.0	155.4	154.82	155.24	251126.0
2022-07-21 17:00:00	AAPL	Stock	155.25	155.26	154.81	154.99	91334.0
2022-07-21 17:30:00	AAPL	Stock	154.98	154.98	154.77	154.88	48457.0
2022-07-21 18:00:00	AAPL	Stock	154.94	155.09	154.63	154.85	71758.0
2022-07-21 18:30:00	AAPL	Stock	154.81	154.88	154.78	154.85	10791.0
2022-07-21 19:00:00	AAPL	Stock	154.8	154.84	154.71	154.84	12101.0
2022-07-21 19:30:00	AAPL	Stock	154.8	154.92	154.72	154.92	29767.0
2022-07-21 04:00:00	MSFT	Stock	260.02	260.73	259.5	259.91	3308.0
2022-07-21 04:30:00	MSFT	Stock	260.25	260.25	259.72	259.77	6866.0
2022-07-21 05:00:00	MSFT	Stock	259.89	260.05	259.89	260.02	2098.0
2022-07-21 05:30:00	MSFT	Stock	260.1	260.38	260.1	260.2	3317.0
2022-07-21 06:00:00	MSFT	Stock	260.46	260.7	260.45	260.55	6218.0
2022-07-21 06:30:00	MSFT	Stock	260.55	260.55	260.11	260.11	374.0
2022-07-21 07:00:00	MSFT	Stock	260.48	260.56	260.2	260.45	9358.0
2022-07-21 07:30:00	MSFT	Stock	260.39	260.46	260.0	260.46	5613.0
2022-07-21 08:00:00	MSFT	Stock	260.2101	262.0	259.6	261.0	37352.0
2022-07-21 08:30:00	MSFT	Stock	261.02	262.19	261.02	261.37	45242.0
2022-07-21 09:00:00	MSFT	Stock	261.34	261.7	259.3	259.53	52691.0
2022-07-21 09:30:00	MSFT	Stock	259.85	260.5	257.03	260.17	2559957.0
2022-07-21 10:00:00	MSFT	Stock	260.155	261.35	257.32	258.07	1408543.0
2022-07-21 10:30:00	MSFT	Stock	258.08	259.285	257.8701	259.15	902612.0
2022-07-21 11:00:00	MSFT	Stock	259.11	260.83	258.96	260.83	849131.0
2022-07-21 11:30:00	MSFT	Stock	260.88	261.59	260.55	261.4	719513.0
2022-07-21 12:00:00	MSFT	Stock	261.36	263.8	261.28	263.721	1164093.0
2022-07-21 12:30:00	MSFT	Stock	263.7	264.38	263.64	264.22	714367.0

> showing 50 of 102,684 rows — these rows as CSV

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