PREVIEW / stock_30min / 2018-08-22

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-08-22.parquet
  size:    1.6 MB
  rows:    82,132
  symbols: 2,793

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-08-22 04:00:00	AAPL	Stock	53.5	53.6	53.5	53.6	1828.0
2018-08-22 04:30:00	AAPL	Stock	53.55	53.6	53.55	53.6	4500.0
2018-08-22 06:00:00	AAPL	Stock	53.6125	53.6825	53.5975	53.6825	41776.0
2018-08-22 06:30:00	AAPL	Stock	53.6575	53.7	53.6575	53.7	1200.0
2018-08-22 07:00:00	AAPL	Stock	53.7	53.7375	53.625	53.67	99964.0
2018-08-22 07:30:00	AAPL	Stock	53.67	53.67	53.605	53.6625	37380.0
2018-08-22 08:00:00	AAPL	Stock	53.6375	53.7	53.5625	53.565	121264.0
2018-08-22 08:30:00	AAPL	Stock	53.6	53.6775	53.575	53.675	140720.0
2018-08-22 09:00:00	AAPL	Stock	53.6675	53.7225	53.53	53.53	202100.0
2018-08-22 09:30:00	AAPL	Stock	53.525	53.9298	53.5125	53.5662	9521996.0
2018-08-22 10:00:00	AAPL	Stock	53.565	53.7825	53.46	53.625	7531976.0
2018-08-22 10:30:00	AAPL	Stock	53.625	53.865	53.6102	53.815	4301016.0
2018-08-22 11:00:00	AAPL	Stock	53.815	54.0875	53.8025	54.0725	5283820.0
2018-08-22 11:30:00	AAPL	Stock	54.07	54.09	53.928	54.0325	3218284.0
2018-08-22 12:00:00	AAPL	Stock	54.03	54.0425	53.8825	53.895	2042376.0
2018-08-22 12:30:00	AAPL	Stock	53.8925	53.9225	53.78	53.835	2265036.0
2018-08-22 13:00:00	AAPL	Stock	53.8325	53.8925	53.7578	53.8678	2174080.0
2018-08-22 13:30:00	AAPL	Stock	53.8682	53.92	53.785	53.8375	2042200.0
2018-08-22 14:00:00	AAPL	Stock	53.8375	53.945	53.64	53.76	4682640.0
2018-08-22 14:30:00	AAPL	Stock	53.76	53.885	53.7075	53.8842	3860888.0
2018-08-22 15:00:00	AAPL	Stock	53.88	53.91	53.8	53.815	3103880.0
2018-08-22 15:30:00	AAPL	Stock	53.8175	53.9025	53.75	53.765	6755896.0
2018-08-22 16:00:00	AAPL	Stock	53.765	53.7975	53.7375	53.74	9118104.0
2018-08-22 16:30:00	AAPL	Stock	53.76	53.775	53.76	53.765	3544.0
2018-08-22 17:00:00	AAPL	Stock	53.7625	53.7625	53.7525	53.7525	2324.0
2018-08-22 17:30:00	AAPL	Stock	53.7525	53.7725	53.7525	53.7725	6944.0
2018-08-22 18:00:00	AAPL	Stock	53.7725	53.775	53.7625	53.7725	7828.0
2018-08-22 18:30:00	AAPL	Stock	53.7875	53.7875	53.7725	53.775	26440.0
2018-08-22 19:00:00	AAPL	Stock	53.8075	53.8125	53.8075	53.8075	19144.0
2018-08-22 19:30:00	AAPL	Stock	53.8125	53.8125	53.8	53.8125	26576.0
2018-08-22 04:00:00	MSFT	Stock	105.42	105.42	105.42	105.42	179.0
2018-08-22 06:00:00	MSFT	Stock	105.75	105.79	105.75	105.79	300.0
2018-08-22 07:00:00	MSFT	Stock	105.78	105.82	105.76	105.76	6865.0
2018-08-22 07:30:00	MSFT	Stock	105.74	105.76	105.7	105.73	2688.0
2018-08-22 08:00:00	MSFT	Stock	105.78	105.94	105.5	105.5	16512.0
2018-08-22 08:30:00	MSFT	Stock	105.56	105.71	105.51	105.71	2249.0
2018-08-22 09:00:00	MSFT	Stock	105.65	105.85	105.6	105.8	14552.0
2018-08-22 09:30:00	MSFT	Stock	105.85	106.4	105.78	106.04	2160915.0
2018-08-22 10:00:00	MSFT	Stock	106.04	106.2	105.79	105.96	1509687.0
2018-08-22 10:30:00	MSFT	Stock	105.965	106.48	105.965	106.424	1528925.0
2018-08-22 11:00:00	MSFT	Stock	106.422	106.63	106.36	106.589	931357.0
2018-08-22 11:30:00	MSFT	Stock	106.585	106.71	106.51	106.69	589400.0
2018-08-22 12:00:00	MSFT	Stock	106.69	106.77	106.47	106.615	656224.0
2018-08-22 12:30:00	MSFT	Stock	106.64	106.71	106.52	106.6	410135.0
2018-08-22 13:00:00	MSFT	Stock	106.61	106.775	106.51	106.67	424157.0
2018-08-22 13:30:00	MSFT	Stock	106.67	106.89	106.67	106.81	955763.0
2018-08-22 14:00:00	MSFT	Stock	106.81	107.005	106.78	106.93	1011766.0
2018-08-22 14:30:00	MSFT	Stock	106.93	107.04	106.85	107.03	633080.0
2018-08-22 15:00:00	MSFT	Stock	107.03	107.19	106.99	107.16	1025314.0
2018-08-22 15:30:00	MSFT	Stock	107.16	107.34	106.96	107.07	2527877.0

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

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