PREVIEW / stock_30min / 2020-10-27

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-10-27.parquet
  size:    1.9 MB
  rows:    96,229
  symbols: 2,500

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
2020-10-27 04:00:00	AAPL	Stock	115.22	115.36	115.0	115.23	19297.0
2020-10-27 04:30:00	AAPL	Stock	115.25	115.47	115.18	115.37	4782.0
2020-10-27 05:00:00	AAPL	Stock	115.33	115.35	115.15	115.25	5502.0
2020-10-27 05:30:00	AAPL	Stock	115.26	115.32	115.18	115.25	1768.0
2020-10-27 06:00:00	AAPL	Stock	115.23	115.56	115.23	115.5	8811.0
2020-10-27 06:30:00	AAPL	Stock	115.46	116.0	115.45	115.66	20646.0
2020-10-27 07:00:00	AAPL	Stock	115.74	115.86	115.35	115.71	135485.0
2020-10-27 07:30:00	AAPL	Stock	115.71	115.8	115.67	115.8	42181.0
2020-10-27 08:00:00	AAPL	Stock	115.75	115.86	115.41	115.5	210782.0
2020-10-27 08:30:00	AAPL	Stock	115.5	115.57	115.27	115.4	182478.0
2020-10-27 09:00:00	AAPL	Stock	115.42	115.67	115.0	115.5	245402.0
2020-10-27 09:30:00	AAPL	Stock	115.42	116.03	114.54	116.0	11300587.0
2020-10-27 10:00:00	AAPL	Stock	116.015	116.45	115.45	115.84	8446332.0
2020-10-27 10:30:00	AAPL	Stock	115.84	116.39	115.66	116.0	5211577.0
2020-10-27 11:00:00	AAPL	Stock	115.998	116.85	115.95	116.425	6432467.0
2020-10-27 11:30:00	AAPL	Stock	116.43	117.19	116.11	117.11	6425990.0
2020-10-27 12:00:00	AAPL	Stock	117.11	117.28	116.73	116.76	5454437.0
2020-10-27 12:30:00	AAPL	Stock	116.765	117.11	116.54	117.03	4375835.0
2020-10-27 13:00:00	AAPL	Stock	117.02	117.16	116.46	116.505	5145747.0
2020-10-27 13:30:00	AAPL	Stock	116.51	116.81	116.305	116.374	3674770.0
2020-10-27 14:00:00	AAPL	Stock	116.37	116.469	115.98	116.286	4896866.0
2020-10-27 14:30:00	AAPL	Stock	116.29	116.41	115.92	116.215	3340968.0
2020-10-27 15:00:00	AAPL	Stock	116.22	116.63	116.03	116.61	3653620.0
2020-10-27 15:30:00	AAPL	Stock	116.6	117.0	116.53	116.53	7665974.0
2020-10-27 16:00:00	AAPL	Stock	116.55	116.8	116.277	116.53	6202631.0
2020-10-27 16:30:00	AAPL	Stock	116.53	116.53	116.11	116.12	164950.0
2020-10-27 17:00:00	AAPL	Stock	116.12	116.28	116.08	116.16	75561.0
2020-10-27 17:30:00	AAPL	Stock	116.17	116.27	116.13	116.21	28778.0
2020-10-27 18:00:00	AAPL	Stock	116.21	116.29	115.78	115.89	159057.0
2020-10-27 18:30:00	AAPL	Stock	115.89	116.18	115.82	116.02	82289.0
2020-10-27 19:00:00	AAPL	Stock	116.07	116.18	116.0	116.1	47091.0
2020-10-27 19:30:00	AAPL	Stock	116.1	116.19	116.02	116.12	99519.0
2020-10-27 04:00:00	MSFT	Stock	211.3	211.3	210.72	211.0	6871.0
2020-10-27 04:30:00	MSFT	Stock	211.09	211.09	211.02	211.02	485.0
2020-10-27 05:00:00	MSFT	Stock	211.18	211.25	211.02	211.22	1405.0
2020-10-27 05:30:00	MSFT	Stock	211.2	211.2	211.2	211.2	400.0
2020-10-27 06:00:00	MSFT	Stock	211.27	211.8	211.27	211.61	1672.0
2020-10-27 06:30:00	MSFT	Stock	211.61	212.3	211.12	211.96	9986.0
2020-10-27 07:00:00	MSFT	Stock	212.0	212.1	211.61	211.76	33340.0
2020-10-27 07:30:00	MSFT	Stock	211.8	211.8	211.66	211.76	18061.0
2020-10-27 08:00:00	MSFT	Stock	211.744	212.09	211.5	211.5	59707.0
2020-10-27 08:30:00	MSFT	Stock	211.5	211.75	211.25	211.31	36413.0
2020-10-27 09:00:00	MSFT	Stock	211.316	211.88	211.1	211.61	70024.0
2020-10-27 09:30:00	MSFT	Stock	211.62	212.41	210.57	211.905	2837780.0
2020-10-27 10:00:00	MSFT	Stock	211.92	212.03	210.329	210.71	1426051.0
2020-10-27 10:30:00	MSFT	Stock	210.73	212.38	210.58	211.71	1430023.0
2020-10-27 11:00:00	MSFT	Stock	211.72	212.54	211.54	212.022	1280846.0
2020-10-27 11:30:00	MSFT	Stock	212.03	213.23	211.9	213.08	1406761.0
2020-10-27 12:00:00	MSFT	Stock	213.07	213.4	212.58	212.715	1285680.0
2020-10-27 12:30:00	MSFT	Stock	212.72	213.39	212.42	213.36	989524.0

> showing 50 of 96,229 rows — these rows as CSV

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