PREVIEW / stock_30min / 2019-08-12

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-08-12.parquet
  size:    1.7 MB
  rows:    84,840
  symbols: 2,534

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-08-12 04:00:00	AAPL	Stock	50.6225	50.6225	50.2375	50.2375	13512.0
2019-08-12 04:30:00	AAPL	Stock	50.2125	50.2125	50.0125	50.0875	18092.0
2019-08-12 05:00:00	AAPL	Stock	50.05	50.055	49.9425	50.0	20908.0
2019-08-12 05:30:00	AAPL	Stock	50.05	50.05	49.955	49.955	7688.0
2019-08-12 06:00:00	AAPL	Stock	49.945	49.945	49.88	49.8875	15600.0
2019-08-12 06:30:00	AAPL	Stock	49.875	49.875	49.7575	49.865	45764.0
2019-08-12 07:00:00	AAPL	Stock	49.875	49.995	49.725	49.7575	82680.0
2019-08-12 07:30:00	AAPL	Stock	49.765	49.8875	49.75	49.8	55576.0
2019-08-12 08:00:00	AAPL	Stock	49.9625	50.0	49.6975	49.8325	141816.0
2019-08-12 08:30:00	AAPL	Stock	49.8625	50.0325	49.7875	49.925	98780.0
2019-08-12 09:00:00	AAPL	Stock	49.95	49.9975	49.8425	49.87	95276.0
2019-08-12 09:30:00	AAPL	Stock	49.865	50.375	49.8375	50.375	11909188.0
2019-08-12 10:00:00	AAPL	Stock	50.3725	50.49	50.089	50.3625	8484112.0
2019-08-12 10:30:00	AAPL	Stock	50.36	50.465	50.26	50.38	4966108.0
2019-08-12 11:00:00	AAPL	Stock	50.3775	50.38	50.0725	50.3225	5396656.0
2019-08-12 11:30:00	AAPL	Stock	50.325	50.4325	50.2275	50.38	4029660.0
2019-08-12 12:00:00	AAPL	Stock	50.3815	50.455	50.29	50.4487	3056956.0
2019-08-12 12:30:00	AAPL	Stock	50.445	50.513	50.355	50.4225	3837240.0
2019-08-12 13:00:00	AAPL	Stock	50.4175	50.495	50.37	50.4325	2665232.0
2019-08-12 13:30:00	AAPL	Stock	50.435	50.445	50.2875	50.3225	2551512.0
2019-08-12 14:00:00	AAPL	Stock	50.32	50.3725	50.0825	50.09	3111584.0
2019-08-12 14:30:00	AAPL	Stock	50.09	50.155	49.7875	49.8425	5729248.0
2019-08-12 15:00:00	AAPL	Stock	49.84	50.08	49.82	50.0418	5280808.0
2019-08-12 15:30:00	AAPL	Stock	50.0412	50.19	49.9875	50.125	6219196.0
2019-08-12 16:00:00	AAPL	Stock	50.12	50.1885	50.04	50.055	8316788.0
2019-08-12 16:30:00	AAPL	Stock	50.0625	50.12	50.0375	50.0525	19440.0
2019-08-12 17:00:00	AAPL	Stock	50.055	50.15	50.055	50.105	25636.0
2019-08-12 17:30:00	AAPL	Stock	50.1125	50.12	50.1025	50.1025	8948.0
2019-08-12 18:00:00	AAPL	Stock	50.075	50.0875	50.0625	50.0775	6800.0
2019-08-12 18:30:00	AAPL	Stock	50.1125	50.125	50.09	50.125	6724.0
2019-08-12 19:00:00	AAPL	Stock	50.1325	50.1325	50.1025	50.1025	2380.0
2019-08-12 19:30:00	AAPL	Stock	50.1125	50.175	50.1125	50.15	12304.0
2019-08-12 04:00:00	MSFT	Stock	138.22	138.5	138.0	138.09	2600.0
2019-08-12 04:30:00	MSFT	Stock	137.19	137.31	136.92	137.31	609.0
2019-08-12 05:00:00	MSFT	Stock	137.02	137.02	136.97	136.97	471.0
2019-08-12 05:30:00	MSFT	Stock	137.58	137.58	137.19	137.2	1595.0
2019-08-12 06:00:00	MSFT	Stock	136.97	136.97	136.82	136.92	780.0
2019-08-12 06:30:00	MSFT	Stock	136.92	136.95	136.7	136.95	1480.0
2019-08-12 07:00:00	MSFT	Stock	136.94	137.06	136.48	136.48	12361.0
2019-08-12 07:30:00	MSFT	Stock	136.62	136.9	136.6	136.6	11559.0
2019-08-12 08:00:00	MSFT	Stock	137.0	137.08	136.48	136.9	23674.0
2019-08-12 08:30:00	MSFT	Stock	136.82	137.0	136.66	137.0	7409.0
2019-08-12 09:00:00	MSFT	Stock	136.95	137.11	136.816	137.1	7591.0
2019-08-12 09:30:00	MSFT	Stock	137.07	137.86	136.41	136.81	1898269.0
2019-08-12 10:00:00	MSFT	Stock	136.82	137.34	136.51	137.075	1129008.0
2019-08-12 10:30:00	MSFT	Stock	137.07	137.312	136.66	137.04	750509.0
2019-08-12 11:00:00	MSFT	Stock	137.046	137.05	136.3	136.71	1009276.0
2019-08-12 11:30:00	MSFT	Stock	136.71	137.21	136.55	137.08	706550.0
2019-08-12 12:00:00	MSFT	Stock	137.07	137.25	136.76	137.106	573422.0
2019-08-12 12:30:00	MSFT	Stock	137.12	137.37	136.68	136.84	684900.0

> showing 50 of 84,840 rows — these rows as CSV

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