PREVIEW / stock_30min / 2020-11-19

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-11-19.parquet
  size:    2.0 MB
  rows:    101,473
  symbols: 2,570

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-11-19 04:00:00	AAPL	Stock	117.4	117.7	117.4	117.58	13543.0
2020-11-19 04:30:00	AAPL	Stock	117.61	117.61	117.42	117.61	2974.0
2020-11-19 05:00:00	AAPL	Stock	117.61	117.62	117.52	117.56	2330.0
2020-11-19 05:30:00	AAPL	Stock	117.66	117.75	117.66	117.73	872.0
2020-11-19 06:00:00	AAPL	Stock	117.76	117.76	117.51	117.51	4967.0
2020-11-19 06:30:00	AAPL	Stock	117.54	117.79	117.51	117.65	16477.0
2020-11-19 07:00:00	AAPL	Stock	117.71	117.98	117.71	117.92	67540.0
2020-11-19 07:30:00	AAPL	Stock	117.93	118.03	117.88	117.91	70030.0
2020-11-19 08:00:00	AAPL	Stock	117.9	118.2	117.75	118.04	193866.0
2020-11-19 08:30:00	AAPL	Stock	118.02	118.04	117.85	117.99	130565.0
2020-11-19 09:00:00	AAPL	Stock	118.0	118.18	117.51	117.67	326461.0
2020-11-19 09:30:00	AAPL	Stock	117.66	118.12	116.81	117.944	13525961.0
2020-11-19 10:00:00	AAPL	Stock	117.95	118.17	117.5	117.98	5258770.0
2020-11-19 10:30:00	AAPL	Stock	117.99	118.3	117.76	117.76	4599949.0
2020-11-19 11:00:00	AAPL	Stock	117.775	118.12	117.65	118.093	3506532.0
2020-11-19 11:30:00	AAPL	Stock	118.1	118.38	117.91	118.13	3377785.0
2020-11-19 12:00:00	AAPL	Stock	118.135	118.35	117.7	117.852	3192670.0
2020-11-19 12:30:00	AAPL	Stock	117.85	117.985	117.57	117.729	2814395.0
2020-11-19 13:00:00	AAPL	Stock	117.723	117.89	117.54	117.785	2625816.0
2020-11-19 13:30:00	AAPL	Stock	117.78	118.14	117.75	118.098	2592815.0
2020-11-19 14:00:00	AAPL	Stock	118.096	118.18	117.9	118.04	2138125.0
2020-11-19 14:30:00	AAPL	Stock	118.047	118.7	118.03	118.63	4348638.0
2020-11-19 15:00:00	AAPL	Stock	118.64	118.82	118.43	118.638	3810507.0
2020-11-19 15:30:00	AAPL	Stock	118.63	119.05	118.53	118.64	6152910.0
2020-11-19 16:00:00	AAPL	Stock	118.64	118.9	118.51	118.62	6184813.0
2020-11-19 16:30:00	AAPL	Stock	118.61	118.61	118.45	118.49	89347.0
2020-11-19 17:00:00	AAPL	Stock	118.47	118.64	118.41	118.43	138217.0
2020-11-19 17:30:00	AAPL	Stock	118.43	118.56	118.42	118.51	21425.0
2020-11-19 18:00:00	AAPL	Stock	118.51	118.51	118.24	118.35	73702.0
2020-11-19 18:30:00	AAPL	Stock	118.35	118.36	118.08	118.2	102686.0
2020-11-19 19:00:00	AAPL	Stock	118.18	118.29	118.15	118.26	28064.0
2020-11-19 19:30:00	AAPL	Stock	118.26	118.4	118.25	118.32	60755.0
2020-11-19 04:00:00	MSFT	Stock	210.4	210.8	210.0	210.8	3907.0
2020-11-19 04:30:00	MSFT	Stock	210.52	210.52	210.27	210.27	768.0
2020-11-19 05:00:00	MSFT	Stock	210.89	210.99	210.84	210.84	381.0
2020-11-19 05:30:00	MSFT	Stock	210.65	210.65	210.65	210.65	100.0
2020-11-19 06:00:00	MSFT	Stock	210.5	210.5	210.31	210.31	1400.0
2020-11-19 06:30:00	MSFT	Stock	210.6	210.7	210.6	210.7	2681.0
2020-11-19 07:00:00	MSFT	Stock	210.89	211.0	210.71	210.74	8095.0
2020-11-19 07:30:00	MSFT	Stock	210.75	211.06	210.66	210.85	8496.0
2020-11-19 08:00:00	MSFT	Stock	210.8	211.187	210.55	210.91	35468.0
2020-11-19 08:30:00	MSFT	Stock	210.91	211.39	210.5	211.24	46391.0
2020-11-19 09:00:00	MSFT	Stock	211.37	211.45	211.08	211.39	31671.0
2020-11-19 09:30:00	MSFT	Stock	211.39	212.37	210.02	212.23	2630709.0
2020-11-19 10:00:00	MSFT	Stock	212.25	212.6	210.12	210.58	2070054.0
2020-11-19 10:30:00	MSFT	Stock	210.6	211.54	209.93	211.22	2236013.0
2020-11-19 11:00:00	MSFT	Stock	211.25	211.48	210.6	211.115	952118.0
2020-11-19 11:30:00	MSFT	Stock	211.13	211.34	210.66	211.315	735989.0
2020-11-19 12:00:00	MSFT	Stock	211.31	212.43	211.2	212.079	1220102.0
2020-11-19 12:30:00	MSFT	Stock	212.07	212.38	211.22	211.28	591334.0

> showing 50 of 101,473 rows — these rows as CSV

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