PREVIEW / stock_30min / 2019-05-10

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-05-10.parquet
  size:    1.7 MB
  rows:    82,688
  symbols: 2,604

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-05-10 04:00:00	AAPL	Stock	49.9825	49.9825	49.745	49.9	44452.0
2019-05-10 04:30:00	AAPL	Stock	49.905	49.905	49.84	49.845	14248.0
2019-05-10 05:00:00	AAPL	Stock	49.9475	50.1	49.9475	50.1	7496.0
2019-05-10 05:30:00	AAPL	Stock	50.1	50.15	49.9525	49.9525	18868.0
2019-05-10 06:00:00	AAPL	Stock	50.0025	50.0025	49.9625	49.9625	1200.0
2019-05-10 06:30:00	AAPL	Stock	50.0025	50.175	49.73	49.73	62104.0
2019-05-10 07:00:00	AAPL	Stock	49.7675	49.8925	49.7	49.7	121172.0
2019-05-10 07:30:00	AAPL	Stock	49.725	49.745	49.5825	49.6	127348.0
2019-05-10 08:00:00	AAPL	Stock	49.725	49.8975	49.375	49.4	748504.0
2019-05-10 08:30:00	AAPL	Stock	49.425	49.4525	49.27	49.3475	367128.0
2019-05-10 09:00:00	AAPL	Stock	49.3475	49.5225	49.335	49.355	400132.0
2019-05-10 09:30:00	AAPL	Stock	49.3575	49.7125	49.2525	49.3675	16177364.0
2019-05-10 10:00:00	AAPL	Stock	49.3725	49.435	48.8575	48.895	12417048.0
2019-05-10 10:30:00	AAPL	Stock	48.8875	48.9225	48.1925	48.4325	20671772.0
2019-05-10 11:00:00	AAPL	Stock	48.44	48.6925	48.295	48.4575	9295060.0
2019-05-10 11:30:00	AAPL	Stock	48.4675	48.6375	48.2675	48.54	8197196.0
2019-05-10 12:00:00	AAPL	Stock	48.532	48.945	48.53	48.865	8274920.0
2019-05-10 12:30:00	AAPL	Stock	48.86	49.0	48.7575	48.8875	5850312.0
2019-05-10 13:00:00	AAPL	Stock	48.891	49.23	48.8275	49.0275	6694400.0
2019-05-10 13:30:00	AAPL	Stock	49.0292	49.22	49.02	49.195	5168428.0
2019-05-10 14:00:00	AAPL	Stock	49.1987	49.2542	48.8562	48.9375	6943524.0
2019-05-10 14:30:00	AAPL	Stock	48.9475	49.2475	48.9225	49.205	4522244.0
2019-05-10 15:00:00	AAPL	Stock	49.2012	49.6375	49.1675	49.585	8743848.0
2019-05-10 15:30:00	AAPL	Stock	49.5825	49.5875	49.1098	49.325	13342188.0
2019-05-10 16:00:00	AAPL	Stock	49.295	49.3125	49.1952	49.25	6390552.0
2019-05-10 16:30:00	AAPL	Stock	49.2575	49.295	49.2275	49.2875	101860.0
2019-05-10 17:00:00	AAPL	Stock	49.2625	49.2675	49.2525	49.2675	13540.0
2019-05-10 17:30:00	AAPL	Stock	49.2675	49.3075	49.2525	49.3025	27964.0
2019-05-10 18:00:00	AAPL	Stock	49.3025	49.31	49.295	49.31	8036.0
2019-05-10 18:30:00	AAPL	Stock	49.305	49.3125	49.295	49.3125	32468.0
2019-05-10 19:00:00	AAPL	Stock	49.3125	49.3125	49.3	49.3025	26980.0
2019-05-10 19:30:00	AAPL	Stock	49.305	49.31	49.2875	49.2875	17664.0
2019-05-10 04:00:00	MSFT	Stock	125.48	125.66	125.2	125.2	3100.0
2019-05-10 04:30:00	MSFT	Stock	125.38	125.38	125.38	125.38	100.0
2019-05-10 05:00:00	MSFT	Stock	125.71	125.8	125.71	125.8	467.0
2019-05-10 05:30:00	MSFT	Stock	125.81	125.81	125.6	125.6	472.0
2019-05-10 06:00:00	MSFT	Stock	125.55	125.55	125.55	125.55	199.0
2019-05-10 06:30:00	MSFT	Stock	126.0	126.0	125.44	125.44	3196.0
2019-05-10 07:00:00	MSFT	Stock	125.5	125.75	125.15	125.15	1676.0
2019-05-10 07:30:00	MSFT	Stock	125.01	125.25	124.98	125.01	7822.0
2019-05-10 08:00:00	MSFT	Stock	125.5	125.82	124.64	124.9	10048.0
2019-05-10 08:30:00	MSFT	Stock	124.68	124.91	124.26	124.76	5006.0
2019-05-10 09:00:00	MSFT	Stock	124.86	125.25	124.79	124.98	18827.0
2019-05-10 09:30:00	MSFT	Stock	124.9	126.0	124.9	125.28	2311264.0
2019-05-10 10:00:00	MSFT	Stock	125.29	125.305	124.65	124.87	1657898.0
2019-05-10 10:30:00	MSFT	Stock	124.865	124.92	124.02	124.2	1998363.0
2019-05-10 11:00:00	MSFT	Stock	124.19	124.54	123.93	124.06	1647056.0
2019-05-10 11:30:00	MSFT	Stock	124.05	124.58	123.82	124.24	1864239.0
2019-05-10 12:00:00	MSFT	Stock	124.24	125.42	124.23	125.35	1635025.0
2019-05-10 12:30:00	MSFT	Stock	125.34	126.0	125.235	125.776	1201796.0

> showing 50 of 82,688 rows — these rows as CSV

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