PREVIEW / stock_30min / 2022-01-20

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-01-20.parquet
  size:    2.3 MB
  rows:    112,283
  symbols: 2,621

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-01-20 04:00:00	AAPL	Stock	166.53	166.96	166.2	166.87	29175.0
2022-01-20 04:30:00	AAPL	Stock	166.85	167.15	166.81	167.05	9489.0
2022-01-20 05:00:00	AAPL	Stock	167.01	167.12	166.81	167.12	6317.0
2022-01-20 05:30:00	AAPL	Stock	166.98	167.0	166.8	166.88	7980.0
2022-01-20 06:00:00	AAPL	Stock	167.1	167.47	167.1	167.47	12244.0
2022-01-20 06:30:00	AAPL	Stock	167.46	167.46	167.2	167.22	5509.0
2022-01-20 07:00:00	AAPL	Stock	167.16	167.3	166.68	166.81	74778.0
2022-01-20 07:30:00	AAPL	Stock	166.77	166.91	166.41	166.88	60295.0
2022-01-20 08:00:00	AAPL	Stock	167.2501	167.29	165.815	166.9	395962.0
2022-01-20 08:30:00	AAPL	Stock	166.93	167.35	166.88	167.14	297830.0
2022-01-20 09:00:00	AAPL	Stock	167.14	167.27	166.8	166.98	239623.0
2022-01-20 09:30:00	AAPL	Stock	166.98	168.92	166.76	168.88	9428837.0
2022-01-20 10:00:00	AAPL	Stock	168.87	169.34	168.47	169.23	5655285.0
2022-01-20 10:30:00	AAPL	Stock	169.2399	169.68	168.94	169.229	4434693.0
2022-01-20 11:00:00	AAPL	Stock	169.23	169.5498	168.96	169.35	3515771.0
2022-01-20 11:30:00	AAPL	Stock	169.36	169.48	168.78	169.11	3374384.0
2022-01-20 12:00:00	AAPL	Stock	169.11	169.25	168.81	169.075	2348404.0
2022-01-20 12:30:00	AAPL	Stock	169.09	169.22	168.495	168.645	2489952.0
2022-01-20 13:00:00	AAPL	Stock	168.64	168.64	167.6	167.6	3443402.0
2022-01-20 13:30:00	AAPL	Stock	167.61	167.8	167.15	167.4167	3684158.0
2022-01-20 14:00:00	AAPL	Stock	167.4388	167.91	166.46	166.6401	4559445.0
2022-01-20 14:30:00	AAPL	Stock	166.6474	166.93	166.32	166.66	4086592.0
2022-01-20 15:00:00	AAPL	Stock	166.66	166.97	165.65	165.845	5674606.0
2022-01-20 15:30:00	AAPL	Stock	165.84	165.97	164.18	164.52	12066480.0
2022-01-20 16:00:00	AAPL	Stock	164.53	167.4329	163.02	163.05	6255005.0
2022-01-20 16:30:00	AAPL	Stock	163.01	164.51	162.25	163.4	2239055.0
2022-01-20 17:00:00	AAPL	Stock	163.38	164.51	163.08	163.24	731292.0
2022-01-20 17:30:00	AAPL	Stock	163.16	163.4	162.69	162.8	69844.0
2022-01-20 18:00:00	AAPL	Stock	162.79	163.82	162.65	162.8	151388.0
2022-01-20 18:30:00	AAPL	Stock	162.8	163.83	162.76	163.49	42540.0
2022-01-20 19:00:00	AAPL	Stock	163.49	163.83	163.05	163.34	32648.0
2022-01-20 19:30:00	AAPL	Stock	163.22	163.39	162.95	163.05	56631.0
2022-01-20 04:00:00	MSFT	Stock	305.93	306.5	305.29	306.0	5431.0
2022-01-20 04:30:00	MSFT	Stock	306.0	306.4	306.0	306.36	3296.0
2022-01-20 05:00:00	MSFT	Stock	306.55	306.6	305.99	306.6	7979.0
2022-01-20 05:30:00	MSFT	Stock	306.19	307.0	306.19	307.0	6646.0
2022-01-20 06:00:00	MSFT	Stock	307.22	307.82	307.11	307.7	5639.0
2022-01-20 06:30:00	MSFT	Stock	307.6	307.6	307.08	307.5	3822.0
2022-01-20 07:00:00	MSFT	Stock	307.69	307.76	307.0	307.38	17763.0
2022-01-20 07:30:00	MSFT	Stock	307.4	307.9	306.79	307.9	25529.0
2022-01-20 08:00:00	MSFT	Stock	306.93	308.33	304.088	308.29	62229.0
2022-01-20 08:30:00	MSFT	Stock	308.25	309.89	308.25	309.28	73994.0
2022-01-20 09:00:00	MSFT	Stock	309.2	309.9	308.48	309.07	60082.0
2022-01-20 09:30:00	MSFT	Stock	309.07	311.48	307.45	311.03	4041515.0
2022-01-20 10:00:00	MSFT	Stock	311.08	311.6494	309.08	309.86	2211819.0
2022-01-20 10:30:00	MSFT	Stock	309.87	310.8828	309.3301	309.96	1510604.0
2022-01-20 11:00:00	MSFT	Stock	309.95	311.19	309.95	310.8094	1091149.0
2022-01-20 11:30:00	MSFT	Stock	310.8	311.34	309.85	310.68	1202029.0
2022-01-20 12:00:00	MSFT	Stock	310.71	311.16	309.66	310.26	962328.0
2022-01-20 12:30:00	MSFT	Stock	310.26	310.61	309.35	309.635	784798.0

> showing 50 of 112,283 rows — these rows as CSV

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