PREVIEW / stock_30min / 2021-06-21

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-06-21.parquet
  size:    2.2 MB
  rows:    112,558
  symbols: 2,922

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
2021-06-21 04:00:00	AAPL	Stock	130.77	131.3	130.21	130.51	17542.0
2021-06-21 04:30:00	AAPL	Stock	130.54	130.97	130.52	130.95	7602.0
2021-06-21 05:00:00	AAPL	Stock	130.91	131.18	130.85	131.07	14070.0
2021-06-21 05:30:00	AAPL	Stock	131.07	131.19	131.0	131.0	6838.0
2021-06-21 06:00:00	AAPL	Stock	131.01	131.01	130.88	130.88	2839.0
2021-06-21 06:30:00	AAPL	Stock	130.92	130.98	130.92	130.97	553.0
2021-06-21 07:00:00	AAPL	Stock	130.93	130.93	130.45	130.56	89786.0
2021-06-21 07:30:00	AAPL	Stock	130.55	130.67	130.44	130.61	40868.0
2021-06-21 08:00:00	AAPL	Stock	130.8499	130.89	130.345	130.37	214044.0
2021-06-21 08:30:00	AAPL	Stock	130.43	130.59	130.24	130.51	118331.0
2021-06-21 09:00:00	AAPL	Stock	130.47	130.55	130.03	130.31	131765.0
2021-06-21 09:30:00	AAPL	Stock	130.32	130.83	129.21	130.405	10592582.0
2021-06-21 10:00:00	AAPL	Stock	130.41	130.78	130.17	130.76	6478657.0
2021-06-21 10:30:00	AAPL	Stock	130.76	131.435	130.7	131.2573	5163292.0
2021-06-21 11:00:00	AAPL	Stock	131.26	131.7	131.2582	131.61	4375672.0
2021-06-21 11:30:00	AAPL	Stock	131.6184	131.7	131.41	131.61	3209867.0
2021-06-21 12:00:00	AAPL	Stock	131.62	132.17	131.61	132.11	4250772.0
2021-06-21 12:30:00	AAPL	Stock	132.1198	132.19	131.97	132.045	2717346.0
2021-06-21 13:00:00	AAPL	Stock	132.05	132.17	131.88	132.1	2202007.0
2021-06-21 13:30:00	AAPL	Stock	132.11	132.41	132.11	132.245	2958617.0
2021-06-21 14:00:00	AAPL	Stock	132.245	132.3	132.08	132.2	2389942.0
2021-06-21 14:30:00	AAPL	Stock	132.2	132.205	131.97	131.99	2580038.0
2021-06-21 15:00:00	AAPL	Stock	131.99	132.129	131.96	132.08	2900158.0
2021-06-21 15:30:00	AAPL	Stock	132.0799	132.3	131.93	132.3	7103889.0
2021-06-21 16:00:00	AAPL	Stock	132.29	132.36	132.11	132.2	13801368.0
2021-06-21 16:30:00	AAPL	Stock	132.21	132.3	132.1999	132.27	36179.0
2021-06-21 17:00:00	AAPL	Stock	132.27	132.35	132.25	132.33	28676.0
2021-06-21 17:30:00	AAPL	Stock	132.33	132.36	132.27	132.32	12372.0
2021-06-21 18:00:00	AAPL	Stock	132.3	132.35	132.27	132.3	13157.0
2021-06-21 18:30:00	AAPL	Stock	132.3	132.35	132.29	132.31	9430.0
2021-06-21 19:00:00	AAPL	Stock	132.32	132.37	132.31	132.35	25093.0
2021-06-21 19:30:00	AAPL	Stock	132.37	132.45	132.35	132.45	38301.0
2021-06-21 04:00:00	MSFT	Stock	259.56	260.99	259.56	260.99	1064.0
2021-06-21 04:30:00	MSFT	Stock	259.89	260.37	259.89	260.37	1781.0
2021-06-21 05:00:00	MSFT	Stock	260.85	261.0	260.65	261.0	4958.0
2021-06-21 05:30:00	MSFT	Stock	261.3	261.39	260.95	260.95	1848.0
2021-06-21 06:30:00	MSFT	Stock	260.73	260.73	260.73	260.73	189.0
2021-06-21 07:00:00	MSFT	Stock	260.56	260.95	259.78	260.0	10860.0
2021-06-21 07:30:00	MSFT	Stock	260.18	260.5	260.18	260.35	4768.0
2021-06-21 08:00:00	MSFT	Stock	260.65	260.9	259.67	259.67	19231.0
2021-06-21 08:30:00	MSFT	Stock	259.4	259.88	259.38	259.85	8786.0
2021-06-21 09:00:00	MSFT	Stock	259.86	260.0	259.7	259.9	15051.0
2021-06-21 09:30:00	MSFT	Stock	259.97	260.45	257.92	260.29	2408882.0
2021-06-21 10:00:00	MSFT	Stock	260.3	261.34	260.18	260.71	1599060.0
2021-06-21 10:30:00	MSFT	Stock	260.69	263.16	260.62	262.77	2271512.0
2021-06-21 11:00:00	MSFT	Stock	262.75	263.52	262.66	262.84	1354534.0
2021-06-21 11:30:00	MSFT	Stock	262.85	263.1	262.51	262.99	909964.0
2021-06-21 12:00:00	MSFT	Stock	263.0	263.06	262.04	262.19	640980.0
2021-06-21 12:30:00	MSFT	Stock	262.1776	262.49	261.88	261.92	649429.0
2021-06-21 13:00:00	MSFT	Stock	261.915	262.27	261.6802	262.1447	684656.0

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

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