PREVIEW / stock_30min / 2019-10-18

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-10-18.parquet
  size:    1.7 MB
  rows:    82,268
  symbols: 2,488

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-18 04:00:00	AAPL	Stock	58.84	58.84	58.7275	58.7275	1788.0
2019-10-18 04:30:00	AAPL	Stock	58.7275	58.7275	58.7275	58.7275	664.0
2019-10-18 06:00:00	AAPL	Stock	58.75	58.75	58.75	58.75	600.0
2019-10-18 06:30:00	AAPL	Stock	58.8125	58.8125	58.75	58.75	2400.0
2019-10-18 07:00:00	AAPL	Stock	58.7925	58.8625	58.7875	58.835	42444.0
2019-10-18 07:30:00	AAPL	Stock	58.8375	58.855	58.8375	58.855	7436.0
2019-10-18 08:00:00	AAPL	Stock	58.865	58.865	58.7875	58.8625	51308.0
2019-10-18 08:30:00	AAPL	Stock	58.8525	58.865	58.755	58.7875	74908.0
2019-10-18 09:00:00	AAPL	Stock	58.7875	58.7875	58.59	58.59	208704.0
2019-10-18 09:30:00	AAPL	Stock	58.59	59.005	58.59	58.98	14391436.0
2019-10-18 10:00:00	AAPL	Stock	58.9775	59.0705	58.8525	58.905	6507852.0
2019-10-18 10:30:00	AAPL	Stock	58.91	58.9325	58.74	58.8838	4596420.0
2019-10-18 11:00:00	AAPL	Stock	58.885	59.025	58.855	59.0025	3270188.0
2019-10-18 11:30:00	AAPL	Stock	59.005	59.045	58.735	58.7838	4381332.0
2019-10-18 12:00:00	AAPL	Stock	58.785	58.875	58.5725	58.65	5170808.0
2019-10-18 12:30:00	AAPL	Stock	58.6525	58.8175	58.625	58.81	3064336.0
2019-10-18 13:00:00	AAPL	Stock	58.8125	58.96	58.7975	58.935	2664908.0
2019-10-18 13:30:00	AAPL	Stock	58.9375	59.1425	58.925	59.0275	4136348.0
2019-10-18 14:00:00	AAPL	Stock	59.0275	59.1	58.985	59.0625	2148168.0
2019-10-18 14:30:00	AAPL	Stock	59.0625	59.1825	59.0125	59.1775	3038436.0
2019-10-18 15:00:00	AAPL	Stock	59.18	59.395	59.1725	59.2675	6580900.0
2019-10-18 15:30:00	AAPL	Stock	59.2675	59.33	59.0675	59.07	8426992.0
2019-10-18 16:00:00	AAPL	Stock	59.1025	59.1175	59.07	59.075	9116176.0
2019-10-18 16:30:00	AAPL	Stock	59.0975	59.11	59.09	59.1	147544.0
2019-10-18 17:00:00	AAPL	Stock	59.0975	59.105	59.0875	59.0875	11416.0
2019-10-18 17:30:00	AAPL	Stock	59.0825	59.1	59.0525	59.0675	27636.0
2019-10-18 18:00:00	AAPL	Stock	59.075	59.0875	59.075	59.0875	15956.0
2019-10-18 18:30:00	AAPL	Stock	59.0875	59.1	59.075	59.075	15532.0
2019-10-18 19:00:00	AAPL	Stock	59.0875	59.0925	59.075	59.075	21300.0
2019-10-18 19:30:00	AAPL	Stock	59.085	59.0875	59.0525	59.0525	28224.0
2019-10-18 04:00:00	MSFT	Stock	139.64	140.02	139.64	140.02	1800.0
2019-10-18 04:30:00	MSFT	Stock	140.04	140.04	140.04	140.04	100.0
2019-10-18 05:00:00	MSFT	Stock	140.02	140.14	140.01	140.14	5094.0
2019-10-18 05:30:00	MSFT	Stock	140.2	140.2	140.1	140.1	999.0
2019-10-18 06:30:00	MSFT	Stock	140.17	140.19	140.06	140.06	1970.0
2019-10-18 07:00:00	MSFT	Stock	140.05	140.19	140.01	140.13	7504.0
2019-10-18 07:30:00	MSFT	Stock	140.13	140.2	140.12	140.18	10762.0
2019-10-18 08:00:00	MSFT	Stock	140.07	140.28	140.02	140.17	38623.0
2019-10-18 08:30:00	MSFT	Stock	140.17	140.23	140.02	140.15	16436.0
2019-10-18 09:00:00	MSFT	Stock	140.08	140.16	139.72	139.82	70015.0
2019-10-18 09:30:00	MSFT	Stock	139.78	140.0	139.31	139.61	4264603.0
2019-10-18 10:00:00	MSFT	Stock	139.615	139.625	138.87	138.96	1683659.0
2019-10-18 10:30:00	MSFT	Stock	138.96	138.98	138.2	138.34	1364010.0
2019-10-18 11:00:00	MSFT	Stock	138.35	138.355	137.91	138.19	1923087.0
2019-10-18 11:30:00	MSFT	Stock	138.19	138.365	137.03	137.07	1865115.0
2019-10-18 12:00:00	MSFT	Stock	137.05	137.445	136.61	136.698	2477815.0
2019-10-18 12:30:00	MSFT	Stock	136.69	137.25	136.56	137.216	2222499.0
2019-10-18 13:00:00	MSFT	Stock	137.216	137.95	137.16	137.79	1280837.0
2019-10-18 13:30:00	MSFT	Stock	137.798	138.23	137.655	138.17	1113934.0
2019-10-18 14:00:00	MSFT	Stock	138.18	138.495	138.01	138.37	1022838.0

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

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