PREVIEW / stock_30min / 2019-12-02

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-12-02.parquet
  size:    1.8 MB
  rows:    86,735
  symbols: 2,496

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
2019-12-02 04:00:00	AAPL	Stock	67.0625	67.31	67.0625	67.25	45804.0
2019-12-02 04:30:00	AAPL	Stock	67.25	67.2525	67.2225	67.225	18400.0
2019-12-02 05:00:00	AAPL	Stock	67.2525	67.27	67.2525	67.27	12084.0
2019-12-02 05:30:00	AAPL	Stock	67.29	67.3	67.2625	67.2675	8440.0
2019-12-02 06:00:00	AAPL	Stock	67.2675	67.2675	67.1	67.1225	54276.0
2019-12-02 06:30:00	AAPL	Stock	67.09	67.1	66.975	67.1	29688.0
2019-12-02 07:00:00	AAPL	Stock	67.075	67.075	66.9675	67.0	208792.0
2019-12-02 07:30:00	AAPL	Stock	67.005	67.05	66.9675	67.0175	48988.0
2019-12-02 08:00:00	AAPL	Stock	67.0175	67.045	66.8125	66.9625	171308.0
2019-12-02 08:30:00	AAPL	Stock	66.9425	67.0	66.8125	66.975	950552.0
2019-12-02 09:00:00	AAPL	Stock	66.9975	67.05	66.805	66.8975	335224.0
2019-12-02 09:30:00	AAPL	Stock	66.8975	67.0625	66.6375	66.64	11690432.0
2019-12-02 10:00:00	AAPL	Stock	66.6425	66.6462	66.2075	66.3625	7963728.0
2019-12-02 10:30:00	AAPL	Stock	66.3612	66.3775	65.9365	65.9365	7462092.0
2019-12-02 11:00:00	AAPL	Stock	65.9475	66.125	65.8625	66.0675	5643288.0
2019-12-02 11:30:00	AAPL	Stock	66.065	66.2225	65.9938	66.169	3492824.0
2019-12-02 12:00:00	AAPL	Stock	66.17	66.245	65.9375	66.0425	3435852.0
2019-12-02 12:30:00	AAPL	Stock	66.05	66.2075	66.03	66.1525	2011988.0
2019-12-02 13:00:00	AAPL	Stock	66.1475	66.3325	66.14	66.3	2365508.0
2019-12-02 13:30:00	AAPL	Stock	66.2988	66.4035	66.24	66.3432	2368824.0
2019-12-02 14:00:00	AAPL	Stock	66.3435	66.4225	66.2875	66.411	2036968.0
2019-12-02 14:30:00	AAPL	Stock	66.41	66.4375	66.305	66.3675	2431764.0
2019-12-02 15:00:00	AAPL	Stock	66.37	66.385	66.205	66.2175	2512416.0
2019-12-02 15:30:00	AAPL	Stock	66.2175	66.3375	65.9975	66.0225	9409660.0
2019-12-02 16:00:00	AAPL	Stock	66.0225	66.1125	66.0225	66.0425	10530776.0
2019-12-02 16:30:00	AAPL	Stock	66.015	66.0425	66.0	66.04	127204.0
2019-12-02 17:00:00	AAPL	Stock	66.0375	66.0475	66.0	66.0025	19640.0
2019-12-02 17:30:00	AAPL	Stock	66.0	66.035	66.0	66.0	21888.0
2019-12-02 18:00:00	AAPL	Stock	66.035	66.035	65.77	65.7775	84152.0
2019-12-02 18:30:00	AAPL	Stock	65.7875	65.8625	65.75	65.78	115952.0
2019-12-02 19:00:00	AAPL	Stock	65.79	65.8475	65.775	65.7925	31440.0
2019-12-02 19:30:00	AAPL	Stock	65.85	65.97	65.785	65.89	36484.0
2019-12-02 04:00:00	MSFT	Stock	152.02	152.29	152.02	152.12	2613.0
2019-12-02 04:30:00	MSFT	Stock	152.05	152.15	152.05	152.15	540.0
2019-12-02 05:00:00	MSFT	Stock	152.1	152.14	152.1	152.14	400.0
2019-12-02 06:00:00	MSFT	Stock	152.01	152.16	151.76	151.76	4152.0
2019-12-02 06:30:00	MSFT	Stock	151.78	151.8	151.77	151.8	800.0
2019-12-02 07:00:00	MSFT	Stock	151.71	151.85	151.69	151.73	13151.0
2019-12-02 07:30:00	MSFT	Stock	151.75	151.82	151.75	151.82	4297.0
2019-12-02 08:00:00	MSFT	Stock	151.8	151.9	151.38	151.65	11978.0
2019-12-02 08:30:00	MSFT	Stock	151.56	151.65	151.38	151.65	369646.0
2019-12-02 09:00:00	MSFT	Stock	151.65	151.8	151.5	151.75	10057.0
2019-12-02 09:30:00	MSFT	Stock	151.8	151.87	149.22	149.31	2928509.0
2019-12-02 10:00:00	MSFT	Stock	149.29	149.64	148.62	149.1	2527693.0
2019-12-02 10:30:00	MSFT	Stock	149.09	149.29	148.32	148.95	1980234.0
2019-12-02 11:00:00	MSFT	Stock	148.94	149.12	148.47	148.94	1524965.0
2019-12-02 11:30:00	MSFT	Stock	148.938	149.6	148.67	149.58	1253700.0
2019-12-02 12:00:00	MSFT	Stock	149.585	149.92	149.23	149.467	1231642.0
2019-12-02 12:30:00	MSFT	Stock	149.47	149.66	149.275	149.535	647434.0
2019-12-02 13:00:00	MSFT	Stock	149.53	150.21	149.51	150.127	729434.0

> showing 50 of 86,735 rows — these rows as CSV

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