PREVIEW / stock_30min / 2020-07-29

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-07-29.parquet
  size:    1.9 MB
  rows:    97,859
  symbols: 2,443

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-07-29 04:00:00	AAPL	Stock	93.85	93.9225	93.8025	93.9225	4580.0
2020-07-29 04:30:00	AAPL	Stock	93.8725	93.8725	93.8725	93.8725	612.0
2020-07-29 05:00:00	AAPL	Stock	93.75	93.75	93.75	93.75	1572.0
2020-07-29 05:30:00	AAPL	Stock	93.75	93.75	93.75	93.75	980.0
2020-07-29 06:00:00	AAPL	Stock	93.8925	93.8925	93.7825	93.7825	2876.0
2020-07-29 06:30:00	AAPL	Stock	93.8825	93.945	93.8625	93.885	16488.0
2020-07-29 07:00:00	AAPL	Stock	93.925	94.03	93.855	93.93	98268.0
2020-07-29 07:30:00	AAPL	Stock	93.8875	94.0025	93.8275	93.8975	47580.0
2020-07-29 08:00:00	AAPL	Stock	93.9265	94.125	93.825	94.1	231932.0
2020-07-29 08:30:00	AAPL	Stock	94.075	94.095	93.7975	93.905	114404.0
2020-07-29 09:00:00	AAPL	Stock	93.9125	93.94	93.2525	93.7525	843920.0
2020-07-29 09:30:00	AAPL	Stock	93.75	94.425	93.7125	94.2625	10234384.0
2020-07-29 10:00:00	AAPL	Stock	94.2725	94.82	94.255	94.62	8346876.0
2020-07-29 10:30:00	AAPL	Stock	94.6375	94.7575	94.5	94.605	4104724.0
2020-07-29 11:00:00	AAPL	Stock	94.6025	94.6575	94.3775	94.6325	3527836.0
2020-07-29 11:30:00	AAPL	Stock	94.6315	94.6375	94.35	94.56	2814876.0
2020-07-29 12:00:00	AAPL	Stock	94.5525	94.5525	94.09	94.3268	3486404.0
2020-07-29 12:30:00	AAPL	Stock	94.3252	94.4725	94.2675	94.3472	2156980.0
2020-07-29 13:00:00	AAPL	Stock	94.35	94.426	94.1202	94.3	2811452.0
2020-07-29 13:30:00	AAPL	Stock	94.2925	94.3525	94.0875	94.165	2329220.0
2020-07-29 14:00:00	AAPL	Stock	94.1642	94.7688	94.0425	94.717	4268152.0
2020-07-29 14:30:00	AAPL	Stock	94.7222	95.1442	94.71	94.7575	6848252.0
2020-07-29 15:00:00	AAPL	Stock	94.7652	95.015	94.4425	94.9075	6000648.0
2020-07-29 15:30:00	AAPL	Stock	94.9112	95.23	94.815	95.0675	7191792.0
2020-07-29 16:00:00	AAPL	Stock	95.04	95.58	94.97	95.2875	4407808.0
2020-07-29 16:30:00	AAPL	Stock	95.325	95.3975	95.2775	95.37	131528.0
2020-07-29 17:00:00	AAPL	Stock	95.375	95.4225	95.3125	95.36	83416.0
2020-07-29 17:30:00	AAPL	Stock	95.36	95.43	95.36	95.4	27136.0
2020-07-29 18:00:00	AAPL	Stock	95.375	95.375	95.1	95.175	139172.0
2020-07-29 18:30:00	AAPL	Stock	95.1675	95.2375	95.125	95.2225	110308.0
2020-07-29 19:00:00	AAPL	Stock	95.1875	95.1875	95.125	95.1875	29428.0
2020-07-29 19:30:00	AAPL	Stock	95.22	95.2475	95.1575	95.225	56200.0
2020-07-29 04:00:00	MSFT	Stock	202.9	202.99	202.9	202.99	871.0
2020-07-29 04:30:00	MSFT	Stock	202.88	202.89	202.88	202.89	571.0
2020-07-29 05:30:00	MSFT	Stock	202.9	202.9	202.9	202.9	100.0
2020-07-29 07:00:00	MSFT	Stock	203.01	203.08	202.79	202.79	12501.0
2020-07-29 07:30:00	MSFT	Stock	202.72	203.1	202.65	203.1	13181.0
2020-07-29 08:00:00	MSFT	Stock	203.06	203.48	202.52	203.13	55748.0
2020-07-29 08:30:00	MSFT	Stock	203.24	203.24	201.976	203.0	12088.0
2020-07-29 09:00:00	MSFT	Stock	203.0	203.25	202.02	202.54	316466.0
2020-07-29 09:30:00	MSFT	Stock	202.49	203.38	202.01	203.36	2361831.0
2020-07-29 10:00:00	MSFT	Stock	203.37	204.35	203.33	204.17	2015605.0
2020-07-29 10:30:00	MSFT	Stock	204.18	204.48	203.67	203.74	1091293.0
2020-07-29 11:00:00	MSFT	Stock	203.76	203.95	203.27	203.85	813675.0
2020-07-29 11:30:00	MSFT	Stock	203.84	204.055	203.59	203.626	621402.0
2020-07-29 12:00:00	MSFT	Stock	203.62	203.64	203.08	203.44	690755.0
2020-07-29 12:30:00	MSFT	Stock	203.44	203.794	203.36	203.76	516169.0
2020-07-29 13:00:00	MSFT	Stock	203.76	204.16	203.47	203.99	630019.0
2020-07-29 13:30:00	MSFT	Stock	204.0	204.15	203.5	203.565	562680.0
2020-07-29 14:00:00	MSFT	Stock	203.55	204.08	203.23	203.56	814791.0

> showing 50 of 97,859 rows — these rows as CSV

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