PREVIEW / stock_30min / 2022-06-24

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-06-24.parquet
  size:    2.1 MB
  rows:    106,860
  symbols: 2,271

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-06-24 04:00:00	AAPL	Stock	139.01	139.85	139.01	139.56	33218.0
2022-06-24 04:30:00	AAPL	Stock	139.56	139.74	139.44	139.7	9487.0
2022-06-24 05:00:00	AAPL	Stock	139.69	140.0	139.57	139.67	15328.0
2022-06-24 05:30:00	AAPL	Stock	139.64	139.88	139.63	139.88	3661.0
2022-06-24 06:00:00	AAPL	Stock	139.91	139.91	139.73	139.73	1674.0
2022-06-24 06:30:00	AAPL	Stock	139.65	139.79	139.54	139.55	22675.0
2022-06-24 07:00:00	AAPL	Stock	139.51	139.69	139.05	139.66	37768.0
2022-06-24 07:30:00	AAPL	Stock	139.69	139.8	139.33	139.5	56618.0
2022-06-24 08:00:00	AAPL	Stock	139.5	139.79	139.25	139.5001	213278.0
2022-06-24 08:30:00	AAPL	Stock	139.5	139.7	139.41	139.67	119744.0
2022-06-24 09:00:00	AAPL	Stock	139.64	140.0	139.64	139.85	177115.0
2022-06-24 09:30:00	AAPL	Stock	139.9	141.07	139.81	139.9892	10273117.0
2022-06-24 10:00:00	AAPL	Stock	139.99	141.48	139.99	140.8846	5969746.0
2022-06-24 10:30:00	AAPL	Stock	140.89	141.0	140.22	140.315	4178623.0
2022-06-24 11:00:00	AAPL	Stock	140.3	140.5	139.77	140.27	3160671.0
2022-06-24 11:30:00	AAPL	Stock	140.28	140.3	139.8417	140.24	2530734.0
2022-06-24 12:00:00	AAPL	Stock	140.2418	140.4	140.01	140.1057	2086499.0
2022-06-24 12:30:00	AAPL	Stock	140.12	140.17	139.83	140.12	1954597.0
2022-06-24 13:00:00	AAPL	Stock	140.13	140.27	139.89	140.01	1923999.0
2022-06-24 13:30:00	AAPL	Stock	140.0	140.14	139.81	139.92	2104011.0
2022-06-24 14:00:00	AAPL	Stock	139.915	140.26	139.85	140.1605	2084333.0
2022-06-24 14:30:00	AAPL	Stock	140.16	140.48	140.115	140.445	2287883.0
2022-06-24 15:00:00	AAPL	Stock	140.445	140.485	140.04	140.315	2827408.0
2022-06-24 15:30:00	AAPL	Stock	140.32	141.91	140.18	141.81	10497706.0
2022-06-24 16:00:00	AAPL	Stock	141.82	141.89	141.36	141.4	23547433.0
2022-06-24 16:30:00	AAPL	Stock	141.3803	141.66	141.3803	141.66	201107.0
2022-06-24 17:00:00	AAPL	Stock	141.58	141.65	141.5	141.51	43002.0
2022-06-24 17:30:00	AAPL	Stock	141.53	141.55	141.45	141.52	31929.0
2022-06-24 18:00:00	AAPL	Stock	141.52	141.66	141.52	141.57	22089.0
2022-06-24 18:30:00	AAPL	Stock	141.59	141.64	141.52	141.64	13240.0
2022-06-24 19:00:00	AAPL	Stock	141.65	141.7	141.61	141.7	14090.0
2022-06-24 19:30:00	AAPL	Stock	141.7	141.75	141.67	141.75	16243.0
2022-06-24 04:00:00	MSFT	Stock	259.8	261.93	259.01	261.55	4519.0
2022-06-24 04:30:00	MSFT	Stock	261.83	262.0	261.72	262.0	1065.0
2022-06-24 05:00:00	MSFT	Stock	262.2	262.2	261.7	261.7	2102.0
2022-06-24 05:30:00	MSFT	Stock	261.55	262.0	261.55	262.0	1580.0
2022-06-24 06:00:00	MSFT	Stock	262.0	262.29	261.99	262.0	4464.0
2022-06-24 06:30:00	MSFT	Stock	262.1	262.22	262.1	262.18	547.0
2022-06-24 07:00:00	MSFT	Stock	261.7	261.95	261.6	261.9	7504.0
2022-06-24 07:30:00	MSFT	Stock	262.01	262.01	261.2	261.61	7978.0
2022-06-24 08:00:00	MSFT	Stock	261.5	262.1785	260.0	261.38	25235.0
2022-06-24 08:30:00	MSFT	Stock	261.3	261.6482	261.0	261.3	14403.0
2022-06-24 09:00:00	MSFT	Stock	261.3	262.08	261.3	261.8	31946.0
2022-06-24 09:30:00	MSFT	Stock	261.81	266.64	261.72	264.215	3222835.0
2022-06-24 10:00:00	MSFT	Stock	264.39	266.75	264.21	265.7	1717601.0
2022-06-24 10:30:00	MSFT	Stock	265.71	265.8899	264.06	264.86	1140186.0
2022-06-24 11:00:00	MSFT	Stock	264.87	265.66	263.65	264.23	978489.0
2022-06-24 11:30:00	MSFT	Stock	264.22	264.345	263.45	264.3384	822197.0
2022-06-24 12:00:00	MSFT	Stock	264.34	264.7054	263.97	264.06	509584.0
2022-06-24 12:30:00	MSFT	Stock	264.07	264.29	263.41	264.25	513908.0

> showing 50 of 106,860 rows — these rows as CSV

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