PREVIEW / stock_30min / 2021-07-02

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-07-02.parquet
  size:    2.2 MB
  rows:    109,362
  symbols: 2,892

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-07-02 04:00:00	AAPL	Stock	137.27	137.5	136.86	137.0	14769.0
2021-07-02 04:30:00	AAPL	Stock	137.0	137.11	137.0	137.1	3272.0
2021-07-02 05:00:00	AAPL	Stock	137.09	137.32	137.09	137.27	3423.0
2021-07-02 05:30:00	AAPL	Stock	137.2	137.28	137.2	137.28	3134.0
2021-07-02 06:00:00	AAPL	Stock	137.21	137.32	137.17	137.31	2016.0
2021-07-02 06:30:00	AAPL	Stock	137.25	137.32	137.25	137.3	3539.0
2021-07-02 07:00:00	AAPL	Stock	137.29	137.5	137.28	137.5	41035.0
2021-07-02 07:30:00	AAPL	Stock	137.5	137.8	137.45	137.76	62301.0
2021-07-02 08:00:00	AAPL	Stock	137.35	137.98	136.927	137.86	178117.0
2021-07-02 08:30:00	AAPL	Stock	137.8	138.275	137.7	138.06	354814.0
2021-07-02 09:00:00	AAPL	Stock	138.0799	138.33	137.56	137.89	332174.0
2021-07-02 09:30:00	AAPL	Stock	137.92	139.07	137.745	139.015	11558652.0
2021-07-02 10:00:00	AAPL	Stock	139.015	139.13	138.57	138.8393	6623906.0
2021-07-02 10:30:00	AAPL	Stock	138.8375	138.8375	138.39	138.5926	4182407.0
2021-07-02 11:00:00	AAPL	Stock	138.5903	138.91	138.56	138.7	3502835.0
2021-07-02 11:30:00	AAPL	Stock	138.695	139.12	138.68	138.9608	3205838.0
2021-07-02 12:00:00	AAPL	Stock	138.97	139.4201	138.97	139.3114	4078440.0
2021-07-02 12:30:00	AAPL	Stock	139.3118	139.62	139.16	139.5991	3792586.0
2021-07-02 13:00:00	AAPL	Stock	139.6	139.67	139.35	139.425	2875977.0
2021-07-02 13:30:00	AAPL	Stock	139.42	139.705	139.39	139.6729	2474857.0
2021-07-02 14:00:00	AAPL	Stock	139.67	139.81	139.51	139.7423	2640180.0
2021-07-02 14:30:00	AAPL	Stock	139.74	139.75	139.37	139.515	2735476.0
2021-07-02 15:00:00	AAPL	Stock	139.515	139.76	139.46	139.675	4198124.0
2021-07-02 15:30:00	AAPL	Stock	139.67	140.0	139.63	139.96	9998024.0
2021-07-02 16:00:00	AAPL	Stock	139.96	139.98	139.8	139.9	7240349.0
2021-07-02 16:30:00	AAPL	Stock	139.91	139.95	139.81	139.82	47962.0
2021-07-02 17:00:00	AAPL	Stock	139.82	139.85	139.81	139.8499	26772.0
2021-07-02 17:30:00	AAPL	Stock	139.84	139.93	139.84	139.93	23261.0
2021-07-02 18:00:00	AAPL	Stock	139.95	139.95	139.8	139.82	19913.0
2021-07-02 18:30:00	AAPL	Stock	139.82	139.96	139.82	139.89	19483.0
2021-07-02 19:00:00	AAPL	Stock	139.89	139.96	139.86	139.96	25501.0
2021-07-02 19:30:00	AAPL	Stock	139.92	139.96	139.85	139.85	23111.0
2021-07-02 04:00:00	MSFT	Stock	272.05	272.09	271.9	271.9	971.0
2021-07-02 05:30:00	MSFT	Stock	271.77	271.98	271.55	271.98	2084.0
2021-07-02 06:00:00	MSFT	Stock	271.97	272.0	271.97	272.0	242.0
2021-07-02 06:30:00	MSFT	Stock	272.18	272.25	272.18	272.25	986.0
2021-07-02 07:00:00	MSFT	Stock	272.25	272.25	272.15	272.15	2579.0
2021-07-02 07:30:00	MSFT	Stock	272.16	272.69	272.16	272.69	4275.0
2021-07-02 08:00:00	MSFT	Stock	272.7399	272.97	272.05	272.51	14935.0
2021-07-02 08:30:00	MSFT	Stock	272.35	273.0	272.21	272.79	38243.0
2021-07-02 09:00:00	MSFT	Stock	272.8	273.49	272.35	272.76	48130.0
2021-07-02 09:30:00	MSFT	Stock	272.77	275.18	272.5	274.75	2936365.0
2021-07-02 10:00:00	MSFT	Stock	274.74	275.05	274.435	274.93	1096737.0
2021-07-02 10:30:00	MSFT	Stock	274.91	275.295	274.63	275.08	1075254.0
2021-07-02 11:00:00	MSFT	Stock	275.08	275.4312	275.0	275.35	701505.0
2021-07-02 11:30:00	MSFT	Stock	275.34	276.57	275.3	276.1561	960566.0
2021-07-02 12:00:00	MSFT	Stock	276.16	276.68	276.11	276.5142	1020812.0
2021-07-02 12:30:00	MSFT	Stock	276.53	276.845	276.17	276.82	1143121.0
2021-07-02 13:00:00	MSFT	Stock	276.81	276.86	276.5	276.86	1151976.0
2021-07-02 13:30:00	MSFT	Stock	276.86	277.15	276.76	277.0984	869519.0

> showing 50 of 109,362 rows — these rows as CSV

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