PREVIEW / stock_30min / 2020-04-02

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-04-02.parquet
  size:    1.8 MB
  rows:    92,726
  symbols: 2,408

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-04-02 04:00:00	AAPL	Stock	61.1525	61.55	61.1	61.55	24108.0
2020-04-02 04:30:00	AAPL	Stock	61.5075	61.5075	61.25	61.355	8440.0
2020-04-02 05:00:00	AAPL	Stock	61.355	61.3825	61.2375	61.375	12840.0
2020-04-02 05:30:00	AAPL	Stock	61.2625	61.2625	60.8	60.8775	7600.0
2020-04-02 06:00:00	AAPL	Stock	60.9225	61.125	60.8	61.0775	16232.0
2020-04-02 06:30:00	AAPL	Stock	61.0625	61.3	61.055	61.125	31888.0
2020-04-02 07:00:00	AAPL	Stock	61.17	61.225	60.825	61.09	225212.0
2020-04-02 07:30:00	AAPL	Stock	61.08	61.28	61.0375	61.28	186824.0
2020-04-02 08:00:00	AAPL	Stock	61.25	61.3175	60.825	61.0925	355124.0
2020-04-02 08:30:00	AAPL	Stock	61.0575	61.1875	60.05	60.2775	668688.0
2020-04-02 09:00:00	AAPL	Stock	60.275	60.3725	59.75	60.03	573488.0
2020-04-02 09:30:00	AAPL	Stock	60.06	60.525	59.395	59.8388	18621104.0
2020-04-02 10:00:00	AAPL	Stock	59.8475	60.4675	59.7275	60.3065	11348984.0
2020-04-02 10:30:00	AAPL	Stock	60.2975	61.0875	60.2312	60.65	12106056.0
2020-04-02 11:00:00	AAPL	Stock	60.6425	60.825	60.3	60.401	7140652.0
2020-04-02 11:30:00	AAPL	Stock	60.3925	60.8275	60.335	60.675	7119776.0
2020-04-02 12:00:00	AAPL	Stock	60.685	60.8825	60.485	60.5025	5443540.0
2020-04-02 12:30:00	AAPL	Stock	60.52	60.7575	60.425	60.6638	4691484.0
2020-04-02 13:00:00	AAPL	Stock	60.6725	60.8125	59.865	59.9625	7072116.0
2020-04-02 13:30:00	AAPL	Stock	59.955	60.1802	59.74	60.0375	6307704.0
2020-04-02 14:00:00	AAPL	Stock	60.0475	60.055	59.225	59.6175	10056136.0
2020-04-02 14:30:00	AAPL	Stock	59.61	60.2775	59.4125	60.24	8564560.0
2020-04-02 15:00:00	AAPL	Stock	60.25	60.59	60.125	60.445	9270024.0
2020-04-02 15:30:00	AAPL	Stock	60.45	61.2875	60.2225	61.2325	20538648.0
2020-04-02 16:00:00	AAPL	Stock	61.2325	61.43	61.1625	61.295	11316132.0
2020-04-02 16:30:00	AAPL	Stock	61.295	61.385	61.2775	61.28	120692.0
2020-04-02 17:00:00	AAPL	Stock	61.275	61.295	61.25	61.25	88804.0
2020-04-02 17:30:00	AAPL	Stock	61.225	61.3625	61.225	61.3625	35744.0
2020-04-02 18:00:00	AAPL	Stock	61.3275	61.375	61.13	61.3575	101604.0
2020-04-02 18:30:00	AAPL	Stock	61.3575	61.3625	61.205	61.25	40648.0
2020-04-02 19:00:00	AAPL	Stock	61.2812	61.3275	61.18	61.2075	45536.0
2020-04-02 19:30:00	AAPL	Stock	61.19	61.19	60.9	60.975	90128.0
2020-04-02 04:00:00	MSFT	Stock	154.81	155.4	154.7	155.27	4617.0
2020-04-02 04:30:00	MSFT	Stock	155.32	155.5	154.95	154.95	2994.0
2020-04-02 05:00:00	MSFT	Stock	155.0	155.0	154.73	155.0	2557.0
2020-04-02 05:30:00	MSFT	Stock	154.99	155.0	154.0	154.0	5674.0
2020-04-02 06:00:00	MSFT	Stock	154.0	154.25	153.6	154.25	3244.0
2020-04-02 06:30:00	MSFT	Stock	154.29	154.75	153.53	153.88	6422.0
2020-04-02 07:00:00	MSFT	Stock	154.24	154.29	153.6	153.9	37887.0
2020-04-02 07:30:00	MSFT	Stock	153.91	154.9	153.81	154.9	38662.0
2020-04-02 08:00:00	MSFT	Stock	154.0	155.2	152.11	154.5	133775.0
2020-04-02 08:30:00	MSFT	Stock	154.5	154.98	151.8	152.4	166022.0
2020-04-02 09:00:00	MSFT	Stock	152.4	153.0	150.65	151.84	178048.0
2020-04-02 09:30:00	MSFT	Stock	151.86	155.12	150.36	151.674	6184014.0
2020-04-02 10:00:00	MSFT	Stock	151.665	153.35	151.36	152.33	3597212.0
2020-04-02 10:30:00	MSFT	Stock	152.33	154.55	152.222	153.425	3184703.0
2020-04-02 11:00:00	MSFT	Stock	153.41	154.23	152.86	153.43	2159678.0
2020-04-02 11:30:00	MSFT	Stock	153.42	155.01	153.25	154.86	2032883.0
2020-04-02 12:00:00	MSFT	Stock	154.91	155.48	154.3	154.34	2046146.0
2020-04-02 12:30:00	MSFT	Stock	154.37	154.77	153.74	154.26	1451061.0

> showing 50 of 92,726 rows — these rows as CSV

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