PREVIEW / stock_30min / 2018-10-05

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-10-05.parquet
  size:    1.7 MB
  rows:    83,187
  symbols: 2,773

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
2018-10-05 04:00:00	AAPL	Stock	56.7675	56.9125	56.7675	56.875	10596.0
2018-10-05 04:30:00	AAPL	Stock	56.775	56.85	56.775	56.85	800.0
2018-10-05 05:00:00	AAPL	Stock	56.7775	56.87	56.775	56.78	3144.0
2018-10-05 05:30:00	AAPL	Stock	56.825	56.825	56.78	56.785	7988.0
2018-10-05 06:00:00	AAPL	Stock	56.85	56.9125	56.7875	56.9125	4200.0
2018-10-05 06:30:00	AAPL	Stock	56.88	56.91	56.88	56.91	2612.0
2018-10-05 07:00:00	AAPL	Stock	56.91	57.025	56.8625	57.02	68824.0
2018-10-05 07:30:00	AAPL	Stock	56.9975	57.0125	56.8825	56.9025	26040.0
2018-10-05 08:00:00	AAPL	Stock	57.05	57.05	56.7575	56.83	190024.0
2018-10-05 08:30:00	AAPL	Stock	56.8575	57.125	56.745	56.975	803060.0
2018-10-05 09:00:00	AAPL	Stock	56.97	57.1225	56.9475	56.9475	238036.0
2018-10-05 09:30:00	AAPL	Stock	56.99	57.1025	56.4175	56.529	12084884.0
2018-10-05 10:00:00	AAPL	Stock	56.525	56.67	56.39	56.6065	7720968.0
2018-10-05 10:30:00	AAPL	Stock	56.605	56.685	56.32	56.5085	5673636.0
2018-10-05 11:00:00	AAPL	Stock	56.5075	56.515	55.9625	56.1182	9245928.0
2018-10-05 11:30:00	AAPL	Stock	56.1225	56.225	55.8875	55.9755	6570484.0
2018-10-05 12:00:00	AAPL	Stock	55.98	56.195	55.965	56.0875	4874904.0
2018-10-05 12:30:00	AAPL	Stock	56.09	56.0925	55.6825	55.72	6874760.0
2018-10-05 13:00:00	AAPL	Stock	55.715	55.715	55.145	55.38	12467656.0
2018-10-05 13:30:00	AAPL	Stock	55.3875	55.875	55.3575	55.8172	8142356.0
2018-10-05 14:00:00	AAPL	Stock	55.816	56.0825	55.75	56.055	5932864.0
2018-10-05 14:30:00	AAPL	Stock	56.0575	56.3	55.965	56.235	6862624.0
2018-10-05 15:00:00	AAPL	Stock	56.235	56.345	56.125	56.16	5761140.0
2018-10-05 15:30:00	AAPL	Stock	56.1592	56.25	55.9525	56.065	11025236.0
2018-10-05 16:00:00	AAPL	Stock	56.1175	56.1875	55.975	56.12	7746660.0
2018-10-05 16:30:00	AAPL	Stock	56.1375	56.1375	56.0875	56.135	80836.0
2018-10-05 17:00:00	AAPL	Stock	56.1025	56.1225	56.095	56.12	17436.0
2018-10-05 17:30:00	AAPL	Stock	56.11	56.11	56.07	56.0725	19696.0
2018-10-05 18:00:00	AAPL	Stock	56.085	56.1	56.0625	56.08	13308.0
2018-10-05 18:30:00	AAPL	Stock	56.075	56.09	56.0375	56.0375	35588.0
2018-10-05 19:00:00	AAPL	Stock	56.0625	56.0625	56.0125	56.025	21296.0
2018-10-05 19:30:00	AAPL	Stock	56.0	56.025	55.9875	55.9975	18600.0
2018-10-05 04:00:00	MSFT	Stock	113.0	113.0	113.0	113.0	131.0
2018-10-05 04:30:00	MSFT	Stock	112.99	112.99	112.99	112.99	100.0
2018-10-05 05:30:00	MSFT	Stock	112.77	112.77	112.77	112.77	120.0
2018-10-05 06:00:00	MSFT	Stock	112.79	112.79	112.79	112.79	600.0
2018-10-05 06:30:00	MSFT	Stock	112.7	112.8	112.7	112.8	1724.0
2018-10-05 07:00:00	MSFT	Stock	112.93	112.98	112.84	112.84	1705.0
2018-10-05 07:30:00	MSFT	Stock	112.84	112.85	112.74	112.74	2280.0
2018-10-05 08:00:00	MSFT	Stock	112.95	112.97	112.45	112.65	11975.0
2018-10-05 08:30:00	MSFT	Stock	112.77	113.33	112.05	112.79	54940.0
2018-10-05 09:00:00	MSFT	Stock	112.76	113.0	112.45	112.62	29681.0
2018-10-05 09:30:00	MSFT	Stock	112.63	113.17	111.95	112.09	3437022.0
2018-10-05 10:00:00	MSFT	Stock	112.085	112.6	111.86	112.48	2247297.0
2018-10-05 10:30:00	MSFT	Stock	112.485	112.53	111.96	112.34	1176208.0
2018-10-05 11:00:00	MSFT	Stock	112.35	112.36	111.39	111.64	1881423.0
2018-10-05 11:30:00	MSFT	Stock	111.64	111.87	111.38	111.48	1590844.0
2018-10-05 12:00:00	MSFT	Stock	111.5	111.82	111.415	111.54	1086091.0
2018-10-05 12:30:00	MSFT	Stock	111.55	111.567	111.04	111.13	1395347.0
2018-10-05 13:00:00	MSFT	Stock	111.12	111.19	110.64	110.91	1424306.0

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

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