PREVIEW / stock_30min / 2019-10-21

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-10-21.parquet
  size:    1.7 MB
  rows:    83,710
  symbols: 2,492

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-10-21 04:00:00	AAPL	Stock	59.31	59.375	59.31	59.3575	21828.0
2019-10-21 04:30:00	AAPL	Stock	59.3875	59.3875	59.3625	59.375	23232.0
2019-10-21 05:00:00	AAPL	Stock	59.3625	59.3775	59.3625	59.3775	8788.0
2019-10-21 05:30:00	AAPL	Stock	59.3775	59.3775	59.3775	59.3775	1620.0
2019-10-21 06:00:00	AAPL	Stock	59.3675	59.375	59.3675	59.375	8400.0
2019-10-21 06:30:00	AAPL	Stock	59.375	59.4225	59.375	59.4	4812.0
2019-10-21 07:00:00	AAPL	Stock	59.3525	59.3775	59.2875	59.375	123320.0
2019-10-21 07:30:00	AAPL	Stock	59.37	59.4375	59.34	59.4375	67512.0
2019-10-21 08:00:00	AAPL	Stock	59.35	59.525	59.2778	59.4525	346900.0
2019-10-21 08:30:00	AAPL	Stock	59.45	59.5125	59.3875	59.4075	441960.0
2019-10-21 09:00:00	AAPL	Stock	59.4125	59.4475	59.375	59.4125	218184.0
2019-10-21 09:30:00	AAPL	Stock	59.4125	60.0	59.33	59.925	16145160.0
2019-10-21 10:00:00	AAPL	Stock	59.9178	60.0	59.775	59.875	7267028.0
2019-10-21 10:30:00	AAPL	Stock	59.8738	59.985	59.8325	59.98	3770420.0
2019-10-21 11:00:00	AAPL	Stock	59.98	60.21	59.96	60.1625	8168108.0
2019-10-21 11:30:00	AAPL	Stock	60.165	60.22	60.0175	60.1825	4291928.0
2019-10-21 12:00:00	AAPL	Stock	60.1825	60.2125	60.1325	60.1575	2580448.0
2019-10-21 12:30:00	AAPL	Stock	60.165	60.2475	60.135	60.145	3419704.0
2019-10-21 13:00:00	AAPL	Stock	60.1525	60.2175	60.1125	60.2025	2167368.0
2019-10-21 13:30:00	AAPL	Stock	60.2012	60.235	60.1675	60.2	2116052.0
2019-10-21 14:00:00	AAPL	Stock	60.2025	60.2325	60.15	60.1578	1942172.0
2019-10-21 14:30:00	AAPL	Stock	60.1575	60.1875	60.1292	60.1725	1722756.0
2019-10-21 15:00:00	AAPL	Stock	60.1745	60.1875	60.0925	60.125	2358956.0
2019-10-21 15:30:00	AAPL	Stock	60.125	60.155	60.015	60.1325	7786656.0
2019-10-21 16:00:00	AAPL	Stock	60.1275	60.15	60.0072	60.1475	8933916.0
2019-10-21 16:30:00	AAPL	Stock	60.1275	60.145	60.115	60.125	272524.0
2019-10-21 17:00:00	AAPL	Stock	60.125	60.1475	60.125	60.14	23660.0
2019-10-21 17:30:00	AAPL	Stock	60.14	60.165	60.14	60.165	23804.0
2019-10-21 18:00:00	AAPL	Stock	60.1575	60.1625	60.125	60.155	18748.0
2019-10-21 18:30:00	AAPL	Stock	60.1275	60.155	60.1125	60.1375	4636.0
2019-10-21 19:00:00	AAPL	Stock	60.1375	60.15	60.1075	60.15	9232.0
2019-10-21 19:30:00	AAPL	Stock	60.1375	60.175	60.125	60.1725	48600.0
2019-10-21 04:00:00	MSFT	Stock	138.13	138.43	138.13	138.43	2263.0
2019-10-21 04:30:00	MSFT	Stock	138.4	138.45	138.3	138.3	1762.0
2019-10-21 05:00:00	MSFT	Stock	138.2	138.55	138.2	138.32	1800.0
2019-10-21 05:30:00	MSFT	Stock	138.75	138.93	138.45	138.93	4580.0
2019-10-21 06:00:00	MSFT	Stock	138.88	138.89	138.88	138.89	200.0
2019-10-21 06:30:00	MSFT	Stock	138.7	138.7	138.41	138.55	1445.0
2019-10-21 07:00:00	MSFT	Stock	138.5	138.59	138.31	138.49	7043.0
2019-10-21 07:30:00	MSFT	Stock	138.49	138.6	138.49	138.51	14686.0
2019-10-21 08:00:00	MSFT	Stock	138.41	138.64	137.75	138.4	53734.0
2019-10-21 08:30:00	MSFT	Stock	138.35	138.45	138.2	138.29	75556.0
2019-10-21 09:00:00	MSFT	Stock	138.29	138.54	138.18	138.5	58367.0
2019-10-21 09:30:00	MSFT	Stock	138.49	138.51	137.105	137.41	2792276.0
2019-10-21 10:00:00	MSFT	Stock	137.38	137.85	137.01	137.75	1509543.0
2019-10-21 10:30:00	MSFT	Stock	137.76	138.11	137.59	137.92	1126512.0
2019-10-21 11:00:00	MSFT	Stock	137.92	138.0	137.73	137.84	958065.0
2019-10-21 11:30:00	MSFT	Stock	137.85	137.85	137.314	137.465	833521.0
2019-10-21 12:00:00	MSFT	Stock	137.465	137.858	137.394	137.84	654171.0
2019-10-21 12:30:00	MSFT	Stock	137.85	137.96	137.74	137.9	850082.0

> showing 50 of 83,710 rows — these rows as CSV

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