PREVIEW / stock_30min / 2020-09-29

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-09-29.parquet
  size:    1.9 MB
  rows:    96,485
  symbols: 2,489

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-09-29 04:00:00	AAPL	Stock	115.0	115.0	114.2	114.59	22398.0
2020-09-29 04:30:00	AAPL	Stock	114.59	114.74	114.49	114.61	12721.0
2020-09-29 05:00:00	AAPL	Stock	114.6	114.89	114.24	114.4	9536.0
2020-09-29 05:30:00	AAPL	Stock	114.4	114.84	114.22	114.8	18048.0
2020-09-29 06:00:00	AAPL	Stock	114.77	115.1	114.62	115.09	21132.0
2020-09-29 06:30:00	AAPL	Stock	115.07	115.11	114.73	114.9	13741.0
2020-09-29 07:00:00	AAPL	Stock	114.92	115.2	114.65	114.86	287150.0
2020-09-29 07:30:00	AAPL	Stock	114.88	114.95	114.48	114.48	122196.0
2020-09-29 08:00:00	AAPL	Stock	115.12	115.2	114.42	114.75	448192.0
2020-09-29 08:30:00	AAPL	Stock	114.8	115.03	114.6	114.94	237582.0
2020-09-29 09:00:00	AAPL	Stock	114.91	115.0	114.4	114.49	299893.0
2020-09-29 09:30:00	AAPL	Stock	114.54	115.31	113.76	113.935	14783393.0
2020-09-29 10:00:00	AAPL	Stock	113.93	114.8	113.845	114.32	8832280.0
2020-09-29 10:30:00	AAPL	Stock	114.325	114.37	113.57	113.95	8891983.0
2020-09-29 11:00:00	AAPL	Stock	113.95	114.32	113.81	114.108	5688764.0
2020-09-29 11:30:00	AAPL	Stock	114.104	114.48	113.78	113.95	5680554.0
2020-09-29 12:00:00	AAPL	Stock	113.95	114.14	113.79	114.03	4612571.0
2020-09-29 12:30:00	AAPL	Stock	114.04	114.27	113.89	114.245	3870346.0
2020-09-29 13:00:00	AAPL	Stock	114.25	114.25	113.68	113.98	4896700.0
2020-09-29 13:30:00	AAPL	Stock	113.971	114.53	113.93	114.32	4088124.0
2020-09-29 14:00:00	AAPL	Stock	114.322	114.5	114.2	114.41	3774576.0
2020-09-29 14:30:00	AAPL	Stock	114.415	114.67	114.36	114.395	5010026.0
2020-09-29 15:00:00	AAPL	Stock	114.39	114.695	114.12	114.25	5814823.0
2020-09-29 15:30:00	AAPL	Stock	114.26	114.48	113.85	114.11	7577591.0
2020-09-29 16:00:00	AAPL	Stock	114.17	114.39	114.05	114.16	5124359.0
2020-09-29 16:30:00	AAPL	Stock	114.14	114.34	114.06	114.08	523057.0
2020-09-29 17:00:00	AAPL	Stock	114.08	114.08	113.85	113.93	86730.0
2020-09-29 17:30:00	AAPL	Stock	113.96	114.06	113.95	114.02	39797.0
2020-09-29 18:00:00	AAPL	Stock	114.08	114.11	114.02	114.05	54202.0
2020-09-29 18:30:00	AAPL	Stock	114.05	114.29	114.0	114.16	58689.0
2020-09-29 19:00:00	AAPL	Stock	114.18	114.35	114.09	114.25	483945.0
2020-09-29 19:30:00	AAPL	Stock	114.26	114.34	114.16	114.3	83360.0
2020-09-29 04:00:00	MSFT	Stock	209.61	209.61	209.1	209.46	888.0
2020-09-29 04:30:00	MSFT	Stock	209.8	210.22	209.8	210.19	2180.0
2020-09-29 05:00:00	MSFT	Stock	210.21	210.49	210.0	210.0	1460.0
2020-09-29 05:30:00	MSFT	Stock	209.75	210.28	209.6	210.28	2600.0
2020-09-29 06:00:00	MSFT	Stock	210.18	210.57	210.18	210.57	518.0
2020-09-29 06:30:00	MSFT	Stock	210.75	210.75	210.49	210.49	2734.0
2020-09-29 07:00:00	MSFT	Stock	210.33	210.63	209.82	209.84	11850.0
2020-09-29 07:30:00	MSFT	Stock	210.01	210.03	209.51	209.61	16298.0
2020-09-29 08:00:00	MSFT	Stock	210.366	210.582	209.15	209.38	32895.0
2020-09-29 08:30:00	MSFT	Stock	209.46	209.89	209.25	209.88	14685.0
2020-09-29 09:00:00	MSFT	Stock	209.95	209.975	209.0	209.47	25871.0
2020-09-29 09:30:00	MSFT	Stock	209.49	210.07	208.1	209.33	2693052.0
2020-09-29 10:00:00	MSFT	Stock	209.37	209.55	208.68	209.19	1280376.0
2020-09-29 10:30:00	MSFT	Stock	209.21	209.29	208.24	208.69	1194094.0
2020-09-29 11:00:00	MSFT	Stock	208.72	209.32	208.34	208.65	1072338.0
2020-09-29 11:30:00	MSFT	Stock	208.63	208.89	207.64	208.05	1363690.0
2020-09-29 12:00:00	MSFT	Stock	208.07	208.475	207.86	207.89	887826.0
2020-09-29 12:30:00	MSFT	Stock	207.9	208.26	207.73	208.07	819132.0

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

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