PREVIEW / stock_30min / 2021-08-17

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-08-17.parquet
  size:    2.2 MB
  rows:    111,393
  symbols: 2,848

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
2021-08-17 04:00:00	AAPL	Stock	150.79	150.9	150.5	150.69	43563.0
2021-08-17 04:30:00	AAPL	Stock	150.62	151.03	150.55	150.71	49629.0
2021-08-17 05:00:00	AAPL	Stock	150.75	150.89	150.71	150.8	8034.0
2021-08-17 05:30:00	AAPL	Stock	150.7	150.7	150.16	150.58	30445.0
2021-08-17 06:00:00	AAPL	Stock	150.58	150.8	150.58	150.7	10930.0
2021-08-17 06:30:00	AAPL	Stock	150.74	150.83	150.63	150.78	14230.0
2021-08-17 07:00:00	AAPL	Stock	150.82	151.03	150.65	150.84	137722.0
2021-08-17 07:30:00	AAPL	Stock	150.84	151.0	150.78	150.89	66779.0
2021-08-17 08:00:00	AAPL	Stock	150.8301	151.0	150.58	150.6	238833.0
2021-08-17 08:30:00	AAPL	Stock	150.6	151.12	150.39	150.43	573439.0
2021-08-17 09:00:00	AAPL	Stock	150.43	150.46	150.03	150.21	299066.0
2021-08-17 09:30:00	AAPL	Stock	150.23	151.68	149.32	150.51	16402194.0
2021-08-17 10:00:00	AAPL	Stock	150.49	150.63	149.7601	150.5675	7062941.0
2021-08-17 10:30:00	AAPL	Stock	150.56	151.4899	150.3711	151.1	5879221.0
2021-08-17 11:00:00	AAPL	Stock	151.11	151.35	150.47	150.66	4947484.0
2021-08-17 11:30:00	AAPL	Stock	150.65	150.86	150.13	150.155	4455566.0
2021-08-17 12:00:00	AAPL	Stock	150.16	150.32	149.81	150.3	4043294.0
2021-08-17 12:30:00	AAPL	Stock	150.29	150.39	149.12	149.2292	5365756.0
2021-08-17 13:00:00	AAPL	Stock	149.221	149.67	149.14	149.67	3481757.0
2021-08-17 13:30:00	AAPL	Stock	149.6691	149.67	149.09	149.49	3078444.0
2021-08-17 14:00:00	AAPL	Stock	149.485	150.1731	149.46	149.82	4474621.0
2021-08-17 14:30:00	AAPL	Stock	149.82	150.0946	149.6	150.035	3344487.0
2021-08-17 15:00:00	AAPL	Stock	150.0301	150.25	149.77	149.975	4140984.0
2021-08-17 15:30:00	AAPL	Stock	149.975	150.29	149.72	150.23	6828166.0
2021-08-17 16:00:00	AAPL	Stock	150.19	150.25	149.97	150.03	6808444.0
2021-08-17 16:30:00	AAPL	Stock	150.03	150.08	149.8	149.85	34606.0
2021-08-17 17:00:00	AAPL	Stock	149.91	150.0	149.9	150.0	15152.0
2021-08-17 17:30:00	AAPL	Stock	149.98	150.04	149.96	149.9999	8358.0
2021-08-17 18:00:00	AAPL	Stock	149.96	150.02	149.9	149.95	14081.0
2021-08-17 18:30:00	AAPL	Stock	149.95	149.96	149.81	149.81	23596.0
2021-08-17 19:00:00	AAPL	Stock	149.85	149.92	149.83	149.85	15050.0
2021-08-17 19:30:00	AAPL	Stock	149.84	149.86	149.75	149.77	26440.0
2021-08-17 04:00:00	MSFT	Stock	294.0	294.05	294.0	294.05	2276.0
2021-08-17 04:30:00	MSFT	Stock	294.02	294.04	293.96	293.96	1121.0
2021-08-17 05:00:00	MSFT	Stock	294.04	294.13	294.04	294.13	4623.0
2021-08-17 05:30:00	MSFT	Stock	294.1	294.1	294.02	294.09	1060.0
2021-08-17 06:00:00	MSFT	Stock	294.0	294.1	293.91	294.1	1493.0
2021-08-17 06:30:00	MSFT	Stock	294.11	294.48	294.0	294.2	4796.0
2021-08-17 07:00:00	MSFT	Stock	294.1	294.2	293.25	293.25	30587.0
2021-08-17 07:30:00	MSFT	Stock	293.32	293.53	293.0	293.39	27821.0
2021-08-17 08:00:00	MSFT	Stock	294.1308	294.31	292.9	292.9	15769.0
2021-08-17 08:30:00	MSFT	Stock	292.85	293.21	292.56	293.0	22852.0
2021-08-17 09:00:00	MSFT	Stock	292.99	293.0	292.0	292.38	54792.0
2021-08-17 09:30:00	MSFT	Stock	292.44	293.43	291.62	292.12	1690042.0
2021-08-17 10:00:00	MSFT	Stock	292.08	292.4	291.315	291.97	1004965.0
2021-08-17 10:30:00	MSFT	Stock	291.96	293.2999	291.71	292.88	914843.0
2021-08-17 11:00:00	MSFT	Stock	292.89	293.0688	292.36	292.4635	621903.0
2021-08-17 11:30:00	MSFT	Stock	292.4	292.83	291.21	291.26	785595.0
2021-08-17 12:00:00	MSFT	Stock	291.26	292.5	291.08	292.49	790635.0
2021-08-17 12:30:00	MSFT	Stock	292.49	292.57	291.66	292.1914	995268.0

> showing 50 of 111,393 rows — these rows as CSV

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