PREVIEW / stock_30min / 2021-03-22

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-03-22.parquet
  size:    2.3 MB
  rows:    115,694
  symbols: 2,907

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-03-22 04:00:00	AAPL	Stock	120.7	121.13	120.2	120.71	24182.0
2021-03-22 04:30:00	AAPL	Stock	120.84	120.99	120.75	120.83	10257.0
2021-03-22 05:00:00	AAPL	Stock	120.82	120.91	120.73	120.78	5869.0
2021-03-22 05:30:00	AAPL	Stock	120.88	120.95	120.81	120.85	6505.0
2021-03-22 06:00:00	AAPL	Stock	120.87	121.12	120.8	121.12	10634.0
2021-03-22 06:30:00	AAPL	Stock	121.18	121.18	120.98	121.0	7651.0
2021-03-22 07:00:00	AAPL	Stock	120.95	121.0	120.71	120.91	113414.0
2021-03-22 07:30:00	AAPL	Stock	120.92	120.94	120.83	120.89	55938.0
2021-03-22 08:00:00	AAPL	Stock	120.8495	120.94	119.99	120.79	355485.0
2021-03-22 08:30:00	AAPL	Stock	120.8	120.86	120.76	120.81	122217.0
2021-03-22 09:00:00	AAPL	Stock	120.82	120.88	119.99	120.35	1173743.0
2021-03-22 09:30:00	AAPL	Stock	120.31	121.79	120.26	121.425	12296605.0
2021-03-22 10:00:00	AAPL	Stock	121.43	122.255	121.43	122.18	7664687.0
2021-03-22 10:30:00	AAPL	Stock	122.19	122.69	122.0701	122.58	5788625.0
2021-03-22 11:00:00	AAPL	Stock	122.575	122.84	122.41	122.565	5142342.0
2021-03-22 11:30:00	AAPL	Stock	122.5678	122.72	122.16	122.32	3904716.0
2021-03-22 12:00:00	AAPL	Stock	122.32	123.45	122.32	123.43	5859433.0
2021-03-22 12:30:00	AAPL	Stock	123.425	123.77	123.29	123.4212	6217450.0
2021-03-22 13:00:00	AAPL	Stock	123.4212	123.4499	123.04	123.0911	4284277.0
2021-03-22 13:30:00	AAPL	Stock	123.0901	123.7	123.08	123.68	4511964.0
2021-03-22 14:00:00	AAPL	Stock	123.69	123.72	123.4	123.542	3623740.0
2021-03-22 14:30:00	AAPL	Stock	123.545	123.84	123.545	123.79	4014744.0
2021-03-22 15:00:00	AAPL	Stock	123.79	123.87	123.275	123.345	5265304.0
2021-03-22 15:30:00	AAPL	Stock	123.34	123.6	123.02	123.37	9417411.0
2021-03-22 16:00:00	AAPL	Stock	123.39	123.47	123.11	123.21	13480382.0
2021-03-22 16:30:00	AAPL	Stock	123.3	123.39	123.1	123.12	111065.0
2021-03-22 17:00:00	AAPL	Stock	123.13	123.2	123.1	123.18	30757.0
2021-03-22 17:30:00	AAPL	Stock	123.18	123.2	123.05	123.1	57555.0
2021-03-22 18:00:00	AAPL	Stock	123.14	123.39	123.09	123.22	300941.0
2021-03-22 18:30:00	AAPL	Stock	123.24	123.34	123.1	123.14	50092.0
2021-03-22 19:00:00	AAPL	Stock	123.18	123.24	123.14	123.18	22713.0
2021-03-22 19:30:00	AAPL	Stock	123.18	123.23	123.01	123.18	74288.0
2021-03-22 04:00:00	MSFT	Stock	231.2	231.95	231.2	231.62	1480.0
2021-03-22 04:30:00	MSFT	Stock	231.81	231.99	231.74	231.8	1117.0
2021-03-22 05:00:00	MSFT	Stock	231.82	231.86	231.66	231.66	565.0
2021-03-22 05:30:00	MSFT	Stock	231.73	231.73	231.66	231.66	203.0
2021-03-22 06:00:00	MSFT	Stock	232.08	232.63	232.08	232.63	2594.0
2021-03-22 06:30:00	MSFT	Stock	232.35	232.35	232.16	232.16	476.0
2021-03-22 07:00:00	MSFT	Stock	232.15	232.25	231.61	232.23	15553.0
2021-03-22 07:30:00	MSFT	Stock	232.15	232.27	232.11	232.25	5281.0
2021-03-22 08:00:00	MSFT	Stock	231.9999	232.3	230.35	232.0	17223.0
2021-03-22 08:30:00	MSFT	Stock	231.93	232.1799	231.8	232.02	8044.0
2021-03-22 09:00:00	MSFT	Stock	232.09	232.18	230.18	230.37	434797.0
2021-03-22 09:30:00	MSFT	Stock	230.37	233.69	230.14	233.6033	2675966.0
2021-03-22 10:00:00	MSFT	Stock	233.62	234.6726	233.331	234.24	1701118.0
2021-03-22 10:30:00	MSFT	Stock	234.2599	235.1454	234.03	234.97	1377729.0
2021-03-22 11:00:00	MSFT	Stock	234.98	236.11	234.8	235.88	1428350.0
2021-03-22 11:30:00	MSFT	Stock	235.9	236.325	235.41	235.8901	1137341.0
2021-03-22 12:00:00	MSFT	Stock	235.93	236.6162	235.8728	236.51	962853.0
2021-03-22 12:30:00	MSFT	Stock	236.53	236.9	236.3701	236.715	845270.0

> showing 50 of 115,694 rows — these rows as CSV

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