PREVIEW / stock_30min / 2022-01-27

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-01-27.parquet
  size:    2.2 MB
  rows:    110,389
  symbols: 2,697

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-27 04:00:00	AAPL	Stock	160.33	160.5	159.28	160.48	41905.0
2022-01-27 04:30:00	AAPL	Stock	160.31	160.92	160.12	160.92	7277.0
2022-01-27 05:00:00	AAPL	Stock	160.8	161.3	160.4	160.95	9796.0
2022-01-27 05:30:00	AAPL	Stock	160.9	161.0	159.33	159.53	18821.0
2022-01-27 06:00:00	AAPL	Stock	159.65	161.04	159.52	161.0	15558.0
2022-01-27 06:30:00	AAPL	Stock	160.65	161.1	160.23	161.0	24251.0
2022-01-27 07:00:00	AAPL	Stock	161.0	161.44	160.7	160.86	69764.0
2022-01-27 07:30:00	AAPL	Stock	160.9	161.7	160.51	161.56	84544.0
2022-01-27 08:00:00	AAPL	Stock	160.9999	162.05	159.321	161.84	456580.0
2022-01-27 08:30:00	AAPL	Stock	161.8796	162.06	159.69	162.03	262282.0
2022-01-27 09:00:00	AAPL	Stock	162.02	162.73	162.02	162.39	334358.0
2022-01-27 09:30:00	AAPL	Stock	162.42	163.84	161.7	163.07	10761314.0
2022-01-27 10:00:00	AAPL	Stock	163.08	163.81	162.47	162.61	6326533.0
2022-01-27 10:30:00	AAPL	Stock	162.59	163.03	161.68	162.97	5976660.0
2022-01-27 11:00:00	AAPL	Stock	162.96	163.39	162.18	162.33	5061974.0
2022-01-27 11:30:00	AAPL	Stock	162.34	163.35	162.27	162.67	4114573.0
2022-01-27 12:00:00	AAPL	Stock	162.689	162.705	160.96	161.1446	5516122.0
2022-01-27 12:30:00	AAPL	Stock	161.14	161.35	160.08	160.905	6053922.0
2022-01-27 13:00:00	AAPL	Stock	160.9	161.14	158.59	158.78	6073493.0
2022-01-27 13:30:00	AAPL	Stock	158.77	159.9299	158.68	159.7899	5414022.0
2022-01-27 14:00:00	AAPL	Stock	159.77	160.65	158.83	159.07	5452951.0
2022-01-27 14:30:00	AAPL	Stock	159.06	160.22	158.77	159.37	5196243.0
2022-01-27 15:00:00	AAPL	Stock	159.375	159.82	158.29	158.795	6342962.0
2022-01-27 15:30:00	AAPL	Stock	158.79	159.97	158.28	159.2	11902645.0
2022-01-27 16:00:00	AAPL	Stock	159.09	159.48	158.4	158.79	7025022.0
2022-01-27 16:30:00	AAPL	Stock	159.04	166.0	157.5	165.17	5593910.0
2022-01-27 17:00:00	AAPL	Stock	165.65	167.62	163.81	163.88	2335329.0
2022-01-27 17:30:00	AAPL	Stock	163.88	168.0	163.17	167.29	1760149.0
2022-01-27 18:00:00	AAPL	Stock	167.2001	168.38	166.8	166.96	910150.0
2022-01-27 18:30:00	AAPL	Stock	166.94	167.5	166.41	166.7	313378.0
2022-01-27 19:00:00	AAPL	Stock	166.7	166.7	165.95	166.15	251014.0
2022-01-27 19:30:00	AAPL	Stock	166.14	167.3	165.75	167.25	323429.0
2022-01-27 04:00:00	MSFT	Stock	296.71	297.65	296.57	297.38	11423.0
2022-01-27 04:30:00	MSFT	Stock	297.8	299.71	297.61	299.0	9798.0
2022-01-27 05:00:00	MSFT	Stock	299.0	299.01	297.75	298.59	4181.0
2022-01-27 05:30:00	MSFT	Stock	298.59	298.59	296.03	296.09	3887.0
2022-01-27 06:00:00	MSFT	Stock	296.44	299.45	296.44	299.45	2458.0
2022-01-27 06:30:00	MSFT	Stock	298.88	299.33	297.85	299.1	2783.0
2022-01-27 07:00:00	MSFT	Stock	299.0	299.07	297.65	298.0	15257.0
2022-01-27 07:30:00	MSFT	Stock	297.7	300.25	297.03	299.74	15337.0
2022-01-27 08:00:00	MSFT	Stock	298.2298	300.49	297.3001	300.0	63403.0
2022-01-27 08:30:00	MSFT	Stock	300.2	301.29	296.71	301.25	63343.0
2022-01-27 09:00:00	MSFT	Stock	301.12	302.68	301.12	302.6	90753.0
2022-01-27 09:30:00	MSFT	Stock	302.62	307.3	301.35	306.35	6185336.0
2022-01-27 10:00:00	MSFT	Stock	306.33	306.79	303.72	303.7776	3363196.0
2022-01-27 10:30:00	MSFT	Stock	303.76	305.27	302.34	304.89	3051103.0
2022-01-27 11:00:00	MSFT	Stock	304.87	306.55	303.6	304.715	3168015.0
2022-01-27 11:30:00	MSFT	Stock	304.7139	306.55	304.62	305.329	2140480.0
2022-01-27 12:00:00	MSFT	Stock	305.36	305.42	301.64	302.32	2149846.0
2022-01-27 12:30:00	MSFT	Stock	302.33	302.77	300.2	302.176	2320624.0

> showing 50 of 110,389 rows — these rows as CSV

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