PREVIEW / stock_30min / 2019-09-05

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-09-05.parquet
  size:    1.7 MB
  rows:    85,551
  symbols: 2,565

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-09-05 04:00:00	AAPL	Stock	52.65	52.875	52.65	52.875	9528.0
2019-09-05 04:30:00	AAPL	Stock	52.875	52.875	52.875	52.875	5568.0
2019-09-05 05:00:00	AAPL	Stock	52.8975	52.945	52.875	52.895	9412.0
2019-09-05 05:30:00	AAPL	Stock	52.9125	53.0375	52.9125	53.0	51484.0
2019-09-05 06:00:00	AAPL	Stock	53.005	53.0225	52.8	52.8125	23892.0
2019-09-05 06:30:00	AAPL	Stock	52.7775	52.9725	52.7675	52.93	20864.0
2019-09-05 07:00:00	AAPL	Stock	52.905	52.9575	52.8275	52.8775	152472.0
2019-09-05 07:30:00	AAPL	Stock	52.875	52.875	52.765	52.765	75540.0
2019-09-05 08:00:00	AAPL	Stock	52.895	52.9475	52.79	52.9125	276052.0
2019-09-05 08:30:00	AAPL	Stock	52.9125	52.95	52.878	52.905	207556.0
2019-09-05 09:00:00	AAPL	Stock	52.91	53.0	52.8725	52.9875	188748.0
2019-09-05 09:30:00	AAPL	Stock	52.9875	53.4375	52.9675	53.275	15349736.0
2019-09-05 10:00:00	AAPL	Stock	53.2775	53.4925	53.2225	53.2925	9341404.0
2019-09-05 10:30:00	AAPL	Stock	53.2938	53.2962	53.15	53.2175	6117264.0
2019-09-05 11:00:00	AAPL	Stock	53.2175	53.315	53.1582	53.2128	3717592.0
2019-09-05 11:30:00	AAPL	Stock	53.21	53.2325	53.1075	53.1075	3170568.0
2019-09-05 12:00:00	AAPL	Stock	53.105	53.175	53.03	53.0625	3278588.0
2019-09-05 12:30:00	AAPL	Stock	53.07	53.1025	53.0325	53.0525	1792248.0
2019-09-05 13:00:00	AAPL	Stock	53.0525	53.1125	52.8775	53.0375	4157232.0
2019-09-05 13:30:00	AAPL	Stock	53.0375	53.0925	53.0	53.0488	1769380.0
2019-09-05 14:00:00	AAPL	Stock	53.0475	53.1	53.0112	53.0938	2320816.0
2019-09-05 14:30:00	AAPL	Stock	53.0925	53.2825	53.0775	53.275	4168176.0
2019-09-05 15:00:00	AAPL	Stock	53.275	53.3975	53.255	53.2672	3561588.0
2019-09-05 15:30:00	AAPL	Stock	53.265	53.3375	53.175	53.3175	7977052.0
2019-09-05 16:00:00	AAPL	Stock	53.3375	53.3375	53.2525	53.2875	10259508.0
2019-09-05 16:30:00	AAPL	Stock	53.3075	53.32	53.2525	53.2725	179964.0
2019-09-05 17:00:00	AAPL	Stock	53.2625	53.27	53.245	53.2592	21316.0
2019-09-05 17:30:00	AAPL	Stock	53.25	53.32	53.25	53.2875	55516.0
2019-09-05 18:00:00	AAPL	Stock	53.3325	53.3375	53.295	53.32	19972.0
2019-09-05 18:30:00	AAPL	Stock	53.3275	53.3375	53.315	53.3375	19900.0
2019-09-05 19:00:00	AAPL	Stock	53.3375	53.3625	53.33	53.35	18188.0
2019-09-05 19:30:00	AAPL	Stock	53.375	53.4	53.345	53.4	62516.0
2019-09-05 04:00:00	MSFT	Stock	138.45	139.0	138.45	139.0	4688.0
2019-09-05 04:30:00	MSFT	Stock	139.0	139.06	138.95	138.95	865.0
2019-09-05 05:00:00	MSFT	Stock	139.08	139.3	139.0	139.11	3648.0
2019-09-05 05:30:00	MSFT	Stock	139.3	139.3	139.29	139.29	877.0
2019-09-05 06:00:00	MSFT	Stock	139.21	139.28	139.2	139.28	1604.0
2019-09-05 06:30:00	MSFT	Stock	139.39	139.4	139.34	139.36	1726.0
2019-09-05 07:00:00	MSFT	Stock	139.23	139.49	139.13	139.34	13292.0
2019-09-05 07:30:00	MSFT	Stock	139.35	139.36	139.07	139.12	22555.0
2019-09-05 08:00:00	MSFT	Stock	139.29	139.48	139.04	139.34	40248.0
2019-09-05 08:30:00	MSFT	Stock	139.35	139.45	139.23	139.24	33078.0
2019-09-05 09:00:00	MSFT	Stock	139.24	139.44	139.0	139.08	42391.0
2019-09-05 09:30:00	MSFT	Stock	139.09	139.67	138.76	139.47	3372464.0
2019-09-05 10:00:00	MSFT	Stock	139.48	140.04	139.44	139.94	2884421.0
2019-09-05 10:30:00	MSFT	Stock	139.937	140.384	139.75	139.88	1725506.0
2019-09-05 11:00:00	MSFT	Stock	139.89	140.05	139.695	139.83	1079586.0
2019-09-05 11:30:00	MSFT	Stock	139.82	139.92	139.36	139.4	817085.0
2019-09-05 12:00:00	MSFT	Stock	139.406	139.66	139.364	139.48	915003.0
2019-09-05 12:30:00	MSFT	Stock	139.48	139.58	139.37	139.38	646957.0

> showing 50 of 85,551 rows — these rows as CSV

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